public IList <Donhang_Model> GetId(Donhang_Model model) { IList <Donhang_Model> result = new List <Donhang_Model>(); result = Connect_Enttity.Donhangs.Where(x => x.IDhd == model.IDhd).Select(x => new Donhang_Model { IDhd = x.IDhd, IDuser = (int)(x.IDuser), SDT = x.SDT, Hoten = x.Hoten, Mail = x.Mail, Diachi = x.Diachi, Tinh = x.Tinh, Huyen = x.Huyen, Xungho = x.Xungho, Hinhthucgiaohang = x.Hinhthucthanhtoan, Goidichvu = x.Goidichvu, Tongtienhang = Convert.ToDouble(x.Tongtienhang), Thanhtoan = Convert.ToDouble(x.Thanhtoan), ngaydathang = Convert.ToDateTime(x.ngaydathang), KH = x.KH, Duyet = x.Duyet, Khuyenmai = x.Khuyenmai, Hinhthucthanhtoan = x.Hinhthucgiaohang, GhiChuKhac = x.GhiChuKhac, Tiengiamgia = (int)(x.Tiengiamgia) }).ToList(); return(result); }
public void Update(Donhang_Model model) { var data = Connect_Enttity.Donhangs.FirstOrDefault(x => x.IDhd == model.IDhd); if (data != null) { data.IDuser = (int)(model.IDuser); data.SDT = model.SDT; data.Hoten = model.Hoten; data.Mail = model.Mail; data.Diachi = model.Diachi; data.Tinh = model.Tinh; data.Huyen = model.Huyen; data.Xungho = model.Xungho; data.Hinhthucgiaohang = model.Hinhthucthanhtoan; data.Goidichvu = model.Goidichvu; data.Tongtienhang = Convert.ToDouble(model.Tongtienhang); data.Thanhtoan = Convert.ToDouble(model.Thanhtoan); data.ngaydathang = Convert.ToDateTime(model.ngaydathang); data.KH = model.KH; data.Duyet = model.Duyet; data.Khuyenmai = model.Khuyenmai; data.Hinhthucthanhtoan = model.Hinhthucgiaohang; data.GhiChuKhac = model.GhiChuKhac; data.Tiengiamgia = (int)(model.Tiengiamgia); Connect_Enttity.SaveChanges(); Dispose(); } }
public void Create(Donhang_Model model) { var entity = new Donhang(); entity.IDuser = (int)(model.IDuser); entity.SDT = model.SDT; entity.Hoten = model.Hoten; entity.Mail = model.Mail; entity.Diachi = model.Diachi; entity.Tinh = model.Tinh; entity.Huyen = model.Huyen; entity.Xungho = model.Xungho; entity.Hinhthucgiaohang = model.Hinhthucthanhtoan; entity.Goidichvu = model.Goidichvu; entity.Tongtienhang = Convert.ToDouble(model.Tongtienhang); entity.Thanhtoan = Convert.ToDouble(model.Thanhtoan); entity.ngaydathang = Convert.ToDateTime(model.ngaydathang); entity.KH = model.KH; entity.Duyet = model.Duyet; entity.Khuyenmai = model.Khuyenmai; entity.Hinhthucthanhtoan = model.Hinhthucgiaohang; entity.GhiChuKhac = model.GhiChuKhac; entity.Tiengiamgia = (int)(model.Tiengiamgia); Connect_Enttity.Donhangs.Add(entity); Connect_Enttity.SaveChanges(); //Dispose(); }
public ActionResult Edit_donhang(Donhang_Model model) { if (ModelState.IsValid) { var data = connect_entity.Donhangs.FirstOrDefault(x => x.IDhd.Equals(model.IDhd)); if (data != null) { data.IDhd = model.IDhd; data.Hoten = model.Hoten; data.SDT = model.SDT; data.Mail = model.Mail; data.Diachi = model.Diachi; data.Tinh = model.Tinh; data.Huyen = model.Huyen; data.Xungho = model.Xungho; data.Hinhthucgiaohang = model.Hinhthucgiaohang; // data.Tongtienhang = model.Tongtienhang; data.Duyet = model.Duyet; // data.ngaydathang = model.ngaydathang; data.GhiChuKhac = model.GhiChuKhac; data.Tiengiamgia = model.Tiengiamgia; connect_entity.SaveChanges(); ModelState.AddModelError("", "Bạn Cập nhật Thành Công, Bấm Back Danh Sách để quay trở về"); ViewBag.id = model.IDhd; string strURLOld = HttpContext.Request.UrlReferrer.ToString(); string strUrlHienTai = HttpContext.Request.Url.AbsoluteUri; return(Redirect(strURLOld)); } } return(View(model)); }
public ActionResult Edit_donhang(int id) { var data_d = connect_entity.Donhangs.FirstOrDefault(x => x.IDhd.Equals(id)); Donhang_Model model = new Donhang_Model(); if (data_d != null) { model.IDhd = id; model.Hoten = data_d.Hoten; model.SDT = data_d.SDT; model.Mail = data_d.Mail; model.Diachi = data_d.Diachi; model.Tinh = data_d.Tinh; model.Huyen = data_d.Huyen; model.Xungho = data_d.Xungho; model.Hinhthucgiaohang = data_d.Hinhthucgiaohang; model.Tongtienhang = Convert.ToInt32(data_d.Tongtienhang); model.Duyet = data_d.Duyet; model.ngaydathang = Convert.ToDateTime(data_d.ngaydathang); model.GhiChuKhac = data_d.GhiChuKhac; model.Tiengiamgia = Convert.ToInt32(data_d.Tiengiamgia); ViewBag.id = id; string strURLOld = HttpContext.Request.UrlReferrer.ToString(); ViewBag.link = strURLOld; Session["tongtien"] = model.Tongtienhang; Session["IDhd"] = model.IDhd; } return(View(model)); }
public IEnumerable <Donhang_Model> ReadID(Donhang_Model model) { return(GetId(model)); }
public JsonResult CreateDonhang(string Hoten, string Mail, string Diachi, string GhiChuKhac, string SDT, string ngaydathang, string Duyet, string Xungho, string Tongtienhang, string Hinhthucgiaohang, string Tiengiamgia) { try { if (MySession.TongTien != 0) { CTdonhang_Model modelCTDonhang = new CTdonhang_Model(); Donhang_Model modelDonhang = new Donhang_Model();//gọi model data //xử lý Đơn hàng modelDonhang.IDuser = 0; modelDonhang.SDT = SDT; modelDonhang.Hoten = Hoten; modelDonhang.Mail = Mail; modelDonhang.Diachi = Diachi; modelDonhang.Tinh = ""; modelDonhang.Huyen = ""; modelDonhang.Xungho = Xungho; modelDonhang.Hinhthucthanhtoan = ""; modelDonhang.Goidichvu = ""; modelDonhang.Tongtienhang = Convert.ToDouble(MySession.TongTien); modelDonhang.Thanhtoan = 0; modelDonhang.ngaydathang = DateTime.Now; modelDonhang.KH = ""; modelDonhang.Duyet = "0"; modelDonhang.Khuyenmai = ""; modelDonhang.Hinhthucgiaohang = ""; modelDonhang.GhiChuKhac = GhiChuKhac; modelDonhang.Tiengiamgia = 0; ///Xử lý chi tiết đơn hàng ///////////////////////////// ConnectDonhang.Create(modelDonhang); var donhangmax = connect_entity.Donhang_Max().FirstOrDefault(); int id = Convert.ToInt32(donhangmax); foreach (var s in MySession.GioHang) { modelCTDonhang.IDhd = id; modelCTDonhang.IDsanpham = Convert.ToString(s.IDsanpham); modelCTDonhang.Tensanpham = s.TenSanPham; modelCTDonhang.Soluong = Convert.ToInt32(s.SoLuong); modelCTDonhang.Giacu = Convert.ToDouble(s.Giacu); modelCTDonhang.Giaban = Convert.ToDouble(s.Giaban); modelCTDonhang.Size = s.Size; modelCTDonhang.Mausac = _resurtTenmau(Convert.ToInt32(s.Mausac)); modelCTDonhang.Dungluong = s.Dungluong; modelCTDonhang.Hinhanh = s.Hinhanh; modelCTDonhang.Giamthem = s.Giamthem; modelCTDonhang.danhmucsanpham = s.danhmucsanpham; modelCTDonhang.chitietsanpham = s.chitietsanpham; modelCTDonhang.Giamthem = s.Giamthem; modelCTDonhang.phantramkm = s.phantramkm; modelCTDonhang.Baohanh = Convert.ToInt32(s.Baohanh); modelCTDonhang.tinhtrang = s.tinhtrang; ConnectCTDonhang.Create(modelCTDonhang); } //sendmail(modelDonhang.Mail, modelDonhang.Hoten, modelDonhang.Xungho, modelDonhang.SDT, Convert.ToInt32(modelDonhang.Hinhthucgiaohang), modelDonhang.Diachi, 0 ); MySession.GioHang.Clear(); MySession.TongTien = 0; } resurt = 1; return(Json(resurt, JsonRequestBehavior.AllowGet)); } catch { return(Json("", JsonRequestBehavior.AllowGet)); } }