public DutyResumeVM GetDutyEdit(string Cmpycode, string LsNo) { DutyResumeVM du = null; //ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRDR001 where Cmpycode='" + Cmpycode + "' and PRDR001_CODE='" + LsNo +"'"); ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRDR001 a,PRLR001 b where a.Cmpycode='" + Cmpycode + "' and a.PRDR001_CODE='" + LsNo + "' and a.PRLR001_CODE = b.PRLR001_CODE and a.Cmpycode = b.Cmpycode"); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; du = new DutyResumeVM(); foreach (DataRow dr in dt.Rows) { du.Cmpycode = dr["Cmpycode"].ToString(); du.EmpCode = dr["EmpCode"].ToString(); du.ResumeDate = Convert.ToDateTime(dr["ResumeDate"].ToString()); du.PRLR001_CODE = dr["PRLR001_CODE"].ToString(); du.StartDate = Convert.ToDateTime(dr["StartDate"].ToString()); du.EndDate = Convert.ToDateTime(dr["EndDate"].ToString()); du.Actual_Leave_Type = dr["Actual_Leave_Type"].ToString(); du.Approve_Days = dr["Approve_Days"].ToString(); du.Approve_Days_in_full = dr["Approve_Days_in_full"].ToString(); du.Approve_Days_in_Half = dr["Approve_Days_in_Half"].ToString(); du.country = dr["country"].ToString(); du.division = dr["division"].ToString(); du.Excess_Days_plus_minus = dr["Excess_Days_plus_minus"].ToString(); du.PRDR001_CODE = dr["PRDR001_CODE"].ToString(); du.PRLS001_CODE = dr["PRLS001_CODE"].ToString(); du.BalanceLeave = dr["TotalBalance"].ToString(); // du.Remark = dr["Remark"].ToString(); //du.DrNo = dr["DrNo"].ToString(); } } return(du); }
public ActionResult SaveDrs(DutyResumeVM Drs) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Drs.Cmpycode = list[0].CmpyCode; Drs.UserName = list[0].user_name; return(Json(_DrService.SaveDrs(Drs), JsonRequestBehavior.AllowGet)); } }
public DutyResumeVM SaveDrs(DutyResumeVM Drs) { Drs.division = _codeRep.GetDiv(Drs.Cmpycode, Drs.EmpCode); Drs.country = _codeRep.GetCountryP(Drs.Cmpycode, Drs.ResumeDate); if (Drs.country == null) { Drs.SaveFlag = false; Drs.ErrorMessage = "PayRoll Config not Generated"; return(Drs); } else { return(_DrRepo.SaveDrs(Drs)); } // return _DrRepo.SaveDrs(Drs); }
public DutyResumeVM SaveDrs(DutyResumeVM Drs) { bool cstatus = false; int n; string dtstr1, dtstr2, dtstr3 = null; DateTime dte; dte = Convert.ToDateTime(Drs.EndDate.ToString()); dtstr3 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); //dte = Convert.ToDateTime(Drs.StartDate.ToString()); //dtstr2 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); dte = Convert.ToDateTime(Drs.ResumeDate.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); try { if (!Drs.EditFlag) { SqlParameter[] param1 = { new SqlParameter("@PRLR001_CODE", Drs.PRLR001_CODE), new SqlParameter("@CmpyCode", Drs.Cmpycode), new SqlParameter("@country", Drs.country), new SqlParameter("@division", Drs.division), new SqlParameter("@PRLS001_CODE", Drs.PRLS001_CODE), new SqlParameter("@Empcode", Drs.EmpCode), new SqlParameter("@ResumeDate", dtstr1), new SqlParameter("@Excess_Date", dtstr3), new SqlParameter("@Actual_Leave_Type", Drs.Actual_Leave_Type), new SqlParameter("@Duty_Rm_type", Drs.Duty_Rm_type), new SqlParameter("@Approve_Days", Drs.Approve_Days != null?Drs.Approve_Days:""), new SqlParameter("@Excess_Days_plus_minus", Drs.Excess_Days_plus_minus != null?Drs.Excess_Days_plus_minus:""), new SqlParameter("@Approve_Days_in_full", Drs.Approve_Days_in_full != null?Drs.Approve_Days_in_full:""), new SqlParameter("@Approve_Days_in_Half", Drs.Approve_Days_in_Half != null?Drs.Approve_Days_in_Half:"") }; cstatus = _EzBusinessHelper.ExecuteNonQuery("AddDutyResume", param1); if (cstatus == true) { Drs.SaveFlag = true; Drs.ErrorMessage = string.Empty; } else { Drs.SaveFlag = false; Drs.ErrorMessage = "Duplicate Record"; } return(Drs); } else { SqlParameter[] param1 = { new SqlParameter("@PRDR001_CODE", Drs.PRDR001_CODE), new SqlParameter("@PRLR001_CODE", Drs.PRLR001_CODE), new SqlParameter("@CmpyCode", Drs.Cmpycode), new SqlParameter("@country", Drs.country), new SqlParameter("@division", Drs.division), new SqlParameter("@PRLS001_CODE", Drs.PRLS001_CODE), new SqlParameter("@Empcode", Drs.EmpCode), new SqlParameter("@ResumeDate", dtstr1), new SqlParameter("@Excess_Date", dtstr3), new SqlParameter("@Actual_Leave_Type", Drs.Actual_Leave_Type), new SqlParameter("@Duty_Rm_type", Drs.Duty_Rm_type), new SqlParameter("@Approve_Days", Drs.Approve_Days), new SqlParameter("@Excess_Days_plus_minus", Drs.Excess_Days_plus_minus), new SqlParameter("@Approve_Days_in_full", Drs.Approve_Days_in_full), new SqlParameter("@Approve_Days_in_Half", Drs.Approve_Days_in_Half), new SqlParameter("@oldLeavedays", Drs.oldLeavedays) }; cstatus = _EzBusinessHelper.ExecuteNonQuery("UpdateDutyResume", param1); if (cstatus == true) { Drs.SaveFlag = true; Drs.ErrorMessage = string.Empty; } else { Drs.SaveFlag = false; Drs.ErrorMessage = "Duplicate Record"; } return(Drs); } } catch { Drs.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Drs); }