public void EmployeeAdd(EmployeeInfo employeeinfo) { try { SPEmployee.EmployeeAdd(employeeinfo); } catch (Exception ex) { MessageBox.Show("EC1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <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 insert values to Employee Table if not exist employee code /// </summary> /// <param name="employeeinfo"></param> /// <returns></returns> public bool EmployeeAddIfNotExistsEmployeeCode(EmployeeInfo employeeinfo) { bool isSave = false; try { isSave = SPEmployee.EmployeeAddIfNotExistsEmployeeCode(employeeinfo); } catch (Exception ex) { MessageBox.Show("EC5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isSave; }
/// <summary> /// Function to get all details for search based on parameter /// </summary> /// <param name="strUnitName"></param> /// <returns></returns> public List<DataTable> UnitSearch(string strUnitName) { EmployeeInfo infoEmployee = new EmployeeInfo(); List<DataTable> ListObj = new List<DataTable>(); DataTable dtbl = new DataTable(); try { SqlDataAdapter sqlda = new SqlDataAdapter("UnitSearch", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; dtbl.Columns.Add("SLNO", typeof(decimal)); dtbl.Columns["SLNO"].AutoIncrement = true; dtbl.Columns["SLNO"].AutoIncrementSeed = 1; dtbl.Columns["SLNO"].AutoIncrementStep = 1; sqlda.SelectCommand.Parameters.Add("@unitName", SqlDbType.VarChar).Value = strUnitName; sqlda.Fill(dtbl); ListObj.Add(dtbl); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return ListObj; }
/// <summary> /// Function to get particular values from employee table based on the parameter /// </summary> /// <param name="employeeId"></param> /// <returns></returns> public EmployeeInfo SalesmanViewSpecificFeilds(decimal employeeId) { EmployeeInfo infoemployee = new EmployeeInfo(); try { infoemployee = SPEmployee.SalesmanViewSpecificFeilds(employeeId); } catch (Exception ex) { MessageBox.Show("EC14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoemployee; }
/// <summary> /// Function to Update values in employee Table for salesman /// </summary> /// <param name="employeeinfo"></param> /// <returns></returns> public bool SalesmanEdit(EmployeeInfo employeeinfo) { bool isEdit = false; try { isEdit = SPEmployee.SalesmanEdit(employeeinfo); } catch (Exception ex) { MessageBox.Show("EC16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isEdit; }
/// <summary> /// Function to get particular values from Employee table based on the parameter /// </summary> /// <param name="employeeId"></param> /// <returns></returns> public EmployeeInfo EmployeeView(decimal employeeId) { EmployeeInfo infoemployee = new EmployeeInfo(); try { infoemployee = SPEmployee.EmployeeView(employeeId); } catch (Exception ex) { MessageBox.Show("EC8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoemployee; }
/// <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 search the employee /// </summary> /// <param name="infoEmployee"></param> /// <returns></returns> public List<DataTable> EmployeeSearch(EmployeeInfo infoEmployee) { List<DataTable> listObj = new List<DataTable>(); DataTable dtblEmployee = new DataTable(); try { SqlDataAdapter sqlda = new SqlDataAdapter("EmployeeSearch", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; dtblEmployee.Columns.Add("SlNo", typeof(decimal)); dtblEmployee.Columns["SlNo"].AutoIncrement = true; dtblEmployee.Columns["SlNo"].AutoIncrementSeed = 1; dtblEmployee.Columns["SlNo"].AutoIncrementStep = 1; sqlda.SelectCommand.Parameters.Add("@employeeCode", SqlDbType.VarChar).Value = infoEmployee.EmployeeCode; sqlda.SelectCommand.Parameters.Add("@employeeName", SqlDbType.VarChar).Value = infoEmployee.EmployeeName; sqlda.SelectCommand.Parameters.Add("@designationId", SqlDbType.Decimal).Value = infoEmployee.DesignationId; sqlda.SelectCommand.Parameters.Add("@salaryType", SqlDbType.VarChar).Value = infoEmployee.SalaryType; sqlda.SelectCommand.Parameters.Add("@bankAccountNumber", SqlDbType.VarChar).Value = infoEmployee.BankAccountNumber; sqlda.SelectCommand.Parameters.Add("@passportNumber", SqlDbType.VarChar).Value = infoEmployee.PassportNo; sqlda.SelectCommand.Parameters.Add("@labourCardNumber", SqlDbType.VarChar).Value = infoEmployee.LabourCardNumber; sqlda.SelectCommand.Parameters.Add("@visaNumber", SqlDbType.VarChar).Value = infoEmployee.VisaNumber; sqlda.Fill(dtblEmployee); listObj.Add(dtblEmployee); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return listObj; }
/// <summary> /// Function to get particular values from Employee table based on the parameter /// </summary> /// <param name="employeeId"></param> /// <returns></returns> public EmployeeInfo EmployeeView(decimal employeeId) { EmployeeInfo infoemployee = new EmployeeInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("EmployeeView", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sqlcmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = employeeId; sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoemployee.EmployeeId = Convert.ToDecimal(sqldr["employeeId"].ToString()); infoemployee.DesignationId = Convert.ToDecimal(sqldr["designationId"].ToString()); infoemployee.EmployeeName = sqldr["employeeName"].ToString(); infoemployee.EmployeeCode = sqldr["employeeCode"].ToString(); infoemployee.Dob = Convert.ToDateTime(sqldr["dob"].ToString()); infoemployee.MaritalStatus = sqldr["maritalStatus"].ToString(); infoemployee.Gender = sqldr["gender"].ToString(); infoemployee.Qualification = sqldr["qualification"].ToString(); infoemployee.Address = sqldr["address"].ToString(); infoemployee.PhoneNumber = sqldr["phoneNumber"].ToString(); infoemployee.MobileNumber = sqldr["mobileNumber"].ToString(); infoemployee.Email = sqldr["email"].ToString(); infoemployee.JoiningDate = Convert.ToDateTime(sqldr["joiningDate"].ToString()); infoemployee.TerminationDate = Convert.ToDateTime(sqldr["terminationDate"].ToString()); infoemployee.IsActive = bool.Parse(sqldr["isActive"].ToString()); infoemployee.Narration = sqldr["narration"].ToString(); infoemployee.BloodGroup = sqldr["bloodGroup"].ToString(); infoemployee.PassportNo = sqldr["passportNo"].ToString(); infoemployee.PassportExpiryDate = Convert.ToDateTime(sqldr["passportExpiryDate"].ToString()); infoemployee.LabourCardNumber = sqldr["labourCardNumber"].ToString(); infoemployee.LabourCardExpiryDate = Convert.ToDateTime(sqldr["labourCardExpiryDate"].ToString()); infoemployee.VisaNumber = sqldr["visaNumber"].ToString(); infoemployee.VisaExpiryDate = Convert.ToDateTime(sqldr["visaExpiryDate"].ToString()); infoemployee.SalaryType = sqldr["salaryType"].ToString(); infoemployee.DailyWage = Convert.ToDecimal(sqldr["dailyWage"].ToString()); infoemployee.BankName = sqldr["bankName"].ToString(); infoemployee.BranchName = sqldr["branchName"].ToString(); infoemployee.BankAccountNumber = sqldr["bankAccountNumber"].ToString(); infoemployee.BranchCode = sqldr["branchCode"].ToString(); infoemployee.PanNumber = sqldr["panNumber"].ToString(); infoemployee.PfNumber = sqldr["pfNumber"].ToString(); infoemployee.EsiNumber = sqldr["esiNumber"].ToString(); infoemployee.DefaultPackageId = Convert.ToDecimal(sqldr["defaultPackageId"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqldr.Close(); sqlcon.Close(); } return infoemployee; }
/// <summary> /// Function to Update values in Employee Table /// </summary> /// <param name="employeeinfo"></param> /// <returns></returns> public bool EmployeeEdit(EmployeeInfo employeeinfo) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("EmployeeEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@designationId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DesignationId; sprmparam = sccmd.Parameters.Add("@employeeName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeName; sprmparam = sccmd.Parameters.Add("@employeeCode", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeCode; sprmparam = sccmd.Parameters.Add("@dob", SqlDbType.DateTime); sprmparam.Value = employeeinfo.Dob; sprmparam = sccmd.Parameters.Add("@maritalStatus", SqlDbType.VarChar); sprmparam.Value = employeeinfo.MaritalStatus; sprmparam = sccmd.Parameters.Add("@gender", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Gender; sprmparam = sccmd.Parameters.Add("@qualification", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Qualification; sprmparam = sccmd.Parameters.Add("@address", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Address; sprmparam = sccmd.Parameters.Add("@phoneNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PhoneNumber; sprmparam = sccmd.Parameters.Add("@mobileNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.MobileNumber; sprmparam = sccmd.Parameters.Add("@email", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Email; sprmparam = sccmd.Parameters.Add("@joiningDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.JoiningDate; sprmparam = sccmd.Parameters.Add("@terminationDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.TerminationDate; sprmparam = sccmd.Parameters.Add("@active", SqlDbType.Bit); sprmparam.Value = employeeinfo.IsActive; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Narration; sprmparam = sccmd.Parameters.Add("@bloodGroup", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BloodGroup; sprmparam = sccmd.Parameters.Add("@passportNo", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PassportNo; sprmparam = sccmd.Parameters.Add("@passportExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.PassportExpiryDate; sprmparam = sccmd.Parameters.Add("@labourCardNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.LabourCardNumber; sprmparam = sccmd.Parameters.Add("@labourCardExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.LabourCardExpiryDate; sprmparam = sccmd.Parameters.Add("@visaNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.VisaNumber; sprmparam = sccmd.Parameters.Add("@visaExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.VisaExpiryDate; sprmparam = sccmd.Parameters.Add("@salaryType", SqlDbType.VarChar); sprmparam.Value = employeeinfo.SalaryType; sprmparam = sccmd.Parameters.Add("@dailyWage", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DailyWage; sprmparam = sccmd.Parameters.Add("@bankName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BankName; sprmparam = sccmd.Parameters.Add("@branchName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BranchName; sprmparam = sccmd.Parameters.Add("@bankAccountNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BankAccountNumber; sprmparam = sccmd.Parameters.Add("@branchCode", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BranchCode; sprmparam = sccmd.Parameters.Add("@panNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PanNumber; sprmparam = sccmd.Parameters.Add("@pfNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PfNumber; sprmparam = sccmd.Parameters.Add("@esiNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EsiNumber; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Extra2; sprmparam = sccmd.Parameters.Add("@defaultPackageId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DefaultPackageId; int inAffectedRows = sccmd.ExecuteNonQuery(); if (inAffectedRows > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }
/// <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 { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("EmployeeForTakingEmployeeId", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@designationId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DesignationId; sprmparam = sccmd.Parameters.Add("@employeeName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeName; sprmparam = sccmd.Parameters.Add("@employeeCode", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeCode; sprmparam = sccmd.Parameters.Add("@dob", SqlDbType.DateTime); sprmparam.Value = employeeinfo.Dob; sprmparam = sccmd.Parameters.Add("@maritalStatus", SqlDbType.VarChar); sprmparam.Value = employeeinfo.MaritalStatus; sprmparam = sccmd.Parameters.Add("@gender", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Gender; sprmparam = sccmd.Parameters.Add("@qualification", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Qualification; sprmparam = sccmd.Parameters.Add("@address", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Address; sprmparam = sccmd.Parameters.Add("@phoneNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PhoneNumber; sprmparam = sccmd.Parameters.Add("@mobileNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.MobileNumber; sprmparam = sccmd.Parameters.Add("@email", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Email; sprmparam = sccmd.Parameters.Add("@joiningDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.JoiningDate; sprmparam = sccmd.Parameters.Add("@terminationDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.TerminationDate; sprmparam = sccmd.Parameters.Add("@active", SqlDbType.Bit); sprmparam.Value = employeeinfo.IsActive; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Narration; sprmparam = sccmd.Parameters.Add("@bloodGroup", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BloodGroup; sprmparam = sccmd.Parameters.Add("@passportNo", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PassportNo; sprmparam = sccmd.Parameters.Add("@passportExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.PassportExpiryDate; sprmparam = sccmd.Parameters.Add("@labourCardNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.LabourCardNumber; sprmparam = sccmd.Parameters.Add("@labourCardExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.LabourCardExpiryDate; sprmparam = sccmd.Parameters.Add("@visaNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.VisaNumber; sprmparam = sccmd.Parameters.Add("@visaExpiryDate", SqlDbType.DateTime); sprmparam.Value = employeeinfo.VisaExpiryDate; sprmparam = sccmd.Parameters.Add("@salaryType", SqlDbType.VarChar); sprmparam.Value = employeeinfo.SalaryType; sprmparam = sccmd.Parameters.Add("@dailyWage", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DailyWage; sprmparam = sccmd.Parameters.Add("@bankName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BankName; sprmparam = sccmd.Parameters.Add("@branchName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BranchName; sprmparam = sccmd.Parameters.Add("@bankAccountNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BankAccountNumber; sprmparam = sccmd.Parameters.Add("@branchCode", SqlDbType.VarChar); sprmparam.Value = employeeinfo.BranchCode; sprmparam = sccmd.Parameters.Add("@panNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PanNumber; sprmparam = sccmd.Parameters.Add("@pfNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PfNumber; sprmparam = sccmd.Parameters.Add("@esiNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EsiNumber; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Extra2; sprmparam = sccmd.Parameters.Add("@defaultPackageId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.DefaultPackageId; object AdvancePaymentId = sccmd.ExecuteScalar(); if (AdvancePaymentId != null) { decEmployee = Convert.ToDecimal(AdvancePaymentId.ToString()); } else { decEmployee = -1; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decEmployee; }
/// <summary> /// Function to get particular values from employee table based on the parameter /// </summary> /// <param name="employeeId"></param> /// <returns></returns> public EmployeeInfo SalesmanViewSpecificFeilds(decimal employeeId) { EmployeeInfo infoemployee = new EmployeeInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("SalesmanViewSpecificFeilds", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sqlcmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = employeeId; sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoemployee.EmployeeId = Convert.ToDecimal(sqldr["employeeId"].ToString()); infoemployee.EmployeeName = sqldr["employeeName"].ToString(); infoemployee.EmployeeCode = sqldr["employeeCode"].ToString(); infoemployee.Email = sqldr["email"].ToString(); infoemployee.PhoneNumber = sqldr["phoneNumber"].ToString(); infoemployee.MobileNumber = sqldr["mobileNumber"].ToString(); infoemployee.Address = sqldr["address"].ToString(); infoemployee.Narration = sqldr["narration"].ToString(); infoemployee.IsActive = Convert.ToBoolean(sqldr["isActive"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqldr.Close(); sqlcon.Close(); } return infoemployee; }
/// <summary> /// Function to Update values in employee Table for salesman /// </summary> /// <param name="employeeinfo"></param> /// <returns></returns> public bool SalesmanEdit(EmployeeInfo employeeinfo) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalesmanEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = employeeinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@employeeName", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeName; sprmparam = sccmd.Parameters.Add("@employeeCode", SqlDbType.VarChar); sprmparam.Value = employeeinfo.EmployeeCode; sprmparam = sccmd.Parameters.Add("@address", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Address; sprmparam = sccmd.Parameters.Add("@phoneNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.PhoneNumber; sprmparam = sccmd.Parameters.Add("@mobileNumber", SqlDbType.VarChar); sprmparam.Value = employeeinfo.MobileNumber; sprmparam = sccmd.Parameters.Add("@email", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Email; sprmparam = sccmd.Parameters.Add("@isActive", SqlDbType.Bit); sprmparam.Value = employeeinfo.IsActive; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = employeeinfo.Narration; int inAffectedRows = sccmd.ExecuteNonQuery(); if (inAffectedRows > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }
/// <summary> /// Function to view details for update based on parameter /// </summary> /// <param name="decBonusDeductionId"></param> /// <returns></returns> public BonusDedutionInfo BonusDeductionViewForUpdate(decimal decBonusDeductionId) { BonusDedutionInfo BonusDeductionInfo = new BonusDedutionInfo(); EmployeeInfo InfoEmployee = new EmployeeInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("BonusDeductionViewForUpdate", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@bonusDeductionId", SqlDbType.Decimal).Value = decBonusDeductionId; sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { BonusDeductionInfo.EmployeeId = decimal.Parse(sqldr["employeeId"].ToString()); BonusDeductionInfo.Date = DateTime.Parse(sqldr["date"].ToString()); BonusDeductionInfo.Month = DateTime.Parse(sqldr["month"].ToString()); BonusDeductionInfo.BonusAmount = decimal.Parse(sqldr["bonusAmount"].ToString()); BonusDeductionInfo.DeductionAmount = decimal.Parse(sqldr["deductionAmount"].ToString()); BonusDeductionInfo.Narration = sqldr["narration"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqldr.Close(); sqlcon.Close(); } return BonusDeductionInfo; }