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