private DataTable SearchEmployeesFromDB(EmployeeInfo info) { EmployeeSP spEmployee = new EmployeeSP(); DataTable tblEmployees = spEmployee.EmployeeSearch(info); return(tblEmployees); }
public JsonResult SearchEmployee(string code, string name, int designationId, string salaryType, string bankNo, string passportNo, string labCardNo, string visaNo) { bool isSuccess = true; string message = "success"; string jsonResults = ""; try { EmployeeInfo infoEmployee = new EmployeeInfo(); EmployeeSP spEmployee = new EmployeeSP(); infoEmployee.EmployeeCode = (code == null ? string.Empty : code); infoEmployee.EmployeeName = (name == null ? string.Empty : name); infoEmployee.DesignationId = designationId; infoEmployee.SalaryType = salaryType; infoEmployee.BankAccountNumber = (bankNo == null ? string.Empty: bankNo); infoEmployee.PassportNo = (passportNo == null ? string.Empty: passportNo); infoEmployee.LabourCardNumber = (labCardNo == null ? string.Empty : labCardNo); infoEmployee.VisaNumber = (visaNo == null ? string.Empty : visaNo); DataTable tblEmployees = spEmployee.EmployeeSearch(infoEmployee); jsonResults = Utils.ConvertDataTabletoString(tblEmployees); } catch (Exception ex) { isSuccess = false; message = ex.Message; } return(Json(new { isSuccess = isSuccess, message = message, data = jsonResults })); }
/// <summary> /// Function to search the employee /// </summary> /// <param name="infoEmployee"></param> /// <returns></returns> public List <DataTable> EmployeeSearch(EmployeeInfo infoEmployee) { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPEmployee.EmployeeSearch(infoEmployee); } catch (Exception ex) { MessageBox.Show("EC7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill Datagridview /// </summary> public void Gridfill() { try { EmployeeInfo infoEmployee = new EmployeeInfo(); EmployeeSP spEmployee = new EmployeeSP(); infoEmployee.EmployeeCode = txtEmployeeCode.Text.Trim(); infoEmployee.EmployeeName = txtEmployeeName.Text.Trim(); infoEmployee.DesignationId = decimal.Parse(cmbDesignation.SelectedValue.ToString()); infoEmployee.SalaryType = cmbsalaryType.SelectedItem.ToString(); infoEmployee.BankAccountNumber = txtBankAccountNumber.Text.Trim(); infoEmployee.PassportNo = txtPassportNumber.Text.Trim(); infoEmployee.LabourCardNumber = txtLabourCardNumber.Text.Trim(); infoEmployee.VisaNumber = txtVisaNumber.Text.Trim(); dgvEmployee.DataSource = spEmployee.EmployeeSearch(infoEmployee); } catch (Exception ex) { MessageBox.Show("ER1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void Gridfill() { try { EmployeeInfo infoEmployee = new EmployeeInfo(); EmployeeSP spEmployee = new EmployeeSP(); infoEmployee.EmployeeCode = txtEmployeeCode.Text.Trim(); infoEmployee.EmployeeName = txtEmployeeName.Text.Trim(); infoEmployee.DesignationId = decimal.Parse(cmbDesignation.SelectedValue.ToString()); infoEmployee.SalaryType = cmbsalaryType.SelectedItem.ToString(); infoEmployee.BankAccountNumber = txtBankAccountNumber.Text.Trim(); infoEmployee.PassportNo = txtPassportNumber.Text.Trim(); infoEmployee.LabourCardNumber = txtLabourCardNumber.Text.Trim(); infoEmployee.VisaNumber = txtVisaNumber.Text.Trim(); dgvEmployee.DataSource = spEmployee.EmployeeSearch(infoEmployee); } catch (Exception ex) { formMDI.infoError.ErrorString = "ER1:" + ex.Message; } }