public object[] queryDataMstProductUnitByProductUnitId(MST_PRODUCT_UNIT param) { log.Info("Start log INFO... queryDataMstProductUnitByProductUnitId"); MsgForm msgError = new MsgForm(); MST_PRODUCT_UNIT form = new MST_PRODUCT_UNIT(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.MST_PRODUCT_UNIT where row.PRODUCT_UNIT_ID == param.PRODUCT_UNIT_ID select row).FirstOrDefault(); db.Dispose(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... queryDataMstProductUnitByProductUnitId"); } return(new object[] { msgError, form }); }
public void queryDataMstProductUnitByProductUnitId() { MST002Controller mst002Ctrl = new MST002Controller(); try { object[] result = mst002Ctrl.queryDataMstProductUnitByProductUnitId(formMstProductUnit); MsgForm msgForm = (MsgForm)result[0]; MST_PRODUCT_UNIT data = (MST_PRODUCT_UNIT)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { txtProductUnitId.Text = data.PRODUCT_UNIT_ID; txtProductUnitName.Text = data.PRODUCT_UNIT_NAME; formMstProductUnit = data; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public object[] deleteDataMstProductUnit(MST_PRODUCT_UNIT param) { log.Info("Start log INFO... deleteDataMstProductUnit"); MsgForm msgError = new MsgForm(); MST_PRODUCT_UNIT form = new MST_PRODUCT_UNIT(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.MST_PRODUCT_UNIT where row.PRODUCT_UNIT_ID == param.PRODUCT_UNIT_ID select row).FirstOrDefault(); if (Util.isNotEmpty(form)) { log.Info("Delete Data form MST_PRODUCT_UNIT" + " PRODUCT_UNIT_ID : " + form.PRODUCT_UNIT_ID ); db.MST_PRODUCT_UNIT.Remove(form); } db.SaveChanges(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... deleteDataMstProductUnit"); } return(new object[] { msgError }); }
public void resetDataMstProductUnit() { txtProductUnitId.Text = ""; txtProductUnitName.Text = ""; formMstProductUnit = new MST_PRODUCT_UNIT(); flagAddEdit = "A"; txtProductUnitId.Enabled = true; txtProductUnitId.Focus(); }
public object[] insertOrUpdateDataMstProductUnit(MST_PRODUCT_UNIT param, string flagAddEdit) { log.Info("Start log INFO... insertOrUpdateDataMstProductUnit"); MsgForm msgError = new MsgForm(); MST_PRODUCT_UNIT formInsert = new MST_PRODUCT_UNIT(); MST_PRODUCT_UNIT formUpdate = new MST_PRODUCT_UNIT(); try { using (var db = new PaknampoScaleDBEntities()) { formUpdate = (from row in db.MST_PRODUCT_UNIT where row.PRODUCT_UNIT_ID == param.PRODUCT_UNIT_ID select row).FirstOrDefault(); if (flagAddEdit.Equals("A")) { if (Util.isEmpty(formUpdate)) { formInsert.PRODUCT_UNIT_ID = param.PRODUCT_UNIT_ID; formInsert.PRODUCT_UNIT_NAME = param.PRODUCT_UNIT_NAME; db.MST_PRODUCT_UNIT.Add(formInsert); log.Info("Insert Data form MST_PRODUCT_UNIT" + " PRODUCT_UNIT_ID : " + formInsert.PRODUCT_UNIT_ID + " PRODUCT_UNIT_NAME : " + formInsert.PRODUCT_UNIT_NAME ); } } else if (flagAddEdit.Equals("E")) { if (Util.isNotEmpty(formUpdate)) { formUpdate.PRODUCT_UNIT_ID = param.PRODUCT_UNIT_ID; formUpdate.PRODUCT_UNIT_NAME = param.PRODUCT_UNIT_NAME; log.Info("Update Data form MST_PRODUCT_UNIT" + " PRODUCT_UNIT_ID : " + formUpdate.PRODUCT_UNIT_ID + " PRODUCT_UNIT_NAME : " + formUpdate.PRODUCT_UNIT_NAME ); } } db.SaveChanges(); msgError.statusFlag = MsgForm.STATUS_SUCCESS; } } catch (Exception ex) { log.Error(ex.ToString(), ex); msgError.statusFlag = MsgForm.STATUS_ERROR; msgError.messageDescription = ex.ToString(); } finally { log.Info("End log INFO... insertOrUpdateDataMstProductUnit"); } return(new object[] { msgError, formUpdate }); }
public void deleteDataMstProductUnit() { MST002Controller mst002Ctrl = new MST002Controller(); MST_PRODUCT_UNIT form = new MST_PRODUCT_UNIT(); try { form.PRODUCT_UNIT_ID = txtProductUnitId.Text; if (Util.isEmpty(form.PRODUCT_UNIT_ID)) { MessageBox.Show(CommonUtil.SELECT_DATA_DELETE); return; } if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes) { object[] result = mst002Ctrl.deleteDataMstProductUnit(form); MsgForm msgForm = (MsgForm)result[0]; if (msgForm.statusFlag.Equals(1)) { resetDataMstProductUnit(); searchDataMstProductUnit(); MessageBox.Show(CommonUtil.DELETE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void insertOrUpdateDataMstProductUnit() { MST002Controller mst002Ctrl = new MST002Controller(); MST_PRODUCT_UNIT form = new MST_PRODUCT_UNIT(); try { if (Util.isEmpty(txtProductUnitId.Text) || Util.isEmpty(txtProductUnitName.Text)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } form.PRODUCT_UNIT_ID = txtProductUnitId.Text; form.PRODUCT_UNIT_NAME = txtProductUnitName.Text; if (Util.isEmpty(form)) { return; } object[] result = mst002Ctrl.insertOrUpdateDataMstProductUnit(form, flagAddEdit); MsgForm msgForm = (MsgForm)result[0]; MST_PRODUCT_UNIT data = (MST_PRODUCT_UNIT)result[1]; if (flagAddEdit.Equals("A")) { if (Util.isNotEmpty(data)) { if (msgForm.statusFlag.Equals(1)) { MessageBox.Show(CommonUtil.DUPLICATE_DATA); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } else { if (msgForm.statusFlag.Equals(1)) { resetDataMstProductUnit(); searchDataMstProductUnit(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } else if (flagAddEdit.Equals("E")) { if (msgForm.statusFlag.Equals(1)) { resetDataMstProductUnit(); searchDataMstProductUnit(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }