public SalaryProcessDetailsVM SaveSalaryProcessD(SalaryProcessDetailsVM salary)
{
if (!salary.EditFlag)
{
salary.PRSP001_Code = _CodeRep.GetCode(salary.CmpyCode, "SalaryProcess");
}
return(_salaryrepo.SaveSalaryProcessD(salary));
}
public ActionResult SaveSalaryProcess(SalaryProcessDetailsVM 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(_SalService.SaveSalaryProcessD(salarym), JsonRequestBehavior.AllowGet));
}
}
public SalaryProcessDetailsVM GetSalaryProcessEdit(string CmpyCode, string salaryCode)
{
ds = _EzBusinessHelper.ExecuteDataSet("select * from PRSP001 where CmpyCode='" + CmpyCode + "' and PRSP001_CODE='" + salaryCode + "' and Flag=0");
dt = ds.Tables[0];
SalaryProcessDetailsVM drc = new SalaryProcessDetailsVM();
foreach (DataRow dr in dt.Rows)
{
drc.CmpyCode = dr["CmpyCode"].ToString();
drc.PRSP001_Code = dr["PRSP001_Code"].ToString();
drc.Country = dr["Country"].ToString();
drc.DivisionCode = dr["Division"].ToString();
drc.VisaLocation1 = dr["VisaLocation"].ToString();
drc.year = Convert.ToInt32(dr["Tyear"].ToString());
drc.Month = Convert.ToInt32(dr["Tmonth"].ToString());
drc.Process_Date = Convert.ToDateTime(dr["Process_Date"].ToString());
}
return(drc);
}
public ActionResult GetCalculatedSalaryDetails(SalaryProcessDetailsVM 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";
}
List <SalaryProcessDetailsListItem> data = _SalService.GetSalaryProcessGrid(list[0].CmpyCode, slryVM.Process_Date, slryVM.DivisionCode, slryVM.Deptcode, slryVM.VisaLocation1);
// 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.country.ToString().ToLower().Contains(search.ToLower()) ||
p.Tmonth.ToString().ToLower().Contains(search.ToLower()) ||
p.Tyear.ToString().ToLower().Contains(search.ToLower()) ||
p.cmpycode.ToString().ToLower().Contains(search.ToLower()) ||
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 SalaryProcessDetailsVM SaveSalaryProcessD(SalaryProcessDetailsVM SPDV)
{
string deptcode1 = SPDV.Deptcode == "0" ? "" : SPDV.Deptcode;
string vloc1 = SPDV.VisaLocation1 == "0" ? "" : SPDV.VisaLocation1;
string Month = "";
string year = "";
List <SalaryProcessDetailsListItem> objList = null;
try
{
var Drecord = new List <string>();
List <SalaryProcessDetailsListItem> ObjList = new List <SalaryProcessDetailsListItem>();
ObjList.AddRange(SPDV.salaryList.Select(m => new SalaryProcessDetailsListItem
{
//country = m.country,
//Division = m.Division,
//Tyear = m.Tyear,
//Tmonth = m.Tmonth,
Empcode = m.Empcode,
//Empname = m.Empname,
//ProfCode = m.ProfCode,
//DepCode = m.DepCode,
//ComnPrjcode = m.ComnPrjcode,
//VisaLocation = m.VisaLocation,
//WorkLocation = m.WorkLocation,
//Total_Days = m.Total_Days,
//Worked_Days = m.Worked_Days,
//loan_amt = m.loan_amt,
//adn_amount = m.adn_amount,
//ExtraOTAmt = m.ExtraOTAmt,
//NOTAmt = m.NOTAmt,
//HOTAmt = m.HOTAmt,
//WOTAmt = m.WOTAmt,
//NetSalary = m.NetSalary,
//flag = m.flag,
//Salary_Paid = m.Salary_Paid,
//Incentive_Paid = m.Incentive_Paid
}).ToList());
int n = 0;
int countl = 0;
n = ObjList.Count;
if (!SPDV.EditFlag)
{
using (TransactionScope scope1 = new TransactionScope())
{
DateTime dte = Convert.ToDateTime(SPDV.Process_Date);
string saldate = dte.ToString("yyyy-MM-dd");
Month = dte.ToString("MM");
DateTime dte1 = Convert.ToDateTime(SPDV.Process_Date);
year = dte.ToString("yyyy");
string yeardata = SPDV.Process_Date.ToString("yyyy");
string monthdata = SPDV.Process_Date.ToString("MM");
SqlParameter[] param = { new SqlParameter("@CmpyCode", SPDV.CmpyCode),
new SqlParameter("@DivCode", SPDV.DivisionCode),
new SqlParameter("@Year", yeardata),
new SqlParameter("@Month", monthdata),
new SqlParameter("@UserName", SPDV.UserName),
new SqlParameter("@PRSP001_CODE", SPDV.PRSP001_Code),
new SqlParameter("Process_Date", SPDV.Process_Date),
new SqlParameter("@DeptCode", deptcode1),
new SqlParameter("@visaloction", vloc1) };
bool result = _EzBusinessHelper.ExecuteNonQuery("usp_SaveDataSalaryProcess", param);
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + PurchaseMgmtConstants.SalaryProcessHeader + "' ");
if (result == true)
{
while (n > 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.ExecuteScalar("select count(*) from PRLA001 prl inner join PRLA002 la on prl.PRLA001_CODE=la.PRLA001_CODE and prl.CmpyCode=la.CmpyCode where EmpCode='" + ObjList[n - 1].Empcode + "' and la.TMONTH='" + Month + "' and la.TYEAR='" + year + "'");
if (loanstatus > 0)
{
countl = _EzBusinessHelper.ExecuteNonQuery("UPDATE A SET Paid = 'Y' from PRLA002 A INNER JOIN PRLA001 RA ON A.PRLA001_CODE = RA.PRLA001_CODE and a.CmpyCode = ra.CmpyCode where a.TMONTH ='" + Month + "' and a.TYEAR ='" + year + "' and ra.EmpCode ='" + ObjList[n - 1].Empcode + "' and a.CmpyCode ='" + SPDV.CmpyCode + "'");
}
n = n - 1;
}
}
//if (bool flg == true)
//{
//_EzBusinessHelper.ExecuteNonQuery(" UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + PurchaseMgmtConstants.SalaryProcessHeader + "'");
// _EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + PurchaseMgmtConstants.SalaryProcessHeader + "'");
_EzBusinessHelper.ActivityLog(SPDV.CmpyCode, SPDV.UserName, "Add Salary Process", SPDV.PRSP001_Code, Environment.MachineName);
SPDV.SaveFlag = true;
SPDV.ErrorMessage = string.Empty;
//}
scope1.Complete();
}
return(SPDV);
}
else
{
using (TransactionScope scope = new TransactionScope())
{
while (n > 0)
{
var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from PRSPD001 where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + SPDV.PRSP001_Code + "' and Flag=0");
if (StatsEdit != 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("CmpyCode='" + SPDV.CmpyCode + "',");
//sb.Append("Sno='" + ObjList[n - 1].Sno + "',");
//sb.Append("Code='" + ObjList[n - 1].Code + "',");
//sb.Append("EmpName='" + ObjList[n - 1].EmpName + "',");
//sb.Append("ProjectCode='"+ ObjList[n - 1].ProjectCode + "',");
//sb.Append("EmpCode='" + ObjList[n - 1].EmpCode + "',");
//sb.Append("WorkingDay='" + ObjList[n - 1].WorkingDay + "',");
//sb.Append("Present='" + ObjList[n - 1].Present + "',");
//sb.Append("LossDays='" + ObjList[n - 1].LossDays + "',");
//sb.Append("Absent='" + ObjList[n - 1].Absent + "',");
//sb.Append("Leaves='" + ObjList[n - 1].Leaves + "',");
//sb.Append("SickLeave='" + ObjList[n - 1].SickLeaves + "',");
//sb.Append("WeeklyOff='" + ObjList[n - 1].WeeklyOff + "',");
//sb.Append("Holiday='" + ObjList[n - 1].Holiday + "',");
//sb.Append("NormalOTHrs='" + ObjList[n - 1].NormalOTHrs + "',");
//sb.Append("HolidayOTHrs='" + ObjList[n - 1].HolidayOTHrs + "',");
//sb.Append("WeeklyOffOTHrs='" + ObjList[n - 1].WeeklyOffOTHrs + "',");
//sb.Append("ExtraOTHrs='" + ObjList[n - 1].ExtraOTHrs + "',");
//sb.Append("FExtraOTHrs='" + ObjList[n - 1].FExtraOTHrs + "',");
//sb.Append("TotalAddition='" + ObjList[n - 1].MonthlyAddition + "',");
//sb.Append("TotalEarning='" + ObjList[n - 1].TotalEarning + "',");
//sb.Append("TotalDeduction='" + ObjList[n - 1].TotalDeduction + "',");
//sb.Append("LoanDeduction='" + ObjList[n - 1].LoanDeduction + "',");
sb.Append("NetSalary='" + ObjList[n - 1].NetSalary + "')");
_EzBusinessHelper.ExecuteNonQuery("update PRSPD001 set'" + sb.ToString() + "' where compycode='" + SPDV.CmpyCode + "'and code='" + SPDV.PRSP001_Code + "' and Flag=0 ");
_EzBusinessHelper.ActivityLog(SPDV.CmpyCode, SPDV.UserName, "Update Salary Process", SPDV.PRSP001_Code, Environment.MachineName);
SPDV.SaveFlag = true;
SPDV.ErrorMessage = string.Empty;
}
else
{
SPDV.SaveFlag = false;
SPDV.ErrorMessage = "Record not available";
}
n = n - 1;
}
var SalaryEdit = _EzBusinessHelper.ExecuteNonQuery("Select * from PRSPH001 where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + SPDV.PRSP001_Code + "' and Flag=0");
if (SalaryEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update PRSPH001 set CmpyCode='" + SPDV.CmpyCode + "',Code='" + SPDV.PRSP001_Code + "',Month='" + Month + "',year='" + year + "' where CmpyCode='" + SPDV.CmpyCode + "' and Code='" + SPDV.PRSP001_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);
}