//public Leave_App_VW GetJOingDate(string CmpyCode,) //{ //} public Leave_App_VW SaveLeaveApp(Leave_App_VW LeaveApp) { //bool t= _CodeRep.GetSalaryProcess(LeaveApp.CmpyCode, LeaveApp.EmpCode, LeaveApp.StartDate); // if(t==false) // { // LeaveApp.ErrorMessage = "Salary Process Genereted this Month...You can not Change ...!"; // LeaveApp.IsSavedFlag = false; // return LeaveApp; // } if (!LeaveApp.IsEditMode) { LeaveApp.PRLR001_CODE = _CodeRep.GetCode(LeaveApp.CmpyCode, "LeaveApplication"); } LeaveApp.COUNTRY = _CodeRep.GetCountryP(LeaveApp.CmpyCode, LeaveApp.Entry_Dates); LeaveApp.DIVISION = _CodeRep.GetDiv(LeaveApp.CmpyCode, LeaveApp.EmpCode); if (LeaveApp.COUNTRY == null) { LeaveApp.IsSavedFlag = false; LeaveApp.ErrorMessage = "PayRoll Config not Generated"; return(LeaveApp); } else { return(_LeaveAppRepo.SaveLeaveApp(LeaveApp)); } }
public Leave_App_VW GetLeaveAppDetailsEdit(string CmpyCode, string code) { ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRLR001 where CmpyCode='" + CmpyCode + "' and PRLR001_CODE='" + code + "' "); dt = ds.Tables[0]; Leave_App_VW LeaveApp1 = new Leave_App_VW(); foreach (DataRow dr in dt.Rows) { LeaveApp1.ApprovalYN = dr["ApprovalYN"].ToString(); //LeaveApp1.Branch = dr["Branch"].ToString(); LeaveApp1.CmpyCode = dr["CmpyCode"].ToString(); LeaveApp1.COUNTRY = dr["COUNTRY"].ToString(); // LeaveApp1.Dept = dr["Dept"].ToString(); // LeaveApp1.DIVISION = dr["DIVISION"].ToString(); LeaveApp1.EmpCode = dr["EmpCode"].ToString(); LeaveApp1.Entry_Dates = Convert.ToDateTime(dr["Dates"].ToString()); LeaveApp1.JoiningDate = Convert.ToDateTime(dr["JoiningDate"].ToString()); LeaveApp1.EndDate = Convert.ToDateTime(dr["EndDate"].ToString()); LeaveApp1.StartDate = Convert.ToDateTime(dr["StartDate"].ToString()); LeaveApp1.Status = dr["Status"].ToString(); LeaveApp1.TotalApplied = dr["TotalApplied"].ToString(); LeaveApp1.TotalBalance = dr["TotalBalance"].ToString(); LeaveApp1.oldLeavedays = dr["LeaveDays"].ToString(); LeaveApp1.LeaveDays = dr["LeaveDays"].ToString(); LeaveApp1.TotalSanctioned = dr["TotalSanctioned"].ToString(); LeaveApp1.Remarks = dr["Remarks"].ToString(); LeaveApp1.LeaveType = dr["LeaveType"].ToString(); LeaveApp1.PRLR001_CODE = dr["PRLR001_CODE"].ToString(); } return(LeaveApp1); }
public ActionResult SaveLeaveApp(Leave_App_VW LeaveApp) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { LeaveApp.CmpyCode = list[0].CmpyCode.ToString(); LeaveApp.UserName = list[0].user_name; //LeaveApp.Branch = list[0].BraCode.ToString(); //LeaveApp.Dept = list[0].DepCode.ToString(); //LeaveApp.DIVISION = list[0].Divcode.ToString(); return(Json(_LeaveAppService.SaveLeaveApp(LeaveApp), JsonRequestBehavior.AllowGet)); } }
public Leave_App_VW SaveLeaveApp(Leave_App_VW LeaveApp) { bool cstatus = false; int n; string dtstr1, dtstr2, dtstr3, dtstr4 = null; DateTime dte; dte = Convert.ToDateTime(LeaveApp.StartDate.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); dte = Convert.ToDateTime(LeaveApp.EndDate.ToString()); dtstr2 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); dte = Convert.ToDateTime(LeaveApp.Entry_Dates.ToString()); dtstr3 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); dte = Convert.ToDateTime(LeaveApp.JoiningDate.ToString()); dtstr4 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); try { if (!LeaveApp.IsEditMode) { SqlParameter[] param1 = { new SqlParameter("@CmpyCode", LeaveApp.CmpyCode), new SqlParameter("@COUNTRY", LeaveApp.COUNTRY), new SqlParameter("@DIVISION", LeaveApp.DIVISION), new SqlParameter("@Entry_Dates", dtstr3), new SqlParameter("@EmpCode", LeaveApp.EmpCode), new SqlParameter("@JoiningDate", dtstr4), new SqlParameter("@LeaveType", LeaveApp.LeaveType), new SqlParameter("@StartDate", dtstr1), new SqlParameter("@EndDate", dtstr2), new SqlParameter("@LeaveDays", LeaveApp.LeaveDays), //new SqlParameter("@Remarks",LeaveApp.Remarks), new SqlParameter("@Remarks", !String.IsNullOrWhiteSpace(LeaveApp.Remarks) ? LeaveApp.Remarks : ""), new SqlParameter("@TotalBalance", !String.IsNullOrWhiteSpace(LeaveApp.TotalBalance) ? LeaveApp.TotalBalance :"0"), new SqlParameter("@TotalApplied", LeaveApp.TotalApplied), new SqlParameter("@TotalSanctioned", !String.IsNullOrWhiteSpace(LeaveApp.TotalSanctioned) ? LeaveApp.TotalSanctioned : "0"), new SqlParameter("@ApprovalYN", LeaveApp.ApprovalYN), new SqlParameter("@Status", LeaveApp.Status), }; cstatus = _EzBusinessHelper.ExecuteNonQuery("AddLeaveproc", param1); if (cstatus == true) { LeaveApp.IsSavedFlag = true; LeaveApp.ErrorMessage = string.Empty; } else { LeaveApp.IsSavedFlag = false; LeaveApp.ErrorMessage = "Duplicate Record"; } return(LeaveApp); } else { SqlParameter[] param1 = { new SqlParameter("@CmpyCode", LeaveApp.CmpyCode), new SqlParameter("@PRLR001_CODE", LeaveApp.PRLR001_CODE), new SqlParameter("@COUNTRY", LeaveApp.COUNTRY), new SqlParameter("@DIVISION", LeaveApp.DIVISION), new SqlParameter("@Entry_Dates", dtstr3), new SqlParameter("@EmpCode", LeaveApp.EmpCode), new SqlParameter("@JoiningDate", dtstr4), new SqlParameter("@LeaveType", LeaveApp.LeaveType), new SqlParameter("@StartDate", dtstr1), new SqlParameter("@EndDate", dtstr2), new SqlParameter("@LeaveDays", LeaveApp.LeaveDays), //! String.IsNullOrWhiteSpace(productName) ? productName : null // new SqlParameter("@Remarks",LeaveApp.Remarks), new SqlParameter("@Remarks", !String.IsNullOrWhiteSpace(LeaveApp.Remarks) ? LeaveApp.Remarks : ""), new SqlParameter("@TotalBalance", LeaveApp.TotalBalance), new SqlParameter("@oldLeavedays", LeaveApp.oldLeavedays), new SqlParameter("@TotalApplied", LeaveApp.TotalApplied), new SqlParameter("@TotalSanctioned", !String.IsNullOrWhiteSpace(LeaveApp.TotalSanctioned) ? LeaveApp.TotalSanctioned : "0"), new SqlParameter("@ApprovalYN", LeaveApp.ApprovalYN), new SqlParameter("@Status", LeaveApp.Status), }; cstatus = _EzBusinessHelper.ExecuteNonQuery("UpdateLeaveproc", param1); if (cstatus == true) { LeaveApp.IsSavedFlag = true; LeaveApp.ErrorMessage = string.Empty; } else { LeaveApp.IsSavedFlag = false; LeaveApp.ErrorMessage = "Duplicate Record"; } return(LeaveApp); } } catch (Exception ex) { LeaveApp.IsSavedFlag = false; LeaveApp.ErrorMessage = ex.Message; } return(LeaveApp); }