private void SaveData(string cmdType) { dsPayroll objDS = new dsPayroll(); if (cmdType == "I") { hfId.Value = Common.getMaxId("FinalPayment", "FinalPayId"); } DataTable dtMst = objDS.Tables["FinalPayment"]; DataRow nRow = dtMst.NewRow(); nRow["FinalPayId"] = Common.RoundDecimal(hfId.Value, 0); nRow["EmpID"] = txtEmpID.Text.Trim(); nRow["TotServiceYr"] = lblServiceYr.Text.Trim() == "" ? "0" : lblServiceYr.Text.Trim(); nRow["BasicPay"] = txtBasicPay.Text.Trim() == "" ? "0" : txtBasicPay.Text.Trim(); nRow["TotalPay"] = txtTotalPay.Text.Trim() == "" ? "0" : txtTotalPay.Text.Trim(); nRow["ELBalance"] = txtELLeave.Text.Trim() == "" ? "0" : txtELLeave.Text.Trim(); nRow["LeaveEncash"] = txtLeaveEncash.Text.Trim() == "" ? "0" : txtLeaveEncash.Text.Trim(); nRow["PF"] = txtPF.Text.Trim() == "" ? "0" : txtPF.Text.Trim(); nRow["Gratuity"] = txtGratuity.Text.Trim() == "" ? "0" : txtGratuity.Text.Trim(); nRow["LastMonthSalary"] = txtLastMonthSalary.Text.Trim() == "" ? "0" : txtLastMonthSalary.Text.Trim(); nRow["SeperateMonthSalary"] = txtSeperateMonthSal.Text.Trim() == "" ? "0" : txtSeperateMonthSal.Text.Trim(); nRow["TripAdvPay"] = txtTripAdvPay.Text.Trim() == "" ? "0" : txtTripAdvPay.Text.Trim(); nRow["AlreadyPay"] = txtAlreadyPay.Text.Trim() == "" ? "0" : txtAlreadyPay.Text.Trim(); nRow["OtherPay"] = txtOtherPay.Text.Trim() == "" ? "0" : txtOtherPay.Text.Trim(); nRow["PFLoan"] = txtPFLoan.Text.Trim() == "" ? "0" : txtPFLoan.Text.Trim(); nRow["Other"] = txtOther.Text.Trim() == "" ? "0" : txtOther.Text.Trim(); nRow["NetPay"] = txtNetPay.Text.Trim() == "" ? "0" : txtNetPay.Text.Trim(); nRow["SeparateDate"] = Common.ReturnDate(lblSeprateDate.Text.Trim()); nRow["SeparateDay"] = lblSalaryDays.Text.Trim() == "" ? "0" : lblSalaryDays.Text.Trim(); nRow["ProcessDate"] = Common.ReturnDate(txtProcessDate.Text.Trim()); nRow["Remarks"] = txtRemarks.Text.ToString().Trim(); nRow["PayStatus"] = "P"; if (cmdType == "I") { nRow["InsertedBy"] = Session["USERID"].ToString().Trim(); nRow["InsertedDate"] = DateTime.Now; } else if (cmdType == "U") { nRow["UpdatedBy"] = Session["USERID"].ToString().Trim(); nRow["UpdatedDate"] = DateTime.Now; } dtMst.Rows.Add(nRow); dtMst.AcceptChanges(); try { objPayMgr.SaveData(dtMst, cmdType == "D" ? "U" : cmdType); lblMsg.Text = Common.GetMessage(cmdType); Common.EmptyTextBoxValues(this); this.EntryMode(false); this.OpenRecord(); } catch (Exception ex) { lblMsg.Text = ex.ToString(); } }