public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_defective_reason"); sqlQuery.Append(" Set "); sqlQuery.Append(" defective_reason_name = :defectivereasonname, "); sqlQuery.Append(" defective_category_id = :defectivecategoryid, "); sqlQuery.Append(" display_order = :displayorder"); sqlQuery.Append(" Where "); sqlQuery.Append(" defective_reason_id = :defectivereasonid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("defectivereasonid", inVo.DefectiveReasonId); sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName); sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); DefectiveReasonVo outVo = new DefectiveReasonVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_defective_reason"); sqlQuery.Append(" Where "); sqlQuery.Append(" defective_reason_id = :defectivereasonid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("defectivereasonid", inVo.DefectiveReasonId); DefectiveReasonVo outVo = new DefectiveReasonVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DefectiveReasonVo inVo = (DefectiveReasonVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <DefectiveReasonVo> voList = new ValueObjectList <DefectiveReasonVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("SELECT a.defective_reason_id, a.defective_reason_name FROM m_defective_reason a LEFT JOIN m_cause b ON b.defective_reason_id = a.defective_reason_id LEFT JOIN m_machine c ON c.machine_id = b.machine_id WHERE machine_name = :machine_name ORDER BY defective_reason_id"); sqlParameter.AddParameterString("machine_name", inVo.DefectiveReasonCode); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { DefectiveReasonVo outVo = new DefectiveReasonVo { DefectiveReasonId = int.Parse(dataReader["defective_reason_id"].ToString()), DefectiveReasonName = dataReader["defective_reason_name"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateUserData() { int selectedrowindex = DefectiveReason_dgv.SelectedCells[0].RowIndex; DefectiveReasonVo selectedData = (DefectiveReasonVo)DefectiveReason_dgv.Rows[selectedrowindex].DataBoundItem; AddDefectiveReasonNewForm newAddForm = new AddDefectiveReasonNewForm(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()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DefectiveReasonVo inVo = (DefectiveReasonVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <DefectiveReasonVo> voList = new ValueObjectList <DefectiveReasonVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT b.defective_reason_id, b.defective_reason_name from m_defective_reason b, m_ncvp_cause a where a.defective_reason_id = b.defective_reason_id and machine_id = :machine_id order by display_order"); sqlParameter.AddParameterInteger("machine_id", inVo.DefectiveReasonId); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { DefectiveReasonVo outVo = new DefectiveReasonVo { DefectiveReasonId = int.Parse(dataReader["defective_reason_id"].ToString()), DefectiveReasonName = dataReader["defective_reason_name"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select max(display_order)+1 display_order "); sqlQuery.Append(" from m_defective_reason dr "); sqlQuery.Append(" Where dr.factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); DefectiveReasonVo outVo = null; while (dataReader.Read()) { outVo = new DefectiveReasonVo(); outVo.DisplayOrder = ConvertDBNull <int>(dataReader, "display_order"); } dataReader.Close(); return(outVo); }
/// <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 = DefectiveReason_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = DefectiveReason_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colDefectiveReasonCode"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { DefectiveReasonVo inVo = new DefectiveReasonVo(); inVo.DefectiveReasonId = Convert.ToInt32(selectedRow.Cells["colDefectiveReasonId"].Value); try { inVo.DefectiveReasonCode = selectedRow.Cells["colDefectiveReasonCode"].Value.ToString(); DefectiveReasonVo tableCount = CheckDefectiveRelation(inVo); if (tableCount.AffectedCount > 0) { messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, DefectiveReason.ToString()); popUpMessage.Information(messageData, Text); return; } DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new DeleteDefectiveReasonMasterMntCbm(), 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> /// 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(DefectiveReasonVo dgvData) { if (dgvData != null) { DefectiveReasonCode_txt.Text = dgvData.DefectiveReasonCode; DefectiveReasonName_txt.Text = dgvData.DefectiveReasonName; DefectiveCategory_cmb.SelectedValue = dgvData.DefectiveCategoryId.ToString(); DisplayOrder_txt.Text = dgvData.DisplayOrder.ToString(); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_defective_reason"); sqlQuery.Append(" ( "); sqlQuery.Append(" defective_reason_cd, "); sqlQuery.Append(" defective_reason_name, "); sqlQuery.Append(" defective_category_id, "); 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(" :defectivereasoncd ,"); sqlQuery.Append(" :defectivereasonname ,"); sqlQuery.Append(" :defectivecategoryid ,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING defective_reason_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode); sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName); sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); //return outVo; DefectiveReasonVo outVo = new DefectiveReasonVo(); outVo.DefectiveReasonId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; if (outVo != null && outVo.DefectiveReasonId > 0) { outVo.AffectedCount = 1; } return(outVo); }
/// <summary> /// constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="dataItem"></param> public AddDefectiveReasonNewForm(string pmode, DefectiveReasonVo dataItem = null) { InitializeComponent(); mode = pmode; updateData = dataItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DefectiveReasonVo deleteOutVo = (DefectiveReasonVo)deleteDefectiveReasonMasterMntCbm.Execute(trxContext, vo); if (deleteOutVo.AffectedCount > 0) { ProcessDefectiveReasonVo inVo = new ProcessDefectiveReasonVo(); inVo.DefectiveReasonId = ((DefectiveReasonVo)vo).DefectiveReasonId; ProcessDefectiveReasonVo deleteProcessDefectiveReasonOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, inVo); } return(deleteOutVo); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddDefectiveReasonNewForm_Load(object sender, EventArgs e) { FormDatatableFromVo(); if (defectiveCategoryDatatable.Rows.Count > 0) { ComboBind(DefectiveCategory_cmb, defectiveCategoryDatatable, "name", "id"); } else { DefectiveCategory_cmb.Enabled = false; } DefectiveReasonCode_txt.Select(); int defectRsnId = 0; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { LoadUserData(updateData); defectRsnId = updateData.DefectiveReasonId; DefectiveReasonCode_txt.Enabled = false; DefectiveReasonName_txt.Select(); } else { DefectiveReasonVo outVo = null; try { outVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonDisplayOrderCbm(), null, false); } catch (Framework.ApplicationException ex) { popUpMessage.ApplicationError(ex.GetMessageData(), this.TitleText); } if (outVo != null) { DisplayOrder_txt.Text = outVo.DisplayOrder.ToString(); } else { DisplayOrder_txt.Text = "1"; } } BindGrid(defectRsnId); }
/// <summary> /// checks duplicate Defective reason Code /// </summary> /// <param name="defectVo"></param> /// <returns></returns> private DefectiveReasonVo DuplicateCheck(DefectiveReasonVo defectVo) { DefectiveReasonVo outVo = new DefectiveReasonVo(); try { outVo = (DefectiveReasonVo)base.InvokeCbm(new CheckDefectiveReasonMasterMntCbm(), defectVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_defective_reason"); sqlQuery.Append(" ( "); sqlQuery.Append(" defective_reason_cd, "); sqlQuery.Append(" defective_reason_name, "); sqlQuery.Append(" defective_category_id, "); 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(" :defectivereasoncd ,"); sqlQuery.Append(" :defectivereasonname ,"); sqlQuery.Append(" :defectivecategoryid ,"); sqlQuery.Append(" :displayorder,"); 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("defectivereasoncd", inVo.DefectiveReasonCode); sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName); sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); DefectiveReasonVo outVo = new DefectiveReasonVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; DefectiveReasonVo outVo = new DefectiveReasonVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("select Count(dfr.defective_reason_cd) as DefRsnCount from m_defective_reason as dfr "); sqlQuery.Append(" inner join m_process_work_defective_reason as pwdr on dfr.defective_reason_id = pwdr.defective_reason_id "); sqlQuery.Append(" where dfr.factory_cd = :faccd "); if (inVo.DefectiveReasonCode != null) { sqlQuery.Append(" and UPPER(defective_reason_cd) = UPPER(:defectivereasoncd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.DefectiveReasonCode != null) { sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); outVo.AffectedCount = 0; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; DefectiveReasonVo outVo = new DefectiveReasonVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL query sqlQuery.Append("Select Count(*) DefRsnCount from m_defective_reason "); sqlQuery.Append(" where factory_cd = :faccd "); 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("faccd", UserData.GetUserData().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); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault(); ProcessDefectiveReasonVo processDefectiveReasonInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault(); DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)addDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo); if (defectiveReasonVoOutVo != null && defectiveReasonVoOutVo.DefectiveReasonId > 0) { processDefectiveReasonInVo.DefectiveReasonId = defectiveReasonVoOutVo.DefectiveReasonId; ProcessDefectiveReasonVo processDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonInVo); } return(defectiveReasonVoOutVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; DefectiveReasonVo outVo = new DefectiveReasonVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select Count(*) DefRsnCount from m_defective_reason "); sqlQuery.Append(" where 1 = 1 "); if (inVo.DefectiveReasonCode != null) { sqlQuery.Append(" and UPPER(defective_reason_cd) = UPPER(:defectivereasoncd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.DefectiveReasonCode != null) { sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode); } //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> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private DefectiveReasonVo FormConditionVo() { DefectiveReasonVo inVo = new DefectiveReasonVo(); if (DefectiveReasonCode_txt.Text != string.Empty) { inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text; } if (DefectiveReasonName_txt.Text != string.Empty) { inVo.DefectiveReasonName = DefectiveReasonName_txt.Text; } if (DefectiveCategory_cmb.SelectedIndex > -1) { inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue); } return(inVo); }
private void CauseMasterForm_Load(object sender, EventArgs e) { try { DefectiveReasonVo defectiveReasonvo = (DefectiveReasonVo)DefaultCbmInvoker.Invoke(getDefectiveReasonMasterMntCmb, new DefectiveReasonVo()); foreach (DefectiveReasonVo vo in defectiveReasonvo.DefectiveReasonListVo) { cause.Add(new Cause { dvo = vo, Selected = false, CauseId = 0 }); } BindingSource bds = new BindingSource(cause, null); Cause_dgv.DataSource = bds; MachineVo machinelist = (MachineVo)DefaultCbmInvoker.Invoke(getMachineMasterMntCbm, new MachineVo()); MachineName_cmb.DisplayMember = "MachineName"; MachineName_cmb.DataSource = machinelist.MachineListVo; MachineName_cmb.SelectedIndex = -1; } catch { } //gfg }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(DefectiveReasonVo conditionInVo) { DefectiveReason_dgv.DataSource = null; isExcelUpload = false; try { DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), conditionInVo, false); DefectiveReason_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.DefectiveReasonListVo, null); if (bindingSource1 != null && bindingSource1.Count > 0) { DefectiveReason_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"defective reason" logger.Info(messageData); popUpMessage.Information(messageData, Text); } DefectiveReason_dgv.ClearSelection(); DefectiveReason_dgv.Columns["colRemarks"].Visible = false; Update_btn.Enabled = false; Delete_btn.Enabled = false; AddExcel_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList(); DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault(); ProcessDefectiveReasonVo processDefectiveReasonVoInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault(); DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)updateDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo); if (defectiveReasonVoOutVo.AffectedCount > 0) { processDefectiveReasonVoInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId; ProcessDefectiveReasonVo deleteInVo = new ProcessDefectiveReasonVo(); deleteInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId; ProcessDefectiveReasonVo deleteOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, deleteInVo); ProcessDefectiveReasonVo ProcessDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonVoInVo); } return(defectiveReasonVoOutVo); }
/// <summary> /// inserts/updates def reason /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { DefectiveReasonVo inVo = new DefectiveReasonVo(); if (CheckMandatory()) { //var sch = StringCheckHelper.GetInstance(); //if (string.IsNullOrEmpty(DefectiveReasonCode_txt.Text) || string.IsNullOrEmpty(DefectiveReasonName_txt.Text)) //{ // messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // if (string.IsNullOrEmpty(DefectiveReasonCode_txt.Text)) // { // DefectiveReasonCode_txt.Focus(); // } // else // { // DefectiveReasonName_txt.Focus(); // } // return; //} inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text.Trim(); inVo.DefectiveReasonName = DefectiveReasonName_txt.Text.Trim(); inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue); inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text); inVo.RegistrationUserCode = UserData.GetUserData().UserCode; inVo.FactoryCode = UserData.GetUserData().FactoryCode; if (string.Equals(mode, CommonConstants.MODE_ADD)) { DefectiveReasonVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DefectiveReasonCode_lbl.Text + " : " + DefectiveReasonCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); DefectiveReasonCode_txt.Focus(); return; } DefectiveReasonVo 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; } } if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { //if (updateData.DisplayOrder != Convert.ToInt32(DisplayOrder_txt.Text)) // { // DefectiveReasonVo 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 { if (string.Equals(mode, CommonConstants.MODE_ADD)) { DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.DefectiveReasonId = updateData.DefectiveReasonId; DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new UpdateDefectiveReasonMasterMntCbm(), 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(); } } }
/// <summary> /// save excel data to DB /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddExcel_btn_Click(object sender, EventArgs e) { if (DefectiveReason_dgv.RowCount > 0 && DefectiveReason_dgv.Columns["colRemarks"].Visible == true) { bool isRemarksNG = false; foreach (DataGridViewRow row in DefectiveReason_dgv.Rows) { if (DefectiveReason_dgv["colRemarks", row.Index].Value != null && !string.IsNullOrWhiteSpace(DefectiveReason_dgv["colRemarks", row.Index].Value.ToString())) { row.Cells["colRemarks"].Style.ForeColor = Color.Red; isRemarksNG = true; } } if (isRemarksNG) { messageData = new MessageData("mmci00015", Properties.Resources.mmci00015, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } string previousReasonCode = string.Empty; int uploadedCount = 0; int insertedCount = 0; DefectiveReasonVo defectiveReasonInVo = new DefectiveReasonVo(); ProcessDefectiveReasonVo processDefectiveReasonInVo = new ProcessDefectiveReasonVo(); if (processWorkList.Count == 0) { GetProcessWork(); } this.StartProgress(Properties.Resources.mmci00009); foreach (DataRow row in excelUploadDt.Rows) { if (!string.IsNullOrEmpty(row["DefectiveReasonCode"].ToString()) && previousReasonCode != row["DefectiveReasonCode"].ToString()) { defectiveReasonInVo = new DefectiveReasonVo(); processDefectiveReasonInVo = new ProcessDefectiveReasonVo(); defectiveReasonInVo.DefectiveReasonCode = row["DefectiveReasonCode"].ToString(); defectiveReasonInVo.DefectiveReasonName = row["DefectiveReasonName"].ToString(); defectiveReasonInVo.DefectiveCategoryId = 0; defectiveReasonInVo.DisplayOrder = Convert.ToInt32(row["DisplayOrder"].ToString()); uploadedCount += 1; DataRow[] processWorkCodeList = excelUploadDt.Select("DefectiveReasonCode = '" + defectiveReasonInVo.DefectiveReasonCode + "'"); foreach (DataRow item in processWorkCodeList) { ProcessDefectiveReasonVo addVo = new ProcessDefectiveReasonVo(); ProcessWorkVo processWorkVo = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault(); if (processWorkVo != null && processWorkVo.ProcessWorkId > 0) { addVo.ProcessWorkId = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault().ProcessWorkId; processDefectiveReasonInVo.ProcessDefectiveReasonListVo.Add(addVo); } } ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(defectiveReasonInVo); inVoList.add(processDefectiveReasonInVo); DefectiveReasonVo outVo = null; try { outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntNewCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { this.CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo != null && outVo.AffectedCount > 0) { insertedCount += outVo.AffectedCount; } } previousReasonCode = row["DefectiveReasonCode"].ToString(); } this.CompleteProgress(); if (insertedCount > 0 && uploadedCount > 0 && insertedCount == uploadedCount) { messageData = new MessageData("mmci00010", Properties.Resources.mmci00010, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } else { messageData = new MessageData("mmci00016", Properties.Resources.mmci00016, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } }
/// <summary> /// upload excel and insert to DB /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelUpload_btn_Click(object sender, EventArgs e) { OpenFileDialog openDialog_dlg = new OpenFileDialog(); openDialog_dlg.Filter = "Excel Files(*.xls) |*.xls"; if (openDialog_dlg.ShowDialog() == DialogResult.OK) { this.StartProgress(Properties.Resources.mmci00009); try { excelUploadDt = new ExcelUpload().ReadExcel(openDialog_dlg.FileName, Properties.Settings.Default.EXCEL_SHEET_DEFECTIVE_REASON); } catch (Framework.ApplicationException exception) { this.CompleteProgress(); popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } DefectiveReasonVo defectiveReasonInVo = new DefectiveReasonVo(); ProcessDefectiveReasonVo processDefectiveReasonInVo = new ProcessDefectiveReasonVo(); int displayOrder = 0; DefectiveReason_dgv.DataSource = null; excelUploadDt.Columns.Add("Remarks"); var sch = StringCheckHelper.GetInstance(); bool inputDataNG = false; foreach (DataRow row in excelUploadDt.Rows) { if (row["DefectiveReasonCode"] == null || string.IsNullOrWhiteSpace(row["DefectiveReasonCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, DefectiveReasonCode_lbl.Text); inputDataNG = true; continue; } if (!sch.IsASCII(row["DefectiveReasonCode"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmci00017, DefectiveReasonCode_lbl.Text); inputDataNG = true; continue; } var duplicates = excelUploadDt.AsEnumerable().GroupBy(r => r["DefectiveReasonCode"]).Where(gr => gr.Count() > 1).ToList(); if (duplicates.Any() && duplicates.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["DefectiveReasonCode"].ToString()) { row["Remarks"] = string.Format(Properties.Resources.mmce00009, DefectiveReasonCode_lbl.Text + " : " + row["DefectiveReasonCode"].ToString()); inputDataNG = true; continue; } if (row["DefectiveReasonName"] == null || string.IsNullOrWhiteSpace(row["DefectiveReasonName"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, DefectiveReasonName_lbl.Text); inputDataNG = true; continue; } if (row["DisplayOrder"] == null || string.IsNullOrWhiteSpace(row["DisplayOrder"].ToString())) { row["Remarks"] = string.Format(Properties.Resources.mmce00011, colDisplayOrder.HeaderText); inputDataNG = true; continue; } if (!int.TryParse(row["DisplayOrder"].ToString(), out displayOrder) || displayOrder <= 0) { row["Remarks"] = string.Format(Properties.Resources.mmci00018, colDisplayOrder.HeaderText); inputDataNG = true; continue; } var duplicateDisplayOrder = excelUploadDt.AsEnumerable().GroupBy(r => r["DisplayOrder"]).Where(gr => gr.Count() > 1).ToList(); if (duplicateDisplayOrder.Any() && duplicateDisplayOrder.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["DisplayOrder"].ToString()) { row["Remarks"] = string.Format(Properties.Resources.mmce00009, colDisplayOrder.HeaderText + " : " + row["DisplayOrder"].ToString()); inputDataNG = true; continue; } defectiveReasonInVo = new DefectiveReasonVo(); processDefectiveReasonInVo = new ProcessDefectiveReasonVo(); defectiveReasonInVo.DefectiveReasonCode = row["DefectiveReasonCode"].ToString(); defectiveReasonInVo.DefectiveReasonName = row["DefectiveReasonName"].ToString(); defectiveReasonInVo.DefectiveCategoryId = 0; defectiveReasonInVo.DisplayOrder = Convert.ToInt32(row["DisplayOrder"].ToString()); if (!ValidateProcessWorkCodeInExcel(excelUploadDt, defectiveReasonInVo.DefectiveReasonCode)) { row["Remarks"] = string.Format(Properties.Resources.mmci00019); inputDataNG = true; continue; } DefectiveReasonVo checkVo = DuplicateCheck(defectiveReasonInVo); if (checkVo != null && checkVo.AffectedCount > 0) { row["Remarks"] = string.Format(Properties.Resources.mmce00012, DefectiveReasonCode_lbl.Text + " : " + defectiveReasonInVo.DefectiveReasonCode); inputDataNG = true; continue; } DefectiveReasonVo checkDisplayVo = DuplicateDisplayCheck(defectiveReasonInVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { row["Remarks"] = string.Format(Properties.Resources.mmce00012, colDisplayOrder.HeaderText + " : " + defectiveReasonInVo.DisplayOrder.ToString()); inputDataNG = true; continue; } } DefectiveReason_dgv.AutoGenerateColumns = false; isExcelUpload = true; DefectiveReason_dgv.Columns["colRemarks"].Visible = true; DefectiveReason_dgv.DataSource = excelUploadDt; if (inputDataNG) { AddExcel_btn.Enabled = false; } else { AddExcel_btn.Enabled = true; } this.CompleteProgress(); } }
/// <summary> /// Binds tree view /// </summary> /// <param name="Linelist"></param> private void PopulateTreeView(List <LineVo> Linelist) { DefectiveReasonVo defOutVo = new DefectiveReasonVo(); try { defOutVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), defInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } LineDefectiveReasonDetails_tv.Nodes.Clear(); TreeNode[] headerNode = new TreeNode[Linelist.Count]; int i = 0; foreach (LineVo lin in Linelist) { TreeNode child = new TreeNode { Text = lin.LineCode + " " + lin.LineName, Tag = lin.LineId }; headerNode[i] = child; int childNodes = defOutVo.DefectiveReasonListVo.Count; TreeNode[] rootNodes = new TreeNode[childNodes]; int node = 0; ValueObjectList <LineDefectiveReasonVo> linDefRsnOutVo = new ValueObjectList <LineDefectiveReasonVo>(); try { linDefRsnOutVo = (ValueObjectList <LineDefectiveReasonVo>)base.InvokeCbm(new GetLineDefectiveReasonMasterMntCbm(), new LineDefectiveReasonVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (DefectiveReasonVo dfrVo in defOutVo.DefectiveReasonListVo) { TreeNode rootChild = new TreeNode { Text = dfrVo.DefectiveReasonCode + " " + dfrVo.DefectiveReasonName, Tag = dfrVo.DefectiveReasonId }; if (linDefRsnOutVo != null && linDefRsnOutVo.GetList() != null && linDefRsnOutVo.GetList().Count > 0) { List <LineDefectiveReasonVo> linDefRsnList = linDefRsnOutVo.GetList().Where(t => t.LineId == Convert.ToInt32(child.Tag)).ToList(); foreach (LineDefectiveReasonVo lnDfRsnVo in linDefRsnList) { if (lnDfRsnVo.DefectiveReasonId == Convert.ToInt32(rootChild.Tag)) { rootChild.Checked = true; } } } rootNodes[node] = rootChild; headerNode[i].Nodes.Add(rootNodes[node]); node += 1; } LineDefectiveReasonDetails_tv.Nodes.Add(headerNode[i]); i += 1; } if (LineDefectiveReasonDetails_tv.Nodes.Count > 0) { Update_btn.Enabled = true; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; DefectiveReasonVo outVo = new DefectiveReasonVo(); StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select distinct dr.*, dc.defective_category_name from m_defective_reason dr "); if (inVo.ProcessId > 0) { sqlQuery.Append(" inner join m_process_work_defective_reason pwdr on pwdr.defective_reason_id = dr.defective_reason_id "); sqlQuery.Append(" inner join m_process_work pw on pw.process_work_id = pwdr.process_work_id"); } sqlQuery.Append(" left join m_defective_category dc on dc.defective_category_id = dr.defective_category_id "); sqlQuery.Append(" where dr.factory_cd = :faccd "); if (inVo.DefectiveReasonCode != null) { sqlQuery.Append(" and defective_reason_cd like :defectivereasoncd "); } if (inVo.DefectiveReasonName != null) { sqlQuery.Append(" and defective_reason_name like :defectivereasonname "); } if (inVo.DefectiveCategoryId > 0) { sqlQuery.Append(" and dr.defective_category_id = :defectivecategoryid "); } if (inVo.ProcessId > 0) { sqlQuery.Append(" and pw.process_id = :processid "); } sqlQuery.Append(" order by dr.display_order "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.DefectiveReasonCode != null) { sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode + "%"); } if (inVo.DefectiveReasonName != null) { sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName + "%"); } if (inVo.DefectiveCategoryId != 0) { sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId); } if (inVo.ProcessId > 0) { sqlParameter.AddParameterInteger("processid ", inVo.ProcessId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { DefectiveReasonVo currOutVo = new DefectiveReasonVo { DefectiveReasonId = Convert.ToInt32(dataReader["defective_reason_id"]), DefectiveReasonCode = dataReader["defective_reason_cd"].ToString(), DefectiveReasonName = dataReader["defective_reason_name"].ToString(), DefectiveCategoryId = ConvertDBNull <Int32>(dataReader, "defective_category_id"), DefectiveCategoryName = ConvertDBNull <string>(dataReader, "defective_category_name"), DisplayOrder = Convert.ToInt32(dataReader["display_order"].ToString()) }; outVo.DefectiveReasonListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// inserts/updates def reason /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { DefectiveReasonVo inVo = new DefectiveReasonVo(); if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (!sch.IsASCII(DefectiveReasonCode_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); DefectiveReasonCode_txt.Focus(); return; } ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text.Trim(); inVo.DefectiveReasonName = DefectiveReasonName_txt.Text.Trim(); inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue); inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text); inVo.RegistrationUserCode = UserData.GetUserData().UserCode; inVo.FactoryCode = UserData.GetUserData().FactoryCode; if (string.Equals(mode, CommonConstants.MODE_ADD)) { DefectiveReasonVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DefectiveReasonCode_lbl.Text + " : " + DefectiveReasonCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); DefectiveReasonCode_txt.Focus(); return; } DefectiveReasonVo 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.StartProgress(Properties.Resources.mmci00009); if (string.Equals(mode, CommonConstants.MODE_ADD)) { inVoList.add(inVo); inVoList.add(GetSelectedProcessWork()); DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntNewCbm(), inVoList, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.DefectiveReasonId = updateData.DefectiveReasonId; inVoList.add(inVo); inVoList.add(GetSelectedProcessWork()); DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new UpdateDefectiveReasonMasterMntNewCbm(), inVoList, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { this.CompleteProgress(); } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }
/// <summary> /// Binds tree view /// </summary> /// <param name="prcWrkList"></param> private void PopulateTreeView(List <ProcessWorkVo> prcWrkList) { DefectiveReasonVo defOutVo = new DefectiveReasonVo(); try { defOutVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), defInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } ProcessDefectiveReasonDetails_tv.Nodes.Clear(); TreeNode[] headerNode = new TreeNode[prcWrkList.Count]; int i = 0; foreach (ProcessWorkVo prcW in prcWrkList) { TreeNode child = new TreeNode { Text = prcW.ProcessWorkCode + " " + prcW.ProcessWorkName, Tag = prcW.ProcessWorkId }; headerNode[i] = child; int childNodes = defOutVo.DefectiveReasonListVo.Count; TreeNode[] rootNodes = new TreeNode[childNodes]; int node = 0; ProcessDefectiveReasonVo prcDefRsnOutVo = new ProcessDefectiveReasonVo(); try { prcDefRsnOutVo = (ProcessDefectiveReasonVo)base.InvokeCbm(new GetProcessDefectiveReasonMasterMntCbm(), new ProcessDefectiveReasonVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (DefectiveReasonVo dfrVo in defOutVo.DefectiveReasonListVo) { TreeNode rootChild = new TreeNode { Text = dfrVo.DefectiveReasonName, Tag = dfrVo.DefectiveReasonId }; List <ProcessDefectiveReasonVo> prcDefRsnList = prcDefRsnOutVo.ProcessDefectiveReasonListVo.Where(t => t.ProcessWorkId == Convert.ToInt32(child.Tag)).ToList(); foreach (ProcessDefectiveReasonVo prDfRsnVo in prcDefRsnList) { if (prDfRsnVo.DefectiveReasonId == Convert.ToInt32(rootChild.Tag)) { rootChild.Checked = true; } } rootNodes[node] = rootChild; headerNode[i].Nodes.Add(rootNodes[node]); node += 1; } ProcessDefectiveReasonDetails_tv.Nodes.Add(headerNode[i]); i += 1; } }