public void DesignationUpdate(DesignationInfo designationInfo, decimal designationId) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand sqlcmd = new MySqlCommand("DesignationUpdate", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = sqlcmd.Parameters.Add("?designationName", MySqlDbType.VarChar); sqlparam.Value = designationInfo.Designation; sqlparam = sqlcmd.Parameters.Add("?description", MySqlDbType.VarChar); sqlparam.Value = designationInfo.Description; sqlparam = sqlcmd.Parameters.Add("?designationId", MySqlDbType.Int32); sqlparam.Value = designationId; sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); } }
public static DataTable InsertUpdate(DesignationInfo objDesignationInfo) { ISalesPOSDBManager dbManager = new SalesPOSDBManager(); DataTable dt = new DataTable(); try { dbManager.Open(); IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 5); param[0] = dbManager.getparam("@DesignationID", objDesignationInfo.DesignationID.ToString()); param[1] = dbManager.getparam("@DepartmentID", objDesignationInfo.DepartmentID.ToString()); param[2] = dbManager.getparam("@DesignationName", objDesignationInfo.DesignationName.ToString()); param[3] = dbManager.getparam("@ActivityID", objDesignationInfo.ActivityID.ToString()); param[4] = dbManager.getparam("@CreatedBy", objDesignationInfo.CreatedBy.ToString()); IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "dbo.USP_DesignationInfo_InsertUpdate", param); dt = dbManager.GetDataTable(cmd); } catch (Exception ex) { throw (ex); } finally { dt.Dispose(); dbManager.Dispose(); } return(dt); }
public List <SqlParameter> SetValuesInDesignation(DesignationInfo designation) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (designation.DesignationId != 0) { sqlParam.Add(new SqlParameter("DesignationId", designation.DesignationId)); } else { sqlParam.Add(new SqlParameter("CreatedDate", designation.CreatedDate)); sqlParam.Add(new SqlParameter("CreatedBy", designation.CreatedBy)); } sqlParam.Add(new SqlParameter("DesignationName", designation.DesignationName)); Logger.Debug("Designation Controller DesignationName:" + designation.DesignationName); sqlParam.Add(new SqlParameter("IsActive", designation.IsActive)); Logger.Debug("Designation Controller IsActive:" + designation.IsActive); sqlParam.Add(new SqlParameter("UpdatedBy", designation.UpdatedBy)); sqlParam.Add(new SqlParameter("UpdatedDate", designation.UpdatedDate)); return(sqlParam); }
public void FillControls() { DesignationSP designationSp = new DesignationSP(); DesignationInfo designationInfo = new DesignationInfo(); designationInfo = designationSp.DesignationViewOne(designationId); txtDesignationName.Text = designationInfo.Designation; txtDescription.Text = designationInfo.Description; }
public DesignationInfo GetDesignationValues(DataRow dr) { DesignationInfo retVal = new DesignationInfo(); retVal.DesignationId = Convert.ToInt32(dr["DesignationId"]); retVal.DesignationName = Convert.ToString(dr["DesignationName"]); return(retVal); }
public DesignationViewModel() { DesignationInfo = new DesignationInfo(); FriendlyMessage = new List <FriendlyMessage>(); DesignationList = new List <DesignationInfo>(); Pager = new PaginationInfo(); }
public void SaveFunction() { DesignationSP designationSp = new DesignationSP(); DesignationInfo designationInfo = new DesignationInfo(); designationInfo.Designation = txtDesignationName.Text.Trim(); designationInfo.Description = txtDescription.Text.Trim(); designationSp.DesignationAdd(designationInfo); Messages.SavedMessage(); GridFill(); ClearFunction(); }
public void EditFunction() { DesignationSP designationSp = new DesignationSP(); DesignationInfo designationInfo = new DesignationInfo(); designationInfo.Designation = txtDesignationName.Text.Trim(); designationInfo.Description = txtDescription.Text.Trim(); designationSp.DesignationUpdate(designationInfo, designationId); Messages.UpdatedMessage(); GridFill(); ClearFunction(); }
public bool DesignationEdit(DesignationInfo designationinfo) { bool isStatus = false; try { isStatus = spDesignation.DesignationEdit(designationinfo); } catch (Exception) { } return(isStatus); }
public bool DesignationEdit(DesignationInfo designationinfo) { bool isResult = false; try { isResult = spDesignation.DesignationEdit(designationinfo); } catch (Exception ex) { MessageBox.Show("DBLL:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isResult); }
public decimal DesignationAddWithReturnIdentity(DesignationInfo designationinfo) { decimal decId = 0; try { decId = spDesignation.DesignationAddWithReturnIdentity(designationinfo); } catch (Exception ex) { MessageBox.Show("BR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decId); }
public DesignationInfo DesignationView(decimal designationId) { DesignationInfo designationinfo = new DesignationInfo(); try { designationinfo = spDesignation.DesignationView(designationId); } catch (Exception ex) { MessageBox.Show("DBLL:5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(designationinfo); }
/// <summary> /// Function to Update values in Designation Table /// </summary> /// <param name="designationinfo"></param> /// <returns></returns> public bool DesignationEdit(DesignationInfo designationinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DesignationEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@designationId", SqlDbType.Decimal); sprmparam.Value = designationinfo.DesignationId; sprmparam = sccmd.Parameters.Add("@designationName", SqlDbType.VarChar); sprmparam.Value = designationinfo.DesignationName; sprmparam = sccmd.Parameters.Add("@leaveDays", SqlDbType.Decimal); sprmparam.Value = designationinfo.LeaveDays; sprmparam = sccmd.Parameters.Add("@advanceAmount", SqlDbType.Decimal); sprmparam.Value = designationinfo.AdvanceAmount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = designationinfo.Narration; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = designationinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = designationinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = designationinfo.Extra2; int inEffectedRow = sccmd.ExecuteNonQuery(); if (inEffectedRow > 0) { return(true); } else { return(false); } } catch (Exception ex) { //MessageBox.Show(ex.ToString()); return(false); } finally { sqlcon.Close(); } }
/// <summary> /// Function for save /// </summary> private void SaveFunction() { try { DesignationInfo infoDesignation = new DesignationInfo(); DesignationSP spDesignation = new DesignationSP(); if (txtAdvanceAmount.Text == string.Empty) { infoDesignation.AdvanceAmount = 0; } else { infoDesignation.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text.Trim()); } infoDesignation.DesignationName = txtDesignationName.Text.Trim(); if (txtCLInMonth.Text == string.Empty) { infoDesignation.LeaveDays = 0; } else { infoDesignation.LeaveDays = Convert.ToDecimal(txtCLInMonth.Text.Trim()); } decimal decD = infoDesignation.LeaveDays; infoDesignation.Narration = txtNarration.Text.Trim(); infoDesignation.Extra1 = string.Empty; infoDesignation.Extra2 = string.Empty; infoDesignation.ExtraDate = DateTime.Now; if (CheckExistanceOfDesignation(txtDesignationName.Text.Trim(), 0) == false) { decIdentity = spDesignation.DesignationAddWithReturnIdentity(infoDesignation); if (decIdentity > 0) { Messages.SavedMessage(); } } else { Messages.InformationMessage("Designation already exist"); } } catch (Exception ex) { MessageBox.Show("D8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> private void EditFunction() { try { DesignationInfo infoDesignation = new DesignationInfo(); DesignationSP spDesignation = new DesignationSP(); if (txtAdvanceAmount.Text == string.Empty) { infoDesignation.AdvanceAmount = 0; } else { infoDesignation.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text.Trim()); } infoDesignation.DesignationName = txtDesignationName.Text.TrimEnd(); if (txtCLInMonth.Text == string.Empty) { infoDesignation.LeaveDays = 0; } else { infoDesignation.LeaveDays = Convert.ToDecimal(txtCLInMonth.Text.Trim()); } infoDesignation.Narration = txtNarration.Text.Trim(); infoDesignation.Extra1 = string.Empty; infoDesignation.Extra2 = string.Empty; infoDesignation.ExtraDate = DateTime.Now; if (CheckExistanceOfDesignation(txtDesignationName.Text.Trim(), decDesignationId) == false) { infoDesignation.DesignationId = decDesignationId; if (spDesignation.DesignationEdit(infoDesignation)) { Messages.UpdatedMessage(); } } else { Messages.InformationMessage("Designation already exist"); } } catch (Exception ex) { MessageBox.Show("D9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill controls fpor update /// </summary> private void FillControls() { try { DesignationInfo infoDesignaion = new DesignationInfo(); DesignationSP spDesignation = new DesignationSP(); infoDesignaion = spDesignation.DesignationView(decDesignationId); txtDesignationName.Text = infoDesignaion.DesignationName; txtCLInMonth.Text = infoDesignaion.LeaveDays.ToString(); txtAdvanceAmount.Text = infoDesignaion.AdvanceAmount.ToString(); txtNarration.Text = infoDesignaion.Narration; btnSave.Text = "Update"; } catch (Exception ex) { MessageBox.Show("D6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values and return id /// </summary> /// <param name="designationinfo"></param> /// <returns></returns> public decimal DesignationAddWithReturnIdentity(DesignationInfo designationinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DesignationAddWithReturnIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@designationName", SqlDbType.VarChar); sprmparam.Value = designationinfo.DesignationName; sprmparam = sccmd.Parameters.Add("@leaveDays", SqlDbType.Decimal); sprmparam.Value = designationinfo.LeaveDays; sprmparam = sccmd.Parameters.Add("@advanceAmount", SqlDbType.Decimal); sprmparam.Value = designationinfo.AdvanceAmount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = designationinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = designationinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = designationinfo.Extra2; object obj = sccmd.ExecuteScalar(); if (obj != null) { decIdentity = Convert.ToDecimal(obj.ToString()); } return(decIdentity); } catch (Exception ex) { //MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(decIdentity); }
public List <SqlParameter> SetValuesIndesignationInfo(DesignationInfo designationInfo) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (designationInfo.Id != 0) { sqlParam.Add(new SqlParameter("@DesignationId", designationInfo.Id)); } else { sqlParam.Add(new SqlParameter("@CreatedBy", designationInfo.CreatedBy)); } sqlParam.Add(new SqlParameter("@Designation", designationInfo.DesignationName)); sqlParam.Add(new SqlParameter("@IsActive", designationInfo.Active)); sqlParam.Add(new SqlParameter("@UpdatedBy", designationInfo.UpdatedBy)); return(sqlParam); }
/// <summary> /// Function to get particular values from Designation Table based on the parameter /// </summary> /// <param name="designationId"></param> /// <returns></returns> public DesignationInfo DesignationView(decimal designationId) { DesignationInfo designationinfo = new DesignationInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DesignationView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@designationId", SqlDbType.Decimal); sprmparam.Value = designationId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { designationinfo.DesignationId = decimal.Parse(sdrreader[0].ToString()); designationinfo.DesignationName = sdrreader[1].ToString(); designationinfo.LeaveDays = decimal.Parse(sdrreader[2].ToString()); designationinfo.AdvanceAmount = decimal.Parse(sdrreader[3].ToString()); designationinfo.Narration = sdrreader[4].ToString(); designationinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString()); designationinfo.Extra1 = sdrreader[6].ToString(); designationinfo.Extra2 = sdrreader[7].ToString(); } } catch (Exception ex) { //MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(designationinfo); }
public DesignationInfo DesignationViewOne(decimal designationId) { DesignationInfo designationInfo = new DesignationInfo(); try { MySqlDataReader sqlreader = null; if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } MySqlCommand sqlcmd = new MySqlCommand("DesignationViewOne", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; MySqlParameter sqlparam = new MySqlParameter(); sqlparam = sqlcmd.Parameters.Add("?designationId", MySqlDbType.Int32); sqlparam.Value = designationId; sqlreader = sqlcmd.ExecuteReader(); while (sqlreader.Read()) { designationInfo.Designation = sqlreader[1].ToString(); designationInfo.Description = sqlreader[2].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlcon.Close(); } return(designationInfo); }
public int Insert_Designation(DesignationInfo _designationInfo) { return(_designationRepo.Insert(_designationInfo)); }
public void Update_Designation(DesignationInfo _designationInfo) { _designationRepo.Update(_designationInfo); }
public int Insert(DesignationInfo designationInfo) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesIndesignationInfo(designationInfo), StoredProcedureEnum.sp_Insert_Designation.ToString(), CommandType.StoredProcedure))); }
public void Update(DesignationInfo designation) { _sqlHelper.ExecuteNonQuery(SetValuesInDesignation(designation), Storeprocedures.spUpdateDesignation.ToString(), CommandType.StoredProcedure); }
public int Insert(DesignationInfo designation) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInDesignation(designation), Storeprocedures.spInsertDesignation.ToString(), CommandType.StoredProcedure))); }
public void Update(DesignationInfo designationInfo) { _sqlHelper.ExecuteNonQuery(SetValuesIndesignationInfo(designationInfo), StoredProcedureEnum.sp_Update_Designation.ToString(), CommandType.StoredProcedure); }
/// <summary> /// Function for save /// </summary> private void SaveFunction() { try { DesignationInfo infoDesignation = new DesignationInfo(); //DesignationSP spDesignation = new DesignationSP(); DesiginationBll bllDesigination = new DesiginationBll(); if (txtAdvanceAmount.Text == string.Empty) { infoDesignation.AdvanceAmount = 0; } else { infoDesignation.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text.Trim()); } infoDesignation.DesignationName = txtDesignationName.Text.Trim(); if (txtCLInMonth.Text == string.Empty) { infoDesignation.LeaveDays = 0; } else { infoDesignation.LeaveDays = Convert.ToDecimal(txtCLInMonth.Text.Trim()); } decimal decD = infoDesignation.LeaveDays; infoDesignation.Narration = txtNarration.Text.Trim(); infoDesignation.Extra1 = string.Empty; infoDesignation.Extra2 = string.Empty; infoDesignation.ExtraDate = DateTime.Now; if (CheckExistanceOfDesignation(txtDesignationName.Text.Trim(), 0) == false) { decIdentity = bllDesigination.DesignationAddWithReturnIdentity(infoDesignation); if (decIdentity > 0) { Messages.SavedMessage(); } } else { Messages.InformationMessage("Designation already exist"); } } catch (Exception ex) { MessageBox.Show("D8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill controls fpor update /// </summary> private void FillControls() { try { DesignationInfo infoDesignaion = new DesignationInfo(); //DesignationSP spDesignation = new DesignationSP(); DesiginationBll bllDesigination = new DesiginationBll(); infoDesignaion = bllDesigination.DesignationView(decDesignationId); txtDesignationName.Text = infoDesignaion.DesignationName; txtCLInMonth.Text = infoDesignaion.LeaveDays.ToString(); txtAdvanceAmount.Text = infoDesignaion.AdvanceAmount.ToString(); txtNarration.Text = infoDesignaion.Narration; btnSave.Text = "Update"; } catch (Exception ex) { MessageBox.Show("D6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> private void EditFunction() { try { DesignationInfo infoDesignation = new DesignationInfo(); //DesignationSP spDesignation = new DesignationSP(); DesiginationBll bllDesigination = new DesiginationBll(); if (txtAdvanceAmount.Text == string.Empty) { infoDesignation.AdvanceAmount = 0; } else { infoDesignation.AdvanceAmount = Convert.ToDecimal(txtAdvanceAmount.Text.Trim()); } infoDesignation.DesignationName = txtDesignationName.Text.TrimEnd(); if (txtCLInMonth.Text == string.Empty) { infoDesignation.LeaveDays = 0; } else { infoDesignation.LeaveDays = Convert.ToDecimal(txtCLInMonth.Text.Trim()); } infoDesignation.Narration = txtNarration.Text.Trim(); infoDesignation.Extra1 = string.Empty; infoDesignation.Extra2 = string.Empty; infoDesignation.ExtraDate = DateTime.Now; if (CheckExistanceOfDesignation(txtDesignationName.Text.Trim(), decDesignationId) == false) { infoDesignation.DesignationId = decDesignationId; if (bllDesigination.DesignationEdit(infoDesignation)) { Messages.UpdatedMessage(); } } else { Messages.InformationMessage("Designation already exist"); } } catch (Exception ex) { MessageBox.Show("D9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }