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