public void xoa1ThucDon(string maTD) { ChiTietThucDon td = qlcf.ChiTietThucDons.Where(m => m.MaMon == maTD).FirstOrDefault(); qlcf.ChiTietThucDons.DeleteOnSubmit(td); qlcf.SubmitChanges(); }
private void btnInTD_Click(object sender, EventArgs e) { ExcelExport excel = new ExcelExport(); SaveFileDialog saveFile = new SaveFileDialog(); if (dgvThucDon.Rows.Count == 0) { MessageBox.Show("Không có dữ liệu để xuất", "ERROR"); return; } List <ChiTietThucDon> pList = new List <ChiTietThucDon>(); foreach (DataGridViewRow item in dgvThucDon.Rows) { ChiTietThucDon i = new ChiTietThucDon(); //i.STT = int.Parse(item.Cells[0].Value.ToString()); i.MaMon = item.Cells[0].Value.ToString(); i.MaLoai = item.Cells[1].Value.ToString(); i.TenMon = item.Cells[3].Value.ToString(); i.DonGia = Int32.Parse(item.Cells[4].Value.ToString()); //i.HinhAnh = item.Cells[5].Value.ToString(); pList.Add(i); } string path = string.Empty; excel.ExportThucDon(pList, ref path, false); if (!string.IsNullOrEmpty(path) && MessageBox.Show("Bạn có muốn mở file không?", "Thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { System.Diagnostics.Process.Start(path); } }
public int getGiaBan(string masp) { int giaban = 0; ChiTietThucDon td = qlcf.ChiTietThucDons.Where(sp => sp.MaMon == masp).FirstOrDefault(); if (td != null) { giaban = (int)td.DonGia; } return(giaban); }
public ActionResult xulithemmonan(FormCollection fc, ChiTietThucDon ct) { var session = Session[Modelss.Common.CommonConstans.MaThucDon_SESSTION]; ct.MaMonAn = int.Parse(fc["tenmonan"]); ct.MaThucDon = int.Parse(session.ToString()); qltc.ChiTietThucDons.InsertOnSubmit(ct); qltc.SubmitChanges(); return(RedirectToAction("Index")); }
public bool CapNhat(ChiTietThucDon item) { ChiTietThucDonDAL dal = new ChiTietThucDonDAL(db); if (item != null) { return(dal.CapNhat(item)); } else { return(false); } }
public void them1ThucDon(string maMon, string maLoai, string tenMon, int donGia, string hinhMon) { ChiTietThucDon td = new ChiTietThucDon(); td.MaMon = maMon; td.MaLoai = maLoai; td.TenMon = tenMon; td.DonGia = donGia; td.HinhMon = hinhMon; qlcf.ChiTietThucDons.InsertOnSubmit(td); qlcf.SubmitChanges(); }
public bool Xoa(ChiTietThucDon item) { ChiTietThucDonDAL dal = new ChiTietThucDonDAL(db); try { if (item != null) { return(dal.Xoa(item)); } else { return(false); } } catch (Exception) { throw; } }
public JsonResult CapNhatDanhSachMonAnThucUong(string maMonAn, string maThucDon) { maThucDon = Session["maThucDon"].ToString(); int status = 0; var chiTietThucDon = chiTietThucDonBll.TimKiemChiTietThucDon(maMonAn, maThucDon); if (chiTietThucDon == null) { ChiTietThucDon ct = new ChiTietThucDon() { MaMonAnThucUong = maMonAn, MaThucDon = maThucDon, GhiChu = "" }; if (chiTietThucDonBll.ThemMoi(ct) == true) { status = 1; } else { status = 2; } } else { if (chiTietThucDonBll.XoaChiTietThucDon(maMonAn, maThucDon) == true) { status = 3; } else { status = 4; } } return(Json(new { status = status }, JsonRequestBehavior.AllowGet)); }