private bool SavePayHeadDetails(SalaryPackageDetailsSP spSalaryPackageDetails, string jsonDetails, int nSalaryPackageId)
{
bool isSave = false;
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(jsonDetails);
for (int i = 0; i < items.Count; i++)
{
SalaryPackageDetailsInfo infoSalaryPackageDetails = new SalaryPackageDetailsInfo();
infoSalaryPackageDetails.PayHeadId = Convert.ToDecimal(items[i]["payHeadId"]);
infoSalaryPackageDetails.Amount = Convert.ToDecimal(items[i]["Amount"]);
infoSalaryPackageDetails.Narration = items[i]["Narration"].ToString();
infoSalaryPackageDetails.SalaryPackageId = nSalaryPackageId;
infoSalaryPackageDetails.Extra1 = string.Empty;
infoSalaryPackageDetails.Extra2 = string.Empty;
if (spSalaryPackageDetails.SalaryPackageDetailsAdd(infoSalaryPackageDetails))
{
isSave = true;
}
else
{
isSave = false;
break;
}
}
}
catch (Exception ex)
{
isSave = false;
}
return(isSave);
}
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
}
}));
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
SalaryPackageDetailsSP spSalaryPackageDetails = new SalaryPackageDetailsSP();
DataTable dtbl = spSalaryPackageDetails.SalaryPackageDetailsForSalaryPackageDetailsReport(cmbSalaryPackage.Text);
dgvSalaryPackageDetails.DataSource = dtbl;
decCountAdditon = 0;
decCountDeduction = 0;
decTotalAmount = 0;
foreach (DataGridViewRow dgvRaw in dgvSalaryPackageDetails.Rows)
{
if (dgvRaw.Cells["dgvtxttype"].Value.ToString() == "Addition")
{
decimal decAmt = Convert.ToDecimal(dgvRaw.Cells["txtAmount"].Value.ToString());
decCountAdditon = decCountAdditon + decAmt;
}
else
{
decimal decAmt = Convert.ToDecimal(dgvRaw.Cells["txtAmount"].Value.ToString());
decCountDeduction = decCountDeduction + decAmt;
}
if (dgvRaw.Cells["txtAmount"].Value != null && dgvRaw.Cells["txtAmount"].Value.ToString() != "")
{
decimal decAmt = Convert.ToDecimal(dgvRaw.Cells["txtAmount"].Value.ToString());
decTotalAmount = decTotalAmount + decAmt;
}
}
txttotalReduction.Text = Math.Round(decCountDeduction, PublicVariables._inNoOfDecimalPlaces).ToString();
txttotalAddition.Text = Math.Round(decCountAdditon, PublicVariables._inNoOfDecimalPlaces).ToString(); //Convert.ToString(decCountAdditon);
txtTotal.Text = Math.Round(decTotalAmount, PublicVariables._inNoOfDecimalPlaces).ToString(); //Convert.ToString(decTotalAmount);
}
catch (Exception ex)
{
MessageBox.Show("SPDR:1" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On 'Print' button click to Print
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvSalaryPackageDetails.RowCount > 0)
{
DataTable dtblOther = new DataTable();
frmReport frmreport = new frmReport();
DataSet ds = new DataSet();
CompanySP spCompany = new CompanySP();
DataTable dtblCompany = spCompany.CompanyViewDataTable(1);
SalaryPackageDetailsSP spSalaryPackageDetails = new SalaryPackageDetailsSP();
DataTable dtbl = spSalaryPackageDetails.SalaryPackageDetailsForSalaryPackageDetailsReport(cmbSalaryPackage.Text);
ds.Tables.Add(dtblCompany);
ds.Tables.Add(dtbl);
ds.Tables.Add(dtblOther);
DataColumn dc = new DataColumn("Addition", typeof(decimal));
dtblOther.Columns.Add(dc);
dc = new DataColumn("Deduction", typeof(decimal));
dtblOther.Columns.Add(dc);
DataRow dr = dtblOther.NewRow();
dr[0] = decCountAdditon;
dr[1] = decCountDeduction;
dtblOther.Rows.InsertAt(dr, 0);
frmreport.MdiParent = formMDI.MDIObj;
frmreport.SalaryPackageDetailsReport(ds);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("SPDR:7" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public JsonResult SaveSalaryPackage(string salaryPackageId, string salaryPackageName, string active, string narration, string jsonDetails, string totalAmount)
{
bool isSave = true;
string message = "success";
SalaryPackageInfo infoSalaryPackage = new SalaryPackageInfo();
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
SalaryPackageDetailsSP spSalaryPackageDetails = new SalaryPackageDetailsSP();
int nSalaryPackageId = int.Parse(salaryPackageId);
float fTotalAmount = float.Parse(totalAmount);
bool isActive = bool.Parse(active);
infoSalaryPackage.SalaryPackageId = nSalaryPackageId;
infoSalaryPackage.SalaryPackageName = salaryPackageName;
infoSalaryPackage.Narration = narration;
infoSalaryPackage.Extra1 = string.Empty;
infoSalaryPackage.Extra2 = string.Empty;
infoSalaryPackage.IsActive = isActive;
infoSalaryPackage.TotalAmount = Convert.ToDecimal(totalAmount);
if (nSalaryPackageId > 0) // edit mode
{
spSalaryPackage.SalaryPackageEdit(infoSalaryPackage);
spSalaryPackageDetails.SalaryPackageDetailsDeleteWithSalaryPackageId(nSalaryPackageId);
isSave = SavePayHeadDetails(spSalaryPackageDetails, jsonDetails, nSalaryPackageId);
if (!isSave)
{
spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId);
}
}
else
{
nSalaryPackageId = (int)spSalaryPackage.SalaryPackageAdd(infoSalaryPackage);
if (nSalaryPackageId != -1)
{
infoSalaryPackage.SalaryPackageId = nSalaryPackageId;
isSave = SavePayHeadDetails(spSalaryPackageDetails, jsonDetails, nSalaryPackageId);
if (!isSave)
{
spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId);
}
}
else
{
message = "Package name already exists";
}
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new {
isSuccess = isSave,
messaage = message,
data = infoSalaryPackage
}));
}