public ActionResult Create(DonDatHang dondathangs)
{
HttpResponseMessage response = client.PostAsJsonAsync(url + @"dondathang/", dondathangs).Result;
response.EnsureSuccessStatusCode();
if (response.IsSuccessStatusCode)
{
ViewBag.Detail = "Sucess";
}
return(RedirectToAction("Index"));
}
public ActionResult DatHang(KhachHang kh)
{
//Kiểm tra session giỏ hàng tồn tại chưa
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
KhachHang khachHang = new KhachHang();
//Đổi với khác hàng không đăng nhập
if (Session["TaiKhoan"] == null)
{
khachHang = kh;
db.KhachHangs.Add(khachHang);
db.SaveChanges();
}
//Đổi với khác hàng đã đăng nhập
else
{
AspNetUser thanhVien = Session["TaiKhoan"] as AspNetUser;
khachHang.Email = thanhVien.Email;
khachHang.TenKH = thanhVien.Name;
khachHang.DiaChi = thanhVien.Address;
khachHang.SoDienThoai = thanhVien.PhoneNumber;
db.KhachHangs.Add(khachHang);
db.SaveChanges();
}
//Thêm đơn hàng
DonDatHang ddh = new DonDatHang();
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangGiaoHang = false;
ddh.DaThanhToan = false;
ddh.IdKhachHang = khachHang.MaKH;
db.DonDatHangs.Add(ddh);
db.SaveChanges();
//Thêm chi tiết đơn đặt hàng
List <ItemGioHang> lstGH = LayGioHang();
foreach (var item in lstGH)
{
ChiTietDonDatHang ctdh = new ChiTietDonDatHang();
ctdh.MaDDH = ddh.MaDDH;
ctdh.MaSP = item.MaSP;
ctdh.TenSP = item.TenSP;
ctdh.SoLuong = item.SoLuong;
ctdh.DonGia = item.DonGia;
db.ChiTietDonDatHangs.Add(ctdh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XemGioHang"));
}
public ActionResult DuyetDon(DonDatHang ddh)
{
DonDatHang ddhupdate = db.dondathangs.SingleOrDefault(c => c.MaDDH == ddh.MaDDH);
ddhupdate.DaGiao = ddh.DaGiao;
ddhupdate.DaThanhToan = ddh.DaThanhToan;
ddhupdate.NgayGiao = DateTime.Now;
db.SaveChanges();
ViewBag.lstchitiet = db.chitietdondathangs.Where(c => c.MaDDH == ddh.MaDDH).ToList();
return(View(ddhupdate));
}
public ActionResult Edit([Bind(Include = "IdDDH,Dathanhtoan,Tinhtranggiaohang,Ngaydat,Ngaygiao,MaKH")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.Accounts, "MaKH", "TenKH", donDatHang.MaKH);
return(View(donDatHang));
}
// GET: api/DonDatHangs/5
public async Task <IHttpActionResult> GetDonDatHang(int id)
{
DonDatHang donDatHang = await db.DonDatHangs.FindAsync(id);
if (donDatHang == null)
{
return(NotFound());
}
return(Ok(donDatHang));
}
// GET: DonDatHang/Edit/5
public async Task <ActionResult> Edit(int?id)
{
DonDatHang donDatHangs = null;
HttpResponseMessage response = await client.GetAsync(url + @"dondathang/" + id);
if (response.IsSuccessStatusCode)
{
donDatHangs = await response.Content.ReadAsAsync <DonDatHang>();
}
return(View(donDatHangs));
}
public ActionResult ThanhToan(int tongtien, string GhiChu)
{
if (Session["BiKhoa"] != null)
{
return(RedirectToAction("LogOffs", "Account"));
}
//Tạo đơn đặt hàng
string strID = null;
strID = User.Identity.GetUserId();
DonDatHang ddh = new DonDatHang();
int slddh = db.DonDatHangs.Count();
string Maddh = "DDH0" + slddh;
ddh.MaDonDatHang = Maddh;
ddh.NgayLap = DateTime.Now;
ddh.TongThanhTien = tongtien;
ddh.MaTinhTrang = 1;
ddh.UserID = strID;
ddh.GhiChu = GhiChu;
//Lưu đơn đặt hàng xuống DB
//Tạo chi tiết đơn đặt hàng
ChiTietDonDatHang ct = null;
SanPham sp = null;
var cart = (List <CartItem>)Session[CartSession];
int slct = 0;
string Mactdh = null;
int k = 1;
foreach (var item in cart)
{
ct = new ChiTietDonDatHang();
slct = db.ChiTietDonDatHangs.Count();
slct += k;
k++;
Mactdh = "CTDH" + k;
ct.MaChiTietDonDatHang = Mactdh;
ct.SoLuong = item.soluong;
ct.GiaBan = item.sanpham.GiaSanPham * ct.SoLuong;
ct.MaSanPham = item.sanpham.MaSanPham;
sp = db.SanPhams.Single(s => s.MaSanPham == ct.MaSanPham);
sp.SoLuongTon -= ct.SoLuong;
sp.SoLuongBan += ct.SoLuong;
ddh.ChiTietDonDatHangs.Add(ct);
}
db.DonDatHangs.Add(ddh);
db.SaveChanges();
Session[CartSession] = null;
//--\\
return(View());
}
public bool DonDatHang_Insert(DonDatHang inp)
{
try
{
return(DonDatHang_bus.Insert(inp));
}
catch (Exception ex)
{
throw ex;
}
}
public bool DonDatHang_Update(DonDatHang inp)
{
try
{
return(DonDatHang_bus.Update(inp));
}
catch (Exception ex)
{
throw ex;
}
}
//Đặt hàng
public ActionResult DatHang(KhachHang kh)
{
//Kiểm tra sp có tồn tai trong csdl hay không
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
KhachHang khang = new KhachHang();
if (Session["TaiKhoan"] == null)
{
//Thêm khach hang vao bang khach hang dối với kh vảng lai
khang = kh;
db.KhachHangs.Add(khang);
db.SaveChanges();
}
else
{
//Đối với KH là thành viên
ThanhVien tv = Session["TaiKhoan"] as ThanhVien;
khang.TenKH = tv.HoTen;
khang.DiaChi = tv.DiaChi;
khang.Email = tv.Email;
khang.SoDienThoai = tv.SoDienThoai;
db.KhachHangs.Add(khang);
db.SaveChanges();
}
//Thêm đơn hàng
DonDatHang ddh = new DonDatHang();
ddh.MaKH = khang.MaKH;
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangDonHang = false;
ddh.DaThanhToan = false;
ddh.UuDai = 0;
db.DonDatHangs.Add(ddh);
db.SaveChanges();
//Thêm chi tiết đơn đặt hàng
List <ItemGioHang> lst = LayGioHang();
foreach (var item in lst)
{
ChiTietDonDatHang ctddh = new ChiTietDonDatHang();
ctddh.MaDDH = ddh.MaDDH;
ctddh.MaSP = item.MaSP;
ctddh.TenSP = item.TenSP;
ctddh.SoLuong = item.SoLuong;
ctddh.DonGia = item.DonGia;
db.ChiTietDonDatHangs.Add(ctddh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XemGioHang"));
}
public DataSet DonDatHang_GetDonHang(DonDatHang inp, string swhere)
{
try
{
return(DonDatHang_bus.GetDonHang(inp, swhere));
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult GetDonDatHang(int id)
{
DonDatHang donDatHang = db.DonDatHangs.Find(id);
if (donDatHang == null)
{
return(NotFound());
}
return(Ok(donDatHang));
}
public void luu(int mancc, int manv, DateTime ngaydat)
{
DonDatHang dhs = new DonDatHang();
dhs.MaNCC = mancc;
dhs.MaNV = manv;
dhs.NgayNhap = ngaydat;
ql.DonDatHangs.InsertOnSubmit(dhs);
ql.SubmitChanges();
}
public RedirectToRouteResult ThanhToan(DonDatHang dh)
{
if (ModelState.IsValid)
{
KhachHang kh = (KhachHang)Session["kh"];
dh.MaKH = kh.MaKhachHang;
db.DonDatHangs.Add(dh);
db.SaveChanges();
}
return(RedirectToAction("DonHang", new { maDH = dh.MaDH }));
}
public ActionResult Edit([Bind(Include = "MaDH,MaKH,NgayDH,NgayGH,DiaChiNhan,SDTNhan,HTGH,HTTT,TinhTrangGH,TongThanhToan")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", donDatHang.MaKH);
return(View(donDatHang));
}
public async Task <ActionResult> DuyetDonHang([Bind(Include = "MaDonDatHang,NgayDat,NgayGiao,TenKhach,DiaChi,SoDienThoai,DaHuy,TinhTrangGiaoHang,DaXoa,DaThanhToan")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("ChuaGiao"));
}
return(View(donDatHang));
}
public ActionResult Edit([Bind(Include = "MaDDH,NgayDat,TinhTrang,MaKH,UuDai,NVGiaoHang,TinhTrangGH,TongTien")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("DonHangDaDuyet", "DonDatHangs"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donDatHang.MaKH);
return(RedirectToAction("DonHangDaDuyet", "DonDatHangs"));
}
public ActionResult DeleteOrder(int id)
{
if (Session["isAdmin"] != null && Session["isAdmin"].ToString() == "1")
{
DonDatHang ddh = db.DonDatHangs.Find(id);
db.DonDatHangs.Remove(ddh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
TempData["myMessage"] = "Bạn cần đăng nhập bằng tài khoản Admin để xe được trang này (^_^)";
return(Redirect("~"));
}
public ActionResult edit([Bind(Include = "MaDon,NgayDat,TenNguoiDat,DiaChiGiaoHang,SoDienThoai,Email,MaNV,MaKH,TrangThai")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.Entry(donDatHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHang, "MaKH", "HoTenKH", donDatHang.MaKH);
ViewBag.MaNV = new SelectList(db.NhanVien, "MaNV", "HoNV", donDatHang.MaNV);
return(View(donDatHang));
}
// Hien Thi Ten San Pham Theo Ma San Pham
public DataTable HienThiTenSpTheoMaSp(DonDatHang dh)
{
var result = donDatHangDAL.sp_HienThiTenSPTheoMaSP(dh.MaSp);
DataTable table = new DataTable();
table.Columns.Add("TENSP", typeof(string));
foreach (sp_HienThiTenSPTheoMaSPResult sp in result)
{
table.Columns.Add(sp.TENSP);
}
return(table);
}
public ActionResult DuyetDonHang(DonDatHang ddh)
{
DonDatHang ddhUpdate = db.DonDatHangs.Single(x => x.MaDDH == ddh.MaDDH);
ddhUpdate.DaThanhToan = ddh.DaThanhToan;
ddhUpdate.TinhTrang = ddh.TinhTrang;
db.SaveChanges();
GuiEmail("Xác nhận đơn hàng", "*****@*****.**", "*****@*****.**", "thangbach1995", "Don hang duoc xac nhan");
return(RedirectToAction("ChuaThanhToan"));
}
public ActionResult Create([Bind(Include = "MaDDH,NgayDat,TinhTrang,MaKH,UuDai,NVGiaoHang,TinhTrangGH,TongTien")] DonDatHang donDatHang)
{
if (ModelState.IsValid)
{
db.DonDatHangs.Add(donDatHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", donDatHang.MaKH);
return(View(donDatHang));
}
public IHttpActionResult PostDonDatHang(DonDatHang donDatHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DonDatHangs.Add(donDatHang);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = donDatHang.MaDonHang }, donDatHang));
}
// Hiển Thị Tên Nhà Cung Theo Mã Cung Câp
public DataTable ShowTenCCFlowMaCC(DonDatHang dh)
{
var result = donDatHangDAL.sp_HienThiTenCCTheoMaCC(dh.MaCc);
DataTable table = new DataTable();
table.Columns.Add("TENCC", typeof(string));
foreach (sp_HienThiTenCCTheoMaCCResult ncc in result)
{
table.Columns.Add(ncc.TENCC);
}
return(table);
}
public ActionResult XoaDonHang(int id)
{
DonDatHang sp = data.DonDatHangs.SingleOrDefault(n => n.MaDonDatHang == id);
//ViewBag.MaSanPham = sp.MaSanPham;
if (sp == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(sp));
}
public KhachHangDTO GetCustomerByOrderId(string id)
{
DonDatHang order = db.DonDatHang.Where(o => o.Id == id).FirstOrDefault();
return(db.KhachHang.Where(c => c.Id == order.IdKh).Select(s => new KhachHangDTO {
Id = s.Id,
TenKh = s.TenKh,
DiaChi = s.DiaChi,
Email = s.Email,
SoDienThoai = s.SoDienThoai
}).FirstOrDefault());
}
public ActionResult XemGioHang(KhachHang khachhang, FormCollection f)
{
if (Session["Email"] == null)
{
return(RedirectToAction("Login", "User"));
}
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
KhachHang KH = (KhachHang)Session["Email"];
// thêm đơn hàng
DonDatHang ddh = new DonDatHang();
//ddh.IdKH = int.Parse(KH.IdKH.ToString());
List <ItemGioHang> lstGH = LayGioHang();
ddh.IdKH = KH.IdKH;
ddh.NguoiNhan = f["TenKhachHang"];
ddh.DiaChiNguoiNhan = f["DiaChi"];
ddh.SdtNguoiNhan = f["SoDienThoai"];
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangGiaoHang = false;
ddh.DaThanhToan = false;
ddh.DaHuy = false;
ddh.DaXoa = false;
db.DonDatHangs.Add(ddh);
db.SaveChanges();
// thêm chi tiết đơn đặt hàng
decimal tong = 0;
decimal thanhtien = 0;
foreach (var item in lstGH)
{
ChiTietDonDatHang ctdh = new ChiTietDonDatHang();
ctdh.IdDDH = ddh.IdDDH;
ctdh.IdSanPham = item.IdSanPham;
ctdh.SoLuong = (int)item.SoLuong;
ctdh.DonGia = (decimal)item.DonGia;
thanhtien = item.SoLuong * item.DonGia;
tong += thanhtien;
db.ChiTietDonDatHangs.Add(ctdh);
db.SaveChanges();
}
ddh.TongTien = tong;
UpdateModel(ddh);
db.SaveChanges();
Session["GioHang"] = null;
return(View("ThongBao1"));
}
public ActionResult DatHang(FormCollection f)
{
if(Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "")
{
return RedirectToAction("Dangky","Customer");
}
if(Session["ShoppingCart"] == null)
{
return RedirectToAction("Index","Home");
}
ViewBag.listSC = GetShoppingCart();
DonDatHang ddh = new DonDatHang();
Customer kh = (Customer)Session["TaiKhoan"];
List<ShoppingCart> listSC = GetShoppingCart();
ddh.tinhtrang = 1;
ddh.idkhachhang = kh.id;
ddh.ngaydathang = DateTime.Now;
ddh.tongtien = (int)TongTien();
int check = db.insertDonDatHang(ddh);
int id = db.getDonDatHang(ddh.idkhachhang, ddh.ngaydathang);
if(check == 1)
{
foreach (var item in listSC)
{
CTDonDatHang ct = new CTDonDatHang();
ct.iddonhang = id;
ct.idsanpham = item.MaSP;
ct.soluong = item.SoLuong;
ct.size = item.Size;
int check1 = db.insertCTDonDatHang(ct);
if( check1 == 1)
{
KhoHang kho = new KhoHang();
kho.soluong = item.SoLuong;
kho.idsanpham = item.MaSP;
kho.size = item.Size;
db.UpdateKhoHang(kho);
}
}
}
kh.tenkh = f.Get("txtHoTen").ToString();
kh.diachikh = f.Get("txtDiaChi").ToString();
kh.email = f.Get("txtEmail").ToString();
kh.dienthoai = f.Get("txtSdt").ToString();
int updateCustomer = db.updateCustomer(kh);
if (updateCustomer != 1)
{
return RedirectToAction("ThongTinDonHang", "ShoppingCart");
}
Session["ShoppingCart"] = null;
return RedirectToAction("Index","Home");
}
public ActionResult DatHang(KhachHang kh)
{
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
KhachHang KhachHang = new KhachHang();
if (Session["TaiKhoan"] == null)
{
//Them khach hàng vào bảng khách hàng
KhachHang = kh;
db.KhachHangs.Add(KhachHang);
db.SaveChanges();
}
else
{
// khách hàng là thành viên
ThanhVien tv = Session["TaiKhoan"] as ThanhVien;
KhachHang.TenKH = tv.Hoten;
KhachHang.DiaChi = tv.DiaChi;
KhachHang.Email = tv.Email;
KhachHang.SoDienThoai = tv.SoDienThoai;
db.KhachHangs.Add(KhachHang);
}
// thêm đơn đặt
DonDatHang ddh = new DonDatHang();
ddh.MaKH = KhachHang.MaKH;
ddh.NgayDat = DateTime.Now;
ddh.TinhTrangGiaoHang = false;
ddh.DaThanhToan = false;
ddh.UuDai = 0;
db.DonDatHangs.Add(ddh);
db.SaveChanges();
// Lấy giỏ hàng
List <ItemGioHang> lshGH = LayGioHang();
foreach (var item in lshGH)
{
ChiTietDonDatHang ctddh = new ChiTietDonDatHang();
ctddh.MaDDH = ddh.MaDDH;
ctddh.MaSP = item.MaSP;
ctddh.TenSP = item.TenSP;
ctddh.SoLuong = item.SoLuong;
ctddh.DonGia = item.DonGia;
db.ChiTietDonDatHangs.Add(ctddh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XemGioHang"));
}
public IHttpActionResult getHoaDon(int id) //id
{
try
{
HienThiDonHang ctDonHang = new HienThiDonHang();
string diaChi = "";
DonDatHang donHang = db.DonDatHangs.FirstOrDefault(x => x.id_don_hang == id);
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(x => x.id == donHang.id_dia_chi);
TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == dc.id_tinh);
QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == dc.id_quan);
XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == dc.id_xa_phuong);
if (donHang == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
ctDonHang.idDonDatHang = donHang.id_don_hang;
ctDonHang.trangThai = db.TinhTrangDonHangs.FirstOrDefault(x => x.id_tinh_trang == donHang.id_tinh_trang).tinh_trang_don_hang;
ctDonHang.ngayLap = donHang.ngay_lap.ToShortDateString();
ctDonHang.tenNguoiNhan = db.KhachHangs.FirstOrDefault(x => x.id_khach_hang == donHang.id_khach_hang).ten_nguoi_dung;
ctDonHang.soDT = "0" + donHang.so_dt_nguoi_nhan;
diaChi = "" + dc.dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten;
ctDonHang.diaChi = diaChi;
// add danh sach san pham
List <ChiTietDonHang> list = db.ChiTietDonHangs.Where(x => x.id_don_hang == id).ToList();
List <DSSanPham> lDanhSanPham = new List <DSSanPham>();
for (int i = 0; i < list.Count; i++)
{
DSSanPham dsp = new DSSanPham();
dsp.soLuong = list[i].so_luong;
dsp.tongGia = (float)list[i].tong_tien;
dsp.giaKM = (float)list[i].gia_km;
//gan san pham
SanPham tam = db.SanPhams.FirstOrDefault(x => x.id_san_pham == list[i].id_san_pham);
SanPham sp = new SanPham();
sp.id_san_pham = tam.id_san_pham;
sp.id_danh_muc = tam.id_danh_muc;
sp.mo_ta = tam.mo_ta;
sp.phan_tram_km = tam.phan_tram_km;
sp.ten_sp = tam.ten_sp;
sp.url_hinh_chinh = "http://www.3anhem.somee.com" + tam.url_hinh_chinh;
sp.gia_sp = tam.gia_sp;
sp.gia_km = tam.gia_km;
dsp.sanPham = sp;
lDanhSanPham.Add(dsp);
}
ctDonHang.danhSachHang = lDanhSanPham;
return(Ok(ctDonHang));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult DaDuyet1(int MaDonDatHang = 0)
{
DonDatHang ddh = data.DonDatHangs.SingleOrDefault(n => n.MaDonDatHang == MaDonDatHang);
if (ddh == null)
{
Response.StatusCode = 404;
return(null);
}
ddh.MaTinhTrang = 3;
data.SubmitChanges();
return(Redirect("QuanLyDonHangDaDyet"));
}
/// <summary>
/// Create a new DonDatHang object.
/// </summary>
/// <param name="datHang_ID">Initial value of DatHang_ID.</param>
public static DonDatHang CreateDonDatHang(int datHang_ID)
{
DonDatHang donDatHang = new DonDatHang();
donDatHang.DatHang_ID = datHang_ID;
return donDatHang;
}
/// <summary>
/// There are no comments for DonDatHang in the schema.
/// </summary>
public void AddToDonDatHang(DonDatHang donDatHang)
{
base.AddObject("DonDatHang", donDatHang);
}
