public bool saveMonthlySchedule(int ID, DateTime startday, DateTime endday) { Monthly_Schedule select = base.db.Monthly_Schedule.Where(u => u.UserID == ID).FirstOrDefault(); if (getUserById(ID) != null) { if (select == null) { select = new Monthly_Schedule(); select.BeginDay = startday; select.EndDay = endday; select.UserID = ID; base.db.Monthly_Schedule.Add(select); base.db.SaveChanges(); } else { select.BeginDay = startday; select.EndDay = endday; base.db.SaveChanges(); } return(true); } else { return(false); } }
public String Count(int ID) { try { Roll_Call check = base.db.Roll_Call.Where(c => c.UserID == ID).FirstOrDefault(); Monthly_Schedule set = base.db.Monthly_Schedule.Where(m => m.UserID == ID).FirstOrDefault(); String output = null; if (set != null) { if (check == null) { check = new Roll_Call(); check.Count = true; check.UserID = ID; check.Created = DateTime.Today; base.db.Roll_Call.Add(check); base.db.SaveChanges(); } else { if (DateTime.Compare(Convert.ToDateTime(check.Created.ToString()), DateTime.Today) == 0) { output = "AlreadyCount"; } else { check.Count = true; check.Created = DateTime.Today; base.db.SaveChanges(); } } if (output != "AlreadyCount") { set.TotalCount = (set.TotalCount != null) ? (set.TotalCount + 1) : (1); base.db.SaveChanges(); return("true"); } return(output); } else { return("MonthlyScheduleNotSet"); } } catch (Exception) { return("false"); } }
public ActionResult Index() { int ID = SessionContext.CurrentUser().ID; Monthly_Schedule userMonth = _provider.getDataMonth(ID); Salary userSalary = _provider.getSalaryOfUserByID(ID); PaymentPerDay paymen = _provider.getPaymentOfUserById(ID); ViewBag.Salary = userSalary.Payment; ViewBag.TotalSalary = Convert.ToDateTime(userMonth.EndDay.ToString()).Day *paymen.Money; ViewBag.TotalDay = Convert.ToDateTime(userMonth.EndDay.ToString()).Day; ViewBag.TotalRollCountday = userMonth.TotalCount; ViewBag.Fullname = SessionContext.CurrentUser().Firstname + " " + SessionContext.CurrentUser().Lastname; ViewBag.TotalUser = _provider.getAllUser().Count(); return(View()); }
public Salary getSalaryOfUserByID(int ID) { try { Monthly_Schedule select = base.db.Monthly_Schedule.Where(u => u.UserID == ID).FirstOrDefault(); PaymentPerDay paymentOfDay = base.db.PaymentPerDays.Where(u => u.UserID == ID).FirstOrDefault(); Double salary = 0; if (select != null) { if (paymentOfDay == null) { paymentOfDay = base.db.PaymentPerDays.Where(u => u.UserID == null).FirstOrDefault(); } salary = Convert.ToInt32(select.TotalCount) * Convert.ToDouble(paymentOfDay.Money); Salary UserSalary = base.db.Salaries.Where(u => u.UserID == ID).FirstOrDefault(); if (UserSalary != null) { UserSalary.Payment = Convert.ToDecimal(salary); base.db.SaveChanges(); return(UserSalary); } else { UserSalary = new Salary(); UserSalary.MonthID = select.ID; UserSalary.UserID = ID; UserSalary.Payment = Convert.ToDecimal(salary); UserSalary.PayMentOfUserID = paymentOfDay.ID; base.db.Salaries.Add(UserSalary); base.db.SaveChanges(); return(UserSalary); } } else { return(null); } } catch (Exception ex) { return(null); } }
public bool isMonthlyScheduleSet(int ID) { try { Monthly_Schedule select = base.db.Monthly_Schedule.Where(u => u.UserID == ID).FirstOrDefault(); if (select != null) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }