Система управления проектами территориально-распределенной IT-компании

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@ClientName",client.Name);

AddParameterToSql(sqlCmd, "@UserId", client.Id);

AddParameterToSql(sqlCmd, "@ClientDescription",client.Description);

TExecuteModifyCmd(sqlCmd);

}

}

Класс EmployeeDB

class EmployeeDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Employee> list)

{

while (returnData.Read())

{

var employee = new Employee();

var guidFromSql = GetGuidFromSql(returnData, "UserId");

if (guidFromSql != null) employee.Id = guidFromSql.Value;

employee.Mail = GetStringFromSql(returnData, "Email");

employee.Login = GetStringFromSql(returnData, "UserName");

var dateTimeFromSql = GetDateTimeFromSql(returnData, "CreateDate");

if (dateTimeFromSql != null)

employee.CreateDt = dateTimeFromSql.Value;

dateTimeFromSql = GetDateTimeFromSql(returnData, "LastLoginDate");

if (dateTimeFromSql.HasValue)

employee.LastLoginDt = dateTimeFromSql.Value;

dateTimeFromSql = GetDateTimeFromSql(returnData, "LastPasswordChangedDate");

if (dateTimeFromSql.HasValue)

employee.LastPasswordChangedDt = dateTimeFromSql.Value;

employee.Comment = GetStringFromSql(returnData, "Comment");

employee.FirstName = GetStringFromSql(returnData, "FirstName");

employee.LastName = GetStringFromSql(returnData, "LastName");

employee.Patronumic = GetStringFromSql(returnData, "Patronumic");

guidFromSql = GetGuidFromSql(returnData, "PostId");

if(guidFromSql.HasValue)

employee.Post = Post.GetById(guidFromSql.Value);

list.Add(employee);

}

}

public static Employee GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from vw_Employee where UserId=@UserId ");

sqlCmd.Parameters.Add(new SqlParameter("@UserId", Id));

var eList = new List<Employee>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref eList);

return eList.Count > 0 ? eList[0] : null;

}

public static List<Employee> GetEmployees()

{

var sqlCmd = new SqlCommand("select * from vw_Employee");

var eList = new List<Employee>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref eList);

return eList;

}

public static void SaveEmployee(Employee employee)

{

var sqlCmd = new SqlCommand("dbo.SaveEmployee");

sqlCmd.CommandType=CommandType.StoredProcedure;

AddParameterToSql(sqlCmd,"@UserId",employee.Id);

AddParameterToSql(sqlCmd,"@LastName", employee.LastName);

AddParameterToSql(sqlCmd,"@FirstName", employee.FirstName);

AddParameterToSql(sqlCmd,"@Patronumic", employee.Patronumic);

AddParameterToSql(sqlCmd,"@PostId",employee.Post.Id);

TExecuteModifyCmd(sqlCmd);

}

}

}

Класс JobDB

class JobDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Jobs> list)

{

while (returnData.Read())

{

var jobs = new Jobs();

var guidFromSql = GetGuidFromSql(returnData, "JobId");

if (guidFromSql != null) jobs.Id = guidFromSql.Value;

jobs.Name = GetStringFromSql(returnData, "JobName");

list.Add(jobs);

}

}

public static Jobs GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from Jobs where JobsId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Jobs>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Jobs> GetJobs()

{

var sqlCmd = new SqlCommand("select * from Jobs");

var pList = new List<Jobs>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveJobs(Jobs jobs)

{

var sqlCmd = new SqlCommand("SaveJobs");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@JobId", jobs.Id);

AddParameterToSql(sqlCmd, "@JobName", jobs.Name);

AddParameterToSql(sqlCmd, "@Start", jobs.Start);

AddParameterToSql(sqlCmd, "@Stop", jobs.Stop);

AddParameterToSql(sqlCmd, "@Post", jobs.Post);

TExecuteModifyCmd(sqlCmd);

}

public static List<Jobs> GetJobByEmployeeId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_JobsInEmployee(@UserId)");

var pList = new List<Jobs>();

AddParameterToSql(sqlCmd, "@UserId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveJobInEmployee(Guid jobsId, Guid userId)

{

var sqlCmd = new SqlCommand("SaveJobsInEmployee");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@JobId", jobsId);

AddParameterToSql(sqlCmd, "@UserId", userId);

TExecuteModifyCmd(sqlCmd);

}

}

}

