public ActionResult Payment(DONHANG model)
{
//model. = DateTime.Now;
try
{
context.DONHANGs.Add(model);
context.SaveChanges();
var cart = (Cart)Session["CartSession"];
foreach (var item in cart.Lines)
{
CHITIETDONHANG obj = new CHITIETDONHANG();
obj.MaDH = model.MaDH;
obj.MaThuoc = item.Thuoc.MaThuoc;
//obj.= item.Sanpham.GiaSP;
obj.SoLuong = item.Quantity;
context.CHITIETDONHANGs.Add(obj);
context.SaveChanges();
}
cart.Clear();
Session["CartSession"] = cart;
}
catch (Exception ex)
{
//ghi log
return(RedirectToAction("/Loi"));
}
return(View("Complete"));
}
//Lưu đơn đặt hàng (Lấy từ Session[kh])
public ActionResult LuuDDH()
{
List <GioHang> lstGiohang = Laygiohang();
DONHANG dh = new DONHANG();
KHACHHANG kh = (KHACHHANG)Session["kh"];
dh.MADH = Capma_tudong("DH");
dh.NGAYLAP = DateTime.Now;
dh.TONGTIEN = (int)TongTien();
dh.TINHTRANG = false;
dh.MAKH = kh.MAKH;
data.DONHANGs.InsertOnSubmit(dh);
data.SubmitChanges();
foreach (var item in lstGiohang)
{
CTDH ct = new CTDH();
ct.MADH = Capma_tudong("DH");
ct.MASP = item.masp;
ct.SOLUONG = item.soluong;
data.CTDHs.InsertOnSubmit(ct);
data.SubmitChanges();
}
Update_ma("DH");
Session["GioHang"] = null;
return(RedirectToAction("DatThanhCong", "_Home"));
}
public ActionResult Create(DONHANG model)
{
ValidateBill(model);
if (ModelState.IsValid)
{
using (var scope = new TransactionScope())
{
model.NGAYTAODONHANG = DateTime.Now;
db.DONHANGs.Add(model);
db.SaveChanges();
foreach (var item in ShoppingCart)
{
db.CHITIETDONHANGs.Add(new CHITIETDONHANG
{
MADONHANG = model.MADONHANG,
MASANPHAM = item.SANPHAM.MASP,
GIATIENBAN = item.SANPHAM.GIABAN,
SOLUONG = item.SOLUONG
});
}
db.SaveChanges();
scope.Complete();
Session["ShoppingCart"] = null;
return(RedirectToAction("Index2", "SANPHAMs"));
}
}
GetShoppingCart();
ViewBag.Cart = ShoppingCart;
return(View(model));
}
public async Task <ActionResult> ChiTietDonHang(DONHANG model, int ID)
{
DONHANG obj = null;
using (var client = new HttpClient())
{
//gọi api thêm đơn hàng
client.BaseAddress = new Uri("https://localhost:44366/api/");
var responseTask = await client.GetAsync("donhang/getdonhang/" + ID.ToString());
if (responseTask.IsSuccessStatusCode)
{
obj = await responseTask.Content.ReadAsAsync <DONHANG>();
}
else
{
obj = null;
}
ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
}
obj.TinhTrang = model.TinhTrang;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("https://localhost:44366/api/");
var putTask = await client.PutAsJsonAsync <DONHANG>("donhang/updatedonhang", obj);
if (!putTask.IsSuccessStatusCode)
{
ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
}
}
return(RedirectToAction("DonHang"));
}
public string getDonHangbyMaDH(int id)//DONHANG getDonHangbyMaDH(int id)
{
DONHANG dh = db.DONHANGs.FirstOrDefault(x => x.MaDH == id);
dh.CTDHs.Clear();
return(new JavaScriptSerializer().Serialize(dh));// dh;
}
private void fmXemHangHoa_Load(object sender, EventArgs e)
{
try
{
DONHANG dh = (from a in db.DONHANGs where a.MADH == madon select a).Single();
mahang.Text = dh.MAHANG;
noidung.Text = dh.HANG.NOIDUNG;
chieucao.Text = dh.HANG.CAO.ToString();
chieudai.Text = dh.HANG.DAI.ToString();
chieurong.Text = dh.HANG.RONG.ToString();
trongluong.Text = dh.HANG.TRONGLUONG.ToString();
madonhang.Text = dh.MADH;
nhanvien.Text = dh.NHANVIEN.TEN;
ngaygui.Text = String.Format("{0:MM/dd/yyyy}", dh.NGAYGUI);
ttdh.Text = dh.TTHD;
ttp.Text = dh.PHIGH.TTPHI;
cmtng.Text = dh.NGUOIGUI.CMND;
tenng.Text = dh.NGUOIGUI.HOTEN;
dcng.Text = dh.NGUOIGUI.DIACHI;
sdtng.Text = dh.NGUOIGUI.SDT;
cmtnn.Text = dh.NGUOINHAN.CMND;
tennn.Text = dh.NGUOINHAN.HOTEN;
dcnn.Text = dh.NGUOINHAN.DIACHI;
sdtnn.Text = dh.NGUOINHAN.SDT;
}
catch (Exception er)
{
log.Error(er);
XtraMessageBox.Show("Không xem được thông tin!", "Lỗi!");
}
}
public void deleteDH(long ID)
{
DONHANG dh = db.DONHANGs.Find(ID);
db.DONHANGs.Remove(dh);
db.SaveChanges();
}
public ActionResult Payment(string shipName, string mobile, string address, string email)
{
var order = new DONHANG();
order.NGAYDAT = DateTime.Now;
order.DIACHI = address;
order.HOTEN = shipName;
order.DIENTHOAI = mobile;
order.EMAIL = email;
try
{
var id = new FHoaDon().Insert(order);
var cart = (List <CartItem>)Session[CartSession];
var detailDao = new FChiTietHD();
decimal total = 0;
foreach (var item in cart)
{
var orderDetail = new CHITIETDONHANG();
orderDetail.MASACH = item.SACH.MASACH;
orderDetail.MADONHANG = id;
orderDetail.DONGIA = item.SACH.GIABAN;
orderDetail.SOLUONG = item.Quantity;
detailDao.Insert(orderDetail);
total += (item.SACH.GIABAN.GetValueOrDefault(0) * item.Quantity);
}
}
catch (Exception ex)
{
//ghi log
return(RedirectToAction("Failed"));;
}
return(RedirectToAction("Success"));
}
public JsonResult Book(int id, string ship, int soluong)
{
SANPHAM sanphams = _connect.SANPHAMs.SingleOrDefault(p => p.ID == id);
if (sanphams.SOLUONGDAT == null)
{
sanphams.SOLUONGDAT = soluong;
}
else
{
sanphams.SOLUONGDAT = sanphams.SOLUONGDAT + soluong;
}
JavaScriptSerializer serialzer = new JavaScriptSerializer();
SHIP sp = serialzer.Deserialize <SHIP>(ship);
_connect.SHIPs.Add(sp);
_connect.SaveChanges();
var arrlast = _connect.SHIPs.Select(p => p).OrderByDescending(p => p.ID).ToArray();
var last = arrlast[0];
DONHANG donhang = new DONHANG();
donhang.IDSHIP = (long)last.ID;
donhang.IDSP = id.ToString() + "x" + soluong.ToString();
donhang.NGAYDAT = DateTime.Now;
donhang.TONGTIEN = ((Int32)sanphams.GIA - (Int32)(sanphams.GIA * sanphams.SALE / 100)) * soluong;
_connect.DONHANGs.Add(donhang);
_connect.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult DatHang(FormCollection collection)
{
KHACHHANG kh = (KHACHHANG)Session["TAIKHOAN"];
DONHANG dh = new DONHANG();
List <GioHang> gh = LayGioHang();
dh.MAKH = kh.MAKH;
dh.NGAYDAT = DateTime.Now;
dh.DATHANHTOAN = Convert.ToString(0);
data.DONHANGs.InsertOnSubmit(dh);
data.SubmitChanges();
foreach (var item in gh)
{
CHITIETDONHANG ctdh = new CHITIETDONHANG();
ctdh.MADH = dh.MADH;
ctdh.MATRANH = item.iMATRANH;
ctdh.SOLUONG = item.iSOLUONG;
ctdh.DONGIA = (decimal)item.dTHANHTIEN;
data.CHITIETDONHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
public ActionResult DatHang(FormCollection collection)
{
//thêm đơn hàng
DONHANG dh = new DONHANG();
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan1"];
List <GioHangModels> gh = LayGioHang();
dh.MaKH = kh.MaKH;
dh.NgayDat = DateTime.Now;
var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]);
dh.NgayGiao = DateTime.Parse(NgayGiao);
dh.TinhTrangGiaoHang = false;
dh.DaThanhToan = false;
db.DONHANGs.Add(dh);
db.SaveChanges();
//thêm chi tiết đơn hàng
foreach (var item in gh)
{
CHITIETDONHANG ctdh = new CHITIETDONHANG();
ctdh.MaDonHang = dh.MaDonHang;
ctdh.MASACHCT = item.iMaSach;
ctdh.Soluong = item.iSoLuong;
ctdh.DonGia = (float)item.dDongia;
db.CHITIETDONHANGs.Add(ctdh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
// Phương thức thêm một đơn hàng
public static void AddBill(CusInfoViewModel model, int idKhachHang)
{
// lấy ra id lớn nhất
BANDONGHOEntities db = new BANDONGHOEntities();
DONHANG don = (from dh in db.DONHANGs
orderby dh.MADH descending
select dh).Take(1).SingleOrDefault();
int id = don == null ? 0:don.MADH;
id += 1;
// tạo mới đơn hàng
DONHANG donhang = new DONHANG
{
MADH = id,
MAKH = idKhachHang,
DIACHIGIAO = model.DiaChiGiao,
SDT = model.Sdt,
MOTA = model.MoTa,
TONGTIEN = model.cart.TotalMoney(),
TRANGTHAI = "0",
NGAYDAT = DateTime.Now,
NGAYGIAO = DateTime.Now.AddDays(7)
};
db.DONHANGs.Attach(donhang);
db.DONHANGs.Add(donhang);
db.SaveChanges();
// thêm danh sách chi tiết đơn hàng
AddListDetailBill(model.cart, id);
}
public string CreateId()
{
string idcreated = "";
//lấy mã số đơn hàng cuối cùng trong bảng
DONHANG lastitem = db.DONHANGs.ToList().Last();
if (lastitem != null)
{
//tien hanh tach chuoi de lay 3 so cuoi cung
string lastitemid = lastitem.MA.ToString();
string idfigure = lastitemid.Substring(1);
int figure = int.Parse(idfigure);
figure++;
if (figure <= 99) // co 2 chu so
{
idcreated = "A0" + figure;
}
else
{
idcreated = "A" + figure;
}
}
else
{
idcreated = "A001";
}
return(idcreated);
}
public ActionResult CheckOut(FormCollection collection)
{
// Thêm đơn hàng
DONHANG dh = new DONHANG();
NGUOIDUNG kh = (NGUOIDUNG)Session["TaiKhoan"];
List <ShopCart> sc = GetShopCart();
dh.IDNguoiDung = kh.IDNguoiDung;
dh.NgayDatHang = DateTime.Now;
var ngaygiao = String.Format("{0:mm/dd/yyy}", collection["NgayGiaoHang"]);
dh.NgayGiaoHang = DateTime.Parse(ngaygiao);
dh.TrangThai = false;
db.DONHANGs.Add(dh);
db.SaveChanges();
//thêm chi tiết đơn hàng
foreach (var item in sc)
{
CHITIETDONHANG ctdh = new CHITIETDONHANG();
ctdh.MaDH = dh.MaDH;
ctdh.MaSP = item.iMaSP;
ctdh.SoLuong = item.iSoLuong;
ctdh.TongTien = (decimal)item.dThanhTien;
db.CHITIETDONHANGs.Add(ctdh);
}
db.SaveChanges();
Session["ShopCart"] = null;
return(RedirectToAction("ConfirmOrder", "ShopCart"));
}
public RedirectToRouteResult UpdateState(DONHANG newStateDH)
{
try
{
var check = db.DONHANGs.Where(dh => dh.ID_DONHANG == newStateDH.ID_DONHANG).FirstOrDefault();
check.ID_TRANGTHAI = newStateDH.ID_TRANGTHAI;
db.SaveChanges();
int idComplete = db.TRANGTHAIDONHANGs.Where(tt => tt.TEN_TRANGTHAI == "Hoàn thành").FirstOrDefault().ID_TRANGTHAI;
if (newStateDH.ID_TRANGTHAI == idComplete)
{
HOADON newHD = new HOADON();
newHD.ID_TTKH = check.ID_TTKH;
newHD.ID_TRANGTHAI = newStateDH.ID_TRANGTHAI;
newHD.TONGTIEN = 0;
newHD.ID_DONHANG = check.ID_DONHANG;
db.HOADONs.Add(newHD);
db.SaveChanges();
AutoConvertBill(newStateDH.ID_DONHANG);
}
// Check if id == hoàn thành thì chuyển thành hóa đơn
return(RedirectToRoute(new { controller = "Order", action = "DanhSachDonHang", id = 0 }));
}
catch (Exception)
{
return(RedirectToRoute(new { controller = "Order", action = "DanhSachDonHang", id = 0 }));
}
}
void UpdateTrangThai(string trangThai, string message)
{
try
{
int id = Convert.ToInt32(dataGV_DonHang.CurrentRow.Cells[0].Value);
DateTime ngayDat = Convert.ToDateTime(dataGV_DonHang.CurrentRow.Cells[4].Value);
DONHANG dh = new DONHANG
{
ID = id,
TrangThai = trangThai,
NgayDat = ngayDat
};
int kq = _donHangDao.Update(dh);
if (kq == 1)
{
MessageBox.Show(message, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Cập Nhật Trạng Thái Thất Bại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch
{
MessageBox.Show("Đường Truyền Bị Lỗi Rồi Đại Vương Ơi", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public DONHANG GetDVByMa(int pMa)
{
DONHANG result = new DONHANG();
result = context.DONHANGs.FirstOrDefault(m => m.MaHD == pMa);
return(result);
}
public ActionResult Create([Bind(Include = "DN_ID,TTDH_ID,KH_ID,HTTT_ID,DN_NGALAPDON,DN_GHICHU,DN_SL,DN_SDT,DN_DIACHI,DN_MATHE,DN_CHUTHE,DN_NGAYCAP,DN_EMAIL")] DONHANG dONHANG)
{
string KH_ID = Request["KH_ID"];
string result = db.Database.SqlQuery <string>("select KH_ID from KhachHang where KH_ID='" + KH_ID + "'").FirstOrDefault();
if (result != null)
{
if (ModelState.IsValid)
{
dONHANG.NV_ID = Session["NV_ID"].ToString();
dONHANG.DN_ID = db.autottang("DonHang", "DN_ID", db.DONHANGs.Count());
db.DONHANGs.Add(dONHANG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("KH_ID", "Khách hàng không tồn tại");
}
ViewBag.HTTT_ID = new SelectList(db.HINHTHUCTHANHTOANs, "HTTT_ID", "HTTT_TEN", dONHANG.HTTT_ID);
ViewBag.KH_ID = new SelectList(db.KHACHHANGs, "KH_ID", "KH_TEN", dONHANG.KH_ID);
ViewBag.TTDH_ID = new SelectList(db.TRANGTHAIDONHANGs, "TTDH_ID", "TTDH_TEN", dONHANG.TTDH_ID);
return(View(dONHANG));
}
public bool SuaDonHang(DONHANG donhang)
{
try
{
MyDBContext context = new MyDBContext();
DONHANG DH = context.DONHANGs.Find(donhang.MaDH);
if (DH == null)
{
return(false);
}
//DH.MaKH = donhang.MaKH;
//DH.NgayLap = donhang.NgayLap;
DH.TrangThai = donhang.TrangThai;
DH.TongTien = donhang.TongTien;
//DH.GhiChu = donhang.GhiChu;
DH.HoTen = donhang.HoTen;
DH.Email = donhang.Email;
DH.Diachi = donhang.Diachi;
//DH.SDT = donhang.SDT;
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//CHỨC NĂNG BUTTOM
private void btDaGiaoHang_Click(object sender, EventArgs e)
{
if (ChonShipper.SelectedItem == null)
{
XtraMessageBox.Show("Vui lòng chọn Shipper!", "Lỗi!");
}
else
{
try
{
DONHANG dh = (from a in db.DONHANGs where a.MADH == madh select a).Single();
SHIPPER sp = (from a in db.SHIPPERs where a.MAPT == dh.PHIGH.MAPT && a.TEN == ChonShipper.Text select a).Single();
XtraMessageBox.Show("Chuyển đơn hàng cho " + sp.TEN + " thành công!", "Thông báo");
dh.TTHD = "Đang giao hàng";
dh.PHIGH.MASHIPPER = sp.MASHIPPER;
db.SubmitChanges();
fmXemChiTietDonHang_Load(sender, e);
}
catch (Exception)
{
throw;
}
}
}
public ActionResult ExportDonHang(int id)
{
DONHANG donHang = data.DONHANGs.Where(n => n.mahd == id).SingleOrDefault();
KHACHHANG kh = data.KHACHHANGs.Where(n => n.makh == donHang.makh).SingleOrDefault();
List <CHITIETDONHANG> ctdh = data.CHITIETDONHANGs.Where(n => n.mahd == donHang.mahd).ToList();
decimal tong = 0;
DataSetDonHang db = new DataSetDonHang();
for (int i = 0; i < ctdh.Count; i++)
{
SANPHAM sp = data.SANPHAMs.Where(n => n.masanpham == ctdh[i].masp).Single();
db.DataTable1.AddDataTable1Row(donHang.mahd, kh.hoten, sp.masanpham, sp.tensanpham, String.Format("{0:0,0}", ctdh[i].thanhtien / ctdh[i].soluong) + " VNĐ", (int)ctdh[i].soluong, String.Format("{0:0,0}", ctdh[i].thanhtien) + " VNĐ", kh.sdt, kh.email, kh.diachi);
tong += (decimal)ctdh[i].thanhtien;
}
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/CrystalReports"), "ReportDonHang.rpt"));
db.DataTable2.AddDataTable2Row(String.Format("{0:0,0}", tong) + " VNĐ");
rd.SetDataSource(db);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "DonHang.pdf"));
}
public ActionResult DatHang(FormCollection col)
{
DONHANG dh = new DONHANG();
KHACHHANG kh = (KHACHHANG)Session["TaiKhoan"];
List <GIOHANG> gh = LayGioHang();
dh.MAKH = kh.MAKH;
dh.NGAYDAT = DateTime.Now;
var ngaygiao = String.Format("{0:MM/dd/yyyy}", col["NgayGiao"]);
dh.NGAYGIAO = DateTime.Parse(ngaygiao);
dh.TINHTRANGGIAOHANG = "Chưa giao hàng";
dh.TINHTRANGTHANHTOAN = "Chưa thanh toán";
db.DONHANGs.InsertOnSubmit(dh);
db.SubmitChanges();
foreach (var item in gh)
{
CHITIETDONHANG ctdh = new CHITIETDONHANG();
ctdh.MADH = dh.MADH;
ctdh.MAHOA = item.mahoa;
ctdh.SOLUONG = item.soluong;
ctdh.DONGIA = (int)item.dongia;
db.CHITIETDONHANGs.InsertOnSubmit(ctdh);
}
db.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhan", "GioHang"));
}
public void insertTHONGKE(DONHANG dh)
{
List <CHITIETDONHANG> lstCTDH = new DonHangDAO().GetCTDH(dh.ID);
foreach (CHITIETDONHANG c in lstCTDH)
{
THONGKE tk = new THONGKE();
tk.NGAY = (DateTime)dh.NGAYDAT;
tk.SANPHAM_ID = c.SANPHAM_ID;
List <XUATHANG> lstXH = new XuatHangDAO().GetXuatHang(c.ID);
foreach (XUATHANG x in lstXH)
{
if (!CheckExitsThongke(tk.SANPHAM_ID, tk.NGAY))
{
tk.SOLUONGBAN = c.SOLUONG;
tk.DOANHTHU = c.SOLUONG * c.DONGIA;
tk.LOINHUAN = (x.GIABAN - x.GIANHAP) * x.SOLUONGXUAT;
cn.Post <THONGKE>("api/THONGKE/", tk);
}
else
{
tk.SOLUONGBAN += c.SOLUONG;
tk.DOANHTHU += c.SOLUONG * c.DONGIA;
tk.LOINHUAN += (x.GIABAN - x.GIANHAP) * x.SOLUONGXUAT;
cn.Put <THONGKE>("api/THONGKE/", tk);
}
}
}
}
public ActionResult DatHang(FormCollection collection)
{
DONHANG dh = new DONHANG();
KHACHHANG kh = (KHACHHANG)Session["Email"];
List <Giohang> gh = LayGioHang();
dh.MaKH = kh.MaKH;
dh.NgayLap = DateTime.Now;
var NgayGiao = String.Format("{0:MM/dd/yyyy}", collection["NgayGiao"]);
dh.NgayGiao = DateTime.Parse(NgayGiao);
dh.DaThanhToan = false;
dh.ThanhTien = TongTien();
data.DONHANGs.InsertOnSubmit(dh);
data.SubmitChanges();
foreach (var item in gh)
{
CHITIETDONHANG ctdh = new CHITIETDONHANG();
ctdh.MaDH = dh.MaDH;
ctdh.MaSP = item.sMaSP;
ctdh.Soluong = item.sSoLuong;
ctdh.DonGia = (int)item.sDonGia;
ctdh.TongCong = ctdh.Soluong * ctdh.DonGia;
data.CHITIETDONHANGs.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
protected void btnDatHang_Click(object sender, EventArgs e)
{
if (Session["GioHang"] != null)
{
DataTable dtGioHang = (DataTable)Session["GioHang"];
if (Page.IsValid)
{
KHACHHANG KHACHHANG = new KHACHHANG
{
HOTEN = txtHoTen.Text,
SDT = txtSDT.Text,
EMAIL = txtEmail.Text,
DIACHI = txtDiaChi.Text,
};
DataTable ThongTinKH = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'");
if (ThongTinKH.Rows.Count > 0)
{
}
else
{
bool result = DAO.InsertKHACHHANG(KHACHHANG);
}
DataTable dtKhacHang = DAO.getTable("SELECT * FROM dbo.KHACHHANG WHERE EMAIL='" + txtEmail.Text + "'");
string MaKH = dtKhacHang.Rows[0]["MAKH"].ToString();
DateTime NgayDat = DateTime.Now;
int MaDH = RanDom();
DONHANG DONHANG = new DONHANG
{
NGAYDAT = NgayDat,
MAKH = MaKH,
MADONHANG = MaDH
};
bool result1 = DAO.InsertDONHANG(DONHANG);
//DataTable dtDonHang = DAO.getTable("SELECT * FROM dbo.DONHANG WHERE MAKH='" + MaKH + "' AND NGAYDATHANG='" + NgayDat + "'");
//string MaDonHang = dtDonHang.Rows[0]["MADONHANG"].ToString();
if (dtGioHang.Rows.Count > 0)
{
for (int i = 0; i < dtGioHang.Rows.Count; i++)
{
DataTable dtSanPham = DAO.getTable("SELECT * FROM dbo.SANPHAM WHERE MASP='" + dtGioHang.Rows[i]["MaSanPham"].ToString() + "'");
int SoLuongSP = (int)dtSanPham.Rows[0]["SOLUONG"] - (int)dtGioHang.Rows[i]["SoLuong"];
CHITIETDONHANG CHITIETDONHANG = new CHITIETDONHANG
{
MADONHANG = MaDH,
MASP = dtGioHang.Rows[i]["MaSanPham"].ToString(),
SOLUONG = (int)dtGioHang.Rows[i]["SoLuong"]
};
DAO.InsertCHITIETDONHANG(CHITIETDONHANG);
DAO.UpDate("UPDATE dbo.SANPHAM SET SOLUONG = " + SoLuongSP + "");
}
}
Session["GioHang"] = null;
Response.Write("<script>alert('Đặt hàng thành công. Đơn hàng của bạn đã đực giao cho bộ phận kĩ thuật vui lòng chờ cuộc gọi từ chúng tôi. Cảm ơn!!');</script>");
//Response.Redirect("TrangBanHang.aspx?modul=SanPham&modul1=DanhSachSanPham");
}
}
}
public int Create(DONHANG order)
{
connect.SendPostRequest <DONHANG>(order, "api/DONHANG/");
db.DONHANG = connect.DeserializeObject <List <DONHANG> >("api/DONHANG/");
int id = db.DONHANG.Max(x => x.ID);
return(id);
}
public void XoaDonHang(string madh)
{
DONHANG dh = new DONHANG();
dh = qltg.DONHANGs.Where(t => t.MaDH == madh).FirstOrDefault();
qltg.DONHANGs.DeleteOnSubmit(dh);
qltg.SubmitChanges();
}
public ActionResult Add(DONHANG model)
{
var DonHang = db.DONHANGs.Find(model.MaDonHang);
db.DONHANGs.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void add(DONHANGModel news_dh)
{
Mapper.CreateMap <DONHANGModel, DONHANG>();
DONHANG _news_dh = Mapper.Map <DONHANGModel, DONHANG>(news_dh);
db.DONHANGs.Add(_news_dh);
db.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
DONHANG dONHANG = db.DONHANGs.Find(id);
db.DONHANGs.Remove(dONHANG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddressAndPayment(FormCollection values)
{
var donHang = new DONHANG();
var ctDonHang = new CHITIETDONHANG();
TryUpdateModel(ctDonHang);
TryUpdateModel(donHang);
try
{
donHang.MaTK = Request.Cookies["MaTK"]["MaTK"];
donHang.MaDH = (db.LaySoLuongDonHang() + 1).ToString();
donHang.UserName = values["UserName"];
donHang.NgayDatHang = DateTime.Now;
donHang.MaTT = "TT01";
string thanhPho = values["ThanhPho"];
string quan = values["Quan"];
string phuong = values["Phuong"];
string diaChi = values["DiaChi"];
donHang.DiaChi = diaChi + " " + phuong + " " + quan + " " + thanhPho;
donHang.Email = values["Email"];
donHang.MaHTTT = "TT";
donHang.MaTK = null;
donHang.SDT = values["SDT"];
donHang.TenNguoiNhan = values["Ten"];
donHang.TongTien = Decimal.Parse(values["TongTien"]);
ctDonHang.DonGia = Decimal.Parse(values["DonGia"]);
ctDonHang.MaDH = donHang.MaDH;
ctDonHang.MaSP = donHang.MaDH;
db.DONHANGs.Add(donHang);
db.SaveChanges();
var cart = ShoppingCart.GetCart(this.HttpContext);
cart.TaoDonHang(donHang);
return RedirectToAction("Complete", new { id = donHang.MaDH });
//}
}
catch (System.Exception ex)
{
return View(donHang);
}
}
public string TaoDonHang(DONHANG donHang)
{
decimal TongTien = 0;
var cartItems = GetCartItems();
foreach (var item in cartItems)
{
var ctDonHang = new CHITIETDONHANG
{
MaSP = item.MaSP,
MaDH = donHang.MaDH,
DonGia = item.SanPham.GiaBan,
SoLuong = item.Count
};
TongTien += (item.Count * item.SanPham.GiaBan) ?? 0;
db.CHITIETDONHANGs.Add(ctDonHang);
}
donHang.TongTien = TongTien;
db.SaveChanges();
EmptyCart();
return donHang.MaDH;
}
