public ActionResult SaveMonthly(MonthlyAdddedVM Monthly) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Monthly.CmpyCode = list[0].CmpyCode; Monthly.UserName = list[0].user_name; return(Json(_MonthlyAdddedService.SaveMonthlyAD(Monthly), JsonRequestBehavior.AllowGet)); } }
public MonthlyAdddedVM GetMonthlyADEdit(string CmpyCode, string PRADN001_CODE) { ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRADN001 where CmpyCode='" + CmpyCode + "' and PRADN001_CODE='" + PRADN001_CODE + "' and Flag=0 "); dt = ds.Tables[0]; MonthlyAdddedVM MonthlyAD = new MonthlyAdddedVM(); foreach (DataRow dr in dt.Rows) { MonthlyAD.Entry_Date = Convert.ToDateTime(dr["Entry_Date"].ToString()); MonthlyAD.TMonth = Convert.ToInt32(dr["TMonth"].ToString()); MonthlyAD.TYear = Convert.ToInt32(dr["TYear"].ToString()); MonthlyAD.PRADN001_CODE = dr["PRADN001_CODE"].ToString(); //MonthlyAD.MonthlyAddded = GetMonthlyADGrid(CmpyCode, PRADN001_CODE); } return(MonthlyAD); }
public MonthlyAdddedVM SaveMonthlyAD(MonthlyAdddedVM MonthlyAD) { if (!MonthlyAD.EditFlag) { MonthlyAD.PRADN001_CODE = _CodeRep.GetCode(MonthlyAD.CmpyCode, "MonthlyAddded"); } MonthlyAD.COUNTRY = _CodeRep.GetCountryP(MonthlyAD.CmpyCode, MonthlyAD.Entry_Date); if (MonthlyAD.COUNTRY == null) { MonthlyAD.SaveFlag = false; MonthlyAD.ErrorMessage = "PayRoll Config not Generated"; return(MonthlyAD); } else { return(_MonthlyAdddedPayrollRepo.SaveMonthlyAD(MonthlyAD)); } }
public MonthlyAdddedVM SaveMonthlyAD(MonthlyAdddedVM MonthlyAD) { string dtstr1 = null; DateTime dte; dte = Convert.ToDateTime(MonthlyAD.Entry_Date.ToString()); dtstr1 = dte.ToString("yyyy-MM-dd hh:mm:ss tt"); int n; if (!MonthlyAD.EditFlag) { MonthlyAdddedMst pt = new MonthlyAdddedMst(); int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + MonthlyAD.CmpyCode + "' and Code='PRADN' "); //pt.PRBM001_code = string.Concat("PRBM", "-", (pno + 1).ToString().PadLeft(4, '0')).ToString(); List <MonthlyAdddeddet1> ObjList = new List <MonthlyAdddeddet1>(); ObjList.AddRange(MonthlyAD.MonthlyAddded.Select(m => new MonthlyAdddeddet1 { ADN_Act_code = m.ADN_Act_code, ADN_Amount = m.ADN_Amount, EmpCode = m.EmpCode, EmpName = m.EmpName, Remarks = m.Remarks, T_type = m.T_type, }).ToList()); try { using (TransactionScope scope = new TransactionScope()) { _EzBusinessHelper.ExecuteNonQuery("insert into PRADN001(PRADN001_CODE,COUNTRY,CmpyCode,Entry_Date,TYear,TMonth) values('" + MonthlyAD.PRADN001_CODE + "','" + MonthlyAD.COUNTRY + "','" + MonthlyAD.CmpyCode + "','" + dtstr1 + "','" + MonthlyAD.TYear + "','" + MonthlyAD.TMonth + "')"); n = ObjList.Count; while (n > 0) { _EzBusinessHelper.ExecuteNonQuery("insert into PRADN002(PRADN001_CODE,CmpyCode,EmpCode,EmpName,ADN_Amount,ADN_Act_code,T_type,Remarks) values('" + MonthlyAD.PRADN001_CODE + "','" + MonthlyAD.CmpyCode + "','" + ObjList[n - 1].EmpCode + "','" + ObjList[n - 1].EmpName + "','" + ObjList[n - 1].ADN_Amount + "','" + ObjList[n - 1].ADN_Act_code + "','" + ObjList[n - 1].T_type + "','" + ObjList[n - 1].Remarks + "')"); n = n - 1; } _EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + MonthlyAD.CmpyCode + "' and Code='PRADN'"); MonthlyAD.SaveFlag = true; MonthlyAD.ErrorMessage = string.Empty; scope.Complete(); } } catch (Exception) { MonthlyAD.SaveFlag = false; MonthlyAD.ErrorMessage = "error occur"; } } else { n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRADN001 where CmpyCode='" + MonthlyAD.CmpyCode + "' and PRADN001_CODE='" + MonthlyAD.PRADN001_CODE + "' "); if (n != 0) { MonthlyAdddedMst pt = new MonthlyAdddedMst(); //int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + MonthlyAD.CmpyCode + "' and Code='PRBM' "); //pt.PRBM001_code = string.Concat("PRBM", "-", (pno + 1).ToString().PadLeft(4, '0')).ToString(); List <MonthlyAdddeddet1> ObjList = new List <MonthlyAdddeddet1>(); ObjList.AddRange(MonthlyAD.MonthlyAddded.Select(m => new MonthlyAdddeddet1 { ADN_Act_code = m.ADN_Act_code, ADN_Amount = m.ADN_Amount, EmpCode = m.EmpCode, EmpName = m.EmpName, Remarks = m.Remarks, T_type = m.T_type, }).ToList()); try { using (TransactionScope scope1 = new TransactionScope()) { _EzBusinessHelper.ExecuteNonQuery("delete from PRADN001 where CmpyCode='" + MonthlyAD.CmpyCode + "' and PRADN001_CODE='" + MonthlyAD.PRADN001_CODE + "'"); _EzBusinessHelper.ExecuteNonQuery("delete from PRADN002 where CmpyCode='" + MonthlyAD.CmpyCode + "' and PRADN001_CODE='" + MonthlyAD.PRADN001_CODE + "'"); _EzBusinessHelper.ExecuteNonQuery("insert into PRADN001(PRADN001_CODE,COUNTRY,CmpyCode,Entry_Date,TYear,TMonth) values('" + MonthlyAD.PRADN001_CODE + "','" + MonthlyAD.COUNTRY + "','" + MonthlyAD.CmpyCode + "','" + dtstr1 + "','" + MonthlyAD.TYear + "','" + MonthlyAD.TMonth + "')"); n = ObjList.Count; while (n > 0) { _EzBusinessHelper.ExecuteNonQuery("insert into PRADN002(PRADN001_CODE,CmpyCode,EmpCode,EmpName,ADN_Amount,ADN_Act_code,T_type,Remarks) values('" + MonthlyAD.PRADN001_CODE + "','" + MonthlyAD.CmpyCode + "','" + ObjList[n - 1].EmpCode + "','" + ObjList[n - 1].EmpName + "','" + ObjList[n - 1].ADN_Amount + "','" + ObjList[n - 1].ADN_Act_code + "','" + ObjList[n - 1].T_type + "','" + ObjList[n - 1].Remarks + "')"); n = n - 1; } MonthlyAD.SaveFlag = true; MonthlyAD.ErrorMessage = string.Empty; scope1.Complete(); } } catch (Exception) { MonthlyAD.SaveFlag = false; MonthlyAD.ErrorMessage = "error occur"; } } else { MonthlyAD.SaveFlag = true; MonthlyAD.ErrorMessage = "Error occur"; } } return(MonthlyAD); }