Класс LanguageDB

class LanguageDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Language> list)

{

while (returnData.Read())

{

var language = new Language();

var guidFromSql = GetGuidFromSql(returnData, "LanguageId");

if (guidFromSql != null) language.Id = guidFromSql.Value;

language.Name = GetStringFromSql(returnData, "LanguageName");

// language.Experience = GetStringFromSql(returnData, "Experience");

list.Add(language);

}

}

private static void GenerateExpListFromReader(SqlDataReader returnData, ref List<Language> list)

{

while (returnData.Read())

{

var language = new Language();

var guidFromSql = GetGuidFromSql(returnData, "LanguageId");

if (guidFromSql != null) language.Id = guidFromSql.Value;

language.Name = GetStringFromSql(returnData, "LanguageName");

language.Experience = GetStringFromSql(returnData, "Experience");

list.Add(language);

}

}

public static Language GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from Language where LanguageId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Language>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Language> GetLanguage()

{

var sqlCmd = new SqlCommand("select * from Language");

var pList = new List<Language>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveLanguage(Language language)

{

var sqlCmd = new SqlCommand("SaveLanguage");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@LanguageId", language.Id);

AddParameterToSql(sqlCmd, "@LanguageName", language.Name);

TExecuteModifyCmd(sqlCmd);

}

public static List<Language> GetLanByProjectId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_LanguagesInProject(@ProjectId)");

var pList = new List<Language>();

AddParameterToSql(sqlCmd, "@ProjectId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveLanguageInProject (Guid languageId, Guid projectId)

{

var sqlCmd = new SqlCommand("SaveLangInProject");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@LanguageId",languageId);

AddParameterToSql(sqlCmd, "@ProjectId",projectId);

TExecuteModifyCmd(sqlCmd);

}

public static List<Language> GetLanByEmployeeId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_LanguagesInEmployee(@UserId)");

var pList = new List<Language>();

AddParameterToSql(sqlCmd, "@UserId", Id);

TExecuteReaderCmd(sqlCmd, GenerateExpListFromReader, ref pList);

return pList;

}

public static void SaveLanguageInEmployee(Guid languageId, Guid userId, int start, int stop, int experience)

{

var sqlCmd = new SqlCommand("SaveLangInEmployee"); //дописать в бд

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@LanguageId", languageId);

AddParameterToSql(sqlCmd, "@UserId", userId);

AddParameterToSql(sqlCmd, "@StartDate", start);

AddParameterToSql(sqlCmd, "@StopDate", stop);

AddParameterToSql(sqlCmd, "@Experience", experience);

TExecuteModifyCmd(sqlCmd);

}

}

}

Класс PhaseDB

class PhaseDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Phase> list)

{

while (returnData.Read())

{

var phase = new Phase();

var guidFromSql = GetGuidFromSql(returnData, "PhaseId");

if (guidFromSql != null) phase.Id = guidFromSql.Value;

phase.Name = GetStringFromSql(returnData, "PhaseName");

phase.Description = GetStringFromSql(returnData, "Description");

var dateTimeFromSql = GetDateTimeFromSql(returnData, "StartDate");

if (dateTimeFromSql != null)

phase.StartDt = dateTimeFromSql.Value;

dateTimeFromSql = GetDateTimeFromSql(returnData, "StopDate");

if (dateTimeFromSql != null)

phase.StopDt = dateTimeFromSql.Value;

list.Add(phase);

}

}

private static void GenerateExpListFromReader(SqlDataReader returnData, ref List<Phase> list)

{

while (returnData.Read())

{

var phase = new Phase();

var guidFromSql = GetGuidFromSql(returnData, "PhaseId");

if (guidFromSql != null) phase.Id = guidFromSql.Value;

phase.Name = GetStringFromSql(returnData, "PhaseName");

list.Add(phase);

}

}

