public object[] deleteDataMstVendor(MST_VENDOR param)
{
log.Info("Start log INFO... deleteDataMstVendor");
MsgForm msgError = new MsgForm();
MST_VENDOR form = new MST_VENDOR();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_VENDOR where row.VENDOR_ID == param.VENDOR_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
log.Info("Delete Data form MST_VENDOR"
+ " VENDOR_ID : " + form.VENDOR_ID
);
db.MST_VENDOR.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... deleteDataMstVendor");
}
return(new object[] { msgError });
}
public object[] queryDataMstVendorByVendorId(MST_VENDOR param)
{
log.Info("Start log INFO... queryDataMstVendorByVendorId");
MsgForm msgError = new MsgForm();
MST_VENDOR form = new MST_VENDOR();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_VENDOR where row.VENDOR_ID == param.VENDOR_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... queryDataMstVendorByVendorId");
}
return(new object[] { msgError, form });
}
public void resetDataMstVendor()
{
txtVendorId.Text = "";
txtVendorName.Text = "";
txtVendorAddress.Text = "";
cboDistricts.SelectedValue = "";
cboAmphure.SelectedValue = "";
cboProvince.SelectedValue = "";
txtVendorPostcode.Text = "";
txtVendorTelNo.Text = "";
txtVendorFax.Text = "";
formMstVendor = new MST_VENDOR();
flagAddEdit = "A";
txtVendorId.Enabled = true;
txtVendorId.Focus();
lstdataAmphure = new List <MST_AMPHURES>();
lstdataDistricts = new List <MST_DISTRICTS>();
cboAmphure.DataSource = lstdataAmphure;
cboAmphure.ValueMember = "AMPHURE_ID";
cboAmphure.DisplayMember = "NAME_TH";
cboAmphure.SelectedValue = "";
cboDistricts.DataSource = lstdataDistricts;
cboDistricts.ValueMember = "DISTRICT_ID";
cboDistricts.DisplayMember = "NAME_TH";
cboDistricts.SelectedValue = "";
}
private void cboAmphure_SelectionChangeCommitted(object sender, EventArgs e)
{
formMstVendor = new MST_VENDOR();
lstdataDistricts = new List <MST_DISTRICTS>();
cboDistricts.DataSource = lstdataDistricts;
cboDistricts.ValueMember = "DISTRICT_ID";
cboDistricts.DisplayMember = "NAME_TH";
cboDistricts.SelectedValue = "";
txtVendorPostcode.Text = "";
queryComboMstDistricts();
}
public void queryDataMstVendorByVendorId()
{
MST003Controller mst003Ctrl = new MST003Controller();
try
{
object[] result = mst003Ctrl.queryDataMstVendorByVendorId(formMstVendor);
MsgForm msgForm = (MsgForm)result[0];
MST_VENDOR data = (MST_VENDOR)result[1];
if (msgForm.statusFlag.Equals(1))
{
if (Util.isNotEmpty(data))
{
txtVendorId.Text = data.VENDOR_ID;
txtVendorName.Text = data.VENDOR_NAME;
txtVendorAddress.Text = data.VENDOR_ADDRESS;
//cboDistricts.SelectedValue = data.VENDOR_DISTRICT;
//cboAmphure.SelectedValue = data.VENDOR_AMPHURE;
//cboProvince.SelectedValue = data.VENDOR_PROVINCE;
txtVendorPostcode.Text = data.VENDOR_POSTCODE;
txtVendorTelNo.Text = data.VENDOR_TEL_NO;
txtVendorFax.Text = data.VENDOR_FAX;
formMstVendor = data;
formMstVendor.VENDOR_PROVINCE = data.VENDOR_PROVINCE;
formMstVendor.VENDOR_AMPHURE = data.VENDOR_AMPHURE;
formMstVendor.VENDOR_DISTRICT = data.VENDOR_DISTRICT;
queryComboMstAmphures();
queryComboMstDistricts();
cboDistricts.SelectedValue = data.VENDOR_DISTRICT;
cboAmphure.SelectedValue = data.VENDOR_AMPHURE;
cboProvince.SelectedValue = data.VENDOR_PROVINCE;
}
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
MessageBox.Show("Error : " + ex.ToString());
}
}
public void deleteDataMstVendor()
{
MST003Controller mst003Ctrl = new MST003Controller();
MST_VENDOR form = new MST_VENDOR();
try
{
form.VENDOR_ID = txtVendorId.Text;
if (Util.isEmpty(form.VENDOR_ID))
{
MessageBox.Show(CommonUtil.SELECT_DATA_DELETE);
return;
}
if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
object[] result = mst003Ctrl.deleteDataMstVendor(form);
MsgForm msgForm = (MsgForm)result[0];
if (msgForm.statusFlag.Equals(1))
{
resetDataMstVendor();
searchDataVwMstVendor();
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[] updateDataMstVendor(MST_VENDOR param)
{
log.Info("Start log INFO... updateDataMstVendor");
MsgForm msgError = new MsgForm();
MST_VENDOR form = new MST_VENDOR();
try
{
using (var db = new PaknampoScaleDBEntities())
{
form = (from row in db.MST_VENDOR where row.VENDOR_ID == param.VENDOR_ID select row).FirstOrDefault();
if (Util.isNotEmpty(form))
{
form.VENDOR_NAME = param.VENDOR_NAME;
form.VENDOR_ADDRESS = param.VENDOR_ADDRESS;
form.VENDOR_DISTRICT = param.VENDOR_DISTRICT;
form.VENDOR_AMPHURE = param.VENDOR_AMPHURE;
form.VENDOR_PROVINCE = param.VENDOR_PROVINCE;
form.VENDOR_POSTCODE = param.VENDOR_POSTCODE;
form.VENDOR_TEL_NO = param.VENDOR_TEL_NO;
form.VENDOR_FAX = param.VENDOR_FAX;
}
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... updateDataMstVendor");
}
return(new object[] { msgError });
}
public object[] insertOrUpdateDataMstVendor(MST_VENDOR param, string flagAddEdit)
{
log.Info("Start log INFO... insertOrUpdateDataMstVendor");
MsgForm msgError = new MsgForm();
MST_VENDOR formInsert = new MST_VENDOR();
MST_VENDOR formUpdate = new MST_VENDOR();
try
{
using (var db = new PaknampoScaleDBEntities())
{
formUpdate = (from row in db.MST_VENDOR where row.VENDOR_ID == param.VENDOR_ID select row).FirstOrDefault();
if (flagAddEdit.Equals("A"))
{
if (Util.isEmpty(formUpdate))
{
formInsert.VENDOR_ID = param.VENDOR_ID;
formInsert.VENDOR_NAME = param.VENDOR_NAME;
formInsert.VENDOR_ADDRESS = param.VENDOR_ADDRESS;
formInsert.VENDOR_DISTRICT = param.VENDOR_DISTRICT;
formInsert.VENDOR_AMPHURE = param.VENDOR_AMPHURE;
formInsert.VENDOR_PROVINCE = param.VENDOR_PROVINCE;
formInsert.VENDOR_POSTCODE = param.VENDOR_POSTCODE;
formInsert.VENDOR_TEL_NO = param.VENDOR_TEL_NO;
formInsert.VENDOR_FAX = param.VENDOR_FAX;
db.MST_VENDOR.Add(formInsert);
log.Info("Insert Data form MST_VENDOR"
+ " VENDOR_ID : " + formInsert.VENDOR_ID
+ " VENDOR_NAME : " + formInsert.VENDOR_NAME
+ " VENDOR_ADDRESS : " + formInsert.VENDOR_ADDRESS
+ " VENDOR_DISTRICT : " + formInsert.VENDOR_DISTRICT
+ " VENDOR_AMPHURE : " + formInsert.VENDOR_AMPHURE
+ " VENDOR_PROVINCE : " + formInsert.VENDOR_PROVINCE
+ " VENDOR_POSTCODE : " + formInsert.VENDOR_POSTCODE
+ " VENDOR_TEL_NO : " + formInsert.VENDOR_TEL_NO
+ " VENDOR_FAX : " + formInsert.VENDOR_FAX
);
}
}
else if (flagAddEdit.Equals("E"))
{
if (Util.isNotEmpty(formUpdate))
{
formUpdate.VENDOR_ID = param.VENDOR_ID;
formUpdate.VENDOR_NAME = param.VENDOR_NAME;
formUpdate.VENDOR_ADDRESS = param.VENDOR_ADDRESS;
formUpdate.VENDOR_DISTRICT = param.VENDOR_DISTRICT;
formUpdate.VENDOR_AMPHURE = param.VENDOR_AMPHURE;
formUpdate.VENDOR_PROVINCE = param.VENDOR_PROVINCE;
formUpdate.VENDOR_POSTCODE = param.VENDOR_POSTCODE;
formUpdate.VENDOR_TEL_NO = param.VENDOR_TEL_NO;
formUpdate.VENDOR_FAX = param.VENDOR_FAX;
log.Info("Update Data form MST_VENDOR"
+ " VENDOR_ID : " + formUpdate.VENDOR_ID
+ " VENDOR_NAME : " + formUpdate.VENDOR_NAME
+ " VENDOR_ADDRESS : " + formUpdate.VENDOR_ADDRESS
+ " VENDOR_DISTRICT : " + formUpdate.VENDOR_DISTRICT
+ " VENDOR_AMPHURE : " + formUpdate.VENDOR_AMPHURE
+ " VENDOR_PROVINCE : " + formUpdate.VENDOR_PROVINCE
+ " VENDOR_POSTCODE : " + formUpdate.VENDOR_POSTCODE
+ " VENDOR_TEL_NO : " + formUpdate.VENDOR_TEL_NO
+ " VENDOR_FAX : " + formUpdate.VENDOR_FAX
);
}
}
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... insertOrUpdateDataMstVendor");
}
return(new object[] { msgError, formUpdate });
}
public void save(MST_VENDOR dbVendor, Login userLogin)
{
_uow.GetGenericRepository <MST_VENDOR>().InsertOrUpdate(dbVendor, userLogin, Enums.MenuList.MasterVendor);
}
public void save(MST_VENDOR dbVendor)
{
_uow.GetGenericRepository <MST_VENDOR>().InsertOrUpdate(dbVendor);
}
public void insertOrUpdateDataMstVendor()
{
MST003Controller mst003Ctrl = new MST003Controller();
MST_VENDOR form = new MST_VENDOR();
try
{
if (Util.isEmpty(txtVendorId.Text) || Util.isEmpty(txtVendorName.Text))
{
MessageBox.Show(CommonUtil.REQUIRE_MESSAGE);
return;
}
form.VENDOR_ID = txtVendorId.Text;
form.VENDOR_NAME = txtVendorName.Text;
form.VENDOR_ADDRESS = txtVendorAddress.Text;
form.VENDOR_DISTRICT = Int32.Parse(cboDistricts.SelectedValue.ToString());
form.VENDOR_AMPHURE = Int32.Parse(cboAmphure.SelectedValue.ToString());
form.VENDOR_PROVINCE = Int32.Parse(cboProvince.SelectedValue.ToString());
form.VENDOR_POSTCODE = txtVendorPostcode.Text;
form.VENDOR_TEL_NO = txtVendorTelNo.Text;
form.VENDOR_FAX = txtVendorFax.Text;
if (Util.isEmpty(form))
{
return;
}
object[] result = mst003Ctrl.insertOrUpdateDataMstVendor(form, flagAddEdit);
MsgForm msgForm = (MsgForm)result[0];
MST_VENDOR data = (MST_VENDOR)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))
{
resetDataMstVendor();
searchDataVwMstVendor();
MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS);
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
}
else if (flagAddEdit.Equals("E"))
{
if (msgForm.statusFlag.Equals(1))
{
resetDataMstVendor();
searchDataVwMstVendor();
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());
}
}
