private void dg1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (isRows) { DataGridViewRow row = dg1.Rows[e.RowIndex]; using (DataClassesDataContext db = new DataClassesDataContext()) { int id = Convert.ToInt32(row.Cells["Detailid"].Value.ToString()); Detailorder d = db.Detailorders.Where(s => s.Detailid == id).FirstOrDefault(); d.Status = row.Cells["Action"].Value.ToString(); db.SubmitChanges(); } } }
private void autonumber() { using (DataClassesDataContext db = new DataClassesDataContext()) { Detailorder d = db.Detailorders.OrderByDescending(s => s.Detailid).FirstOrDefault(); if (d != null) { string a = d.Detailid.ToString().Substring(6, 4); int n = Convert.ToInt32(a) + 1; c = DateTime.Today.ToString("yyyyMM") + n.ToString("d4"); } else { c = DateTime.Today.ToString("yyyyMM") + "0001"; } } }
private void detach_Detailorders(Detailorder entity) { this.SendPropertyChanging(); entity.Headerorder = null; }
partial void DeleteDetailorder(Detailorder instance);
partial void UpdateDetailorder(Detailorder instance);
partial void InsertDetailorder(Detailorder instance);
private void attach_Detailorders(Detailorder entity) { this.SendPropertyChanging(); entity.Msmenu = this; }
private void btnOrder_Click(object sender, EventArgs e) { try { using (DataClassesDataContext db = new DataClassesDataContext()) { if (dg2.DataSource == null) { MessageBox.Show("Data Cant Be Empty", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); awal(); } else { Headerorder d = db.Headerorders.OrderByDescending(s => s.OrderID).FirstOrDefault(); if (d != null) { string auto = d.OrderID.ToString().Substring(6, 4); int n = Convert.ToInt32(auto) + 1; c = DateTime.Today.ToString("yyyyMM") + n.ToString("d4"); } else { c = DateTime.Today.ToString("yyyyMM") + "0001"; } int dd; Detailorder ddd = db.Detailorders.OrderByDescending(s => s.Detailid).FirstOrDefault(); if (ddd != null) { string autonumber = ddd.Detailid.ToString(); int n = Convert.ToInt32(autonumber) + 1; dd = Convert.ToInt32(n.ToString("d1")); } else { dd = 1; } var a = c; List <Msmember> m = db.Msmembers.Select(s => s).ToList(); db.Headerorders.InsertOnSubmit(new Headerorder { OrderID = a, Employeeid = emp.EmployeeID, Date = Convert.ToDateTime(DateTime.Today.ToString("yyyy-MM-dd")), Memberid = m[cbxMember.SelectedIndex].MemberID }); db.SubmitChanges(); foreach (menuu i in list) { db.Detailorders.InsertOnSubmit(new Detailorder { Detailid = dd, Orderid = a, Menuid = Convert.ToInt32(i.kodemenu), Qty = i.Qty, Price = i.Price, Status = "Pending" }); db.SubmitChanges(); } MessageBox.Show("Successfully Order Data", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); awal(); } } } catch (Exception ex) { MessageBox.Show("Try Again, Please Contact Admin", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); awal(); } }