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