Пример #1
0
        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 });
        }
Пример #2
0
        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());
            }
        }
Пример #3
0
        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 });
        }
Пример #4
0
 public void resetDataMstProductUnit()
 {
     txtProductUnitId.Text    = "";
     txtProductUnitName.Text  = "";
     formMstProductUnit       = new MST_PRODUCT_UNIT();
     flagAddEdit              = "A";
     txtProductUnitId.Enabled = true;
     txtProductUnitId.Focus();
 }
Пример #5
0
        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 });
        }
Пример #6
0
        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());
            }
        }
Пример #7
0
        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());
            }
        }