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