public void AddHalfLeaveToLeaveData(LvApplication lvappl) { DateTime datetime = new DateTime(); datetime = lvappl.FromDate; string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd"); LvData _LVData = new LvData(); _LVData.EmpID = lvappl.EmpID; _LVData.EmpDate = _EmpDate; _LVData.Remarks = lvappl.LvReason; _LVData.HalfLeave = true; _LVData.LvID = lvappl.LvID; _LVData.AttDate = datetime.Date; _LVData.LvCode = lvappl.LvType; _LVData.FirstHalf = lvappl.FirstHalf; try { using (var db = new TAS2013Entities()) { db.LvDatas.Add(_LVData); db.SaveChanges(); } } catch (Exception ex) { } // Balance Leaves from Emp Table BalanceLeaves(lvappl); }
public bool AddLeaveToLeaveData(LvApplication lvappl) { DateTime datetime = new DateTime(); datetime = lvappl.FromDate; for (int i = 0; i < lvappl.NoOfDays; i++) { string _EmpDate = lvappl.EmpID + datetime.Date.ToString("yyMMdd"); LvData _LVData = new LvData(); _LVData.EmpID = lvappl.EmpID; _LVData.EmpDate = _EmpDate; _LVData.Remarks = lvappl.LvReason; _LVData.LvID = lvappl.LvID; _LVData.AttDate = datetime.Date; _LVData.LvCode = lvappl.LvType; _LVData.CompanyID = lvappl.CompanyID; try { using (var context = new TAS2013Entities()) { context.LvDatas.Add(_LVData); context.SaveChanges(); } } catch (Exception ex) { } datetime = datetime.AddDays(1); // Balance Leaves from Emp Table } BalanceLeaves(lvappl); return true; }