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