/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private CastingMachineVo FormConditionVo() { CastingMachineVo inVo = new CastingMachineVo(); if (CastingMachineCode_txt.Text != string.Empty) { inVo.CastingMachineCode = CastingMachineCode_txt.Text; } if (CastingMachineName_txt.Text != string.Empty) { inVo.CastingMachineName = CastingMachineName_txt.Text; } if (CastingMachineFurnaceId_cmb.SelectedIndex > -1) { inVo.CastingMachineFurnaceId = Convert.ToInt32(CastingMachineFurnaceId_cmb.SelectedValue.ToString()); } if (EquipmentId_cmb.SelectedIndex > -1) { inVo.EquipmentId = Convert.ToInt32(EquipmentId_cmb.SelectedValue.ToString()); } return(inVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private StringBuilder FormCondition(CastingMachineVo inVo) { StringBuilder searchCondition = new StringBuilder(); searchCondition.Append(" where cm.factory_cd = :faccd "); if (inVo.CastingMachineCode != null) { searchCondition.Append(" and UPPER(cm.casting_machine_cd) like UPPER(:castcode)"); } if (inVo.CastingMachineName != null) { searchCondition.Append(" and UPPER(cm.casting_machine_name) like UPPER(:castname)"); } if (inVo.CastingMachineFurnaceId > 0) { searchCondition.Append(" and cmf.casting_machine_furnace_id = :castfurid"); } if (inVo.EquipmentId > 0) { searchCondition.Append(" and cm.equipment_id = :eqpid"); } searchCondition.Append(" order by cm.casting_machine_cd"); return(searchCondition); }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(CastingMachineVo conditionInVo) { CastingMachineDetails_dgv.DataSource = null; try { CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new GetCastingMachineMasterMntCbm(), conditionInVo, false); CastingMachineDetails_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.CastingMachineListVo, null); if (bindingSource1 != null && bindingSource1.Count > 0) { CastingMachineDetails_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"casting machine" logger.Info(messageData); popUpMessage.Information(messageData, Text); } CastingMachineDetails_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
/// <summary> /// passing update data to update form /// </summary> private void BindUpdateCastingMachineData() { int selectedrowindex = CastingMachineDetails_dgv.SelectedCells[0].RowIndex; CastingMachineVo castInVo = (CastingMachineVo)CastingMachineDetails_dgv.Rows[selectedrowindex].DataBoundItem; AddCastingMachineForm newAddForm = new AddCastingMachineForm(CommonConstants.MODE_UPDATE, castInVo); 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> /// constructor /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddCastingMachineForm(string pmode, CastingMachineVo userItem = null) { InitializeComponent(); mode = pmode; updateData = userItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
/// <summary> /// Loads selected data from data grid /// </summary> /// <param name="dgvCastingMachine"></param> private void LoadCastingMachineData(CastingMachineVo dgvCastingMachine) { if (dgvCastingMachine != null) { this.CastingMachineCode_txt.Text = dgvCastingMachine.CastingMachineCode; this.CastingMachineName_txt.Text = dgvCastingMachine.CastingMachineName; this.CastingMachineFurnaceName_cmb.SelectedValue = dgvCastingMachine.CastingMachineFurnaceId.ToString(); this.Equipment_cmb.SelectedValue = dgvCastingMachine.EquipmentId.ToString(); } }
/// <summary> /// delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Delete_btn_Click(object sender, EventArgs e) { int selectedrowindex = CastingMachineDetails_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = CastingMachineDetails_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colCastingMachineCode"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { CastingMachineVo inVo = new CastingMachineVo { CastingMachineId = Convert.ToInt32(selectedRow.Cells["colCastingMachineId"].Value.ToString()), }; try { CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new DeleteCastingMachineMasterMntCbm(), 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 Casting Machine Code /// </summary> /// <param name="castMacVo"></param> /// <returns></returns> private CastingMachineVo DuplicateCheck(CastingMachineVo castMacVo) { CastingMachineVo outVo = new CastingMachineVo(); try { outVo = (CastingMachineVo)base.InvokeCbm(new CheckCastingMachineMasterMntCbm(), castMacVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CastingMachineVo inVo = (CastingMachineVo)arg; CastingMachineVo outVo = new CastingMachineVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_casting_machine"); sqlQuery.Append(" ( "); sqlQuery.Append(" casting_machine_cd,"); sqlQuery.Append(" casting_machine_name,"); sqlQuery.Append(" casting_machine_furnace_id,"); sqlQuery.Append(" equipment_id,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :castcode,"); sqlQuery.Append(" :castname,"); sqlQuery.Append(" :castfurid,"); sqlQuery.Append(" :eqpid,"); sqlQuery.Append(" :regusercode,"); sqlQuery.Append(" now(),"); sqlQuery.Append(" :factcode"); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode); sqlParameter.AddParameterString("castname", inVo.CastingMachineName); sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId); sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId); sqlParameter.AddParameterString("regusercode", inVo.RegistrationUserCode); //sqlParameter.AddParameterDateTime("regdt", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factcode", inVo.FactoryCode); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CastingMachineVo inVo = (CastingMachineVo)arg; CastingMachineVo outVo = new CastingMachineVo(); StringBuilder sql = new StringBuilder(); //create SQL sql.Append("Select Count(*) as CastMachCount from m_casting_machine "); sql.Append(" where factory_cd = :faccd "); if (inVo.CastingMachineCode != null) { sql.Append(" and UPPER(casting_machine_cd) = UPPER(:castcode)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.CastingMachineCode != null) { sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); outVo.AffectedCount = 0; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["CastMachCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CastingMachineVo inVo = (CastingMachineVo)arg; CastingMachineVo outVo = new CastingMachineVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_casting_machine"); sqlQuery.Append(" set "); sqlQuery.Append(" casting_machine_name = "); sqlQuery.Append(" :castname, "); sqlQuery.Append(" casting_machine_furnace_id = "); sqlQuery.Append(" :castfurid,"); sqlQuery.Append(" equipment_id = "); sqlQuery.Append(" :eqpid,"); sqlQuery.Append(" factory_cd = "); sqlQuery.Append(" :factcode"); sqlQuery.Append(" where"); sqlQuery.Append(" casting_machine_id = "); sqlQuery.Append(" :castid"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("castid", inVo.CastingMachineId); sqlParameter.AddParameterString("castname", inVo.CastingMachineName); sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId); sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId); sqlParameter.AddParameterString("factcode", inVo.FactoryCode); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CastingMachineVo inVo = (CastingMachineVo)arg; CastingMachineVo outVo = new CastingMachineVo(); StringBuilder sql = new StringBuilder(); sql.Append("Delete from m_casting_machine"); sql.Append(" where "); sql.Append(" casting_machine_id = :castid"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("castid", inVo.CastingMachineId); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CastingMachineVo inVo = (CastingMachineVo)arg; CastingMachineVo outVo = new CastingMachineVo(); StringBuilder sql = new StringBuilder(); //create SQL sql.Append("select"); sql.Append(" cm.casting_machine_id,"); sql.Append(" cm.casting_machine_cd,"); sql.Append(" cm.casting_machine_name,"); sql.Append(" cmf.casting_machine_furnace_id,"); sql.Append(" cmf.casting_machine_furnace_name,"); sql.Append(" cm.equipment_id,"); sql.Append(" eqp.equipment_name"); sql.Append(" from m_casting_machine cm"); sql.Append(" inner join m_casting_machine_furnace cmf"); sql.Append(" on cm.casting_machine_furnace_id = cmf.casting_machine_furnace_id"); sql.Append(" inner join m_equipment eqp"); sql.Append(" on cm.equipment_id = eqp.equipment_id"); sql.Append(FormCondition(inVo).ToString()); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (!string.IsNullOrEmpty(inVo.FactoryCode)) { sqlParameter.AddParameterString("faccd", inVo.FactoryCode); } else { sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); } if (inVo.CastingMachineCode != null) { sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode + "%"); } if (inVo.CastingMachineName != null) { sqlParameter.AddParameterString("castname", inVo.CastingMachineName + "%"); } if (inVo.CastingMachineFurnaceId > 0) { sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId); } if (inVo.EquipmentId > 0) { sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { CastingMachineVo currOutVo = new CastingMachineVo { CastingMachineId = Convert.ToInt32(dataReader["casting_machine_id"].ToString()), CastingMachineCode = dataReader["casting_machine_cd"].ToString(), CastingMachineName = dataReader["casting_machine_name"].ToString(), CastingMachineFurnaceId = Convert.ToInt32(dataReader["casting_machine_furnace_id"].ToString()), CastingMachineFurnaceName = dataReader["casting_machine_furnace_name"].ToString(), EquipmentId = Convert.ToInt32(dataReader["equipment_id"].ToString()), EquipmentName = dataReader["equipment_name"].ToString() }; outVo.CastingMachineListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// handles insert/update /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { CastingMachineVo inVo = new CastingMachineVo(); var sch = StringCheckHelper.GetInstance(); if (CheckMandatory()) { if (string.IsNullOrEmpty(CastingMachineCode_txt.Text) || string.IsNullOrEmpty(CastingMachineName_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (string.IsNullOrEmpty(CastingMachineCode_txt.Text)) { CastingMachineCode_txt.Focus(); } else if (string.IsNullOrEmpty(CastingMachineName_txt.Text)) { CastingMachineName_txt.Focus(); } return; } inVo.CastingMachineCode = CastingMachineCode_txt.Text.Trim(); inVo.CastingMachineName = CastingMachineName_txt.Text.Trim(); inVo.EquipmentId = Convert.ToInt32(Equipment_cmb.SelectedValue.ToString()); inVo.CastingMachineFurnaceId = Convert.ToInt32(CastingMachineFurnaceName_cmb.SelectedValue.ToString()); inVo.RegistrationUserCode = UserData.GetUserData().UserCode; //inVo.RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); inVo.FactoryCode = UserData.GetUserData().FactoryCode; if (string.Equals(mode, CommonConstants.MODE_ADD)) { CastingMachineVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, CastingMachineCode_lbl.Text + " : " + CastingMachineCode_txt.Text); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); return; } } if (updateData != null) { inVo.CastingMachineId = updateData.CastingMachineId; } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new AddCastingMachineMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new UpdateCastingMachineMasterMntCbm(), 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(); } } }