private void autonumber() { using (DataClassesDataContext db = new DataClassesDataContext()) { Msmenu m = db.Msmenus.OrderByDescending(s => s.MenuID).FirstOrDefault(); if (m != null) { string a = m.MenuID.ToString(); int n = Convert.ToInt32(a) + 1; tbxID.Text = n.ToString("d1"); } else { tbxID.Text = "1"; } } }
private void btnDelete_Click(object sender, EventArgs e) { using (DataClassesDataContext db = new DataClassesDataContext()) { if (tbxID.Text == "" || tbxName.Text == "" || tbxPrice.Text == "" || tbxPhoto.Text == "") { MessageBox.Show("Data Cant Be Empty", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); bersih(); } else { Msmenu m = db.Msmenus.Where(s => s.MenuID == Convert.ToInt32(tbxID.Text)).FirstOrDefault(); db.Msmenus.DeleteOnSubmit(m); db.SubmitChanges(); awal(); MessageBox.Show("Successfully Deleted Data", "information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
partial void UpdateMsmenu(Msmenu instance);
partial void DeleteMsmenu(Msmenu instance);
partial void InsertMsmenu(Msmenu instance);