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