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