public EventChanging()
{
InitializeComponent();
eventID = 0;
menuID = "";
FS = new FSRESTAURANT();
adapterMgr = new FSRESTAURANTTableAdapters.TableAdapterManager();
connect = new MySqlConnection("server=52.87.187.66;user id=theresa;persistsecurityinfo=True;database=restaurant;allowuservariables=True;password=theresa");
try
{
connect.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
adapterMgr.Connection = connect;
}
public void initialize(MySqlConnection c, FSRESTAURANT dSet, bool fillOrNot, bool clearBeforeFill)
{
//instacing object
EVENT_BOOKINGTableAdapter = new EVENT_BOOKINGTableAdapter();
EVENT_DETAILTableAdapter = new EVENT_DETAILTableAdapter();
EVENT_HEADERTableAdapter = new EVENT_HEADERTableAdapter();
EVENT_PENJUALANTableAdapter = new EVENT_PENJUALANTableAdapter();
EVENT_PENJUALAN_DETAILTableAdapter = new EVENT_PENJUALAN_DETAILTableAdapter();
EVENT_TABLETableAdapter = new EVENT_TABLETableAdapter();
MENU_HEADERTableAdapter = new MENU_HEADERTableAdapter();
PELANGGAN_RESTAURANTTableAdapter = new PELANGGAN_RESTAURANTTableAdapter();
PEGAWAI_RESTAURANTTableAdapter = new PEGAWAI_RESTAURANTTableAdapter();
//set connection
EVENT_BOOKINGTableAdapter.Connection = c;
EVENT_DETAILTableAdapter.Connection = c;
EVENT_HEADERTableAdapter.Connection = c;
EVENT_PENJUALANTableAdapter.Connection = c;
EVENT_PENJUALAN_DETAILTableAdapter.Connection = c;
EVENT_TABLETableAdapter.Connection = c;
MENU_HEADERTableAdapter.Connection = c;
PELANGGAN_RESTAURANTTableAdapter.Connection = c;
PEGAWAI_RESTAURANTTableAdapter.Connection = c;
//set clearBeforeFill
EVENT_BOOKINGTableAdapter.ClearBeforeFill = clearBeforeFill;
EVENT_DETAILTableAdapter.ClearBeforeFill = clearBeforeFill;
EVENT_HEADERTableAdapter.ClearBeforeFill = clearBeforeFill;
EVENT_PENJUALANTableAdapter.ClearBeforeFill = clearBeforeFill;
EVENT_PENJUALAN_DETAILTableAdapter.ClearBeforeFill = clearBeforeFill;
EVENT_TABLETableAdapter.ClearBeforeFill = clearBeforeFill;
MENU_HEADERTableAdapter.ClearBeforeFill = clearBeforeFill;
PELANGGAN_RESTAURANTTableAdapter.ClearBeforeFill = clearBeforeFill;
PEGAWAI_RESTAURANTTableAdapter.ClearBeforeFill = clearBeforeFill;
if (fillOrNot)
{
try { EVENT_HEADERTableAdapter.Fill(dSet.EVENT_HEADER); } catch { }
try { EVENT_DETAILTableAdapter.Fill(dSet.EVENT_DETAIL); } catch { }
try { EVENT_BOOKINGTableAdapter.Fill(dSet.EVENT_BOOKING); } catch { }
try { EVENT_TABLETableAdapter.Fill(dSet.EVENT_TABLE); } catch { }
try { MENU_HEADERTableAdapter.Fill(dSet.MENU_HEADER); } catch { }
try { PELANGGAN_RESTAURANTTableAdapter.Fill(dSet.PELANGGAN_RESTAURANT); } catch { }
try { PEGAWAI_RESTAURANTTableAdapter.Fill(dSet.PEGAWAI_RESTAURANT); } catch { }
}
}
