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());
}
}
