//public void queryComboMstGeographies()
//{
// MST003Controller mst003Ctrl = new MST003Controller();
// try
// {
// object[] result = mst003Ctrl.queryComboMstGeographies();
// MsgForm msgForm = (MsgForm)result[0];
// List<MST_GEOGRAPHIES> lstdata = (List<MST_GEOGRAPHIES>)result[1];
// if (msgForm.statusFlag.Equals(1))
// {
// cboGeography.DataSource = lstdata;
// cboGeography.ValueMember = "GEOGRAPHY_ID";
// cboGeography.DisplayMember = "NAME";
// cboGeography.SelectedValue = "";
// cboGeography.Text = "---กรุณาเลือก---";
// }
// else
// {
// MessageBox.Show("Error : " + msgForm.messageDescription);
// }
// }
// catch (Exception ex)
// {
// log.Error(ex.ToString(), ex);
// MessageBox.Show("Error : " + ex.ToString());
// }
//}
public void queryComboMstProvinces()
{
MST003Controller mst003Ctrl = new MST003Controller();
try
{
object[] result = mst003Ctrl.queryComboMstProvinces();
MsgForm msgForm = (MsgForm)result[0];
List <MST_PROVINCES> lstdata = (List <MST_PROVINCES>)result[1];
if (msgForm.statusFlag.Equals(1))
{
cboProvince.DataSource = lstdata;
cboProvince.ValueMember = "PROVINCE_ID";
cboProvince.DisplayMember = "NAME_TH";
cboProvince.SelectedValue = "";
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
MessageBox.Show("Error : " + ex.ToString());
}
}
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 queryComboMstDistricts()
{
MST003Controller mst003Ctrl = new MST003Controller();
MST_DISTRICTS form = new MST_DISTRICTS();
try
{
if (!formMstVendor.VENDOR_AMPHURE.Equals(0))
{
form.AMPHURE_ID = formMstVendor.VENDOR_AMPHURE;
}
else
{
form.AMPHURE_ID = Int32.Parse(cboAmphure.SelectedValue.ToString());
}
if (Util.isEmpty(form.AMPHURE_ID))
{
return;
}
object[] result = mst003Ctrl.queryComboMstDistricts(form);
MsgForm msgForm = (MsgForm)result[0];
//List<MST_DISTRICTS> lstdata = (List<MST_DISTRICTS>)result[1];
lstdataDistricts = (List <MST_DISTRICTS>)result[1];
if (msgForm.statusFlag.Equals(1))
{
cboDistricts.DataSource = lstdataDistricts;
cboDistricts.ValueMember = "DISTRICT_ID";
cboDistricts.DisplayMember = "NAME_TH";
cboDistricts.SelectedValue = "";
}
else
{
MessageBox.Show("Error : " + msgForm.messageDescription);
}
}
catch (Exception ex)
{
log.Error(ex.ToString(), ex);
MessageBox.Show("Error : " + ex.ToString());
}
}
public void searchDataVwMstVendor()
{
MST003Controller mst003Ctrl = new MST003Controller();
try
{
object[] result = mst003Ctrl.searchDataVwMstVendor();
MsgForm msgForm = (MsgForm)result[0];
List <VW_MST_VENDOR> lstdata = (List <VW_MST_VENDOR>)result[1];
if (msgForm.statusFlag.Equals(1))
{
dataGridView1.DataSource = lstdata;
dataGridView1.DefaultCellStyle.Font = new Font("TH SarabunPSK", 16);
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.SkyBlue;
dataGridView1.ColumnHeadersHeight = 150;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("TH SarabunPSK", 16, FontStyle.Bold);
dataGridView1.RowTemplate.Height = 40;
dataGridView1.Columns[0].HeaderCell.Value = "รหัสผู้ขาย";
dataGridView1.Columns[1].HeaderCell.Value = "ชื่อผู้ขาย";
dataGridView1.Columns[2].HeaderCell.Value = "ที่อยู่ผู้ขาย";
dataGridView1.Columns[3].HeaderCell.Value = "ตำบล";
dataGridView1.Columns[4].HeaderCell.Value = "อำเภอ";
dataGridView1.Columns[5].HeaderCell.Value = "จังหวัด";
dataGridView1.Columns[6].HeaderCell.Value = "รหัสไปรษณีย์";
dataGridView1.Columns[7].HeaderCell.Value = "เบอร์โทรศัพท์";
dataGridView1.Columns[8].HeaderCell.Value = "แฟกซ์";
lblCountData.Text = "แสดงข้อมูลทั้งหมด " + lstdata.Count() + " รายการ";
}
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 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());
}
}
