/// <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); } }
public ActionResult DeleteMonthlySalarySettings(string month) { try { MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); spMonthlySalary.MonthlySalaryDeleteAll(spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(month))); } catch (Exception ex) { return(Json(new { success = "false", ex = "MSS5" + ex.Message })); } return(Json(new { success = "true", ex = "no" })); }
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 Delete /// </summary> public void DeleteFunction() { try { MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP(); MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); string strMonth = dtpSalaryMonth.Text; spMonthlySalary.MonthlySalaryDeleteAll(spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(dtpSalaryMonth.Text))); Messages.DeletedMessage(); SalaryPackageComboFill(); GridFill(); UpdateDataGridViewRowColors(); DeleteButtonEnableDisableChoose(); dtpSalaryMonth.Focus(); } catch (Exception ex) { MessageBox.Show("MSS5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <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 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"); }