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;
}
}