public static Phase GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from Phase where PhaseId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Phase>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Phase> GetPhase()

{

var sqlCmd = new SqlCommand("select * from Phase");

var pList = new List<Phase>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SavePhase(Phase phase)

{

var sqlCmd = new SqlCommand("SavePhase");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@PhaseId", phase.Id);

AddParameterToSql(sqlCmd, "@PhaseName", phase.Name);

AddParameterToSql(sqlCmd, "@StartDate",phase.StartDt);

AddParameterToSql(sqlCmd, "@StopDate", phase.StopDt);

AddParameterToSql(sqlCmd, "@Description", phase.Description);

TExecuteModifyCmd(sqlCmd);

}

public static List<Phase> GetPhaseByProjectId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_PhaseInProject(@ProjectId)");

var pList = new List<Phase>();

AddParameterToSql(sqlCmd, "@ProjectId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SavePhaseInProject(Guid projectId, Guid phaseId)

{

var sqlCmd = new SqlCommand("SavePhaseInProject");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@ProjectId", projectId);

AddParameterToSql(sqlCmd, "@PhaseId", phaseId);

TExecuteModifyCmd(sqlCmd);

}

public static List<Phase> GetPhaseInTask(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_PhaseInTask(@TaskId)");

var pList = new List<Phase>();

AddParameterToSql(sqlCmd, "@ProjectId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

} }}

Класс PostDB

class PostDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Post> list)

{

while (returnData.Read())

{

var post = new Post();

var guidFromSql = GetGuidFromSql(returnData, "PostId");

if (guidFromSql != null) post.Id = guidFromSql.Value;

post.Name = GetStringFromSql(returnData,"PostName");

post.Description = GetStringFromSql(returnData,"Description");

list.Add(post);

}

}

public static Post GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from Post where PostId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Post>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Post> GetPosts()

{

var sqlCmd = new SqlCommand("select * from Post");

var pList = new List<Post>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SavePost(Post post)

{

var sqlCmd = new SqlCommand("SavePost");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd,"@PostId",post.Id);

AddParameterToSql(sqlCmd,"@Description",post.Description);

AddParameterToSql(sqlCmd,"@PostName",post.Name);

TExecuteModifyCmd(sqlCmd);

}

}}

Класс ProjectDB

class ProjectDB : DBUtils

