public JsonResult GetSalaryPackageDetails(string salaryPackageId) { int nSalaryPackageId = int.Parse(salaryPackageId); SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); SalaryPackageDetailsSP spSalaryPackageDetils = new SalaryPackageDetailsSP(); SalaryPackageInfo infoSalaryPackage = new SalaryPackageInfo(); string jsonDetails = ""; if (nSalaryPackageId > 0) { infoSalaryPackage = spSalaryPackage.SalaryPackageView(nSalaryPackageId); DataTable dtblSalaryPackageDetails = spSalaryPackageDetils.SalaryPackageDetailsViewWithSalaryPackageId(nSalaryPackageId); jsonDetails = Utils.ConvertDataTabletoString(dtblSalaryPackageDetails); } PayHeadSP spPayhead = new PayHeadSP(); DataTable dtblPayheads = spPayhead.PayHeadViewAll(); string jsonPayheads = Utils.ConvertDataTabletoString(dtblPayheads); return(Json(new { isSuccess = true, message = "success", data = new { salaryPackageId = infoSalaryPackage.SalaryPackageId, salaryPackageName = infoSalaryPackage.SalaryPackageName, narration = infoSalaryPackage.Narration, isActive = infoSalaryPackage.IsActive, salaryPackageDetails = jsonDetails, payHeads = jsonPayheads } })); }
public List <DataTable> PayHeadViewAll() { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPPayHead.PayHeadViewAll(); } catch (Exception ex) { MessageBox.Show("PBBLL:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill PayHead combobox /// </summary> public void PayHeadComboFill() { try { PayHeadSP spPayHead = new PayHeadSP(); DataTable dtblPayHead = spPayHead.PayHeadViewAll(); DataRow dr = dtblPayHead.NewRow(); dr[2] = "All"; dtblPayHead.Rows.InsertAt(dr, 0); cmbPayHead.DataSource = dtblPayHead; cmbPayHead.ValueMember = "payHeadId"; cmbPayHead.DisplayMember = "payHeadName"; } catch (Exception ex) { MessageBox.Show("PHR:1 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }