public bool xoadichvu(int madichvu) { Modelss.Model.QLTCDataContext ql = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; string magoidichvu = (from a in ql.GoiDichVuKHChons from b in ql.KhachHangs where a.MaKhachHang == session.id && a.MaKhachHang == b.MaTaiKhoan select a.MaGoiDichVuKHChon).FirstOrDefault().ToString(); int machitiet = (from a in ql.ChiTietGoiDichVuKHChons where a.MaGoiDichVuKHChon == int.Parse(magoidichvu) && a.MaDichVu == madichvu select a.MaChiTiet).SingleOrDefault(); var xoadichvu = ql.ChiTietGoiDichVuKHChons.Where(d => d.MaChiTiet == machitiet).FirstOrDefault(); ql.ChiTietGoiDichVuKHChons.DeleteOnSubmit(xoadichvu); ql.SubmitChanges(); return(true); }
public bool themdichvu(int madichvu) { Modelss.Model.QLTCDataContext ql = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; string magoidichvu = (from a in ql.GoiDichVuKHChons from b in ql.KhachHangs where a.MaKhachHang == session.id && a.MaKhachHang == b.MaTaiKhoan select a.MaGoiDichVuKHChon).FirstOrDefault().ToString(); var listdichvu = ql.ChiTietGoiDichVuKHChons.Where(d => d.MaGoiDichVuKHChon == int.Parse(magoidichvu)).ToList(); for (int i = 0; i < listdichvu.Count; i++) { if (listdichvu[i].MaDichVu == madichvu) { return(false); } } var chitiet = new Modelss.Framework.ChiTietGoiDichVuKHChon(); chitiet.MaGoiDichVuKHChon = int.Parse(magoidichvu); chitiet.MaDichVu = madichvu; qltc.ChiTietGoiDichVuKHChons.Add(chitiet); qltc.SaveChanges(); return(true); }
public bool xoamonan(int mamonan) { Modelss.Model.QLTCDataContext ql = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; string mathucdon = (from a in ql.ThucDonKHChons from b in ql.KhachHangs where a.MaKhachHang == session.id && a.MaKhachHang == b.MaTaiKhoan select a.MaThucDon).FirstOrDefault().ToString(); int machitiet = (from a in ql.ChiTietThucDonKHChons where a.MaThucDon == int.Parse(mathucdon) && a.MaMonAn == mamonan select a.MaChiTietThucDonKhChon).SingleOrDefault(); var xoamonan = ql.ChiTietThucDonKHChons.Where(d => d.MaChiTietThucDonKhChon == machitiet).FirstOrDefault(); ql.ChiTietThucDonKHChons.DeleteOnSubmit(xoamonan); ql.SubmitChanges(); return(true); }
public bool themmonan(int mamonan) { Modelss.Model.QLTCDataContext ql = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; string mathucdon = (from a in ql.ThucDonKHChons from b in ql.KhachHangs where a.MaKhachHang == session.id && a.MaKhachHang == b.MaTaiKhoan select a.MaThucDon).FirstOrDefault().ToString(); var listmonan = ql.ChiTietThucDonKHChons.Where(d => d.MaThucDon == int.Parse(mathucdon)).ToList(); for (int i = 0; i < listmonan.Count; i++) { if (listmonan[i].MaMonAn == mamonan) { return(false); } } var chitiet = new Modelss.Framework.ChiTietThucDonKHChon(); chitiet.MaThucDon = int.Parse(mathucdon); chitiet.MaMonAn = mamonan; qltc.ChiTietThucDonKHChons.Add(chitiet); qltc.SaveChanges(); return(true); }
public ActionResult xulidattiec(FormCollection fc, Modelss.Model.DatTiec dattiec) { Modelss.Model.QLTCDataContext qltc = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; //dattiec.MaSanh = int.Parse(fc["tensanh"]); ngay = fc["ngaytochuc"]; buoi = fc["buoi"]; var list = (from a in qltc.DatTiecs from b in qltc.ThongTinSanhs where a.Buoi == buoi && a.NgayToChuc == ngay && a.MaSanh == b.MaSanh select b).ToList(); if (list != null) { var tt = qltc.ThongTinSanhs.ToList(); for (int i = 0; i < tt.Count; i++) { for (int i2 = 0; i2 < list.Count; i2++) { if (tt[i].MaSanh.ToString() == list[i2].MaSanh.ToString()) { tt.RemoveAt(i); } } } return(PartialView("hienthisanhtiecphuhop", tt)); } //dattiec.MaThucDonKHChon = int.Parse(laymathucdon(session.id)); //dattiec.MaGoiDichVuKHChon = int.Parse(laymagoidichvu(session.id)); //qltc.DatTiecs.InsertOnSubmit(dattiec); //qltc.SubmitChanges(); //var list = qltc.ThongTinSanhs.ToList(); var tt2 = qltc.ThongTinSanhs.ToList(); return(PartialView("hienthisanhtiecphuhop", tt2)); }
public ActionResult xoaHetDichVu() { Modelss.Model.QLTCDataContext ql = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; string magoidichvukh = (from a in ql.GoiDichVuKHChons where a.MaKhachHang == session.id select a.MaGoiDichVuKHChon).SingleOrDefault().ToString(); List <Modelss.Model.ChiTietGoiDichVuKHChon> listcttd = ql.ChiTietGoiDichVuKHChons.Where(d => d.MaGoiDichVuKHChon == Convert.ToInt32(magoidichvukh)).ToList(); for (int i = 0; i < listcttd.Count; i++) { ql.ChiTietGoiDichVuKHChons.DeleteOnSubmit(listcttd[i]); ql.SubmitChanges(); } return(RedirectToAction("Index", "HoSoKH")); }
public ActionResult xulihoantatdattiec(FormCollection fc, Modelss.Model.DatTiec dattiec) { Modelss.Model.QLTCDataContext qltc = new Modelss.Model.QLTCDataContext(); var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION]; dattiec.MaSanh = int.Parse(fc["tensanh"]); dattiec.NgayToChuc = ngay; dattiec.MaKhachHang = session.id; dattiec.Buoi = buoi; dattiec.MaThucDonKHChon = int.Parse(laymathucdon(session.id)); dattiec.MaGoiDichVuKHChon = int.Parse(laymagoidichvu(session.id)); //dattiec.TongTien = int tongtien = int.Parse(Modelss.Common.CommonConstans.tiengoidichvu) + int.Parse(Modelss.Common.CommonConstans.tienthucdon); dattiec.TongTien = tongtien.ToString(); dattiec.TrangThai = "Chưa xác nhận"; qltc.DatTiecs.InsertOnSubmit(dattiec); qltc.SubmitChanges(); var list = qltc.ThongTinSanhs.ToList(); return(RedirectToAction("Index", "Default1", new { madattiec = dattiec.MaDacTiec })); }