/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateMoldCategoryData() { int selectedrowindex = MoldCategory_dgv.SelectedCells[0].RowIndex; MoldCategoryVo cavInVo = (MoldCategoryVo)MoldCategory_dgv.Rows[selectedrowindex].DataBoundItem; AddMoldCategoryForm newAddForm = new AddMoldCategoryForm(CommonConstants.MODE_UPDATE, cavInVo); newAddForm.ShowDialog(this); if (newAddForm.IntSuccess > 0) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (newAddForm.IntSuccess == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00004, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_mold_category"); sqlQuery.Append(" Set "); sqlQuery.Append(" mold_category_name = :moldcategoryname, "); sqlQuery.Append(" display_order = :displayorder "); sqlQuery.Append(" Where "); sqlQuery.Append(" factory_cd = :factorycode and mold_category_id = :moldcategoryid;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); sqlParameter.AddParameterInteger("moldcategoryid", inVo.MoldCategoryId); sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); MoldCategoryVo outVo = new MoldCategoryVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// For setting selected user record into respective controls(textbox and combobox) for update operation /// passing selected user data as parameter /// </summary> /// <param name="dgvMoldType"></param> private void LoadUserData(MoldCategoryVo dgvMoldType) { if (dgvMoldType != null) { this.MoldCategoryCode_txt.Text = dgvMoldType.MoldCategoryCode; this.MoldCategoryName_txt.Text = dgvMoldType.MoldCategoryName; //this.DisplayOrder_txt.Text = dgvMoldType.DisplayOrder.ToString(); } }
private void LoadMoldCategoryCombo() { MoldCategoryVo inVo = new MoldCategoryVo(); ValueObjectList <MoldCategoryVo> outVo = (ValueObjectList <MoldCategoryVo>)DefaultCbmInvoker.Invoke(new GetMoldCategoryMasterMntCbm(), inVo); MoldCategory_cmb.DataSource = outVo.GetList(); MoldCategory_cmb.DisplayMember = "MoldCategoryName"; MoldCategory_cmb.ValueMember = "MoldCategoryId"; MoldCategory_cmb.SelectedIndex = -1; }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select Count(*) as MoldCategoryCount,"); sqlQuery.Append(" mold_category_cd, "); sqlQuery.Append(" mold_category_id "); sqlQuery.Append(" from m_mold_category "); sqlQuery.Append(" where factory_cd = :factorycode "); if (inVo.MoldCategoryCode != null) { sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldCategorycd) "); } sqlQuery.Append(" group by mold_category_cd,mold_category_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); if (inVo.MoldCategoryCode != null) { sqlParameter.AddParameterString("moldCategorycd", inVo.MoldCategoryCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <MoldCategoryVo> outVo = new ValueObjectList <MoldCategoryVo> (); while (dataReader.Read()) { MoldCategoryVo currOutVo = new MoldCategoryVo { MoldCategoryId = Convert.ToInt32(dataReader["mold_category_id"]), MoldCategoryCode = dataReader["mold_category_cd"].ToString(), }; outVo.add(currOutVo); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_mold_category"); sqlQuery.Append(" ( "); sqlQuery.Append(" mold_category_cd, "); sqlQuery.Append(" mold_category_name, "); sqlQuery.Append(" display_order, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :moldcategorycd ,"); sqlQuery.Append(" :moldcategoryname ,"); sqlQuery.Append(" :displayorder ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append("RETURNING mold_category_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode); sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); //execute SQL int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; MoldCategoryVo outVo = null; if (outId > 0) { outVo = new MoldCategoryVo(); outVo.MoldCategoryId = outId; } return(outVo); }
/// <summary> /// Constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddMoldCategoryForm(string pmode, MoldCategoryVo userItem = null) { InitializeComponent(); mode = pmode; updateData = userItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
/// <summary> /// checks duplicate Display Record /// </summary> /// <param name="defectVo"></param> /// <returns></returns> private MoldCategoryVo DuplicateDisplayCheck(MoldCategoryVo defectVo) { MoldCategoryVo outVo = new MoldCategoryVo(); try { outVo = (MoldCategoryVo)base.InvokeCbm(new CheckDisplayRecordMasterMntCbm(), defectVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private MoldCategoryVo FormConditionVo() { MoldCategoryVo inVo = new MoldCategoryVo(); if (MoldCategoryCode_txt.Text != string.Empty) { inVo.MoldCategoryCode = MoldCategoryCode_txt.Text; } if (MoldCategoryName_txt.Text != string.Empty) { inVo.MoldCategoryName = MoldCategoryName_txt.Text; } return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; MoldCategoryVo outVo = new MoldCategoryVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL query sqlQuery.Append("Select Count(*) DefRsnCount from m_mold_category "); sqlQuery.Append(" where factory_cd = :factorycode "); if (inVo.DisplayOrder != 0) { sqlQuery.Append(" and display_order = :displayorder"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); if (inVo.DisplayOrder != 0) { sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); outVo.AffectedCount = 0; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// form country and factory data for combo /// </summary> //private void FormDatatableFromVo() //{ // moldDatatable = new DataTable(); // moldDatatable.Columns.Add("id"); // moldDatatable.Columns.Add("code"); // try // { // MoldVo moldOutVo = (MoldVo)base.InvokeCbm(new GetMoldMasterMntCbm(), new MoldVo (), false); // foreach (MoldVo mold in moldOutVo.MoldListVo) // { // moldDatatable.Rows.Add(mold.MoldId, mold.MoldCode); // } // } // catch (Framework.ApplicationException exception) // { // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); // } //} /// <summary> /// checks duplicate mold Code /// </summary> /// <returns></returns> private MoldCategoryVo DuplicateCheck(MoldCategoryVo MoldCategoryVo) { MoldCategoryVo outVo = new MoldCategoryVo(); try { this.Cursor = Cursors.WaitCursor; outVo = (MoldCategoryVo)base.InvokeCbm(new CheckMoldCategoryMasterMntCbm(), MoldCategoryVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { this.Cursor = Cursors.Default; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select count(mc.mold_category_cd) as CategoryCount from m_mold_detail md"); sqlQuery.Append(" inner join m_mold_category mc on mc.mold_category_id = md.mold_category_id"); sqlQuery.Append(" where mc.factory_cd = :factorycode "); if (inVo.MoldCategoryCode != null) { sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldcategorycd) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); if (inVo.MoldCategoryCode != null) { sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); MoldCategoryVo outVo = new MoldCategoryVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32("0" + dataReader["CategoryCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(MoldCategoryVo conditionInVo) { MoldCategory_dgv.DataSource = null; try { this.Cursor = Cursors.WaitCursor; ValueObjectList <MoldCategoryVo> outVo = (ValueObjectList <MoldCategoryVo>)base.InvokeCbm(new GetMoldCategoryMasterMntCbm(), conditionInVo, false); MoldCategory_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null); if (bindingSource1 != null && bindingSource1.Count > 0) { MoldCategory_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"MoldCategory" logger.Info(messageData); popUpMessage.Information(messageData, Text); } MoldCategory_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { this.Cursor = Cursors.Default; } }
private void AddCategory(TransactionContext trxContext, ValueObjectList <MoldCategoryVo> moldCategoryInVo) { foreach (MoldCategoryVo moldCategoryVo in moldCategoryInVo.GetList()) { // Checking existing data ValueObjectList <MoldCategoryVo> moldCategoryCheckVo = (ValueObjectList <MoldCategoryVo>)checkMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo); if (moldCategoryCheckVo != null && moldCategoryCheckVo.GetList().Count > 0) { foreach (MoldCategoryVo curVo in moldCategoryCheckVo.GetList()) { if (!categoryList.ContainsKey(curVo.MoldCategoryCode)) { categoryList.Add(curVo.MoldCategoryCode, curVo.MoldCategoryId); } } } else { MoldCategoryVo moldCategoryOutVo = (MoldCategoryVo)addMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo); categoryList.Add(moldCategoryVo.MoldCategoryCode, moldCategoryOutVo.MoldCategoryId); } } }
/// <summary> /// event to delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Delete_btn_Click(object sender, EventArgs e) { int selectedrowindex = MoldCategory_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = MoldCategory_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colMoldCategoryCode"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { MoldCategoryVo inVo = new MoldCategoryVo(); inVo.MoldCategoryId = Convert.ToInt32(selectedRow.Cells["colMoldCategoryId"].Value); inVo.MoldCategoryCode = selectedRow.Cells["colMoldCategoryCode"].Value.ToString(); try { MoldCategoryVo checkVo = CheckRelation(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, "Mold"); popUpMessage.Information(messageData, Text); return; } this.Cursor = Cursors.WaitCursor; MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new DeleteMoldCategoryMasterMntCbm(), inVo, false); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (outVo.AffectedCount == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00004, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { this.Cursor = Cursors.Default; } } else if (dialogResult == DialogResult.Cancel) { //do something else } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select ct.mold_category_id, ct.mold_category_cd, ct.mold_category_name,ct.display_order "); sqlQuery.Append(" from m_mold_category ct "); sqlQuery.Append(" where factory_cd = :factorycode "); if (inVo.MoldCategoryCode != null) { sqlQuery.Append(" and ct.mold_category_cd like :moldcategorycd "); } if (inVo.MoldCategoryName != null) { sqlQuery.Append(" and ct.mold_category_name like :moldcategoryname "); } sqlQuery.Append(" order by ct.display_order"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); if (inVo.MoldCategoryCode != null) { sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode + "%"); } if (inVo.MoldCategoryName != null) { sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <MoldCategoryVo> outVo = null; while (dataReader.Read()) { MoldCategoryVo currOutVo = new MoldCategoryVo { MoldCategoryId = Convert.ToInt32(dataReader["mold_category_id"]), MoldCategoryCode = dataReader["mold_category_cd"].ToString(), MoldCategoryName = dataReader["mold_category_name"].ToString(), DisplayOrder = Convert.ToInt32(dataReader["display_order"]), }; if (outVo == null) { outVo = new ValueObjectList <MoldCategoryVo>(); } outVo.add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// update the record to db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { MoldCategoryVo inVo = new MoldCategoryVo(); if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (!sch.IsASCII(MoldCategoryCode_txt.Text) || !sch.IsASCII(MoldCategoryName_txt.Text)) //|| !sch.IsASCII(DisplayOrder_txt.Text) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (!sch.IsASCII(MoldCategoryCode_txt.Text)) { MoldCategoryCode_txt.Focus(); } else if (!sch.IsASCII(MoldCategoryName_txt.Text)) { MoldCategoryName_txt.Focus(); } else { DisplayOrder_txt.Focus(); } return; } inVo.MoldCategoryCode = MoldCategoryCode_txt.Text.Trim(); inVo.MoldCategoryName = MoldCategoryName_txt.Text.Trim(); // inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text.Trim()); if (string.Equals(mode, CommonConstants.MODE_ADD)) { MoldCategoryVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, MoldCategoryCode_lbl.Text + " : " + MoldCategoryCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); MoldCategoryCode_txt.Focus(); return; } //MoldCategoryVo checkDisplayVo = DuplicateDisplayCheck(inVo); //if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) //{ // messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // DisplayOrder_txt.Focus(); // return; //} } try { this.Cursor = Cursors.WaitCursor; if (string.Equals(mode, CommonConstants.MODE_ADD)) { MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new AddMoldCategoryMasterMntCbm(), inVo, false); IntSuccess = outVo.MoldCategoryId; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { //if (updateData.DisplayOrder != Convert.ToInt32(DisplayOrder_txt.Text)) //{ // MoldCategoryVo checkDisplayVo = DuplicateDisplayCheck(inVo); // if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) // { // messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // DisplayOrder_txt.Focus(); // return; // } //} inVo.MoldCategoryId = updateData.MoldCategoryId; MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new UpdateMoldCategoryMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { this.Cursor = Cursors.Default; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }