public ActionResult Edit(int id, Modelss.Model.ThucDon td)
{
try
{
// TODO: Add update logic here
Modelss.Model.ThucDon tk = qltc.ThucDons.Single(d => d.MaThucDon == id);
tk.TenThucDon = td.TenThucDon;
tk.TrangThai = td.TrangThai;
tk.SoLuongMon = td.SoLuongMon;
tk.TongDonGia = td.TongDonGia;
tk.HinhAnh = td.HinhAnh;
tk.GhiChu = td.GhiChu;
qltc.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Index(Modelss.Model.KhachHang kh)
{
QLTCDataContext qltc = new QLTCDataContext();
qltc.KhachHangs.InsertOnSubmit(kh);
qltc.SubmitChanges();
ViewBag.thanhcong = "Chúc mừng bạn đã đăng kí thành công!";
ThucDonKHChon tdkh = new ThucDonKHChon();
tdkh.MaKhachHang = kh.MaTaiKhoan;
tdkh.TenThucDon = kh.TenKhachHang;
qltc.ThucDonKHChons.InsertOnSubmit(tdkh);
GoiDichVuKHChon gdv = new GoiDichVuKHChon();
gdv.MaKhachHang = kh.MaTaiKhoan;
gdv.TenGoi = kh.TenKhachHang;
qltc.GoiDichVuKHChons.InsertOnSubmit(gdv);
qltc.SubmitChanges();
return(RedirectToAction("Index", "DangNhap"));
}
//
// POST: /Admin/Ad_TaiKhoan/Edit/5
public ActionResult xacnhandattiec(int id)
{
DatTiec tt = qltc.DatTiecs.Where(d => d.MaDacTiec == id).FirstOrDefault();
tt.TrangThai = "Đã xác nhận";
qltc.SubmitChanges();
var dt = from a in qltc.DatTiecs
where a.TrangThai == "Đã xác nhận"
select a;
return(RedirectToAction("Index", "Ad_Home"));
}
public ActionResult Create(TaiKhoan taikhoan)
{
try
{
// TODO: Add insert logic here
qltc.TaiKhoans.InsertOnSubmit(taikhoan);
qltc.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public bool xoadichvu(int madichvu)
{
var session = Session[Modelss.Common.CommonConstans.MaGoiDichVu_SESSTION];
int magoidichvu = int.Parse(session.ToString());
int machitiet = (from a in qltc.ChiTietGoiDichVus
where a.MaDichVu == madichvu && a.MaGoiDichVu == magoidichvu
select a.MaChiTietGoiDV).SingleOrDefault();
var tim = qltc.ChiTietGoiDichVus.Where(d => d.MaChiTietGoiDV == machitiet).SingleOrDefault();
qltc.ChiTietGoiDichVus.DeleteOnSubmit(tim);
qltc.SubmitChanges();
return(true);
}
public ActionResult themthucdon(int mathucdon)
{
//List<ChiTietThucDon> list = qltc.ChiTietThucDons.Where(d => d.MaThucDon == mathucdon).ToList();
var session = (Modelss.Common.UserLogin)Session[Modelss.Common.CommonConstans.TENDANGNHAP_SESSTION];
string mathucdoncuakh = (from a in qltc.ThucDonKHChons
from b in qltc.KhachHangs
where a.MaKhachHang == b.MaTaiKhoan && b.MaTaiKhoan == session.id
select a.MaThucDon).SingleOrDefault().ToString();
var listct = (from a in qltc.ChiTietThucDonKHChons
from b in qltc.ThucDonKHChons
from c in qltc.KhachHangs
where a.MaThucDon == b.MaThucDon && b.MaKhachHang == c.MaTaiKhoan && b.MaThucDon == int.Parse(mathucdoncuakh) && c.MaTaiKhoan == session.id
select a).ToList();
foreach (var item in listct)
{
qltc.ChiTietThucDonKHChons.DeleteOnSubmit(item);
qltc.SubmitChanges();
}
var listmonan = (from a in qltc.ThucDons
from b in qltc.ChiTietThucDons
from c in qltc.Mon_Ans
where a.MaThucDon == b.MaThucDon && b.MaMonAn == c.MaMonAn && a.MaThucDon == mathucdon
select c).ToList();
foreach (var item in listmonan)
{
Modelss.Model.ChiTietThucDonKHChon ct = new ChiTietThucDonKHChon();
ct.MaThucDon = int.Parse(mathucdoncuakh);
ct.MaMonAn = item.MaMonAn;
qltc.ChiTietThucDonKHChons.InsertOnSubmit(ct);
qltc.SubmitChanges();
}
return(RedirectToAction("Index", "HoSoKH"));
}
public ActionResult xuLythemMonAn(FormCollection fc, HttpPostedFileBase hinh, Modelss.Model.Mon_An monan)
{
monan.TenMonAn = fc["tenmonan"];
monan.LoaiMonAn = int.Parse(fc["loaimonan"]);
monan.GiaTien = fc["giatien"];
monan.TrangThai = fc["trangthai"];
monan.GhiChu = fc["ghichu"];
monan.MoTa = fc["mota"];
monan.HinhAnh = hinh.FileName;
string dd = Server.MapPath("/Content/hinhanh/anhmonan/" + hinh.FileName);
hinh.SaveAs(dd);
qltc.Mon_Ans.InsertOnSubmit(monan);
qltc.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult xuLythemDichVu(FormCollection fc, HttpPostedFileBase hinh, DichVu dichvu)
{
dichvu.TenDichVu = fc["tendichvu"];
dichvu.LoaiDichVu = int.Parse(fc["loaidichvu"]);
dichvu.GiaTien = fc["giatien"];
dichvu.TrangThai = fc["trangthai"];
dichvu.GhiChu = fc["ghichu"];
dichvu.MoTa = fc["mota"];
dichvu.Anh = hinh.FileName;
string dd = Server.MapPath("/Content/hinhanh/anhdichvu/" + hinh.FileName);
hinh.SaveAs(dd);
qltc.DichVus.InsertOnSubmit(dichvu);
qltc.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult xulithemsanhtiec(FormCollection fc, HttpPostedFileBase hinh, ThongTinSanh sanhtiec)
{
sanhtiec.TenSanh = fc["tensanh"];
sanhtiec.SoLuongBan = int.Parse(fc["soban"]);
sanhtiec.LoaiSanh = fc["loaisanh"];
sanhtiec.DonGia = fc["dongia"];
sanhtiec.GhiChu = fc["ghichu"];
sanhtiec.MoTa = fc["mota"];
sanhtiec.Hinh = hinh.FileName;
sanhtiec.TrangThai = fc["trangthai"];
string dd = Server.MapPath("/Content/hinhanh/anhsanhtiec/" + hinh.FileName);
hinh.SaveAs(dd);
qltc.ThongTinSanhs.InsertOnSubmit(sanhtiec);
qltc.SubmitChanges();
return(RedirectToAction("Index"));
}
public bool taoTaiKhoan(string tendangnhap, string matkhau, string loaitaikhoan, int trangthai)
{
KhachHang insert = new KhachHang();
insert.TenDangNhap = tendangnhap;
insert.MatKhau = matkhau;
insert.LoaiTaiKhoan = loaitaikhoan;
insert.TrangThai = trangthai;
qltc.KhachHangs.InsertOnSubmit(insert);
qltc.SubmitChanges();
return(true);
}