public ActionResult Create([Bind(Include = "SlID,EmpID,DutyDate,EmpDate,SHour,EHour,THour,Remarks,CreatedBy,ApprovedBy,Status")] LvShort lvshort,string SHour,string EHour) { string STimeIn = SHour; string STimeOut = EHour; string STimeInH = STimeIn.Substring(0, 2); string STimeInM = STimeIn.Substring(2, 2); string STimeOutH = STimeOut.Substring(0, 2); string STimeOutM = STimeOut.Substring(2, 2); lvshort.SHour = new TimeSpan(Convert.ToInt16(STimeInH), Convert.ToInt16(STimeInM), 0); lvshort.EHour = new TimeSpan(Convert.ToInt16(STimeOutH), Convert.ToInt16(STimeOutM), 0); if (lvshort.EHour < lvshort.SHour) { ModelState.AddModelError("EHour", "End hour required"); } if (Request.Form["EmpNo"].ToString() == "") { ModelState.AddModelError("EmpNo", "Emplyee No is required!"); } else { string _EmpNo = Request.Form["EmpNo"].ToString(); List<Emp> _emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo).ToList(); if (_emp.Count == 0) { ModelState.AddModelError("EmpNo", "Emp No not exist"); } else { lvshort.EmpID = _emp.FirstOrDefault().EmpID; lvshort.EmpDate = _emp.FirstOrDefault().EmpID.ToString() + lvshort.DutyDate.Value.ToString("yyMMdd"); lvshort.CreatedDate = DateTime.Today; lvshort.THour = lvshort.EHour - lvshort.SHour; } } if (lvshort.DutyDate == null) { ModelState.AddModelError("DutyDate", "DutyDate is required!"); } if (lvshort.SHour == null) { ModelState.AddModelError("SHour", "Start Time is required!"); } if (lvshort.EHour == null) { ModelState.AddModelError("EHour", "Ending Time is required!"); } if (ModelState.IsValid) { LeaveController LvProcessController = new LeaveController(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; lvshort.CreatedBy = _userID; lvshort.CompanyID = LoggedInUser.CompanyID; lvshort.Status = true; //The below LvShort checks if there is an already existing Lvshort for //this date. If there is an existing LvShort remove it from the database //, check if he has balance for causal leave and then add a causal leave // if (db.Options.FirstOrDefault().TwoShortLToOneCausal == true) { if (db.LvShorts.Where(aa => aa.EmpDate == lvshort.EmpDate).Count() > 0) { if (CheckForLQuota(lvshort) == true) { ShortLRemove(lvshort.EmpDate); switch (AddCausalLeave(lvshort)) { case 1: ModelState.AddModelError("Remarks", "Causal Leave Already exists"); break; case 2: db.SaveChanges(); break; case 3: ModelState.AddModelError("Remarks", "No Quota Defined for this Employee"); break; } return RedirectToAction("Index"); } else { ModelState.AddModelError("Remarks", "No Quota Defined for this Employee"); return View(lvshort); } } } //Check If its already made TimeSpan ehour = new TimeSpan(Convert.ToInt32(STimeOutH), Convert.ToInt32(STimeOutM), 0); TimeSpan shour = new TimeSpan(Convert.ToInt32(STimeInH), Convert.ToInt32(STimeInM), 0); if (db.LvShorts.Where(aa => aa.EmpDate == lvshort.EmpDate && (aa.SHour == shour || aa.EHour == ehour)).Count() > 0) ModelState.AddModelError("Remarks", "Short Leave Already Exists for this time duration"); else { db.LvShorts.Add(lvshort); db.SaveChanges(); LvProcessController.AddShortLeaveToAttData(lvshort); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.ShortLeave, (byte)MyEnums.Operation.Add, DateTime.Now); return RedirectToAction("Index"); } } return View(lvshort); }
public ActionResult Create([Bind(Include = "SlID,EmpID,DutyDate,EmpDate,SHour,EHour,THour,Remarks,CreatedBy,ApprovedBy,Status")] LvShort lvshort, string SHour, string EHour) { string STimeIn = SHour; string STimeOut = EHour; string STimeInH = STimeIn.Substring(0, 2); string STimeInM = STimeIn.Substring(2, 2); string STimeOutH = STimeOut.Substring(0, 2); string STimeOutM = STimeOut.Substring(2, 2); lvshort.SHour = new TimeSpan(Convert.ToInt16(STimeInH), Convert.ToInt16(STimeInM), 0); lvshort.EHour = new TimeSpan(Convert.ToInt16(STimeOutH), Convert.ToInt16(STimeOutM), 0); if (lvshort.EHour < lvshort.SHour) { ModelState.AddModelError("EHour", "End hour required"); } if (Request.Form["EmpNo"].ToString() == "") { ModelState.AddModelError("EmpNo", "Emplyee No is required!"); } else { string _EmpNo = Request.Form["EmpNo"].ToString(); List <Emp> _emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo).ToList(); if (_emp.Count == 0) { ModelState.AddModelError("EmpNo", "Emp No not exist"); } else { lvshort.EmpID = _emp.FirstOrDefault().EmpID; lvshort.EmpDate = _emp.FirstOrDefault().EmpID.ToString() + lvshort.DutyDate.Value.ToString("yyMMdd"); lvshort.CreatedDate = DateTime.Today; lvshort.THour = lvshort.EHour - lvshort.SHour; } } if (lvshort.DutyDate == null) { ModelState.AddModelError("DutyDate", "DutyDate is required!"); } if (lvshort.SHour == null) { ModelState.AddModelError("SHour", "Start Time is required!"); } if (lvshort.EHour == null) { ModelState.AddModelError("EHour", "Ending Time is required!"); } if (ModelState.IsValid) { LeaveController LvProcessController = new LeaveController(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; lvshort.CreatedBy = _userID; lvshort.CompanyID = LoggedInUser.CompanyID; lvshort.Status = true; //The below LvShort checks if there is an already existing Lvshort for //this date. If there is an existing LvShort remove it from the database //, check if he has balance for causal leave and then add a causal leave // if (db.Options.FirstOrDefault().TwoShortLToOneCausal == true) { if (db.LvShorts.Where(aa => aa.EmpDate == lvshort.EmpDate).Count() > 0) { if (CheckForLQuota(lvshort) == true) { ShortLRemove(lvshort.EmpDate); switch (AddCausalLeave(lvshort)) { case 1: ModelState.AddModelError("Remarks", "Causal Leave Already exists"); break; case 2: db.SaveChanges(); break; case 3: ModelState.AddModelError("Remarks", "No Quota Defined for this Employee"); break; } return(RedirectToAction("Index")); } else { ModelState.AddModelError("Remarks", "No Quota Defined for this Employee"); return(View(lvshort)); } } } //Check If its already made TimeSpan ehour = new TimeSpan(Convert.ToInt32(STimeOutH), Convert.ToInt32(STimeOutM), 0); TimeSpan shour = new TimeSpan(Convert.ToInt32(STimeInH), Convert.ToInt32(STimeInM), 0); if (db.LvShorts.Where(aa => aa.EmpDate == lvshort.EmpDate && (aa.SHour == shour || aa.EHour == ehour)).Count() > 0) { ModelState.AddModelError("Remarks", "Short Leave Already Exists for this time duration"); } else { db.LvShorts.Add(lvshort); db.SaveChanges(); LvProcessController.AddShortLeaveToAttData(lvshort); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.ShortLeave, (byte)MyEnums.Operation.Add, DateTime.Now); return(RedirectToAction("Index")); } } return(View(lvshort)); }
public ActionResult Create([Bind(Include = "SlID,EmpID,DutyDate,EmpDate,SHour,EHour,THour,Remarks,CreatedBy,ApprovedBy,Status")] LvShort lvshort, string SHour, string EHour) { string STimeIn = SHour; string STimeOut = EHour; string STimeInH = STimeIn.Substring(0, 2); string STimeInM = STimeIn.Substring(2, 2); string STimeOutH = STimeOut.Substring(0, 2); string STimeOutM = STimeOut.Substring(2, 2); lvshort.SHour = new TimeSpan(Convert.ToInt16(STimeInH), Convert.ToInt16(STimeInM), 0); lvshort.EHour = new TimeSpan(Convert.ToInt16(STimeOutH), Convert.ToInt16(STimeOutM), 0); if (lvshort.EHour < lvshort.SHour) { ModelState.AddModelError("EHour", "End hour required"); } if (Request.Form["EmpNo"].ToString() == "") { ModelState.AddModelError("EmpNo", "Emplyee No is required!"); } else { string _EmpNo = Request.Form["EmpNo"].ToString(); List <Emp> _emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo).OrderBy(s => s.EmpNo).ToList(); if (_emp.Count == 0) { ModelState.AddModelError("EmpNo", "Emp No not exist"); } else { lvshort.EmpID = _emp.FirstOrDefault().EmpID; lvshort.EmpDate = _emp.FirstOrDefault().EmpID.ToString() + lvshort.DutyDate.Value.ToString("yyMMdd"); lvshort.CreatedDate = DateTime.Today; lvshort.THour = lvshort.EHour - lvshort.SHour; } } if (lvshort.DutyDate == null) { ModelState.AddModelError("DutyDate", "DutyDate is required!"); } if (lvshort.SHour == null) { ModelState.AddModelError("SHour", "Start Time is required!"); } if (lvshort.EHour == null) { ModelState.AddModelError("EHour", "Ending Time is required!"); } if (ModelState.IsValid) { LeaveController LvProcessController = new LeaveController(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; lvshort.CreatedBy = _userID; lvshort.Status = true; db.LvShorts.Add(lvshort); db.SaveChanges(); LvProcessController.AddShortLeaveToAttData(lvshort); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.ShortLeave, (byte)MyEnums.Operation.Add, DateTime.Now); return(RedirectToAction("Index")); } return(View(lvshort)); }
public ActionResult Create([Bind(Include = "SlID,EmpID,DutyDate,EmpDate,SHour,EHour,THour,Remarks,CreatedBy,ApprovedBy,Status")] LvShort lvshort,string SHour,string EHour) { string STimeIn = SHour; string STimeOut = EHour; string STimeInH = STimeIn.Substring(0, 2); string STimeInM = STimeIn.Substring(2, 2); string STimeOutH = STimeOut.Substring(0, 2); string STimeOutM = STimeOut.Substring(2, 2); lvshort.SHour = new TimeSpan(Convert.ToInt16(STimeInH), Convert.ToInt16(STimeInM), 0); lvshort.EHour = new TimeSpan(Convert.ToInt16(STimeOutH), Convert.ToInt16(STimeOutM), 0); if (lvshort.EHour < lvshort.SHour) { ModelState.AddModelError("EHour", "End hour required"); } if (Request.Form["EmpNo"].ToString() == "") { ModelState.AddModelError("EmpNo", "Emplyee No is required!"); } else { string _EmpNo = Request.Form["EmpNo"].ToString(); List<Emp> _emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo).ToList(); if (_emp.Count == 0) { ModelState.AddModelError("EmpNo", "Emp No not exist"); } else { lvshort.EmpID = _emp.FirstOrDefault().EmpID; lvshort.EmpDate = _emp.FirstOrDefault().EmpID.ToString() + lvshort.DutyDate.Value.ToString("yyMMdd"); lvshort.CreatedDate = DateTime.Today; lvshort.THour = lvshort.EHour - lvshort.SHour; } } if (lvshort.DutyDate == null) { ModelState.AddModelError("DutyDate", "DutyDate is required!"); } if (lvshort.SHour == null) { ModelState.AddModelError("SHour", "Start Time is required!"); } if (lvshort.EHour == null) { ModelState.AddModelError("EHour", "Ending Time is required!"); } if (ModelState.IsValid) { LeaveController LvProcessController = new LeaveController(); int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); User LoggedInUser = Session["LoggedUser"] as User; lvshort.CreatedBy = _userID; lvshort.CompanyID = LoggedInUser.CompanyID; lvshort.Status = true; db.LvShorts.Add(lvshort); db.SaveChanges(); LvProcessController.AddShortLeaveToAttData(lvshort); HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.ShortLeave, (byte)MyEnums.Operation.Add, DateTime.Now); return RedirectToAction("Index"); } return View(lvshort); }