internal static MbsResult GetEmployeeWorksheetDetailsByDate(string internalEmployeeId, long TaskDate, long TaskDate2) { using (ZBWorksDBContext dbContext = new ZBWorksDBContext()) { List <ZB_WORKS> matchingTask = dbContext.ZBWORKs.Where (src => src.InternalEmployeeID == internalEmployeeId && src.TaskDate == TaskDate || src.TaskDate == TaskDate2).ToList(); if (matchingTask == null) { return(new MbsResult(false, "No Tasks")); } List <ZbWorks> TaskList = new List <ZbWorks>(); foreach (var item in matchingTask) { TaskList.Add(new ZbWorks { TaskName = item.TaskName, TaskDate = item.TaskDate, InternalEmployeeID = item.InternalEmployeeID, EmployeeName = item.EmployeeName, InternalZBWorksId = item.InternalZBWorksId }); } MbsResult retVal = new MbsResult(true, TaskList); return(retVal); } }
internal static MbsResult GetEmployeeList() { ZBWorksDBContext dbContext = new ZBWorksDBContext(); List <ZB_USERDETAILS> EmployeeListDB = dbContext.ZBUSERDETAILs.Where(src => src.EmployeeName != null).ToList(); List <ZBUserDetails> EmployeeList = new List <ZBUserDetails>(); foreach (ZB_USERDETAILS item in EmployeeListDB) { EmployeeList.Add(new ZBUserDetails { EmployeeName = item.EmployeeName, Role = item.Role, Password = item.Password, InternalEmployeeID = item.InternalEmployeeID, }); } MbsResult retVal = new MbsResult(true, EmployeeList); return(retVal); }
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 GetEmployeeDetails(string internalEmployeeId) { using (ZBWorksDBContext dbContext = new ZBWorksDBContext()) { ZB_USERDETAILS matchingEmployee = dbContext.ZBUSERDETAILs.Where (src => src.InternalEmployeeID == internalEmployeeId).FirstOrDefault(); if (matchingEmployee == null) { return(new MbsResult(false, "invalid")); } ZB_USERDETAILS retval = new ZB_USERDETAILS() { InternalEmployeeID = Guid.NewGuid().ToString(), EmployeeName = matchingEmployee.EmployeeName, Password = matchingEmployee.Password, Role = matchingEmployee.Role }; return(new MbsResult(true, retval)); } }
internal static MbsResult AuthenticateEmployee(ZBUserDetails employee) { using (ZBWorksDBContext dbContext = new ZBWorksDBContext()) { ZB_USERDETAILS matchingEmployee = dbContext.ZBUSERDETAILs.Where(src => src.EmployeeName == employee.EmployeeName && src.Password == employee.Password).FirstOrDefault(); //cheking and feching data from DB if (matchingEmployee == null) { return(new MbsResult(false, "Invalid credentails")); } ZBUserDetails retVal = new ZBUserDetails() { EmployeeName = matchingEmployee.EmployeeName, InternalEmployeeID = matchingEmployee.InternalEmployeeID, Role = matchingEmployee.Role, }; return(new MbsResult(true, retVal)); } }
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, "")); } }