public object[] queryDataMstProductByProductId(MST_PRODUCT param) { log.Info("Start log INFO... queryDataMstProductByProductId"); MsgForm msgError = new MsgForm(); MST_PRODUCT form = new MST_PRODUCT(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.MST_PRODUCT where row.PRODUCT_ID == param.PRODUCT_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... queryDataMstProductByProductId"); } return(new object[] { msgError, form }); }
public object[] deleteDataMstProduct(MST_PRODUCT param) { log.Info("Start log INFO... deleteDataMstProduct"); MsgForm msgError = new MsgForm(); MST_PRODUCT form = new MST_PRODUCT(); try { using (var db = new PaknampoScaleDBEntities()) { form = (from row in db.MST_PRODUCT where row.PRODUCT_ID == param.PRODUCT_ID select row).FirstOrDefault(); if (Util.isNotEmpty(form)) { db.MST_PRODUCT.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... deleteDataMstProduct"); } return(new object[] { msgError }); }
public void queryDataMstProductByProductId() { MST001Controller mst001Ctrl = new MST001Controller(); try { object[] result = mst001Ctrl.queryDataMstProductByProductId(formMstProduct); MsgForm msgForm = (MsgForm)result[0]; MST_PRODUCT data = (MST_PRODUCT)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { txtProductId.Text = data.PRODUCT_ID; txtProductName.Text = data.PRODUCT_NAME; cboProductUnit.SelectedValue = data.PRODUCT_UNIT.ToString(); formMstProduct = data; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void resetDataMstProduct() { txtProductId.Text = ""; txtProductName.Text = ""; cboProductUnit.SelectedValue = "1"; formMstProduct = new MST_PRODUCT(); flagAddEdit = "A"; txtProductId.Enabled = true; txtProductId.Focus(); }
public void deleteDataMstProduct() { MST001Controller mst001Ctrl = new MST001Controller(); MST_PRODUCT form = new MST_PRODUCT(); try { form.PRODUCT_ID = txtProductId.Text; if (Util.isEmpty(form.PRODUCT_ID)) { MessageBox.Show(CommonUtil.SELECT_DATA_DELETE); return; } if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes) { object[] result = mst001Ctrl.deleteDataMstProduct(form); MsgForm msgForm = (MsgForm)result[0]; if (msgForm.statusFlag.Equals(1)) { resetDataMstProduct(); searchDataVwMstProduct(); 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 object[] insertOrUpdateDataMstProduct(MST_PRODUCT param, string flagAddEdit) { log.Info("Start log INFO... insertOrUpdateDataMstProduct"); MsgForm msgError = new MsgForm(); MST_PRODUCT formInsert = new MST_PRODUCT(); MST_PRODUCT formUpdate = new MST_PRODUCT(); try { using (var db = new PaknampoScaleDBEntities()) { formUpdate = (from row in db.MST_PRODUCT where row.PRODUCT_ID == param.PRODUCT_ID select row).FirstOrDefault(); if (flagAddEdit.Equals("A")) { if (Util.isEmpty(formUpdate)) { //formInsert.PRODUCT_ID = db.MST_PRODUCT.Count() + 1; formInsert.PRODUCT_ID = param.PRODUCT_ID; formInsert.PRODUCT_NAME = param.PRODUCT_NAME; formInsert.PRODUCT_UNIT = param.PRODUCT_UNIT; db.MST_PRODUCT.Add(formInsert); log.Info("Insert Data form MST_PRODUCT" + " PRODUCT_ID : " + formInsert.PRODUCT_ID + " PRODUCT_NAME : " + formInsert.PRODUCT_NAME + " PRODUCT_UNIT : " + formInsert.PRODUCT_UNIT ); } } else if (flagAddEdit.Equals("E")) { if (Util.isNotEmpty(formUpdate)) { formUpdate.PRODUCT_ID = param.PRODUCT_ID; formUpdate.PRODUCT_NAME = param.PRODUCT_NAME; formUpdate.PRODUCT_UNIT = param.PRODUCT_UNIT; log.Info("Update Data form MST_PRODUCT" + " PRODUCT_ID : " + formUpdate.PRODUCT_ID + " PRODUCT_NAME : " + formUpdate.PRODUCT_NAME + " PRODUCT_UNIT : " + formUpdate.PRODUCT_UNIT ); } } //formUpdate = (from row in db.MST_PRODUCT where row.PRODUCT_ID == param.PRODUCT_ID select row).FirstOrDefault(); //if (CheckUtil.isEmpty(formUpdate)) //{ // //formInsert.PRODUCT_ID = db.MST_PRODUCT.Count() + 1; // formInsert.PRODUCT_ID = param.PRODUCT_ID; // formInsert.PRODUCT_NAME = param.PRODUCT_NAME; // formInsert.PRODUCT_UNIT = param.PRODUCT_UNIT; // db.MST_PRODUCT.Add(formInsert); //} //else if (CheckUtil.isNotEmpty(formUpdate)) //{ // formUpdate.PRODUCT_ID = param.PRODUCT_ID; // formUpdate.PRODUCT_NAME = param.PRODUCT_NAME; // formUpdate.PRODUCT_UNIT = param.PRODUCT_UNIT; //} 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... insertOrUpdateDataMstProduct"); } return(new object[] { msgError, formUpdate }); }
public void insertOrUpdateDataMstProduct() { MST001Controller mst001Ctrl = new MST001Controller(); MST_PRODUCT form = new MST_PRODUCT(); Cursor.Current = Cursors.WaitCursor; try { if (Util.isEmpty(txtProductId.Text) || Util.isEmpty(txtProductName.Text) || Util.isEmpty(cboProductUnit.Text)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } form.PRODUCT_ID = txtProductId.Text; form.PRODUCT_NAME = txtProductName.Text; form.PRODUCT_UNIT = Int32.Parse(cboProductUnit.SelectedValue.ToString()); if (Util.isEmpty(form)) { return; } object[] result = mst001Ctrl.insertOrUpdateDataMstProduct(form, flagAddEdit); MsgForm msgForm = (MsgForm)result[0]; MST_PRODUCT data = (MST_PRODUCT)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)) { resetDataMstProduct(); searchDataVwMstProduct(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } else if (flagAddEdit.Equals("E")) { if (msgForm.statusFlag.Equals(1)) { resetDataMstProduct(); searchDataVwMstProduct(); 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()); } }