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