public ActionResult Employee() { ViewData["nowDate"] = DateTime.UtcNow.ToString("yyyy-MM-dd"); DataTable dtblDesignation = GetDesignationFromDB(); if (dtblDesignation.Rows.Count > 0) { DataRow drRow = dtblDesignation.NewRow(); drRow["designationId"] = "0"; drRow["designationName"] = "All"; dtblDesignation.Rows.InsertAt(drRow, 0); } ViewData["designations"] = dtblDesignation; DataTable dtblSalaryPackages = new SalaryPackageSP().SalaryPackageViewAllForActive(); ViewData["salaryPackages"] = dtblSalaryPackages; EmployeeInfo infoEmployee = new EmployeeInfo(); infoEmployee.EmployeeCode = ""; infoEmployee.EmployeeName = ""; infoEmployee.DesignationId = 0; infoEmployee.SalaryType = "All"; infoEmployee.BankAccountNumber = ""; infoEmployee.PassportNo = ""; infoEmployee.LabourCardNumber = ""; infoEmployee.VisaNumber = ""; DataTable dtblEmployees = SearchEmployeesFromDB(infoEmployee); return(View(dtblEmployees)); }
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> /// 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 (dgvSalaryPackage.RowCount > 0) { frmReport frmreport = new frmReport(); DataSet ds = new DataSet(); SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); CompanySP spCompany = new CompanySP(); DataTable dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForSalaryPackageReport(cmbPackageName.Text, cmbStatus.Text); DataTable dtblCompany = spCompany.CompanyViewDataTable(1); ds.Tables.Add(dtblSalaryPackage); ds.Tables.Add(dtblCompany); frmreport.MdiParent = formMDI.MDIObj; frmreport.SalaryPackageReport(ds); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { MessageBox.Show("SPD:9 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public JsonResult DeleteSalaryPackage(string salaryPackageId) { int nSalaryPackageId = int.Parse(salaryPackageId); SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId); return(Json(new { isSuccess = true, message = "success", })); }
private DataTable SalaryPackageSearchFromDB(string packageName, string status) { try { SalaryPackageSP spSalarayPackage = new SalaryPackageSP(); DataTable dtbl = spSalarayPackage.SalaryPackageregisterSearch(packageName, status); return(dtbl); } catch (Exception ex) { return(null); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); DataTable dtbl = spSalaryPackage.SalaryPackageViewAllForSalaryPackageReport(cmbPackageName.Text, cmbStatus.Text); dgvSalaryPackage.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("SPD:2 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void SaveFunction() { try { SalaryPackageInfo salaryInfo = new SalaryPackageInfo(); SalaryPackageSP salarySp = new SalaryPackageSP(); for (int i = 0; i < dgvSalaryPackage.RowCount - 1; i++) { if (dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value != null) { salaryInfo.PayHead = Convert.ToString(dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value); } if (dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value != null) { salaryInfo.PayType = Convert.ToString(dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value); } if (dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value != null) { salaryInfo.Amount = Convert.ToDecimal(dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value); } bool isCellChecked = (bool)dgvSalaryPackage.Rows[i].Cells["dgvtxtIsActive"].Value; if (isCellChecked == true) { salaryInfo.IsActive = true; } else { salaryInfo.IsActive = false; } salarySp.SalaryPackageAdd(salaryInfo); } clearfielsd(); Messages.SavedMessage(); } catch (Exception ex) { MessageBox.Show(" SaveFunction " + ex.Message); } }
/// <summary> /// Function to fill SalaryPackage combobox /// </summary> public void SalaryPackageComboFill() { try { SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); DataTable dtbl = spSalaryPackage.SalaryPackageViewAll(); DataRow dr = dtbl.NewRow(); dr[1] = "All"; dtbl.Rows.InsertAt(dr, 0); cmbSalaryPackage.DataSource = dtbl; cmbSalaryPackage.ValueMember = "salaryPackageId"; cmbSalaryPackage.DisplayMember = "salaryPackageName"; } catch (Exception ex) { MessageBox.Show("SPDR:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { string strCmbName = string.Empty; try { SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); DataTable dtblSalaryPackage = new DataTable(); if (cmbStatus.Text == "Yes") { strCmbName = "True"; } else if (cmbStatus.Text == "No") { strCmbName = "False"; } else { strCmbName = "All"; } dtblSalaryPackage = spSalaryPackage.SalaryPackageregisterSearch(txtPackageName.Text.Trim(), strCmbName); dgvSalaryPackageRegister.DataSource = dtblSalaryPackage; int inRowCount = dgvSalaryPackageRegister.RowCount; for (int i = 0; i < inRowCount; i++) { if (dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "1") { dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value = "Yes"; } if (dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "0") { dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value = "No"; } } } catch (Exception ex) { MessageBox.Show("SPR1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Package combobox in Datagridview /// </summary> public void SalaryPackageComboFill() { try { DataTable dtblSalaryPackage = new DataTable(); SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForMonthlySalarySettings(); DataRow dr = dtblSalaryPackage.NewRow(); dr[0] = "0"; dr[1] = "--Select--"; dtblSalaryPackage.Rows.InsertAt(dr, 0); dgvcmbPackage.DataSource = dtblSalaryPackage; dgvcmbPackage.ValueMember = "salaryPackageId"; dgvcmbPackage.DisplayMember = "salaryPackageName"; } catch (Exception ex) { MessageBox.Show("MSS2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public JsonResult SalaryPackageViewAllForActive() { bool isSave = true; string message = "success"; string jsonResults = ""; try { SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); DataTable dtblSalaryPackage = new DataTable(); dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForActive(); jsonResults = Utils.ConvertDataTabletoString(dtblSalaryPackage); } catch (Exception ex) { message = ex.Message; } return(Json(new { isSuccess = isSave, messaage = message, data = jsonResults })); }
public ActionResult GetMonthlySalarySettingsDetails(string month) { DataTable dtMonthly = GetMonthlySalarySettingsFromDB(month); DataTable dtblSalaryPackage = new DataTable(); SalaryPackageSP spSalaryPackage = new SalaryPackageSP(); dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForMonthlySalarySettings(); string jsonTableData = Utils.ConvertDataTabletoString(dtMonthly); string jsonComboData = Utils.ConvertDataTabletoString(dtblSalaryPackage); string jsonBtnStatus = string.Empty; MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); if (spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(month)) > 0) { jsonBtnStatus = "Update"; } else { jsonBtnStatus = "Save"; } return(Json(new { success = "true", tableData = jsonTableData, comboData = jsonComboData, btnStatus = jsonBtnStatus })); }
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 })); }