public void queryDataMstCarRegistertionByCarRegistertionId()
{
MST005Controller mst005Ctrl = new MST005Controller();
try
{
object[] result = mst005Ctrl.queryDataMstCarRegistertionByCarRegistertionId(formMstCarRegistertion);
MsgForm msgForm = (MsgForm)result[0];
MST_CAR_REGISTERTION data = (MST_CAR_REGISTERTION)result[1];
if (msgForm.statusFlag.Equals(1))
{
if (Util.isNotEmpty(result))
{
txtCarRegistertionId.Text = data.CAR_REGISTERTION_ID;
txtCarRegistertionName.Text = data.CAR_REGISTERTION_NAME;
cboCarRegistertionVendorId.SelectedValue = data.CAR_REGISTERTION_VENDOR_ID.ToString();
formMstCarRegistertion = data;
}
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
MessageBox.Show("Error : " + ex.ToString());
}
}
public object[] queryDataMstCarRegistertionByCarRegistertionId(MST_CAR_REGISTERTION param)
{
log.Info("Start log INFO... queryDataMstCarRegistertionBycarRegistertionId");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_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... queryDataMstCarRegistertionBycarRegistertionId");
}
return(new object[] { msgError, form });
}
public object[] deleteDataMstCarRegistertion(MST_CAR_REGISTERTION param)
{
log.Info("Start log INFO... deleteDataMstCarRegistertion");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
db.MST_CAR_REGISTERTION.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... deleteDataMstCarRegistertion");
}
return(new object[] { msgError });
}
public object[] insertOrUpdateDataMstCarRegistertion(MST_CAR_REGISTERTION param, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMstCarRegistertion");
MsgForm msgError = new MsgForm();
MST_CAR_REGISTERTION formInsert = new MST_CAR_REGISTERTION();
MST_CAR_REGISTERTION formUpdate = new MST_CAR_REGISTERTION();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_CAR_REGISTERTION where row.CAR_REGISTERTION_ID == param.CAR_REGISTERTION_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.CAR_REGISTERTION_ID = param.CAR_REGISTERTION_ID;
formInsert.CAR_REGISTERTION_NAME = param.CAR_REGISTERTION_NAME;
formInsert.CAR_REGISTERTION_VENDOR_ID = param.CAR_REGISTERTION_VENDOR_ID;
db.MST_CAR_REGISTERTION.Add(formInsert);
log.Info("Insert Data form MST_CAR_REGISTERTION"
+ " CAR_REGISTERTION_ID : " + formInsert.CAR_REGISTERTION_ID
+ " CAR_REGISTERTION_NAME : " + formInsert.CAR_REGISTERTION_NAME
+ " CAR_REGISTERTION_VENDOR_ID : " + formInsert.CAR_REGISTERTION_VENDOR_ID
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.CAR_REGISTERTION_ID = param.CAR_REGISTERTION_ID;
formUpdate.CAR_REGISTERTION_NAME = param.CAR_REGISTERTION_NAME;
formUpdate.CAR_REGISTERTION_VENDOR_ID = param.CAR_REGISTERTION_VENDOR_ID;
log.Info("Update Data form MST_CAR_REGISTERTION"
+ " CAR_REGISTERTION_ID : " + formUpdate.CAR_REGISTERTION_ID
+ " CAR_REGISTERTION_NAME : " + formUpdate.CAR_REGISTERTION_NAME
+ " CAR_REGISTERTION_VENDOR_ID : " + formUpdate.CAR_REGISTERTION_VENDOR_ID
);
}
}
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... insertOrUpdateDataMstCarRegistertion");
}
return(new object[] { msgError, formUpdate });
}
public void resetDataMstCarRegistertion()
{
txtCarRegistertionId.Text = "";
txtCarRegistertionName.Text = "";
cboCarRegistertionVendorId.SelectedValue = "";
formMstCarRegistertion = new MST_CAR_REGISTERTION();
flagAddEdit = "A";
txtCarRegistertionId.Enabled = true;
txtCarRegistertionId.Focus();
}
public void deleteDataMstCarRegistertion()
{
MST005Controller mst005Ctrl = new MST005Controller();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
form.CAR_REGISTERTION_ID = txtCarRegistertionId.Text;
if (Util.isEmpty(form.CAR_REGISTERTION_ID))
{
MessageBox.Show(CommonUtil.SELECT_DATA_DELETE);
return;
}
if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
object[] result = mst005Ctrl.deleteDataMstCarRegistertion(form);
MsgForm msgForm = (MsgForm)result[0];
if (msgForm.statusFlag.Equals(1))
{
resetDataMstCarRegistertion();
searchDataVwMstCarRegistertion();
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 insertOrUpdateDataMstCarRegistertion()
{
MST005Controller mst005Ctrl = new MST005Controller();
MST_CAR_REGISTERTION form = new MST_CAR_REGISTERTION();
try
{
if (Util.isEmpty(txtCarRegistertionId.Text) ||
Util.isEmpty(txtCarRegistertionName.Text) ||
Util.isEmpty(cboCarRegistertionVendorId.Text))
{
MessageBox.Show(CommonUtil.REQUIRE_MESSAGE);
return;
}
form.CAR_REGISTERTION_ID = txtCarRegistertionId.Text;
form.CAR_REGISTERTION_NAME = txtCarRegistertionName.Text;
form.CAR_REGISTERTION_VENDOR_ID = cboCarRegistertionVendorId.SelectedValue.ToString();
if (Util.isEmpty(form))
{
return;
}
object[] result = mst005Ctrl.insertOrUpdateDataMstCarRegistertion(form, flagAddEdit);
MsgForm msgForm = (MsgForm)result[0];
MST_CAR_REGISTERTION data = (MST_CAR_REGISTERTION)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))
{
resetDataMstCarRegistertion();
searchDataVwMstCarRegistertion();
MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS);
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
}
else if (flagAddEdit.Equals("E"))
{
if (msgForm.statusFlag.Equals(1))
{
resetDataMstCarRegistertion();
searchDataVwMstCarRegistertion();
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());
}
}
