/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
string strEmployeeStatus = string.Empty;
if (rbtnAll.Checked)
{
strEmployeeStatus = "All";
}
else if (rbtnActive.Checked)
{
strEmployeeStatus = "Active";
}
else if (rbtnInActive.Checked)
{
strEmployeeStatus = "InActive";
}
if (strEmployeeStatus != string.Empty && cmbDesigantion.SelectedIndex > -1)
{
CreateGrid();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
EmployeeSP spEmployee = new EmployeeSP();
DataTable dtblEmployee = new DataTable();
dtblEmployee = spEmployee.EmployeeViewByDesignationAndStatus(cmbDesigantion.Text, strEmployeeStatus);
if (dtblEmployee.Rows.Count > 0)
{
for (int i = 0; i < dtblEmployee.Rows.Count; i++)
{
dgvMonthlyAttendance.Rows.Add();
dgvMonthlyAttendance.Rows[i].Cells["employeeId"].Value = dtblEmployee.Rows[i]["employeeId"].ToString();
dgvMonthlyAttendance.Rows[i].Cells["SlNo"].Value = i + 1;
dgvMonthlyAttendance.Rows[i].Cells["employeeName"].Value = dtblEmployee.Rows[i]["employeeName"].ToString();
dgvMonthlyAttendance.Rows[i].Cells["employeeCode"].Value = dtblEmployee.Rows[i]["employeeCode"].ToString();
DataTable dtblStatus = spDailyAttendanceMaster.MonthlyAttendanceReportFill(dtpMonth.Value, Convert.ToDecimal(dtblEmployee.Rows[i]["employeeId"].ToString()));
if (dtblStatus.Rows.Count > 0)
{
for (int j = 0; j < dtblStatus.Rows.Count; j++)
{
dgvMonthlyAttendance.Rows[i].Cells[DateTime.Parse(dtblStatus.Rows[j]["date"].ToString()).Day.ToString()].Value = dtblStatus.Rows[j]["status"].ToString();
}
}
FindTotal(i);
}
}
CheckedChange();
}
}
catch (Exception ex)
{
MessageBox.Show("MAR2 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill grid according to search keys
/// </summary>
public void Gridfill()
{
try
{
DataTable dtblEmployeeSearch = new DataTable();
EmployeeSP spEmployee = new EmployeeSP();
string strIsActive = "All";
if (cmbIsActive.Text == "Yes")
{
strIsActive = "True";
}
else if (cmbIsActive.Text == "No")
{
strIsActive = "False";
}
else
{
cmbIsActive.SelectedIndex = 0;
}
dtblEmployeeSearch = spEmployee.SalesmanSearch(txtCode.Text, txtNameSearch.Text, txtPhoneSearch.Text, txtMobileSearch.Text, strIsActive);
dgvSalesman.DataSource = dtblEmployeeSearch;
if (strIsActive == "True")
{
cmbIsActive.Text = "Yes";
}
else if (strIsActive == "False")
{
cmbIsActive.Text = "No";
}
else
{
cmbIsActive.SelectedIndex = 0;
}
int inRowCount = dgvSalesman.RowCount;
for (int i = 0; i <= inRowCount - 1; i++)
{
if (dgvSalesman.Rows[i].Cells["dgvtxtactive"].Value.ToString() == "1")
{
dgvSalesman.Rows[i].Cells["dgvtxtactive"].Value = "Yes";
}
if (dgvSalesman.Rows[i].Cells["dgvtxtactive"].Value.ToString() == "0")
{
dgvSalesman.Rows[i].Cells["dgvtxtactive"].Value = "No";
}
}
}
catch (Exception ex)
{
MessageBox.Show("S1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill EmployeeCode Combobox
/// </summary>
public void EmployeeCodeComboFill()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
DataTable dtblEmployeeCode = new DataTable();
dtblEmployeeCode = spEmployee.EmployeeViewAll();
cmbEmployeeCode.DataSource = dtblEmployeeCode;
cmbEmployeeCode.ValueMember = "employeeId";
cmbEmployeeCode.DisplayMember = "employeeCode";
}
catch (Exception ex)
{
MessageBox.Show("BD1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill EmployeeCode combobox
/// </summary>
public void EmployeeCodeComboFill()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
DataTable dtblEmployee = spEmployee.EmployeeViewAll();
DataRow dr = dtblEmployee.NewRow();
dr[3] = "All";
dtblEmployee.Rows.InsertAt(dr, 0);
cmbEmployeeCode.DataSource = dtblEmployee;
cmbEmployeeCode.ValueMember = "employeeId";
cmbEmployeeCode.DisplayMember = "employeeCode";
}
catch (Exception ex)
{
MessageBox.Show("MSR:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Employee combobox
/// </summary>
public void FillEmployee()
{
try
{
DataTable dtbl = new DataTable();
EmployeeSP spEmployee = new EmployeeSP();
dtbl = spEmployee.EmployeeViewForPaySlip();
DataRow dr = dtbl.NewRow();
dr[1] = "--Select--";
dtbl.Rows.InsertAt(dr, 0);
cmbEmployee.DataSource = dtbl;
cmbEmployee.ValueMember = "employeeId";
cmbEmployee.DisplayMember = "employeeName";
}
catch (Exception ex)
{
MessageBox.Show("PS 1: " + 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)
{
MessageBox.Show("ER1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for save
/// </summary>
public void SaveFunction()
{
try
{
EmployeeInfo infoEmployee = new EmployeeInfo();
EmployeeSP spEmployee = new EmployeeSP();
infoEmployee.EmployeeCode = txtEmployeeCode.Text.Trim();
infoEmployee.EmployeeName = txtEmployeeName.Text.Trim();
infoEmployee.DesignationId = Convert.ToDecimal(cmbDesignation.SelectedValue.ToString());
infoEmployee.Dob = Convert.ToDateTime(dtpDob.Text.ToString());
infoEmployee.MaritalStatus = (cmbMaritalStatus.Text.ToString()).TrimEnd();
if (cmbGender.Text != string.Empty)
{
infoEmployee.Gender = (cmbGender.SelectedItem.ToString()).TrimEnd();
}
else
{
infoEmployee.Gender = cmbGender.Text.ToString();
}
infoEmployee.Qualification = txtQualification.Text.Trim();
infoEmployee.Address = txtAddress.Text.Trim();
infoEmployee.PhoneNumber = txtPhoneNumber.Text.Trim();
infoEmployee.MobileNumber = txtMobileNumber.Text.Trim();
infoEmployee.Email = txtEmail.Text.Trim();
infoEmployee.JoiningDate = Convert.ToDateTime(txtJoiningDate.Text.ToString());
infoEmployee.TerminationDate = Convert.ToDateTime(txtTerminationDate.Text.ToString());
if (cbxActive.Checked)
{
infoEmployee.IsActive = true;
}
else
{
infoEmployee.IsActive = false;
}
infoEmployee.Narration = txtNarration.Text.Trim();
infoEmployee.BloodGroup = (cmbBloodGroup.Text.ToString()).TrimEnd();
infoEmployee.PassportNo = txtPassportNumber.Text.Trim();
infoEmployee.PassportExpiryDate = Convert.ToDateTime(dtpPassportExpiryDate.Text.ToString());
infoEmployee.VisaNumber = txtVisaNumber.Text.Trim();
infoEmployee.VisaExpiryDate = Convert.ToDateTime(dtpVisaExpiryDate.Text.ToString());
infoEmployee.LabourCardNumber = txtlabourCardNumber.Text.Trim();
infoEmployee.LabourCardExpiryDate = Convert.ToDateTime(dtpLabourCardExpiryDate.Text.ToString());
infoEmployee.SalaryType = (cmbSalaryType.SelectedItem.ToString()).TrimEnd();
if (cmbSalaryType.SelectedItem.ToString() == "Daily wage")
{
if (txtDailyWage.Text.Trim() != string.Empty)
{
infoEmployee.DailyWage = Convert.ToDecimal(txtDailyWage.Text.ToString());
}
}
else
{
if (cmbDefaultPackage.Text != string.Empty)
{
infoEmployee.DefaultPackageId = Convert.ToDecimal(cmbDefaultPackage.SelectedValue.ToString());
}
}
infoEmployee.BankName = txtBankName.Text.Trim();
infoEmployee.BankAccountNumber = txtBankAccountNumber.Text.Trim();
infoEmployee.BranchName = txtBranch.Text.Trim();
infoEmployee.BranchCode = txtBranchCode.Text.Trim();
infoEmployee.PanNumber = txtPanNumber.Text.Trim();
infoEmployee.PfNumber = txtPfNumber.Text.Trim();
infoEmployee.EsiNumber = txtEsiNumber.Text.Trim();
infoEmployee.ExtraDate = DateTime.Now;
infoEmployee.Extra1 = string.Empty;
infoEmployee.Extra2 = string.Empty;
if (spEmployee.EmployeeCodeCheckExistance(txtEmployeeCode.Text.Trim(), 0) == false)
{
decEmployeeId = spEmployee.EmployeeAddWithReturnIdentity(infoEmployee);
Messages.SavedMessage();
ClearFunction();
decIdForOtherForms = decEmployeeId;
if (frmSalesInvoiceObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
}
else
{
Messages.InformationMessage("Employee code already exist");
txtEmployeeCode.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("EC1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
DataTable dtbl = spEmployee.EmployeeViewAllEmployeeReport(cmbDesigantion.Text, cmbEmployee.Text, cmbStatus.Text);
dgvEmployee.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("ER3 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Delete
/// </summary>
public void Delete()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
if (spEmployee.EmployeeCheckReferences(Convert.ToDecimal(lblEmployeeId.Text.ToString())) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
Messages.DeletedMessage();
this.Close();
}
if (frmEmployeeRegisterObj != null)
{
frmEmployeeRegisterObj.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("EC10" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill controls when cell double click in frmEmployeeRegister for updation
/// </summary>
/// <param name="decEmployeeId"></param>
/// <param name="frm"></param>
public void CallFromEmployeeRegister(decimal decEmployeeId, frmEmployeeRegister frm)
{
try
{
base.Show();
frmEmployeeRegisterObj = frm;
EmployeeInfo infoEmployee = new EmployeeInfo();
EmployeeSP spEmployee = new EmployeeSP();
infoEmployee = spEmployee.EmployeeView(decEmployeeId);
lblEmployeeId.Text = infoEmployee.EmployeeId.ToString();
txtEmployeeCode.Text = infoEmployee.EmployeeCode.ToString();
strEmployeeCode = infoEmployee.EmployeeCode.ToString();
txtEmployeeName.Text = infoEmployee.EmployeeName.ToString();
cmbDesignation.SelectedValue = infoEmployee.DesignationId;
dtpDob.Text = infoEmployee.Dob.ToString("dd-MMM-yyyy");
cmbMaritalStatus.SelectedItem = infoEmployee.MaritalStatus.ToString();
cmbGender.SelectedItem = infoEmployee.Gender.ToString();
txtQualification.Text = infoEmployee.Qualification;
cmbBloodGroup.SelectedItem = infoEmployee.BloodGroup.ToString();
txtAddress.Text = infoEmployee.Address;
txtBankAccountNumber.Text = infoEmployee.BankAccountNumber;
txtBankName.Text = infoEmployee.BankName;
txtBranch.Text = infoEmployee.BranchName;
txtEmail.Text = infoEmployee.Email;
txtEsiNumber.Text = infoEmployee.EsiNumber;
txtlabourCardNumber.Text = infoEmployee.LabourCardNumber;
txtBranchCode.Text = infoEmployee.BranchCode;
txtMobileNumber.Text = infoEmployee.MobileNumber;
txtNarration.Text = infoEmployee.Narration;
txtPanNumber.Text = infoEmployee.PanNumber;
txtPassportNumber.Text = infoEmployee.PassportNo;
txtPfNumber.Text = infoEmployee.PfNumber;
txtPhoneNumber.Text = infoEmployee.PhoneNumber;
txtVisaNumber.Text = infoEmployee.VisaNumber;
cmbSalaryType.SelectedItem = infoEmployee.SalaryType;
if (cmbSalaryType.SelectedItem.ToString() == "Daily wage")
{
txtDailyWage.Text = infoEmployee.DailyWage.ToString();
}
else
{
cmbDefaultPackage.SelectedValue = int.Parse(infoEmployee.DefaultPackageId.ToString());
}
txtJoiningDate.Text = infoEmployee.JoiningDate.ToString("dd-MMM-yyyy");
dtpLabourCardExpiryDate.Value = infoEmployee.LabourCardExpiryDate;
dtpPassportExpiryDate.Value = infoEmployee.PassportExpiryDate;
txtTerminationDate.Text = infoEmployee.TerminationDate.ToString("dd-MMM-yyyy");
dtpVisaExpiryDate.Value = infoEmployee.VisaExpiryDate;
txtEmployeeCode.Focus();
if (infoEmployee.IsActive)
{
cbxActive.Checked = true;
}
else
{
cbxActive.Checked = false;
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtEmployeeCode.Select();
}
catch (Exception ex)
{
MessageBox.Show("EC12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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);
}
}
/// <summary>
/// Function to fill the controlls for edit or delete
/// </summary>
public void FillControls()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
EmployeeInfo infoEmployee = new EmployeeInfo();
infoEmployee = spEmployee.SalesmanViewSpecificFeilds(Convert.ToDecimal(strSalesmanId.ToString()));
txtSalesmanCode.Text = infoEmployee.EmployeeCode;
txtName.Text = infoEmployee.EmployeeName;
txtEmail.Text = infoEmployee.Email;
txtPhone.Text = infoEmployee.PhoneNumber;
txtMobile.Text = infoEmployee.MobileNumber;
txtAddress.Text = infoEmployee.Address;
txtNarration.Text = infoEmployee.Narration;
if (infoEmployee.IsActive)
{
cbxActive.Checked = true;
}
else
{
cbxActive.Checked = false;
}
decSalesManId = infoEmployee.EmployeeId;
}
catch (Exception ex)
{
MessageBox.Show("S3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the salesman combobox
/// </summary>
public void SalesmanComboFill()
{
try
{
DataTable dtblSalesmen = new DataTable();
EmployeeSP spEmployee = new EmployeeSP();
TransactionsGeneralFill TransactiongeneralFillObj = new TransactionsGeneralFill();
dtblSalesmen = TransactiongeneralFillObj.SalesmanViewAllForComboFill(cmbSalesman, false);
cmbSalesman.DataSource = dtblSalesmen;
cmbSalesman.DisplayMember = "employeeName";
cmbSalesman.ValueMember = "employeeId";
cmbSalesman.SelectedValue = -1;
}
catch (Exception ex)
{
MessageBox.Show("SV 06 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Salesman combobox
/// </summary>
public void SalesmanComboFill()
{
try
{
DataTable dtblSalesmen = new DataTable();
EmployeeSP spEmployee = new EmployeeSP();
dtblSalesmen = spEmployee.EmployeeViewSalesman();
DataRow dr = dtblSalesmen.NewRow();
dr["employeeId"] = 0;
dr["employeeName"] = "All";
dtblSalesmen.Rows.InsertAt(dr, 0);
cmbSalesman.DataSource = dtblSalesmen;
cmbSalesman.DisplayMember = "employeeName";
cmbSalesman.ValueMember = "employeeId";
cmbSalesman.SelectedValue = 0;
}
catch (Exception ex)
{
MessageBox.Show("SVRT 8 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save a salesman
/// </summary>
public void SaveFunction()
{
try
{
EmployeeInfo InfoEmployee = new EmployeeInfo();
EmployeeSP SpEmployee = new EmployeeSP();
InfoEmployee.EmployeeCode = txtSalesmanCode.Text.Trim();
InfoEmployee.DesignationId = Convert.ToDecimal(SpEmployee.SalesmanGetDesignationId());
InfoEmployee.EmployeeName = txtName.Text.Trim();
InfoEmployee.Email = txtEmail.Text.Trim();
InfoEmployee.PhoneNumber = txtPhone.Text.Trim();
InfoEmployee.MobileNumber = txtMobile.Text.Trim();
InfoEmployee.Address = txtAddress.Text.Trim();
InfoEmployee.Narration = txtNarration.Text.Trim();
InfoEmployee.Dob = DateTime.Now;
InfoEmployee.MaritalStatus = "Single";
InfoEmployee.Gender = "Male";
InfoEmployee.Qualification = string.Empty;
InfoEmployee.BloodGroup = string.Empty;
InfoEmployee.JoiningDate = PublicVariables._dtCurrentDate;
InfoEmployee.TerminationDate = DateTime.Now;
if (cbxActive.Checked)
{
InfoEmployee.IsActive = true;
}
else
{
InfoEmployee.IsActive = false;
}
InfoEmployee.SalaryType = "Monthly";
InfoEmployee.DefaultPackageId = 1;
InfoEmployee.BankName = string.Empty;
InfoEmployee.BankAccountNumber = string.Empty;
InfoEmployee.BranchName = string.Empty;
InfoEmployee.BranchCode = string.Empty;
InfoEmployee.PanNumber = string.Empty;
InfoEmployee.PfNumber = string.Empty;
InfoEmployee.EsiNumber = string.Empty;
InfoEmployee.PassportNo = string.Empty;
InfoEmployee.PassportExpiryDate = DateTime.Now;
InfoEmployee.VisaNumber = string.Empty;
InfoEmployee.VisaExpiryDate = DateTime.Now;
InfoEmployee.LabourCardNumber = string.Empty;
InfoEmployee.LabourCardExpiryDate = DateTime.Now;
InfoEmployee.Extra1 = string.Empty;
InfoEmployee.Extra2 = string.Empty;
if (SpEmployee.EmployeeCodeCheckExistance(txtSalesmanCode.Text.Trim().ToString(), 0) == false)
{
decSalesManId = SpEmployee.EmployeeAddWithReturnIdentity(InfoEmployee);
Messages.SavedMessage();
Clear();
Gridfill();
if (frmRejectionInObj != null)
{
this.Close();
}
if (frmSalesQuotationObj != null)
{
this.Close();
}
}
else
{
Messages.InformationMessage("Salesman code already exist");
txtSalesmanCode.Focus();
}
if (frmSalesReturnObj != null)
{
this.Close();
}
if (frmSalesOrderObj != null)
{
this.Close();
}
if (frmSalesInvoiceObj != null)
{
this.Close();
}
if (frmPOSObj != null)
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("S5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit a salesman
/// </summary>
public void EditFunction()
{
try
{
EmployeeInfo InfoEmployee = new EmployeeInfo();
EmployeeSP SpEmployee = new EmployeeSP();
InfoEmployee.EmployeeId = decSalesManId;
InfoEmployee.EmployeeCode = txtSalesmanCode.Text.Trim();
InfoEmployee.EmployeeName = txtName.Text.Trim();
InfoEmployee.Email = txtEmail.Text.Trim();
InfoEmployee.PhoneNumber = txtPhone.Text.Trim();
InfoEmployee.MobileNumber = txtMobile.Text.Trim();
InfoEmployee.Address = txtAddress.Text.Trim();
InfoEmployee.Narration = txtNarration.Text.Trim();
if (cbxActive.Checked)
{
InfoEmployee.IsActive = true;
}
else
{
InfoEmployee.IsActive = false;
}
if (SpEmployee.EmployeeCodeCheckExistance(txtSalesmanCode.Text.Trim().ToString(), decSalesManId) == false)
{
SpEmployee.SalesmanEdit(InfoEmployee);
Messages.UpdatedMessage();
ClearSearch();
Clear();
Gridfill();
}
else
{
Messages.InformationMessage("Salesman code already exist");
txtSalesmanCode.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("S6" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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 (dgvEmployee.RowCount > 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.EmployeeViewAllEmployeeReport(cmbDesigantion.Text, cmbEmployee.Text, cmbStatus.Text);
ds.Tables.Add(dtblEmployee);
frmReport frmReportObj = new frmReport();
frmReportObj.MdiParent = formMDI.MDIObj;
frmReportObj.EmployeeReportPrinting(ds);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("ER9" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On doubleClicking on the grid, It Fill the controlls to edit or delete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvSalesman_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
if (Convert.ToDecimal(dgvSalesman.CurrentRow.Cells["dgvtxtemployeeId"].Value) != 1)
{
EmployeeSP spEmployee = new EmployeeSP();
EmployeeInfo infoEmployee = new EmployeeInfo();
strSalesmanId = dgvSalesman.CurrentRow.Cells["dgvtxtemployeeId"].Value.ToString();
FillControls();
btnSave.Text = "Update";
btnDelete.Enabled = true;
txtSalesmanCode.Focus();
}
else
{
Messages.InformationMessage("Default employee cannot update or delete");
}
}
}
catch (Exception ex)
{
MessageBox.Show("S25" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to delete a salesman
/// </summary>
public void DeleteFunction()
{
try
{
EmployeeSP spEmployee = new EmployeeSP();
if (spEmployee.SalesmanCheckReferenceAndDelete(decSalesManId) == -1)
{
Messages.ReferenceExistsMessage();
}
else
{
spEmployee.EmployeeDeleteCheck(decSalesManId);
Messages.DeletedMessage();
ClearSearch();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("S8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
