public ActionResult TimeSheetAuthorizedSaved(string ButtonType, TimeSheetBO timeSheetBO) { //timeSheetBO.NoOFShift = Convert.ToInt16(TempData["TotalShift" + timeSheetBO.ResourcesID.ToString()]); //timeSheetBO.TolShiftHrs = Convert.ToInt64(TempData["TotalShiftHrs" + timeSheetBO.ResourcesID.ToString()]); //timeSheetBO.TolHly = Convert.ToDouble(TempData["TotalHly" + timeSheetBO.ResourcesID.ToString()]); //timeSheetBO.TolHlyHours = Convert.ToDouble(TempData["TotalHlytHours" + timeSheetBO.ResourcesID.ToString()]); timeSheetBO.Payment = Convert.ToInt64(TempData["Payment" + timeSheetBO.ResourcesID.ToString()]); DateTime StatusDate; string Msg, status = ""; if (timeSheetBL.TimeSheetAuthorizedFun(timeSheetBO, out Msg, ButtonType, out status, out StatusDate)) { return(Json(new { success = true, errorMsg = Msg, AuthoStatus = status, AuthoStatusDate = StatusDate })); } else { return(Json(new { success = false, errorMsg = Msg, AuthoStatus = status, AuthoStatusDate = StatusDate })); } }
public ActionResult TimeSheet(TimeSheetView timeSheetView) { // = new TimeSheetView(); TempData["TimeSerachBO"] = timeSheetView.TsearchBBO; if (TempData["TimeSerachBO"] != null) { timeSheetView.TsearchBBO = TempData["TimeSerachBO"] as TimeSearchBO; } else { timeSheetView.TsearchBBO = new TimeSearchBO(); timeSheetView.TsearchBBO.MonthID = DateTime.Now.Month; timeSheetView.TsearchBBO.Year = DateTime.Now.Year.ToString(); } viewBagList(); TimeSheetBO timeSheetBO = new TimeSheetBO(); var timeSheetList = timeSheetBL.GetfilterTimeSheet(timeSheetView.TsearchBBO); timeSheetView.timeSheetBBO = new TimeSheetBO(); timeSheetView.timeSheetView = timeSheetList; TempData["TimeSerachBO"] = timeSheetView.TsearchBBO; return(View(timeSheetView)); }
//Authorized & UnAuthorized the Timesheet Resources Details public bool TimeSheetAuthorizedFun(TimeSheetBO timeSheetBO, out string Msg, string ButtonType, out string status, out DateTime StatusDate) { Msg = ""; // Authorized if (ButtonType == "Authorized") { if (timeSheetBO.TimesheetID == null) { try { Resource_TimeSheet authorized = new Resource_TimeSheet(); authorized.ResourceID = db.Resource_Employee.Where(x => x.EmployeeID == timeSheetBO.ResourcesID).Select(x => x.EmployeeID).FirstOrDefault(); authorized.TimeSheetDate = (DateTime)(timeSheetBO.TimeSheetDate == null ? timeSheetBO.dtDethTime1 :timeSheetBO.TimeSheetDate); authorized.TimeSheetFrequencyID = db.Common_TimeSheetFrequency.Where(x => x.TimeSheetFrequencyID == timeSheetBO.FrequencyID).Select(x => x.TimeSheetFrequencyID).FirstOrDefault(); authorized.TimeSheetAuthorizationDate = DateTime.Now; authorized.Approved = "Yes"; authorized.LockedBy = HttpContext.Current.User.Identity.Name; authorized.LockedDateTime = DateTime.Now; authorized.Comments = "No Comments "; authorized.NoOfShift = timeSheetBO.NoOFShift; authorized.TotalShiftHours = (double)(timeSheetBO.TolShiftHrs == null ? 0: timeSheetBO.TolShiftHrs); authorized.NoOfHolidays = (double)(timeSheetBO.TolHly == null ? 0 : timeSheetBO.TolHly); authorized.NoOfHolidayHours = (double)(timeSheetBO.TolHlyHours == null ? 0 : timeSheetBO.TolHlyHours); authorized.IsAct = true; authorized.Payment = (double)timeSheetBO.Payment; db.Resource_TimeSheet.Add(authorized); db.SaveChanges(); Msg = "Timesheet Is Successfully Authorized For " + timeSheetBO.TimeSheetDate + " Date"; status = "Authorized"; StatusDate = DateTime.Now; return(true); } catch (Exception e) { StatusDate = DateTime.Now; status = timeSheetBO.Status; Msg = e.Message; return(false); } } else { //Re Authorized var isExitTimesheet = db.Resource_TimeSheet.Where(x => x.TimeSheetID == timeSheetBO.TimesheetID && x.TimeSheetAuthorizationDate == null).SingleOrDefault(); if (isExitTimesheet != null) { try { isExitTimesheet.ResourceID = db.Resource_Employee.Where(x => x.EmployeeID == timeSheetBO.ResourcesID).Select(x => x.EmployeeID).FirstOrDefault(); isExitTimesheet.TimeSheetDate = (DateTime)(timeSheetBO.TimeSheetDate == null ? timeSheetBO.dtDethTime1 : timeSheetBO.TimeSheetDate); isExitTimesheet.TimeSheetFrequencyID = db.Common_TimeSheetFrequency.Where(x => x.TimeSheetFrequencyID == timeSheetBO.FrequencyID).Select(x => x.TimeSheetFrequencyID).FirstOrDefault(); isExitTimesheet.TimeSheetAuthorizationDate = DateTime.Now; isExitTimesheet.Approved = "Yes"; isExitTimesheet.LockedBy = HttpContext.Current.User.Identity.Name; isExitTimesheet.LockedDateTime = DateTime.Now; isExitTimesheet.Comments = "No Comments "; isExitTimesheet.NoOfShift = timeSheetBO.NoOFShift; isExitTimesheet.TotalShiftHours = (double)(timeSheetBO.TolShiftHrs == null ? 0 : timeSheetBO.TolShiftHrs); isExitTimesheet.NoOfHolidays = (double)(timeSheetBO.TolHly == null ? 0 : timeSheetBO.TolHly); isExitTimesheet.NoOfHolidayHours = (double)(timeSheetBO.TolHlyHours == null ? 0 : timeSheetBO.TolHlyHours); isExitTimesheet.IsAct = true; isExitTimesheet.Payment = (double)timeSheetBO.Payment; db.SaveChanges(); Msg = "Timesheet Is Successfully Authorized For " + timeSheetBO.TimeSheetDate + " Date "; status = "Authorized"; StatusDate = DateTime.Now; return(true); } catch (Exception e) { status = timeSheetBO.Status; Msg = e.Message; StatusDate = DateTime.Now; return(false); } } else { Msg = " Timesheet Is Already Authorized For " + db.Resource_TimeSheet.Where(x => x.ResourceID == timeSheetBO.ResourcesID && x.TimeSheetDate.Month == timeSheetBO.MonthID).Select(x => x.TimeSheetDate).SingleOrDefault() + "Date"; status = timeSheetBO.Status; StatusDate = DateTime.Now; return(false); } } } //UnAuthorized The Resources Details else { var isExitUnAuzedTimesheet = db.Resource_TimeSheet.SingleOrDefault(x => x.TimeSheetID == timeSheetBO.TimesheetID && x.TimeSheetAuthorizationDate != null); if (isExitUnAuzedTimesheet != null) { try { isExitUnAuzedTimesheet.TimeSheetAuthorizationDate = null; isExitUnAuzedTimesheet.IsAct = false; db.SaveChanges(); Msg = "Timesheet Is Successfully UnAuthorized For" + timeSheetBO.TimeSheetDate + "Date"; status = "UnAuthorized"; StatusDate = DateTime.Now; return(true); } catch (Exception e) { status = timeSheetBO.Status; Msg = e.Message; StatusDate = DateTime.Now; return(false); } } // Fail UnAuthorized else { status = timeSheetBO.Status; Msg = "Timesheet Is Already UnAuthorized For" + timeSheetBO.TimeSheetDate + "Date"; StatusDate = DateTime.Now; return(false); } } }