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>
/// 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)
{
formMDI.infoError.ErrorString = "S25" + ex.Message;
}
}
/// <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)
{
formMDI.infoError.ErrorString = "S3" + ex.Message;
}
}
/// <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>
/// 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);
}
}
public JsonResult DeleteEmployee(string employeeId)
{
bool isSuccess = true;
string message = "success";
try
{
int nEmployeeId = int.Parse(employeeId);
EmployeeSP spEmployee = new EmployeeSP();
if (spEmployee.EmployeeCheckReferences(nEmployeeId) == -1)
{
isSuccess = false;
message = "You can't delete,reference exist";
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new
{
isSuccess = isSuccess,
message = message
}));
}
/// <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 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 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)
{
formMDI.infoError.ErrorString = "ER3 " + ex.Message;
}
}
/// <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)
{
formMDI.infoError.ErrorString = "S1" + ex.Message;
}
}
public DataTable EmployeeCodeComboFill()
{
DataTable dtblEmployeeCode = new DataTable();
try
{
EmployeeSP spEmployee = new EmployeeSP();
dtblEmployeeCode = spEmployee.EmployeeViewAll();
}
catch (Exception ex)
{
}
return(dtblEmployeeCode);
}
/// <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 dtblEmployeeCode = new DataTable();
dtblEmployeeCode = spEmployee.EmployeeViewAll();
cmbEmployeeCode.DataSource = dtblEmployeeCode;
cmbEmployeeCode.ValueMember = "employeeId";
cmbEmployeeCode.DisplayMember = "employeeCode";
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "BD1:" + ex.Message;
}
}
/// <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("APR:4 " + ex.Message, "Open Miracle", 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)
{
formMDI.infoError.ErrorString = "APR:4 " + ex.Message;
}
}
/// <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 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)
{
formMDI.infoError.ErrorString = "PS1:" + ex.Message;
}
}
public DataTable FillEmployee()
{
DataTable dtbl = new DataTable();
try
{
EmployeeSP spEmployee = new EmployeeSP();
dtbl = spEmployee.EmployeeViewForPaySlip();
DataRow dr = dtbl.NewRow();
dr[0] = "0";
dr[1] = "--Select--";
dtbl.Rows.InsertAt(dr, 0);
return(dtbl);
}
catch (Exception ex)
{
return(null);
}
}
/// <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)
{
formMDI.infoError.ErrorString = "S6" + ex.Message;
}
}
/// <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;
}
}
/// <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)
{
formMDI.infoError.ErrorString = "SVRT8:" + ex.Message;
}
}
/// <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 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 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)
{
formMDI.infoError.ErrorString = "S8" + ex.Message;
}
}
public JsonResult GetEmployee(string employeeId)
{
bool isSuccess = true;
string message = "success";
EmployeeInfo info = new EmployeeInfo();
try
{
EmployeeSP spEmployee = new EmployeeSP();
int nEmployeeId = int.Parse(employeeId);
info = spEmployee.EmployeeView(nEmployeeId);
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new {
isSuccess = isSuccess,
message = message,
data = info
}));
}
public void SaveFunction()
{
try
{
EmployeeInfo empInfo = new EmployeeInfo();
EmployeeSP empSP = new EmployeeSP();
empInfo.EmployeeName = txtEmployeeName.Text.Trim();
empInfo.EmployeeCode = txtEmployeeCode.Text.Trim();
empInfo.Address = txtAddress.Text.Trim();
empInfo.BankAccountNumber = txtBankAccountNumber.Text.Trim();
empInfo.BankName = txtBankName.Text.Trim();
empInfo.BranchName = txtBranch.Text.Trim();
empInfo.DefaultPackageId = Convert.ToDecimal(cmbDefaultPackage.SelectedValue.ToString());
empInfo.Dob = Convert.ToDateTime(dtpDob.Text.Trim());
empInfo.Email = txtEmail.Text.Trim();
empInfo.Gender = cmbGender.SelectedText.Trim();
empInfo.MaritalStatus = cmbMaritalStatus.SelectedText.Trim();
empInfo.NhifNumber = txtNHIFNumber.Text.Trim();
empInfo.NssfNumber = txtNSSFNumber.Text.Trim();
empInfo.PhoneNumber = txtPhoneNumber.Text.Trim();
empInfo.PinNumber = txtPINNumber.Text.Trim();
empInfo.Qualification = txtQualification.Text.Trim();
empInfo.SalaryType = cmbSalaryType.SelectedText.Trim();
empInfo.JoiningDate = Convert.ToDateTime(dtpJoiningDate.Text.Trim());
empInfo.IsActive = cbxActive.Checked ? true : false;
empInfo.Address = txtAddress.Text.Trim();
empSP.EmployeeAdd(empInfo);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public JsonResult SaveEmployee(string employeeId, string strEmployee)
{
bool isSuccess = true;
string message = "success";
EmployeeInfo info = new EmployeeInfo();
try
{
EmployeeSP spEmployee = new EmployeeSP();
int nEmployeeId = int.Parse(employeeId);
Dictionary <string, object> dict = JsonConvert.DeserializeObject <Dictionary <string, object> >(strEmployee);
info.EmployeeId = int.Parse(dict["employeeId"].ToString());
info.EmployeeCode = dict["employeeCode"] == null ? string.Empty : dict["employeeCode"].ToString();
info.EmployeeName = dict["employeeName"] == null ? string.Empty : dict["employeeName"].ToString();
info.SalaryType = dict["salaryType"] == null ? string.Empty : dict["salaryType"].ToString();
if (info.SalaryType == "Daily wage")
{
info.DailyWage = decimal.Parse(dict["dailyWage"].ToString());
}
else
{
info.DefaultPackageId = int.Parse(dict["salaryPackage"].ToString());
}
info.DesignationId = int.Parse(dict["designationId"].ToString());
info.Dob = Convert.ToDateTime(dict["dob"].ToString());
info.MaritalStatus = dict["maritalStatus"] == null ? "Single" : dict["maritalStatus"].ToString();
info.Gender = dict["gender"] == null ? "Male" : dict["gender"].ToString();
info.Qualification = dict["qualification"] == null ? string.Empty : dict["qualification"].ToString();
info.BloodGroup = dict["bloodGroup"] == null ? string.Empty : dict["bloodGroup"].ToString();
info.JoiningDate = Convert.ToDateTime(dict["joiningDate"].ToString());
info.TerminationDate = Convert.ToDateTime(dict["terminationDate"].ToString());
info.Address = dict["address"] == null ? string.Empty : dict["address"].ToString();
info.PhoneNumber = dict["phoneNumber"] == null ? string.Empty : dict["phoneNumber"].ToString();
info.MobileNumber = dict["mobileNumber"] == null ? string.Empty : dict["mobileNumber"].ToString();
info.Email = dict["email"] == null ? string.Empty : dict["email"].ToString();
info.IsActive = bool.Parse(dict["isActive"].ToString());
info.Narration = dict["narration"] == null ? string.Empty : dict["narration"].ToString();
info.BankName = dict["bankName"] == null ? string.Empty : dict["bankName"].ToString();
info.BankAccountNumber = dict["bankNumber"] == null ? string.Empty : dict["bankNumber"].ToString();
info.BranchName = dict["branchName"] == null ? string.Empty : dict["branchName"].ToString();
info.BranchCode = dict["branchCode"] == null ? string.Empty : dict["branchCode"].ToString();
info.PanNumber = dict["panNumber"] == null ? string.Empty : dict["panNumber"].ToString();
info.PfNumber = dict["pfNumber"] == null ? string.Empty : dict["pfNumber"].ToString();
info.EsiNumber = dict["esiNumber"] == null ? string.Empty : dict["esiNumber"].ToString();
info.PassportNo = dict["passportNo"] == null ? string.Empty : dict["passportNo"].ToString();
info.PassportExpiryDate = Convert.ToDateTime(dict["passportExpiryDate"].ToString());
info.LabourCardNumber = dict["labourCardNumber"] == null ? string.Empty : dict["labourCardNumber"].ToString();
info.LabourCardExpiryDate = Convert.ToDateTime(dict["labourCardExpiryDate"].ToString());
info.VisaNumber = dict["visaNumber"] == null ? string.Empty : dict["visaNumber"].ToString();
info.VisaExpiryDate = Convert.ToDateTime(dict["visaExpiryDate"].ToString());
info.ExtraDate = DateTime.Now;
info.Extra1 = string.Empty;
info.Extra2 = string.Empty;
if (spEmployee.EmployeeCodeCheckExistance(info.EmployeeCode, nEmployeeId) == false)
{
if (nEmployeeId > 0) // edit mode
{
isSuccess = spEmployee.EmployeeEdit(info);
}
else //create mode
{
nEmployeeId = (int)spEmployee.EmployeeAddWithReturnIdentity(info);
if (nEmployeeId <= 0)
{
isSuccess = false;
message = "Can not save this employee with any issues.";
}
}
}
else
{
isSuccess = false;
message = "Employee code already Exist.";
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new
{
isSuccess = isSuccess,
message = message,
data = info
}));
}
/// <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)
{
formMDI.infoError.ErrorString = "S5" + ex.Message;
}
}
/// <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)
{
formMDI.infoError.ErrorString = "MSS8:" + ex.Message;
}
}
