/// <summary>
/// Function to insert values to Employee Table and returns last identity
/// </summary>
/// <param name="employeeinfo"></param>
/// <returns></returns>
public decimal EmployeeAddWithReturnIdentity(EmployeeInfo employeeinfo)
{
decimal decEmployee = -1;
try
{
decEmployee = SPEmployee.EmployeeAddWithReturnIdentity(employeeinfo);
}
catch (Exception ex)
{
MessageBox.Show("EC11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decEmployee);
}
/// <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;
}
}
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
}));
}
