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