public object PeOfficeClockIn(string remoteClockData) { using (var dtx = new DataContextEF()) { StaffClockModel remoteClock = dtx.StaffClockData.First(x => x.Staff.StaffClockCardNumber.Equals(remoteClockData.Split('-').Last())); if (remoteClock != null) { remoteClock.DataStatus = 0; remoteClock.ClockDateTime = DateTime.Now; remoteClock.RecordStatus = "Active"; remoteClock.StaffId = GetStaffIdByCardNumber(remoteClock.StaffId); remoteClock.Comments = remoteClock.Comments + ("PE office clock in"); dtx.StaffClockData.Add(remoteClock); dtx.SaveChanges(); object obj = new { Name = remoteClock.Staff.StaffFullName, Time = DateTime.Now.TimeOfDay, CardNumber = remoteClock.Staff.StaffClockCardNumber }; return(Request.CreateResponse(HttpStatusCode.OK, obj)); } return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } }
public void Test_EF_CreatingStaffWorkingHours() { var ctx = new DataContextEF(); foreach (var staff in ctx.Staff.ToList()) { if ((staff.StaffHoursData == null) || (staff.StaffHoursData.Count == 0)) { for (int i = 0; i < 7; i++) { staff.StaffHoursData.Add( new StaffHoursModel { DayId = i + 1, DayTimeStart = Convert.ToDateTime("08:00:00"), DayLunchLength = 1, DayTimeEnd = Convert.ToDateTime("17:00:00"), RecordStatus = "Active", StaffId = staff.StaffId } ); } } } ctx.SaveChanges(); }
public void Test_EF_ProcessClockingData() { using (var ctx = new DataContextEF()) { var isHoliday = ctx.IsHolidayToday(); UoWStaff.ProcessClocking(); ctx.SaveChanges(); } }
public void Test_EF_Create_Staff() { var ctx = new DataContextEF(); var staff = new StaffModel { StaffId = Guid.NewGuid(), StaffName = "Quentin", StaffSurname = "Barnard", StaffIdNumber = "780418", RecordStatus = "Active", StaffDivision = ctx.BranchDivisions.FirstOrDefault() }; ctx.Staff.Add(staff); ctx.SaveChanges(); }
public static string UpdatePhoneStatus(string phoneStatus, string mac) { using (var dtx = new DataContextEF()) { var staffPhone = dtx.PhoneDetails.Include("StaffMember").FirstOrDefault(x => x.RecordStatus.Equals("Active") && x.StaffPhoneMac.Equals(mac)); if (staffPhone != null) { staffPhone.StaffMember.StaffPhoneStatus = phoneStatus; //staffPhone.StaffMember.PhoneDataStatus = Convert.ToInt32(phoneStatus); } dtx.SaveChanges(); if (staffPhone != null && staffPhone.StaffMember != null) { return("Hello " + staffPhone.StaffMember.StaffFullName + "....... You called me from the phone"); } } return("Hello Anonymous"); }
public bool RemoteClockIn(StaffClockModel remoteClock) { remoteClock.RecordStatus = "Active"; remoteClock.StaffId = GetStaffIdByEmail(remoteClock.Email); remoteClock.Comments = remoteClock.Comments + (". This clock in is of an appointment the staff member was in"); try { using (DataContextEF dataContext = new DataContextEF()) { dataContext.StaffClockData.Add(remoteClock); dataContext.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public static bool ClearOldTonerOrders() { using (var contextEf = new DataContextEF()) { var openTonerOrders = contextEf.TonerOrderDetails.Where(x => x.OrderStatus == (int)OrderStatus.Opened).ToList(); if (!openTonerOrders.Any()) { return(false); } else if (openTonerOrders.Any()) { for (int i = 0; i < openTonerOrders.Count; i++) { TonerOrderDetailsModel order = openTonerOrders[i]; var data = contextEf.TonerOrders.FirstOrDefault(x => x.OrderId.Equals(order.OrderId)); if (data != null) { TonerOrdersModel ordersModel = data; openTonerOrders[i].TonerOrder = ordersModel; } if (order.TonerOrder.OrderDate.Date.AddDays(2) > order.TonerOrder.OrderDate.Date) { } } var mailer = new Emailer(); mailer.subject = MessageList.Open_Toner_Orders_Subject; mailer.body = MessageList.Open_Toner_Orders_Body; mailer.TOList.Add(WebConfigurationManager.AppSettings["SupportEmail"]); mailer.SendEmail(); contextEf.SaveChanges(); return(true); } } return(false); }