public void DeleteProject(string ProjectCode) { try { List <PjEmployee> Employee = Context.PjEmployee.Where(z => z.ProjectCode == ProjectCode).ToList(); PjManageProject dataProject = Context.PjManageProject.Where(x => x.ProjectCode == ProjectCode).FirstOrDefault(); if (dataProject == null) { throw new Exception("No data for this project"); } if (Employee != null) { foreach (PjEmployee project in Employee) { Context.PjEmployee.Remove(project); Context.SaveChanges(); } } dataProject.Active = false; Context.PjManageProject.Update(dataProject); Context.SaveChanges(); } catch (Exception ex) { throw ex; } }
// card หน้าบ้านมาเรียก public ProjectDTO ProjectCard(string projectCode) { PjManageProject projectDB = Context.PjManageProject.Where(x => x.ProjectCode == projectCode && x.Active == true).FirstOrDefault(); ProjectDTO project = new ProjectDTO(); project.ProjectCode = projectDB.ProjectCode; project.ProjectName = projectDB.ProjectName; project.Deseription = projectDB.Deseription; project.StartDate = projectDB.StartDate; project.EndDate = projectDB.EndDate; project.PmManday = projectDB.PmManday; project.SaManday = projectDB.SaManday; project.SdManday = projectDB.SdManday; project.Active = projectDB.Active; project.Status = projectDB.Status; project.Company = GetCompany(projectDB.CompanyCode); project.Team = getEmployee(projectCode); return(project); }
//เพิ่ม ข้อมูล project ลง DB public async Task <string> CreateProject(ProjectDTO addProject) { try { PjManageProject check = Context.PjManageProject.Where(x => x.ProjectName == addProject.ProjectName && x.Active == true).FirstOrDefault(); if (addProject == null) { throw new Exception("Please fill out the information."); } if (check != null) { throw new Exception("This project already exists."); } PjManageProject newData = new PjManageProject(); newData.ProjectCode = (await ProjectRunning.GenerateRunningNo("PJ")).Code; newData.ProjectName = addProject.ProjectName; newData.CompanyCode = addProject.Company; newData.Active = true; newData.Deseription = addProject.Deseription; newData.StartDate = addProject.StartDate; newData.EndDate = addProject.EndDate; newData.PmManday = addProject.PmManday; newData.SaManday = addProject.SaManday; newData.SdManday = addProject.SdManday; newData.Status = addProject.Status; newData.CreatedBy = null; newData.CreatedDate = DateTime.Now; newData.UpdatedBy = null; newData.UpdatedDate = DateTime.Now.AddYears(3); CreateEmployee(addProject.Team, newData.ProjectCode);// แยกไปใช้อีกฟังชัน Context.PjManageProject.Add(newData); Context.SaveChanges(); return("success"); } catch (Exception ex) { throw ex; } }
public void UpdateProject(ProjectDTO dataedit) { try { PjManageProject CheckCode = Context.PjManageProject.Where(x => x.ProjectCode == dataedit.ProjectCode).FirstOrDefault(); PjManageProject CheckName = Context.PjManageProject.Where(x => x.ProjectName == dataedit.ProjectName).FirstOrDefault(); if (CheckCode.ProjectCode == null) { throw new Exception("No data for this project"); } if (CheckName != null && CheckName.ProjectCode != dataedit.ProjectCode) { throw new Exception("ProjectName is Duplicate"); } CheckCode.ProjectName = dataedit.ProjectName; CheckCode.CompanyCode = dataedit.Company; CheckCode.Active = dataedit.Active; CheckCode.Deseription = dataedit.Deseription; CheckCode.StartDate = dataedit.StartDate; CheckCode.EndDate = dataedit.EndDate; CheckCode.PmManday = dataedit.PmManday; CheckCode.SaManday = dataedit.SaManday; CheckCode.SdManday = dataedit.SdManday; CheckCode.Status = dataedit.Status; CheckCode.CreatedBy = "sql"; CheckCode.CreatedDate = DateTime.Now; CheckCode.UpdatedBy = null; CheckCode.UpdatedDate = DateTime.Now.AddYears(3); UpdateUser(dataedit.ProjectCode, dataedit.Team); Context.PjManageProject.Update(CheckCode); Context.SaveChanges(); } catch (Exception ex) { throw ex; } }