{

private static void GenerateListFromReader(SqlDataReader returnData, ref List<Project> list)

{

while (returnData.Read())

{

var project = new Project();

var guidFromSql = GetGuidFromSql(returnData, "ProjectId");

if (guidFromSql != null) project.Id = guidFromSql.Value;

project.Name = GetStringFromSql(returnData, "ProjectName");

project.Status = GetBooleanFromSql(returnData, "Status");

var dateTimeFromSql = GetDateTimeFromSql(returnData, "startData");

if (dateTimeFromSql != null)

project.StartDt = dateTimeFromSql.Value;

dateTimeFromSql = GetDateTimeFromSql(returnData, "stopData");

if (dateTimeFromSql.HasValue)

project.EndDt = dateTimeFromSql.Value;

// guidFromSql = GetGuidFromSql(returnData, "UserId");

project.UserId = GetGuidFromSql(returnData, "UserId");

guidFromSql = GetGuidFromSql(returnData, "ClientId");

if (guidFromSql.HasValue)

project.ClientId = guidFromSql.Value;

project.Description = GetStringFromSql(returnData, "ProjectDescription");

var decimalFromSql = GetDecimalFromSql(returnData, "budget");

if (decimalFromSql != null)

project.Budget = decimalFromSql.Value;

list.Add(project);

}

}

public static Project GetProjectById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from vw_Project where ProjectId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Project>();

TExecuteReaderCmd(sqlCmd, GenerateListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Project> GetProjects()

{

var sqlCmd = new SqlCommand("select * from vw_Project");

var pList = new List<Project>();

TExecuteReaderCmd(sqlCmd, GenerateListFromReader, ref pList);

return pList;

}

public static List<Project> GetProjectsByStatus(bool? status )

{

var sqlCmd = new SqlCommand("select * from vw_Project where [Status]=@Status");

var pList = new List<Project>();

if(status.HasValue)

{

AddParameterToSql(sqlCmd,"@Status",status);

}

else

{

sqlCmd.CommandText = string.Format("select * from vw_Project where [Status] IS NULL");

}

TExecuteReaderCmd(sqlCmd, GenerateListFromReader, ref pList);

return pList;

}

public static List<Project> GetProjectByClientId(Guid Id)

{

var sqlCmd = new SqlCommand("select* from vw_Project where [ClientId] =@ClientId");

var pList = new List<Project>();

AddParameterToSql(sqlCmd, "@ClientId", Id);

TExecuteReaderCmd(sqlCmd, GenerateListFromReader, ref pList);

return pList;

}

public static void SaveProject(Project project)

{

var sqlCmd = new SqlCommand("SaveProject");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@ProjectId", project.Id);

AddParameterToSql(sqlCmd, "@ProjectDescription", project.Description);

AddParameterToSql(sqlCmd, "@ProjectName", project.Name);

AddParameterToSql(sqlCmd,"@ClientId",project.ClientId);

AddParameterToSql(sqlCmd,"@startData",project.StartDt);

AddParameterToSql(sqlCmd,"@stopData",project.EndDt);

AddParameterToSql(sqlCmd,"@budget",project.Budget);

AddParameterToSql(sqlCmd, "@Status",project.Status.HasValue?project.Status.Value:(bool?)null);

AddParameterToSql(sqlCmd,"@UserId",project.UserId);

TExecuteModifyCmd(sqlCmd);

}

public static List<Project> GetProjectByPhase(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_ProjectInPhase(@PhaseId)");

var pList = new List<Project>();

AddParameterToSql(sqlCmd, "@PhaseId", Id);

TExecuteReaderCmd(sqlCmd, GenerateListFromReader, ref pList);

return pList;

} }}

Класс TaskDB

class TaskDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Task> list)

{

while (returnData.Read())

{

var task = new Task();

var guidFromSql = GetGuidFromSql(returnData, "TaskId");

if (guidFromSql != null) task.Id = guidFromSql.Value;

task.Name = GetStringFromSql(returnData, "TaskName");

task.Description = GetStringFromSql(returnData, "TaskDescription");

var dateTimeFromSql = GetDateTimeFromSql(returnData, "startData");

if (dateTimeFromSql.HasValue)

task.StartDt = dateTimeFromSql.Value;

dateTimeFromSql = GetDateTimeFromSql(returnData, "stopData");

if (dateTimeFromSql.HasValue)

task.StopDt = dateTimeFromSql.Value;

guidFromSql = GetGuidFromSql(returnData, "UserId");

if (guidFromSql.HasValue)

task.EmployeeId = guidFromSql.Value;

guidFromSql = GetGuidFromSql(returnData, "ProjectId");

if (guidFromSql.HasValue)

task.ProjectId = guidFromSql.Value;

var spent = GetStringFromSql(returnData, "spentTime");

if (!string.IsNullOrEmpty(spent))

{

task.SpentTime = double.Parse(spent);

}

else

{

task.SpentTime = null;

}

task.Description = GetStringFromSql(returnData, "comment");

list.Add(task);

}

}

public static Task GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from v_tasks where TaskId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Task>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Task> GetTaskByPhaseId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_TasksInPhase(@PhaseId)");

var pList = new List<Task>();

