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