public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_process_flow_rule"); sqlQuery.Append(" Where "); sqlQuery.Append(" process_flow_rule_id = :processflowruleid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("processflowruleid", inVo.ProcessFlowRuleId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); ProcessFlowRuleVo outVo = new ProcessFlowRuleVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// form country and factory data for combo /// </summary> private void FormDatatableFromVo() { itemDatatable = new DataTable(); itemDatatable.Columns.Add("id"); itemDatatable.Columns.Add("code"); processFlowRuleDatatable = new DataTable(); processFlowRuleDatatable.Columns.Add("ProcessFlowRuleId", typeof(string)); processFlowRuleDatatable.Columns.Add("Comment", typeof(string)); try { ItemVo ItemOutVo = (ItemVo)base.InvokeCbm(new GetItemMasterMntCbm(), new ItemVo(), false); foreach (ItemVo it in ItemOutVo.ItemListVo) { itemDatatable.Rows.Add(it.ItemId, it.ItemCode); } ProcessFlowRuleVo proceesFlowRuleVo = (ProcessFlowRuleVo)base.InvokeCbm(new GetProcessFlowRuleMasterMntCbm(), new ProcessFlowRuleVo(), false); foreach (ProcessFlowRuleVo pf in proceesFlowRuleVo.ProcessFlowRuleListVo) { processFlowRuleDatatable.Rows.Add(pf.ProcessFlowRuleId, pf.Comment); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg; ProcessFlowRuleVo outVo = new ProcessFlowRuleVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select * from m_process_flow_rule "); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.ProcessFlowRuleCode != null) { sqlQuery.Append(" and process_flow_rule_cd like :processflowrulecd "); } if (inVo.Comment != null) { sqlQuery.Append(" and comment like :comment "); } sqlQuery.Append(" order by process_flow_rule_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.ProcessFlowRuleCode != null) { sqlParameter.AddParameterString("processflowrulecd", inVo.ProcessFlowRuleCode + "%"); } if (inVo.Comment != null) { sqlParameter.AddParameterString("comment", inVo.Comment + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProcessFlowRuleVo currOutVo = new ProcessFlowRuleVo { ProcessFlowRuleId = Convert.ToInt32(dataReader["process_flow_rule_id"]), ProcessFlowRuleCode = dataReader["process_flow_rule_cd"].ToString(), Comment = dataReader["comment"].ToString(), }; outVo.ProcessFlowRuleListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(ProcessFlowRuleVo conditionInVo) { ProcessFlowRule_dgv.DataSource = null; try { ProcessFlowRuleVo outVo = (ProcessFlowRuleVo)base.InvokeCbm(new GetProcessFlowRuleMasterMntCbm(), conditionInVo, false); ProcessFlowRule_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.ProcessFlowRuleListVo, null); if (bindingSource1.Count > 0) { ProcessFlowRule_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } ProcessFlowRule_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateUserData() { int selectedrowindex = ProcessFlowRule_dgv.SelectedCells[0].RowIndex; ProcessFlowRuleVo selectedData = (ProcessFlowRuleVo)ProcessFlowRule_dgv.Rows[selectedrowindex].DataBoundItem; AddProcessFlowRuleForm newAddForm = new AddProcessFlowRuleForm(CommonConstants.MODE_UPDATE, selectedData); 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.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } }
/// <summary> /// For setting selected user record into respective controls(textbox and combobox) for update operation /// passing selected user data as parameter /// </summary> /// <param name="dgvData"></param> private void LoadUserData(ProcessFlowRuleVo dgvData) { if (dgvData != null) { ProcessFlowRuleCode_txt.Text = dgvData.ProcessFlowRuleCode; Comment_txt.Text = dgvData.Comment; } }
/// <summary> /// constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="dataItem"></param> public AddProcessFlowRuleForm(string pmode, ProcessFlowRuleVo dataItem = null) { InitializeComponent(); mode = pmode; updateData = dataItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
/// <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 = ProcessFlowRule_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = ProcessFlowRule_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colProcessFlowRuleCode"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { ProcessFlowRuleVo inVo = new ProcessFlowRuleVo { ProcessFlowRuleId = Convert.ToInt32(selectedRow.Cells["colProcessFlowRuleId"].Value), }; try { ProcessFlowRuleVo outVo = (ProcessFlowRuleVo)base.InvokeCbm(new DeleteProcessFlowRuleMasterMntCbm(), 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.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } else if (dialogResult == DialogResult.Cancel) { //do something else } }
/// <summary> /// checks duplicate Process Code /// </summary> /// <param name="processVo"></param> /// <returns></returns> private ProcessFlowRuleVo DuplicateCheck(ProcessFlowRuleVo machineVo) { ProcessFlowRuleVo outVo = new ProcessFlowRuleVo(); try { outVo = (ProcessFlowRuleVo)base.InvokeCbm(new CheckProcessFlowRuleMasterMntCbm(), machineVo, 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 ProcessFlowRuleVo FormConditionVo() { ProcessFlowRuleVo inVo = new ProcessFlowRuleVo(); if (ProcessFlowRuleCode_txt.Text != string.Empty) { inVo.ProcessFlowRuleCode = ProcessFlowRuleCode_txt.Text; } if (Comment_txt.Text != string.Empty) { inVo.Comment = Comment_txt.Text; } return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_process_flow_rule"); sqlQuery.Append(" ( "); sqlQuery.Append(" process_flow_rule_cd, "); sqlQuery.Append(" comment, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :processflowrulecd ,"); sqlQuery.Append(" :comment ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" now() ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("processflowrulecd", inVo.ProcessFlowRuleCode); sqlParameter.AddParameterString("comment", inVo.Comment); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); //sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); ProcessFlowRuleVo outVo = new ProcessFlowRuleVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as RuleCount from m_process_flow_rule "); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.ProcessFlowRuleCode != null) { sqlQuery.Append(" and UPPER(process_flow_rule_cd) = UPPER(:processflowrulecd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.ProcessFlowRuleCode != null) { sqlParameter.AddParameterString("processflowrulecd", inVo.ProcessFlowRuleCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessFlowRuleVo outVo = new ProcessFlowRuleVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["RuleCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// inserts/updates ProcessFlowRule on ok click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (string.IsNullOrEmpty(ProcessFlowRuleCode_txt.Text) || string.IsNullOrEmpty(Comment_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (string.IsNullOrEmpty(ProcessFlowRuleCode_txt.Text)) { ProcessFlowRuleCode_txt.Focus(); } else { Comment_txt.Focus(); } return; } ProcessFlowRuleVo inVo = new ProcessFlowRuleVo { ProcessFlowRuleCode = ProcessFlowRuleCode_txt.Text.Trim(), Comment = Comment_txt.Text.Trim(), //RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), RegistrationUserCode = UserData.GetUserData().UserCode, FactoryCode = UserData.GetUserData().FactoryCode }; if (string.Equals(mode, CommonConstants.MODE_ADD)) { ProcessFlowRuleVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, ProcessFlowRuleCode_lbl.Text + " : " + ProcessFlowRuleCode_txt.Text); logger.Info(messageData); popUpMessage.ApplicationError(messageData, Text); return; } } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { ProcessFlowRuleVo outVo = (ProcessFlowRuleVo)base.InvokeCbm(new AddProcessFlowRuleMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.ProcessFlowRuleId = updateData.ProcessFlowRuleId; ProcessFlowRuleVo outVo = (ProcessFlowRuleVo)base.InvokeCbm(new UpdateProcessFlowRuleMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }