/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblMonthlySalaryDetails = new DataTable(); MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo(); dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text)); dgvMonthySalarySettings.DataSource = dtblMonthlySalaryDetails; int inRowCount = dgvMonthySalarySettings.RowCount; string strNarration = string.Empty; for (int i = 0; i < inRowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString() != string.Empty) { strNarration = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString(); } } for (int i = 0; i < inRowCount; i++) { //select default package for employee if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value.ToString() != "") { dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value; } } txtNarration.Text = strNarration; } catch (Exception ex) { MessageBox.Show("MSS4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Update values in MonthlySalary Table /// </summary> /// <param name="monthlysalaryinfo"></param> public void MonthlySalaryEdit(MonthlySalaryInfo monthlysalaryinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("MonthlySalaryEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal); sprmparam.Value = monthlysalaryinfo.MonthlySalaryId; sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam.Value = monthlysalaryinfo.SalaryMonth; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
public void MonthlySalarySettingsEdit(MonthlySalaryInfo monthlysalaryinfo) { try { SpMonthlySalary.MonthlySalarySettingsEdit(monthlysalaryinfo); } catch (Exception ex) { MessageBox.Show("MSV:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public decimal MonthlySalaryAddWithIdentity(MonthlySalaryInfo monthlysalaryinfo) { decimal decResult = 0; try { decResult = SPMonthlySalary.MonthlySalaryAddWithIdentity(monthlysalaryinfo); } catch (Exception ex) { MessageBox.Show("MS4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decResult); }
private DataTable GetMonthlySalarySettingsFromDB(string date) { DataTable dtblMonthlySalaryDetails = new DataTable(); try { MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo(); dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(date)); } catch (Exception ex) { } return(dtblMonthlySalaryDetails); }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; decMasterIdForEdit = spMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i < RowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } Messages.SavedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public string SaveMonthlySalarySettings(string month, string tableData) { try { List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData); MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month); infoMonthlySalary.Narration = string.Empty; infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; decimal decMasterIdForEdit = spMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; int RowCount = items.Count; for (int i = 0; i < RowCount; i++) { if (items[i]["employeeId"] != null) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"]); if (items[i]["selectedSalaryPackageId"].ToString() != string.Empty && items[i]["selectedSalaryPackageId"].ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } } catch (Exception ex) { return("MSS7" + ex.Message); } return("no"); }
/// <summary> /// Function to get particular values from MonthlySalary Table based on the parameter /// </summary> /// <param name="monthlySalaryId"></param> /// <returns></returns> public MonthlySalaryInfo MonthlySalaryView(decimal monthlySalaryId) { MonthlySalaryInfo monthlysalaryinfo = new MonthlySalaryInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("MonthlySalaryView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal); sprmparam.Value = monthlySalaryId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { monthlysalaryinfo.MonthlySalaryId = Convert.ToDecimal(sdrreader[0].ToString()); monthlysalaryinfo.SalaryMonth = Convert.ToDateTime(sdrreader[1].ToString()); monthlysalaryinfo.Narration = sdrreader[2].ToString(); monthlysalaryinfo.ExtraDate = Convert.ToDateTime(sdrreader[3].ToString()); monthlysalaryinfo.Extra1 = sdrreader[4].ToString(); monthlysalaryinfo.Extra2 = sdrreader[5].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(monthlysalaryinfo); }
/// <summary> /// Function to insert values to MonthlySalary Table and return the Curresponding row's Id /// </summary> /// <param name="monthlysalaryinfo"></param> /// <returns></returns> public decimal MonthlySalaryAddWithIdentity(MonthlySalaryInfo monthlysalaryinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("MonthlySalaryAddWithIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam.Value = monthlysalaryinfo.SalaryMonth; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = monthlysalaryinfo.Extra2; object obj = sccmd.ExecuteScalar(); if (obj != null) { decIdentity = Convert.ToDecimal(obj.ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(decIdentity); }
public void MonthlySalarySettingsEdit(MonthlySalaryInfo monthlysalaryinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("MonthlySalarySettingsEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam6 = new SqlParameter(); sprmparam6 = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal); sprmparam6.Value = monthlysalaryinfo.MonthlySalaryId; sprmparam6 = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam6.Value = monthlysalaryinfo.SalaryMonth; sprmparam6 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam6.Value = monthlysalaryinfo.Narration; sprmparam6 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam6.Value = monthlysalaryinfo.Extra1; sprmparam6 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam6.Value = monthlysalaryinfo.Extra2; int ineffectedrow = sccmd.ExecuteNonQuery(); if (ineffectedrow > 0) { goto end_IL_0001; } end_IL_0001 :; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; decMasterIdForEdit = BllMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i < RowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } Messages.SavedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { List<DataTable> ListMonthlySalaryDetails = new List<DataTable>(); MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo(); ListMonthlySalaryDetails = BllMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text)); dgvMonthySalarySettings.DataSource = ListMonthlySalaryDetails[0]; int inRowCount = dgvMonthySalarySettings.RowCount; string strNarration = string.Empty; for (int i = 0; i < inRowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString() != string.Empty) { strNarration = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString(); } } for (int i = 0; i < inRowCount; i++) { //select default package for employee if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value.ToString() != "") { dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value; } } txtNarration.Text = strNarration; } catch (Exception ex) { MessageBox.Show("MSS4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); EmployeeCreationBll BllEmployeeCreation = new EmployeeCreationBll(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != string.Empty) { decMasterIdForEdit = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } } infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { string st = dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString(); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString() != "--Select--") { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != "0") { infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; BllEmployeeCreation.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId); BllMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails); } } else { decimal decMonthlySalaryDetailsId = 0; for (int j = 0; j < RowCount; j++) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvcmbPackage"].FormattedValue.ToString() == "--Select--") { decMonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); BllMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId); } } } } } else { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } } Messages.UpdatedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); EmployeeSP spEmployee = new EmployeeSP(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != string.Empty) { decMasterIdForEdit = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } } infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit; spMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { string st = dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString(); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString() != "--Select--") { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != "0") { infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId); spMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails); } } else { decimal decMonthlySalaryDetailsId = 0; for (int j = 0; j < RowCount; j++) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvcmbPackage"].FormattedValue.ToString() == "--Select--") { decMonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); spMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId); } } } } } else { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } } Messages.UpdatedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public string EditMonthlySalarySettings(string month, string tableData) { try { List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData); decimal decMasterIdForEdit = 0; MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); EmployeeSP spEmployee = new EmployeeSP(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month); infoMonthlySalary.Narration = string.Empty; infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; int RowCount = items.Count; for (int i = 0; i < RowCount; i++) { if (items[i]["monthlySalaryId"].GetType().Name != "JObject") { decMasterIdForEdit = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString()); } } infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit; spMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; for (int i = 0; i <= RowCount - 1; i++) { if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject") { string st = items[i]["selectedSalaryPackageId"].ToString(); if (items[i]["selectedSalaryPackageId"].ToString() != "0") { if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString()); } if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[i]["monthlySalaryDetailsId"].ToString() != string.Empty) { infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(items[i]["monthlySalaryDetailsId"].ToString()); } if (items[i]["monthlySalaryId"].GetType().Name != "JObject" && items[i]["monthlySalaryId"].ToString() != "0") { infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString()); } if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId); spMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails); } } else { decimal decMonthlySalaryDetailsId = 0; for (int j = 0; j < RowCount; j++) { if (items[j]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[j]["monthlySalaryDetailsId"].ToString() != string.Empty) { if (items[j]["selectedSalaryPackageId"].ToString() == "0") { decMonthlySalaryDetailsId = Convert.ToDecimal(items[j]["monthlySalaryDetailsId"].ToString()); spMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId); } } } } } else { if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString()); if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } } } catch (Exception ex) { return("MSS8" + ex.Message); } return("no"); }