AddParameterToSql(sqlCmd, "@PhaseId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static List<Task> GetTasks()

{

var sqlCmd = new SqlCommand("select * from v_tasks");

var pList = new List<Task>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveTasks(Task task)

{

var sqlCmd = new SqlCommand("SaveTask");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@TaskId", task.Id);

AddParameterToSql(sqlCmd, "@taskDescription", task.Description);

AddParameterToSql(sqlCmd, "@TaskName", task.Name);

AddParameterToSql(sqlCmd, "@ProjectId", task.ProjectId);

AddParameterToSql(sqlCmd, "@start_data",task.StartDt);

AddParameterToSql(sqlCmd, "@stop_data",task.StopDt);

AddParameterToSql(sqlCmd, "@UserId",task.EmployeeId);

AddParameterToSql(sqlCmd, "@spentTime", task.SpentTime);

AddParameterToSql(sqlCmd, "@comment", task.Comment);

TExecuteModifyCmd(sqlCmd);

}

public static void SaveTaskInPhase(Guid phaseId, Guid taskId)

{

var sqlCmd = new SqlCommand("SaveTaskInPhase");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@PhaseId", phaseId);

AddParameterToSql(sqlCmd, "@TaskId", taskId);

TExecuteModifyCmd(sqlCmd);

} }}

Класс TechnologyDB

class TechnologyDB:DBUtils

{

private static void GenerateContactListFromReader(SqlDataReader returnData, ref List<Technology> list)

{

while (returnData.Read())

{

var technology = new Technology();

var guidFromSql = GetGuidFromSql(returnData, "TechnologyId");

if (guidFromSql != null) technology.Id = guidFromSql.Value;

technology.Name = GetStringFromSql(returnData, "TechnologyName");

list.Add(technology);

}

}

private static void GenerateExperienceListFromReader(SqlDataReader returnData, ref List<Technology> list)

{

while (returnData.Read())

{

var technology = new Technology();

var guidFromSql = GetGuidFromSql(returnData, "TechnologyId");

if (guidFromSql != null) technology.Id = guidFromSql.Value;

technology.Name = GetStringFromSql(returnData, "TechnologyName");

technology.Experience = GetStringFromSql(returnData, "Experience");

list.Add(technology);

}

}

public static Technology GetById(Guid Id)

{

var sqlCmd = new SqlCommand("select * from Technology where TechnologyId=@Id");

sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));

var pList = new List<Technology>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList.Count > 0 ? pList[0] : null;

}

public static List<Technology> GetTechnology()

{

var sqlCmd = new SqlCommand("select * from Technology");

var pList = new List<Technology>();

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveTechnology(Technology technology)

{

var sqlCmd = new SqlCommand("SaveTechnology");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@TechnologyId", technology.Id);

AddParameterToSql(sqlCmd, "@TechnologyName", technology.Name);

TExecuteModifyCmd(sqlCmd);

}

public static List<Technology> GetTechnByProjectId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_TechnologysInProject(@ProjectId)");

var pList = new List<Technology>();

AddParameterToSql(sqlCmd, "@ProjectId", Id);

TExecuteReaderCmd(sqlCmd, GenerateContactListFromReader, ref pList);

return pList;

}

public static void SaveTechnologyInProject(Guid technologyId, Guid projectId)

{

var sqlCmd = new SqlCommand("SaveTechInProject");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@TechnologyId", technologyId);

AddParameterToSql(sqlCmd, "@ProjectId", projectId);

TExecuteModifyCmd(sqlCmd);

}

public static List<Technology> GetTechnByEmployeeId(Guid Id)

{

var sqlCmd = new SqlCommand("select * from V_TechnologysInEmployee(@UserId)");

var pList = new List<Technology>();

AddParameterToSql(sqlCmd, "@UserId", Id);

TExecuteReaderCmd(sqlCmd, GenerateExperienceListFromReader, ref pList);

return pList;

}

public static void SaveTechnologyInEmployee(Guid technologyId, Guid userId, int start, int stop, int experience)

{

var sqlCmd = new SqlCommand("SaveTechInEmployee");

sqlCmd.CommandType = CommandType.StoredProcedure;

AddParameterToSql(sqlCmd, "@TechnologyId", technologyId);

AddParameterToSql(sqlCmd, "@UserId", userId);

AddParameterToSql(sqlCmd, "@StartDate",start);

AddParameterToSql(sqlCmd, "@StopDate",stop);

AddParameterToSql(sqlCmd, "@Experience",experience);

TExecuteModifyCmd(sqlCmd);

}

}

}



Приложение Г

Интерфейс страниц администратора

Интерфейс страниц сотрудника

Размещено на Allbest.ru