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;
}
}
