internal static MbsResult UpdateEmployee(ZBUserDetails updateEmployee)
{
using (ZBWorksDBContext dbContext = new ZBWorksDBContext())
{
ZB_USERDETAILS matchingEmployee = dbContext.ZBUSERDETAILs.Where
(src => src.InternalEmployeeID == updateEmployee.InternalEmployeeID).FirstOrDefault();
if (matchingEmployee == null)
{
return(new MbsResult(false, "invalid Credentails"));
}
if (updateEmployee.EmployeeName != matchingEmployee.EmployeeName)
{
matchingEmployee.EmployeeName = updateEmployee.EmployeeName;
}
if (updateEmployee.Role != matchingEmployee.Role)
{
matchingEmployee.Role = updateEmployee.Role;
}
if (updateEmployee.Password != matchingEmployee.Password)
{
matchingEmployee.Password = updateEmployee.Password;
}
dbContext.SaveChanges();
return(new MbsResult(true, ""));
}
}
internal static MbsResult AddNewEmployee(ZBUserDetails newEmployee)
{
using (ZBWorksDBContext dbContext = new ZBWorksDBContext())
{
ZB_USERDETAILS matchingEmployee = new ZB_USERDETAILS()
{
InternalEmployeeID = Guid.NewGuid().ToString(),
EmployeeName = newEmployee.EmployeeName,
Password = newEmployee.Password,
Role = newEmployee.Role
};
dbContext.ZBUSERDETAILs.Add(matchingEmployee);
dbContext.SaveChanges();
return(new MbsResult(true, ""));
}
}
internal static MbsResult AddEmployeeTask(List <ZbWorks> Newtask)
{
using (ZBWorksDBContext dbContext = new ZBWorksDBContext())
{
List <ZB_WORKS> NewEmployeeTask = new List <ZB_WORKS>();
foreach (var item in Newtask)
{
ZB_WORKS employeetask = new ZB_WORKS()
{
InternalZBWorksId = Guid.NewGuid().ToString(),
EmployeeName = item.EmployeeName,
InternalEmployeeID = item.InternalEmployeeID,
TaskName = item.TaskName,
TaskDuration = item.TaskDuration,
TaskDate = item.TaskDate
};
dbContext.ZBWORKs.Add(employeetask);
}
dbContext.SaveChanges();
return(new MbsResult(true, ""));
}
}
