public ActionResult SaveSry(SalarMpayrollVM Sry)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Sry.CMPYCODE = list[0].CmpyCode;
Sry.UserName = list[0].user_name;
return(Json(_SalzService.SaveSry(Sry), JsonRequestBehavior.AllowGet));
}
}
public SalarMpayrollVM GetSalaryEdit(string CMPYCODE, string PRSM001_CODE)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRSMS001 where CmpyCode='" + CMPYCODE + "' and PRSM001_CODE='" + PRSM001_CODE + "' and Flag=0 ");
dt = ds.Tables[0];
SalarMpayrollVM pr = new SalarMpayrollVM();
foreach (DataRow dr in dt.Rows)
{
CMPYCODE = dr["CMPYCODE"].ToString();
//pr.PRSM001UID = Convert.ToInt16(dr["PRSM001UID"].ToString());
pr.PRSM001_CODE = dr["PRSM001_CODE"].ToString();
pr.DIVISION = dr["DIVISION"].ToString();
pr.COUNTRY = dr["COUNTRY"].ToString();
pr.EMPCODE = dr["EMPCODE"].ToString();
pr.Entery_date = Convert.ToDateTime(dr["Entery_date"].ToString());
pr.Effect_From = Convert.ToDateTime(dr["Effect_From"].ToString());
pr.BASIC = Convert.ToDecimal(dr["BASIC"].ToString());
pr.BASICCAPTION = dr["BASICCAPTION"].ToString();
pr.BASICACT = dr["BASICACT"].ToString();
pr.HRA = Convert.ToDecimal(dr["HRA"].ToString());
pr.HRACAPTION = dr["HRACAPTION"].ToString();
pr.HRAACT = dr["HRAACT"].ToString();
pr.DA = Convert.ToDecimal(dr["DA"].ToString());
pr.DACAPTION = dr["DACAPTION"].ToString();
pr.DAACT = dr["DAACT"].ToString();
pr.TELE = Convert.ToDecimal(dr["TELE"].ToString());
pr.TELECAPTION = dr["TELECAPTION"].ToString();
pr.TELEACT = dr["TELEACT"].ToString();
pr.TRANS = Convert.ToDecimal(dr["TRANS"].ToString());
pr.TRANSCAPTION = dr["TRANSCAPTION"].ToString();
pr.TRANSACT = dr["TRANSACT"].ToString();
pr.CAR = Convert.ToDecimal(dr["CAR"].ToString());
pr.CARCAPTION = dr["CARCAPTION"].ToString();
pr.CARACT = dr["CARACT"].ToString();
pr.ALLOWANCE1 = Convert.ToDecimal(dr["ALLOWANCE1"].ToString());
pr.ALLOWANCE1CAPTION = dr["ALLOWANCE1CAPTION"].ToString();
pr.ALLOWANCE1ACT = dr["ALLOWANCE1ACT"].ToString();
pr.ALLOWANCE2 = Convert.ToDecimal(dr["ALLOWANCE2"].ToString());
pr.ALLOWANCE2CAPTION = dr["ALLOWANCE2CAPTION"].ToString();
pr.ALLOWANCE2ACT = dr["ALLOWANCE2ACT"].ToString();
pr.ALLOWANCE3 = Convert.ToDecimal(dr["ALLOWANCE3"].ToString());
pr.ALLOWANCE3CAPTION = dr["ALLOWANCE3CAPTION"].ToString();
pr.ALLOWANCE3ACT = dr["ALLOWANCE3ACT"].ToString();
pr.TOTAL = Convert.ToDecimal(dr["TOTAL"].ToString());
}
return(pr);
}
public SalarMpayrollVM SaveSry(SalarMpayrollVM Sry)
{
if (!Sry.EditFlag)
{
Sry.PRSM001_CODE = _codeRep.GetCode(Sry.CMPYCODE, "Salary Master");
}
Sry.COUNTRY = _codeRep.GetCountryP(Sry.CMPYCODE, Sry.Entery_date);
Sry.DIVISION = _codeRep.GetDiv(Sry.CMPYCODE, Sry.EMPCODE);
if (Sry.COUNTRY == null)
{
Sry.SaveFlag = false;
Sry.ErrorMessage = "PayRoll Config not Generated";
return(Sry);
}
else
{
return(_SalzPayrollRepo.SaveSry(Sry));
}
}
public SalarMpayrollVM SaveSry(SalarMpayrollVM Sry)
{
int n;
string dtstr, dtstr1 = null;
try
{
if (!Sry.EditFlag)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from PRSMS001 where CmpyCode='" + Sry.CMPYCODE + "' and PRSM001_CODE='" + Sry.PRSM001_CODE + "'");
dt = ds.Tables[0];
int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + Sry.CMPYCODE + "' and Code='PRSM' ");
int Sry1 = 0;
foreach (DataRow dr in dt.Rows)
{
Sry1 = int.Parse(dr["count1"].ToString());
}
if (Sry1 == 0)
{
DateTime dt1 = Convert.ToDateTime(Sry.Entery_date.ToString());
dtstr = dt1.ToString("yyyy-MM-dd");
DateTime dt2 = Convert.ToDateTime(Sry.Effect_From.ToString());
dtstr1 = dt2.ToString("yyyy-MM-dd");
StringBuilder sb = new StringBuilder();
//sb.Append("'" + Sry.PRSM001UID + "',");
sb.Append("'" + Sry.PRSM001_CODE + "',");
sb.Append("'" + Sry.CMPYCODE + "',");
sb.Append("'" + Sry.DIVISION + "',");
sb.Append("'" + Sry.COUNTRY + "',");
sb.Append("'" + Sry.EMPCODE + "',");
sb.Append("'" + dtstr + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + Sry.BASIC + "',");
sb.Append("'" + Sry.BASICCAPTION + "',");
sb.Append("'" + Sry.BASICACT + "',");
sb.Append("'" + Sry.HRA + "',");
sb.Append("'" + Sry.HRACAPTION + "',");
sb.Append("'" + Sry.HRAACT + "',");
sb.Append("'" + Sry.DA + "',");
sb.Append("'" + Sry.DACAPTION + "',");
sb.Append("'" + Sry.DAACT + "',");
sb.Append("'" + Sry.TELE + "',");
sb.Append("'" + Sry.TELECAPTION + "',");
sb.Append("'" + Sry.TELEACT + "',");
sb.Append("'" + Sry.TRANS + "',");
sb.Append("'" + Sry.TRANSCAPTION + "',");
sb.Append("'" + Sry.TRANSACT + "',");
sb.Append("'" + Sry.CAR + "',");
sb.Append("'" + Sry.CARCAPTION + "',");
sb.Append("'" + Sry.CARACT + "',");
sb.Append("'" + Sry.ALLOWANCE1 + "',");
sb.Append("'" + Sry.ALLOWANCE1CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE1ACT + "',");
sb.Append("'" + Sry.ALLOWANCE2 + "',");
sb.Append("'" + Sry.ALLOWANCE2CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE2ACT + "',");
sb.Append("'" + Sry.ALLOWANCE3 + "',");
sb.Append("'" + Sry.ALLOWANCE3CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE3ACT + "',");
sb.Append("'" + Sry.TOTAL + "')");
//List<SalaryGrid> ObjList = new List<SalaryGrid>();
//ObjList.AddRange(Sry.SalaryMas.Select(m => new SalaryGrid
//{
// CmpyCode = m.CmpyCode,
// Code = m.Code,
// Amount = m.Amount.Value,
// Name = m.Name,
// Accountcode = m.Accountcode
// //CmpyCode = po.CmpyCode,
// //MRCode = pt.MRCode, //response.MRCode,
//}).ToList());
using (TransactionScope scope1 = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("insert into PRSMS001(PRSM001_CODE,CMPYCODE,DIVISION,COUNTRY,EMPCODE,Entery_date,Effect_From,BASIC,BASICCAPTION,BASICACT,HRA,HRACAPTION,HRAACT,DA,DACAPTION,DAACT,TELE,TELECAPTION,TELEACT,TRANS,TRANSCAPTION,TRANSACT,CAR,CARCAPTION,CARACT,ALLOWANCE1,ALLOWANCE1CAPTION,ALLOWANCE1ACT,ALLOWANCE2,ALLOWANCE2CAPTION,ALLOWANCE2ACT,ALLOWANCE3,ALLOWANCE3CAPTION,ALLOWANCE3ACT,TOTAL) values(" + sb.ToString() + "");
_EzBusinessHelper.ExecuteNonQuery(" UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + Sry.CMPYCODE + "' and Code='PRSM'");
_EzBusinessHelper.ActivityLog(Sry.CMPYCODE, Sry.UserName, "Add Salary Master", Sry.PRSM001_CODE, Environment.MachineName);
//n = ObjList.Count;
//while (n > 0)
//{
// _EzBusinessHelper.ExecuteNonQuery("insert into SHH004(CmpyCode,Code,Name,Accountcode,Amount) values('" + ObjList[n - 1].CmpyCode + "','" + ObjList[n - 1].Code + "','" + ObjList[n - 1].Name + "','" + ObjList[n - 1].Accountcode + "','" + ObjList[n - 1].Amount + "')");
// n = n - 1;
//}
Sry.SaveFlag = true;
Sry.ErrorMessage = string.Empty;
scope1.Complete();
}
}
}
else
{
n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRSMS001 where CmpyCode='" + Sry.CMPYCODE + "' and PRSM001_CODE='" + Sry.PRSM001_CODE + "' ");
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("Delete from PRSMS001 where CmpyCode='" + Sry.CMPYCODE + "' and PRSM001_CODE='" + Sry.PRSM001_CODE + "' ");
//_EzBusinessHelper.ExecuteNonQuery("Delete from SHH004 where CmpyCode='" + Sry.CMPYCODE + "' and PRSM001_CODE='" + Sry.PRSM001_CODE + "' ");
DateTime dt1 = Convert.ToDateTime(Sry.Entery_date.ToString());
dtstr = dt1.ToString("yyyy-MM-dd");
DateTime dt2 = Convert.ToDateTime(Sry.Effect_From.ToString());
dtstr1 = dt2.ToString("yyyy-MM-dd");
StringBuilder sb = new StringBuilder();
//sb.Append("'" + Sry.PRSM001UID + "',");
sb.Append("'" + Sry.PRSM001_CODE + "',");
sb.Append("'" + Sry.CMPYCODE + "',");
sb.Append("'" + Sry.DIVISION + "',");
sb.Append("'" + Sry.COUNTRY + "',");
sb.Append("'" + Sry.EMPCODE + "',");
sb.Append("'" + dtstr + "',");
sb.Append("'" + dtstr1 + "',");
sb.Append("'" + Sry.BASIC + "',");
sb.Append("'" + Sry.BASICCAPTION + "',");
sb.Append("'" + Sry.BASICACT + "',");
sb.Append("'" + Sry.HRA + "',");
sb.Append("'" + Sry.HRACAPTION + "',");
sb.Append("'" + Sry.HRAACT + "',");
sb.Append("'" + Sry.DA + "',");
sb.Append("'" + Sry.DACAPTION + "',");
sb.Append("'" + Sry.DAACT + "',");
sb.Append("'" + Sry.TELE + "',");
sb.Append("'" + Sry.TELECAPTION + "',");
sb.Append("'" + Sry.TELEACT + "',");
sb.Append("'" + Sry.TRANS + "',");
sb.Append("'" + Sry.TRANSCAPTION + "',");
sb.Append("'" + Sry.TRANSACT + "',");
sb.Append("'" + Sry.CAR + "',");
sb.Append("'" + Sry.CARCAPTION + "',");
sb.Append("'" + Sry.CARACT + "',");
sb.Append("'" + Sry.ALLOWANCE1 + "',");
sb.Append("'" + Sry.ALLOWANCE1CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE1ACT + "',");
sb.Append("'" + Sry.ALLOWANCE2 + "',");
sb.Append("'" + Sry.ALLOWANCE2CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE2ACT + "',");
sb.Append("'" + Sry.ALLOWANCE3 + "',");
sb.Append("'" + Sry.ALLOWANCE3CAPTION + "',");
sb.Append("'" + Sry.ALLOWANCE3ACT + "',");
sb.Append("'" + Sry.TOTAL + "')");
//List<SalaryGrid> ObjList = new List<SalaryGrid>();
//ObjList.AddRange(Sry.SalaryMas.Select(m => new SalaryGrid
//{
// CmpyCode = m.CmpyCode,
// Code = m.Code,
// Amount = m.Amount.Value,
// Name = m.Name,
// Accountcode = m.Accountcode
// //CmpyCode = po.CmpyCode,
// //MRCode = pt.MRCode, //response.MRCode,
//}).ToList());
_EzBusinessHelper.ExecuteNonQuery("insert into PRSMS001(PRSM001_CODE,CMPYCODE,DIVISION,COUNTRY,EMPCODE,Entery_date,Effect_From,BASIC,BASICCAPTION,BASICACT,HRA,HRACAPTION,HRAACT,DA,DACAPTION,DAACT,TELE,TELECAPTION,TELEACT,TRANS,TRANSCAPTION,TRANSACT,CAR,CARCAPTION,CARACT,ALLOWANCE1,ALLOWANCE1CAPTION,ALLOWANCE1ACT,ALLOWANCE2,ALLOWANCE2CAPTION,ALLOWANCE2ACT,ALLOWANCE3,ALLOWANCE3CAPTION,ALLOWANCE3ACT,TOTAL) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(Sry.CMPYCODE, Sry.UserName, "Update Salary Master", Sry.PRSM001_CODE, Environment.MachineName);
//n = ObjList.Count;
//while (n > 0)
//{
// _EzBusinessHelper.ExecuteNonQuery("insert into SHH004(CmpyCode,Code,Name,Accountcode,Amount) values('" + ObjList[n - 1].CmpyCode + "','" + ObjList[n - 1].Code + "','" + ObjList[n - 1].Name + "','" + ObjList[n - 1].Accountcode + "','" + ObjList[n - 1].Amount + "')");
// n = n - 1;
//}
Sry.ErrorMessage = string.Empty;
Sry.SaveFlag = true;
scope.Complete();
}
}
return(Sry);
}
catch
{
Sry.SaveFlag = false;
Sry.ErrorMessage = "Error Occur";
}
return(Sry);
}
