/// <summary> /// On 'Print' button click to take print /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvEmployeeAddressBook.Rows.Count > 0) { DataSet ds = new DataSet(); CompanySP spCompany = new CompanySP(); DataTable dtblCompany = spCompany.CompanyViewDataTable(1); ds.Tables.Add(dtblCompany); EmployeeSP spEmployee = new EmployeeSP(); DataTable dtblEmployee = spEmployee.EmployeeViewAllForEmployeeAddressBook(cmbEmployeeCode.Text, txtMobile.Text, txtPhone.Text, txtEmail.Text); ds.Tables.Add(dtblEmployee); frmReport frmReportObj = new frmReport(); frmReportObj.MdiParent = formMDI.MDIObj; frmReportObj.EmployeeAddressBookPrinting(ds); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { formMDI.infoError.ErrorString = "EMP-AB8 " + ex.Message; } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtbl = spEmployee.EmployeeViewAllForEmployeeAddressBook(cmbEmployeeCode.Text, txtMobile.Text, txtPhone.Text, txtEmail.Text); dgvEmployeeAddressBook.DataSource = dtbl; } catch (Exception ex) { formMDI.infoError.ErrorString = "EMP-AB1 " + ex.Message; } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtbl = spEmployee.EmployeeViewAllForEmployeeAddressBook(cmbEmployeeCode.Text, txtMobile.Text, txtPhone.Text, txtEmail.Text); dgvEmployeeAddressBook.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("EMP1 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to view all employees for addressbook /// </summary> /// <param name="strEmployeeCode"></param> /// <param name="strMobile"></param> /// <param name="strPhone"></param> /// <param name="strEmail"></param> /// <returns></returns> public List <DataTable> EmployeeViewAllForEmployeeAddressBook(string strEmployeeCode, string strMobile, string strPhone, string strEmail) { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPEmployee.EmployeeViewAllForEmployeeAddressBook(strEmployeeCode, strMobile, strPhone, strEmail); } catch (Exception ex) { MessageBox.Show("EC21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }