public ActionResult SaveSalryProcessPaymentDetails(SalaryProcessDVM salarym)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
salarym.CMPYCODE = list[0].CmpyCode;
salarym.UserName = list[0].user_name;
return(Json(_SalpaymntService.SaveSalryProcessPaymentDetails(salarym), JsonRequestBehavior.AllowGet));
}
}
public SalaryProcessDVM GetsalryprocessPaymentEdit(string CmpyCode, string PRSPD001_COD)
{
ds = _EzBusinessHelper.ExecuteDataSet("select * from PRSPD001 where CmpyCode='" + CmpyCode + "' and PRSPD001_CODE='" + PRSPD001_COD + "' and Flag=0");
dt = ds.Tables[0];
SalaryProcessDVM drc = new SalaryProcessDVM();
foreach (DataRow dr in dt.Rows)
{
drc.CMPYCODE = dr["CmpyCode"].ToString();
drc.PRSPD001_CODE = dr["PRSPD001_CODE"].ToString();
drc.COUNTRY = dr["Country"].ToString();
drc.DIVISION = dr["Division"].ToString();
drc.WORKLOCATION = dr["WORKLOCATION"].ToString();
drc.TYEAR = Convert.ToInt32(dr["Tyear"].ToString());
drc.TMONTH = Convert.ToInt32(dr["Tmonth"].ToString());
drc.PAIDTYPE = Convert.ToInt32(dr["PAIDTYPE"].ToString());
}
return(drc);
}
public List <SalaryprocesspaymentDetails> GetSalaryPrcessDetailsList(SalaryProcessDVM slrypymnt)
{
//string deptcode1 = deptcode == "0" ? "" : deptcode;
//string vloc1 = Visalocation1 == "0" ? "" : Visalocation1;
List <SalaryprocesspaymentDetails> objList = null;
string yeardata = slrypymnt.SalProcess_Date.ToString("yyyy");
string monthdata = slrypymnt.SalProcess_Date.ToString("MM");
// var lastDayOfMonth = DateTime.DaysInMonth(Convert.ToInt32(currDate.ToString("yyyy")), Convert.ToInt32(currDate.ToString("MM")));
SqlParameter[] param = { new SqlParameter("@CmpyCode", slrypymnt.CMPYCODE),
new SqlParameter("@divcode", slrypymnt.DIVISION),
new SqlParameter("@Year", yeardata),
//new SqlParameter("@PAIDTYPE", slrypymnt.PAIDTYPE),
// new SqlParameter("@VisaLocation1",vloc1),
new SqlParameter("@Month", monthdata) };
// new SqlParameter("@lastdate",lastDayOfMonth)};
ds = _EzBusinessHelper.ExecuteDataSet("sp_GetSalaryProcessDetailsforBankStatus", CommandType.StoredProcedure, param);
if (ds.Tables.Count >= 0)
{
dt = ds.Tables[0];
DataRowCollection drc = dt.Rows;
objList = new List <SalaryprocesspaymentDetails>();
foreach (DataRow dr in drc)
{
objList.Add(new SalaryprocesspaymentDetails()
{
// PRSPD001_CODE = dr["PRSPD001_CODE"].ToString(),
EMPCODE = dr["Empcode"].ToString(),
EMPNAME = dr["Empname"].ToString(),
BANKCODE = dr["PRBM001_code"].ToString(),
BANKName = dr["Bank_name"].ToString(),
BRANCHCODE = dr["PRBM002_code"].ToString(),
BANkBrachName = dr["Bank_branch_name"].ToString(),
AMOUNT = Convert.ToDouble(dr["NetSalary"].ToString()),
ACCOUNTNO = dr["Account_no"].ToString(),
// PAID_TYPE = dr["Empname"].ToString(),
srno = Convert.ToInt32(dr["srno"].ToString()),
});
}
}
return(objList);
}
public SalaryProcessDVM SaveSalryProcessPaymentDetails(SalaryProcessDVM sly)
{
return(_slpay.SaveSalryProcessPaymentDetails(sly));
}
public List <SalaryprocesspaymentDetails> GetSalaryPrcessDetailsList(SalaryProcessDVM slypymnt)
{
return(_slpay.GetSalaryPrcessDetailsList(slypymnt));
}
public ActionResult GetSalaryProcessDetails(SalaryProcessDVM slryVM)
{
JsonResult result = new JsonResult();
try
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
// Initialization.
string search = Request.Form.GetValues("search[value]")[0];
string draw = Request.Form.GetValues("draw")[0];
string order = Request.Form.GetValues("order[0][column]")[0];
string orderDir = Request.Form.GetValues("order[0][dir]")[0];
int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);
if (pageSize == -1)
{
draw = "2";
}
slryVM.CMPYCODE = list[0].CmpyCode;
List <SalaryprocesspaymentDetails> data = _SalpaymntService.GetSalaryPrcessDetailsList(slryVM);
// Total record count.
int totalRecords = 0;
if (data != null)
{
totalRecords = data.Count;
}
else
{
totalRecords = 0;
}
// Verification.
if (!string.IsNullOrEmpty(search) &&
!string.IsNullOrWhiteSpace(search))
{
// Apply search
data = data.Where(p => p.srno.ToString().ToLower().Contains(search.ToLower()) ||
p.EMPCODE.ToLower().Contains(search.ToLower()) ||
p.EMPNAME.ToString().ToLower().Contains(search.ToLower()) ||
p.BANKCODE.ToString().ToLower().Contains(search.ToLower()) ||
p.BANKName.ToString().ToLower().Contains(search.ToLower()) ||
p.BANkBrachName.ToString().ToLower().Contains(search.ToLower()) ||
p.BRANCHCODE.ToString().ToLower().Contains(search.ToLower()) ||
p.ACCOUNTNO.ToString().ToLower().Contains(search.ToLower())).ToList();
//p.ProfCode.ToString().ToLower().Contains(search.ToLower()) ||
//p.DepCode.ToString().ToLower().Contains(search.ToLower()) ||
//p.ComnPrjcode.ToString().ToLower().Contains(search.ToLower()) ||
//p.Division.ToString().ToLower().Contains(search.ToLower()) ||
//p.VisaLocation.ToString().ToLower().Contains(search.ToLower()) ||
//p.WorkLocation.ToString().ToLower().Contains(search.ToLower()) ||
//p.Total_Days.ToString().ToLower().Contains(search.ToLower()) ||
//p.Worked_Days.ToString().ToLower().Contains(search.ToLower()) ||
//p.VisaLocation.ToString().ToLower().Contains(search.ToLower()) ||
//p.loan_amt.ToString().ToLower().Contains(search.ToLower()) ||
//p.adn_amount.ToString().ToLower().Contains(search.ToLower()) ||
//p.nothrs.ToString().ToLower().Contains(search.ToLower()) ||
//p.extraOThrs.ToString().ToLower().Contains(search.ToLower()) ||
//p.hothrs.ToString().ToLower().Contains(search.ToLower())).ToList();
}
// Sorting.
data = this.salaryprocessColumnWithOrder(order, orderDir, data);
// Filter record count.
int recFilter = data.Count;
if (pageSize != -1)
{
data = data.Skip(startRec).Take(pageSize).ToList();
}
else
{
data = data.ToList();
}
// Loading drop down lists.
result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = data }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
// Return info.
return(result);
}
public SalaryProcessDVM SaveSalryProcessPaymentDetails(SalaryProcessDVM SPDV)
{
// string deptcode1 = SPDV.Deptcode == "0" ? "" : SPDV.Deptcode;
// string vloc1 = SPDV.VisaLocation1 == "0" ? "" : SPDV.VisaLocation1;
string Month = "";
string year = "";
bool rowStatus = false, rowStatus1 = false;
List <SalaryprocesspaymentDetails> objList = null;
try
{
DateTime dte = Convert.ToDateTime(SPDV.SalProcess_Date);
string saldate = dte.ToString("yyyy-MM-dd");
Month = dte.ToString("MM");
DateTime dte1 = Convert.ToDateTime(SPDV.SalProcess_Date);
year = dte.ToString("yyyy");
string yeardata = SPDV.SalProcess_Date.ToString("yyyy");
string monthdata = SPDV.SalProcess_Date.ToString("MM");
var Drecord = new List <string>();
List <SalaryprocesspaymentDetails> ObjList = new List <SalaryprocesspaymentDetails>();
ObjList.AddRange(SPDV.salaryList.Select(m => new SalaryprocesspaymentDetails
{
srno = m.srno,
EMPCODE = m.EMPCODE,
EMPNAME = m.EMPNAME,
BANKCODE = m.BANKCODE,
BRANCHCODE = m.BRANCHCODE,
ACCOUNTNO = m.ACCOUNTNO,
AMOUNT = m.AMOUNT,
Paid = m.Paid
}).ToList());
int n = 0;
int countl = 0;
n = ObjList.Count;
if (!SPDV.EditFlag)
{
using (TransactionScope scope1 = new TransactionScope())
{
string countrry = _EzBusinessHelper.ExecuteScalarS("select COUNTRY from PRCNF001 where FINYEARS='" + yeardata + "' and FINMONTH='" + monthdata + "' and CMPYCODE='" + SPDV.CMPYCODE + "' and Flag=0");
while (n > 0)
{
int count = _EzBusinessHelper.ExecuteScalar("select count(*) from PRSPD002 sp inner join PRSPD001 sp2 on sp.PRSPD001_CODE=sp2.PRSPD001_CODE where Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and sp.Flag=0 and sp2.Flag=0 and EMPCODE='" + ObjList[n - 1].EMPCODE + "'");
if (count == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + SPDV.PRSPD001_CODE + "',");
sb.Append("'" + ObjList[n - 1].EMPCODE + "',");
sb.Append("'" + ObjList[n - 1].EMPNAME + "',");
sb.Append("'" + ObjList[n - 1].BANKCODE + "',");
sb.Append("'" + ObjList[n - 1].BRANCHCODE + "',");
sb.Append("'" + ObjList[n - 1].ACCOUNTNO + "',");
sb.Append("'" + ObjList[n - 1].AMOUNT + "',");
sb.Append("'" + SPDV.PAIDTYPE + "')");
// sb.Append("'" + ObjList[n - 1].UniCodeName + "')");
rowStatus = _EzBusinessHelper.ExecuteNonQuery1("insert into PRSPD002(PRSPD001_CODE,EMPCODE,EMPNAME,BANKCODE,BRANCHCODE,ACCOUNTNO,AMOUNT,PAID_TYPE) values(" + sb.ToString() + "");
//Deps.SaveFlag = true;
//Deps.ErrorMessage = string.Empty;
if (rowStatus == true)
{
if (SPDV.PAIDTYPE == 1)
{
// decimal Stats1 = _EzBusinessHelper.ExecuteScalarDec("Select count(*) as [count1] from PRSP002 where CmpyCode='" + SPDV.CmpyCode + "' and flag=0 and empcode='" + ObjList[n - 1].Empcode + "'");
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set Salary_paid='Y' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
if (SPDV.PAIDTYPE == 0)
{
// decimal Stats1 = _EzBusinessHelper.ExecuteScalarDec("Select count(*) as [count1] from PRSP002 where CmpyCode='" + SPDV.CmpyCode + "' and flag=0 and empcode='" + ObjList[n - 1].Empcode + "'");
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set incentive_paid='Y' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
}
}
else
{
//Drecord.Add(ObjList[n - 1].EMPCODE.ToString());
// SPDV.deco = Drecord;
SPDV.SaveFlag = false;
SPDV.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
int maxcount = _EzBusinessHelper.ExecuteScalar("select COUNT(*) from prspd0011");
int rowcount = maxcount + 1;
if (rowStatus == true)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + rowcount + "',");
sb.Append("'" + SPDV.PRSPD001_CODE + "',");
sb.Append("'" + SPDV.CMPYCODE + "',");
sb.Append("'" + countrry + "',");
sb.Append("'" + SPDV.DIVISION + "',");
sb.Append("'',");
sb.Append("'" + yeardata + "',");
sb.Append("'" + monthdata + "',");
sb.Append("'" + SPDV.PAIDTYPE + "')");
// sb.Append("'" + ObjList[n - 1].UniCodeName + "')");
rowStatus1 = _EzBusinessHelper.ExecuteNonQuery1("insert into PRSPD001(PRSPD001_UID,PRSPD001_CODE,CMPYCODE,COUNTRY,DIVISION,WORKLOCATION,TYEAR,TMONTH,PAIDTYPE) values(" + sb.ToString() + "");
}
if (rowStatus1 == true)
{
_EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos =Nos+1 where CmpyCode='" + SPDV.CMPYCODE + "' and Code='PRSPD'");
_EzBusinessHelper.ActivityLog(SPDV.CMPYCODE, SPDV.UserName, "Add Salary Process Detail", SPDV.PRSPD001_CODE, Environment.MachineName);
SPDV.SaveFlag = true;
SPDV.ErrorMessage = string.Empty;
}
scope1.Complete();
}
}
else
{
using (TransactionScope scope = new TransactionScope())
{
var statsedit = _EzBusinessHelper.ExecuteScalarDec("select count(*) from PRSPD001 where CMPYCODE='" + SPDV.CMPYCODE + "' and PRSPD001_CODE='" + SPDV.PRSPD001_CODE + "' and flag=0");
if (statsedit != 0)
{
while (n > 0)
{
_EzBusinessHelper.ExecuteNonQuery1("update PRSPD002 set PAID_TYPE=" + ObjList[n - 1].Paid + " where PRSPD001_CODE='" + SPDV.PRSPD001_CODE + "' and EMPCODE='" + ObjList[n - 1].EMPCODE + "'");
if (SPDV.PAIDTYPE == 1)
{
if (ObjList[n - 1].Paid == 0)
{
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set Salary_paid='N' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
if (ObjList[n - 1].Paid == 1)
{
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set Salary_paid='Y' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
// decimal Stats1 = _EzBusinessHelper.ExecuteScalarDec("Select count(*) as [count1] from PRSP002 where CmpyCode='" + SPDV.CmpyCode + "' and flag=0 and empcode='" + ObjList[n - 1].Empcode + "'");
}
if (SPDV.PAIDTYPE == 0)
{
// decimal Stats1 = _EzBusinessHelper.ExecuteScalarDec("Select count(*) as [count1] from PRSP002 where CmpyCode='" + SPDV.CmpyCode + "' and flag=0 and empcode='" + ObjList[n - 1].Empcode + "'");
if (ObjList[n - 1].Paid == 0)
{
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set incentive_paid='N' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
if (ObjList[n - 1].Paid == 1)
{
int loanstatus = _EzBusinessHelper.ExecuteNonQuery("update PRSP002 set incentive_paid='Y' where Empcode='" + ObjList[n - 1].EMPCODE + "' and Division='" + SPDV.DIVISION + "' and Tyear='" + year + "' and Tmonth='" + Month + "' and cmpycode='" + SPDV.CMPYCODE + "' and Flag=0");
}
}
// _ezbusinesshelper.executenonquery("update prspd001 set'" + sb.tostring() + "' where compycode='" + spdv.cmpycode + "'and code='" + spdv.prspd001_code + "' and flag=0 ");
// _ezbusinesshelper.activitylog(spdv.cmpycode, spdv.username, "update salary process", spdv.prspd001_code, environment.machinename);
n = n - 1;
}
StringBuilder sb = new StringBuilder();
sb.Append("CMPYCODE='" + SPDV.CMPYCODE + "',");
sb.Append("PRSPD001_CODE='" + SPDV.PRSPD001_CODE + "',");
sb.Append("DIVISION='" + SPDV.DIVISION + "',");
sb.Append("TYEAR='" + yeardata + "',");
sb.Append("TMONTH='" + monthdata + "',");
sb.Append("PAIDTYPE='" + SPDV.PAIDTYPE + "'");
//sb.Append("workingday='" + objlist[n - 1].workingday + "',");
//sb.Append("present='" + objlist[n - 1].present + "',");
////sb.append("lossdays='" + objlist[n - 1].lossdays + "',");
bool status = _EzBusinessHelper.ExecuteNonQuery1("update PRSPD001 set " + sb.ToString() + " where CMPYCODE='" + SPDV.CMPYCODE + "' and PRSPD001_CODE='" + SPDV.PRSPD001_CODE + "'");
SPDV.SaveFlag = true;
SPDV.ErrorMessage = string.Empty;
}
else
{
SPDV.SaveFlag = false;
SPDV.ErrorMessage = "record not available";
}
//var salaryedit = _ezbusinesshelper.executenonquery("select * from prsph001 where cmpycode='" + spdv.cmpycode + "' and code='" + spdv.prspd001_code + "' and flag=0");
//if (salaryedit != 0)
//{
// _ezbusinesshelper.executenonquery("update prsph001 set cmpycode='" + spdv.cmpycode + "',code='" + spdv.prspd001_code + "',month='" + month + "',year='" + year + "' where cmpycode='" + spdv.cmpycode + "' and code='" + spdv.prspd001_code + "' and flag=0");
// spdv.saveflag = true;
// spdv.errormessage = string.empty;
//}
//else
//{
// SPDV.SaveFlag = false;
// SPDV.ErrorMessage = "record not available";
//}
scope.Complete();
}
}
}
catch (Exception ex)
{
SPDV.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(SPDV);
}
