private void button2_Click(object sender, EventArgs e)
{//update
FSRESTAURANT.EVENT_DETAILRow edRow = masterEventDetail.FindByEVENT_IDMENU_ID(eventID, menuID);
edRow.EVENT_PRICE = Convert.ToDecimal(textBox3.Text);
edRow.MENU_ID = getMenuID(textBox2.Text);
edRow.EVENT_PRICE = Convert.ToDecimal(textBox3.Text);
masterEventDetail.AddEVENT_DETAILRow(edRow);
adapterMgr.EVENT_DETAILTableAdapter.Update(masterEventDetail);
masterEventDetail.AcceptChanges();
FSRESTAURANT.EVENT_HEADERRow ehRow = masterEventHeader.FindByEVENT_ID(eventID);
ehRow.EVENT_NAME = textBox1.Text;
ehRow.EVENT_START = dateTimePicker1.Value;
ehRow.EVENT_STOP = dateTimePicker2.Value;
ehRow.EVENT_HEAD_LIMIT = numericUpDown1.Value;
ehRow.EVENT_HEAD_COUNT = numericUpDown1.Value;
masterEventHeader.AddEVENT_HEADERRow(ehRow);
adapterMgr.EVENT_HEADERTableAdapter.Update(masterEventHeader);
masterEventHeader.AcceptChanges();
refreshMasterEventHeader();
refreshMasterEventDetail();
clear();
}
public EventInsert(StateWindow state, FSRESTAURANT.EVENT_HEADERRow header)
{
this.state = state;
eheader = header;
InitializeComponent();
//fill data from menu and fill the listbox
MainForm.adapterMgr.MENU_HEADERTableAdapter.Fill(menudt);
lbMenu.DisplayMember = "MENU_NAME";
lbMenu.ValueMember = "MENU_ID";
dv = menudt.AsDataView();
lbMenu.DataSource = dv;
dv.Sort = "MENU_ID";
switch (state)
{
case StateWindow.insert:
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
break;
case StateWindow.update:
btnInsert.Enabled = false;
tbNama.Text = header.EVENT_NAME;
dtStart.Value = header.EVENT_START;
dtStop.Value = header.EVENT_STOP;
tbDescription.Text = header.DESCRIPTION;
nmCapacity.Value = header.EVENT_HEAD_LIMIT;
evdetail = new FSRESTAURANT.EVENT_DETAILDataTable();
foreach (FSRESTAURANT.EVENT_DETAILRow item in eheader.GetEVENT_DETAILRows())
{
evdetail.ImportRow(item);
}
break;
default:
break;
}
evdetail.EVENT_IDColumn.AllowDBNull = true;
DataColumn dc = new DataColumn("NAMA MENU", typeof(string));
evdetail.Columns.Add(dc);
dvdetail = evdetail.AsDataView();
dgEventDetail.DataSource = evdetail;
}
