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