public ActionResult DatHang(FormCollection collection)
{
DatHang ddh = new DatHang();
TaiKhoan tk = (TaiKhoan)Session["Username"];
List<GioHang> gh = LayGioHang();
ddh.IDUser = tk.IDUser;
ddh.ThoiGianDatHang = DateTime.Now;
ddh.DaGiaoHang = false;
var diachigiaohang = collection["DiaChiGiaoHang"];
ddh.DiaChiGiaoHang = diachigiaohang;
double iTongTien = 0;
List<GioHang> lstGiohang = Session["GioHang"] as List<GioHang>;
if (lstGiohang != null)
{
iTongTien = lstGiohang.Sum(n => n.dThanhTien);
}
ddh.ThanhTien = decimal.Parse( iTongTien.ToString());
data.DatHangs.InsertOnSubmit(ddh);
data.SubmitChanges();
foreach (var item in gh)
{
ChiTietDatHang ctdn = new ChiTietDatHang();
ctdn.ID = ddh.ID;
ctdn.IDThucDon = item.iIDThucDon;
ctdn.SoLuong = item.iSoLuong;
data.ChiTietDatHangs.InsertOnSubmit(ctdn);
}
data.SubmitChanges();
Session["GioHang"] = null;
return RedirectToAction("Xacnhandonhang", "GioHang");
}
public ActionResult DatHang(FormCollection collection)
{
DatHang dh = new DatHang();
KhachHang kh = (KhachHang)Session["ID"];
List <GioHang> gh = laygiohang();
dh.NgayDatHang = DateTime.Now;
dh.DaGiao = false;
var ngaygiao = DateTime.Parse(collection["NgayGiaoHang"]);
dh.NgayGiaoHang = ngaygiao;
dh.TenNguoiNhan = kh.TenKhachHang;
dh.DiaChiNhan = kh.DiaChi;
dh.DienThoaiNhan = kh.SDT;
dh.HTThanhToan = false;
dh.MaKhachHang = kh.MaKhachHang;
data.DatHangs.InsertOnSubmit(dh);
data.SubmitChanges();
foreach (var item in gh)
{
ChiTietDat ctdh = new ChiTietDat();
ctdh.SoDH = dh.SoDH;
ctdh.MaDongHo = item.iMaDongHo;
ctdh.SoLuong = item.isoluong;
ctdh.DonGia = (decimal)item.idongia;
data.ChiTietDats.InsertOnSubmit(ctdh);
}
data.SubmitChanges();
Session["GioHang"] = null;
return(RedirectToAction("XacNhanDonHang", "GioHang"));
}
private void btnLuuDonHang_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
if (trangThai1 == "them")
{
DatHang dh = new DatHang();
dh.MaSoKhachHang = int.Parse(cboKhachHang.EditValue.ToString());
dh.NgayDat = DateTime.Parse(txtNgayDat.EditValue.ToString());
dh.TongThanhTien = "0";
dh.TinhTrang = txtTinhTrang.Text;
data.DatHangs.InsertOnSubmit(dh);
data.SubmitChanges();
loadDgvDatHang();
//ClearAll();
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (trangThai1 == "sua")
{
string maDH = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaDatHang").ToString();
DatHang dh = data.DatHangs.Where(t => t.MaDatHang == int.Parse(maDH)).FirstOrDefault();
dh.MaSoKhachHang = int.Parse(cboKhachHang.EditValue.ToString());
dh.NgayDat = DateTime.Parse(txtNgayDat.EditValue.ToString());
dh.TinhTrang = txtTinhTrang.Text;
data.SubmitChanges();
loadDgvDatHang();
//ClearAll();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
private void btnXoaDonHang_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string maDH = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaDatHang").ToString();
DatHang dh = data.DatHangs.Where(t => t.MaDatHang == int.Parse(maDH)).FirstOrDefault();
try
{
DialogResult r;
r = MessageBox.Show("Bạn có muốn xóa khách hàng này", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
data.DatHangs.DeleteOnSubmit(dh);
data.SubmitChanges();
MessageBox.Show("Xóa đơn hàng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadDgvDatHang();
}
}
catch
{
MessageBox.Show("Không thể xóa đơn hàng này vì có dữ liệu liên quan", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
return;
}
}
}
public ActionResult DeleteConfirmed(string id)
{
DatHang datHang = db.DatHangs.Find(id);
db.DatHangs.Remove(datHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "DatHangID,KhachHangID,NgayDatHang,TriGia,DaGiao,NgayGiao,HoTen,DiaChi,DienThoai,Email")] DatHang datHang)
{
if (ModelState.IsValid)
{
db.Entry(datHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(datHang));
}
public ActionResult Edit([Bind(Include = "MaHoaDon,MaKhachHang,TongTien,NgayDatHang,TrangThai")] DatHang datHang)
{
if (ModelState.IsValid)
{
db.Entry(datHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKhachHang = new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", datHang.MaKhachHang);
return(View(datHang));
}
private void CapNhapTongThanhTien(int maDatHang)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string value = data.ChiTietDatHangs.Where(t => t.MaDatHang == maDatHang).Sum(a => a.ThanhTien).ToString();
DatHang dh = data.DatHangs.Where(t => t.MaDatHang == maDatHang).FirstOrDefault();
dh.TongThanhTien = value;
data.SubmitChanges();
loadDgvDatHang();
txtTongThanhTien.Text = value;
}
}
public ActionResult Edit([Bind(Include = "MaDat,NguoiDat,IdSanPham,TrangThai,SoLuong,DiaChiGiaoHang")] DatHang datHang)
{
if (ModelState.IsValid)
{
db.Entry(datHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NguoiDat = new SelectList(db.KhachHangs, "Id", "HoVaTen", datHang.NguoiDat);
ViewBag.IdSanPham = new SelectList(db.SanPhams, "Id", "TenSanPham", datHang.IdSanPham);
return(View(datHang));
}
public JsonResult XacNhanDatHang(DatHang datHang)
{
try
{
db.DatHangs.Add(datHang);
db.SaveChanges();
return(Json("OK", JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("Failse", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(DatHang order)
{
DatHang dathang = db.DatHangs.Find(order.madh);
if (dathang != null)
{
dathang.Note = order.Note;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public long Them(DatHang dhang)
{
try
{
db.DatHangs.Add(dhang);
db.SaveChanges();
return(dhang.Id);
}
catch
{
return(0);
}
}
public ActionResult InsertData()
{
string name = Request.Form["billing_full_name"];
string phone = Request.Form["billing_phone"];
string email = Request.Form["billing_email"];
string addresstype = Request.Form["billing_address_1"];
string address = Request.Form["billing_address_2"];
ShoppingCart cart = (ShoppingCart)Session["cart"];
List <Item> lst = new List <Item>();
if (cart != null)
{
lst = cart.lst;
if (db.KhachHangs.Where(q => q.hotenkh == name && q.sdt == phone && q.email == email).FirstOrDefault() == null)
{
KhachHang khachhang = new KhachHang();
khachhang.hotenkh = name;
khachhang.diachi = addresstype + " - " + address;
khachhang.email = email;
khachhang.sdt = phone;
db.KhachHangs.Add(khachhang);
db.SaveChanges();
}
DatHang dathang = new DatHang();
var x = db.KhachHangs.Where(q => q.hotenkh == name && q.sdt == phone && q.email == email).FirstOrDefault();
dathang.makh = x.makh;
dathang.ngaytao = DateTime.Today;
dathang.Note = "Chưa được xử lý";
db.DatHangs.Add(dathang);
db.SaveChanges();
CTDatHang cTDatHang = new CTDatHang();
foreach (var item in lst)
{
cTDatHang.madh = dathang.madh;
cTDatHang.mats = item.id;
cTDatHang.soluong = item.amount;
cTDatHang.dongia = (decimal)item.price;
cTDatHang.thanhtien = (decimal)(item.price * item.amount);
db.CTDatHangs.Add(cTDatHang);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public string OrderProduct(OrderDetailDto order, DateTime dateCreate)
{
try
{
using (var dbContext = new XeNangEntities())
{
int ID = (from o in dbContext.DatHangs select o.ID).Count() + 1;
var or = new DatHang()
{
ID = ID,
DiaChi = order.CustomerAddr,
MailZalo = order.CustomerEmail,
//CreateDt = dateCreate,
SDT = order.CustomerPhoneNo,
SoLuong = order.Quantities,
TenHang = order.ProductName,
TenNguoiDat = order.CustomerName,
ThoiGianCanLay = order.DateOfDelivery,
TrangThai = order.Status,
};
if (order.Description != null)
{
or.MoTa = order.Description;
}
dbContext.DatHangs.Add(or);
dbContext.SaveChanges();
return(Constant.MESSAGE_SUCCESS);
}
}
// CATCH EXEPTION FOR DEBUG PURPOSE
catch (DbEntityValidationException ex)
{
foreach (var e in ex.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
e.Entry.Entity.GetType().Name, e.Entry.State);
foreach (var ve in e.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
return(Constant.MESSAGE_ERROR);
}
catch (DbUpdateException ex)
{
return(Constant.MESSAGE_ERROR);
}
}
/* public ActionResult Index()
* {
* var datHangs = db.DatHangs.Include(d => d.KhachHang).Include(d => d.SanPham);
* return View(datHangs.ToList());
* }
*/
// GET: admin/DatHangs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DatHang datHang = db.DatHangs.Find(id);
if (datHang == null)
{
return(HttpNotFound());
}
return(View(datHang));
}
public ActionResult DatHang(KhachHang kh)
{
if (Session["GioHang"] == null)
{
return(RedirectToAction("Index", "Home"));
}
KhachHang kh1 = new KhachHang();
if (Session["ThanhVien"] == null)
{
kh1 = kh;
db.KhachHang.Add(kh1);
}
else
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
kh1.TenKH = tv.HoTen;
kh1.DiaChi = tv.DiaChi;
kh1.DienThoai = tv.SoDienThoai;
kh1.Email = tv.Email;
db.KhachHang.Add(kh1);
}
DatHang dh = new DatHang();
dh.MaKH = kh1.MaKH;
dh.NgayDat = DateTime.Now;
dh.TinhTrangGiao = false;
dh.DaThanhToan = false;
dh.UuDai = 0;
dh.DaHuy = false;
db.DatHang.Add(dh);
List <itemGioHang> lstGH = LayGioHang();
foreach (var item in lstGH)
{
ChiTietDatHang ctdh = new ChiTietDatHang();
ctdh.MaDH = dh.MaDH;
ctdh.MaSP = item.MaSP;
ctdh.TenSP = item.TenSP;
ctdh.SoLuong = item.SoLuong;
ctdh.DonGia = item.DonGia;
db.ChiTietDatHang.Add(ctdh);
}
db.SaveChanges();
Session["GioHang"] = null;
return(RedirectToAction("XemChiTiet"));
}
public static DatHang SelectById(Guid DH_ID)
{
var Item = new DatHang();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("DH_ID", DH_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHang_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
// GET: Administrator/DatHangs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DatHang datHang = db.DatHangs.Find(id);
if (datHang == null)
{
return(HttpNotFound());
}
ViewBag.MaKhachHang = new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", datHang.MaKhachHang);
return(View(datHang));
}
// GET: admin/DatHangs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DatHang datHang = db.DatHangs.Find(id);
if (datHang == null)
{
return(HttpNotFound());
}
ViewBag.NguoiDat = new SelectList(db.KhachHangs, "Id", "HoVaTen", datHang.NguoiDat);
ViewBag.IdSanPham = new SelectList(db.SanPhams, "Id", "TenSanPham", datHang.IdSanPham);
return(View(datHang));
}
public JsonResult CheckOut(DatHang model)
{
if (ModelState.IsValid)
{
model.NgayDatHang = DateTime.Now;
//model.TongTien =
model.MaTT = 1;
var db = new WebDungCuHocTapDbContext();
db.DatHangs.Add(model);
db.SaveChanges();
return(Json(new { Success = 1 }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Success = 0 }, JsonRequestBehavior.AllowGet));
}
public ActionResult ThanhToan(string shipName, string address, string mobile, string httt, string htgh)
{
var od = new OrderDao();
var session = (AccLogin)Session[CommonConstants.Account_Session];
var dondathang = new DatHang();
dondathang.CustomerID = new UserDao().GetCus(session.UserName).ID;
dondathang.CreateDate = DateTime.Now;
dondathang.LastName = shipName;
dondathang.Address = address;
dondathang.Phone = mobile;
dondathang.Papyment = httt;
try
{
var soDH = od.Insert(dondathang);
var cart = (List <CartItem>)Session[CartSession];
var chitietDao = new OrderDetailDao();
decimal total = 0;
string tenmonan = null, gia = null;
foreach (var item in cart)
{
decimal thanhtien = 0;
var chitiet = new ThongTinDatHang();
chitiet.OrderID = soDH;
chitiet.FoodID = item.Monan.ID;
chitiet.Price = item.Monan.Price;
chitiet.Quantity = item.SoLuong;
thanhtien += item.Monan.Price.Value * item.SoLuong;
od.InsertSLBan(item.Monan.ID, item.SoLuong);
chitietDao.Insert(chitiet);
total += (item.Monan.Price.GetValueOrDefault(0) * item.SoLuong);
tenmonan += item.Monan.Name + "<br />";
gia += item.Monan.Price.GetValueOrDefault(0).ToString("N0") + "<br />";
}
Session[CartSession] = null;
}
catch (Exception)
{
return(Redirect("/loi-thanh-toan"));
}
return(RedirectToAction("DatHangThanhCong", "Cart"));
}
public bool DatHang_Update(DatHang Data)
{
try
{
using (SqlCommand dbCmd = new SqlCommand("sp_DatHang_Update", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@NgaylapHD", Data.NgaylapHD));
dbCmd.Parameters.Add(new SqlParameter("@id_KhachHang", Data.Id_KhachHang));
dbCmd.Parameters.Add(new SqlParameter("@IdPay", Data.IdPay));
dbCmd.Parameters.Add(new SqlParameter("@id", Data.Id));
dbCmd.ExecuteNonQuery();
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("DatHang");
return(true);
}
catch
{
return(false);
}
}
// GET: AdminDatHang/Edit/5
public ActionResult Edit(int?id)
{
User nguoiDung = Session["NguoiDung"] as User;
if (nguoiDung != null)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DatHang datHang = db.DatHangs.Find(id);
if (datHang == null)
{
return(HttpNotFound());
}
return(View(datHang));
}
else
{
return(RedirectToAction("Login", "AdminUser"));
}
}
public ActionResult DatHang(DatHang hoaDon)
{
var gioHang = Session["GioHang"] as GioHangModel;
if (gioHang == null || gioHang.TongSanPham == 0)
{
return(RedirectToAction("Index", "Home"));
}
// Xử lý phát sinh HoaDon và HoaDonChiTiet
try
{
//1. Thêm HoaDon
hoaDon.NgayDatHang = DateTime.Now;
hoaDon.TriGia = gioHang.TongTriGia;
db.DatHangs.Add(hoaDon);
//2. Thêm DatHangCT
foreach (var item in gioHang.Items)
{
DatHangCT ct = new DatHangCT();
ct.DatHangID = hoaDon.DatHangID;
ct.SachID = item.SanPham.SachID;
ct.SoLuong = item.SoLuong;
ct.DonGia = item.SanPham.GiaBan;
ct.ThanhTien = item.SanPham.GiaBan * item.SoLuong;
db.DatHangCTs.Add(ct);
}
db.SaveChanges();
gioHang.Clear();
return(View("DatHangThanhCong", hoaDon));
}
catch (Exception ex)
{
ViewData["LoiDatHang"] = "Đặt hàng không thành công.<br>" + ex.Message;
return(View(hoaDon));
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
if (validate.CheckTextBoxisEmpty(txtMaDatHang) &&
validate.CheckTextBoxisEmpty(txtSoLuong) &&
validate.checkisNumber(txtSoLuong) &&
validate.CheckLookupisSelected(cboSanPham, "Bạn chưa chọn sản phẩm") &&
validate.checkDateTime(dtNgayDat.Value, dtNgayNhan.Value, "Ngày nhận phải sau ngày đặt"))
{
QuanLyBanHangEntities db = new QuanLyBanHangEntities();
DatHang dh = new DatHang();
dh.MaDatHang = txtMaDatHang.Text.Trim();
dh.NgayDat = dtNgayDat.Value;
dh.NgayNhan = dtNgayNhan.Value;
dh.IDSP = (long)cboSanPham.EditValue;
dh.SoLuong = Convert.ToDouble(txtSoLuong.Text.Trim());
if (txtTenKhachHang.Text.Length > 0)
{
dh.TenKhachHang = txtTenKhachHang.Text.Trim();
}
if (txtSoDienThoai.Text.Length > 0)
{
dh.DienThoai = txtSoDienThoai.Text.Trim();
}
db.DatHangs.Add(dh);
db.SaveChanges();
loadDatatoGridView();
MsgUtil.MessageThemSuccess();
}
}
catch (Exception v_e)
{
MsgUtil.MessageThongBao("Lỗi: " + v_e);
}
}
public static DatHang getFromReader(IDataReader rd)
{
var Item = new DatHang();
if (rd.FieldExists("DH_ID"))
{
Item.ID = (Guid)(rd["DH_ID"]);
}
if (rd.FieldExists("DH_Ma"))
{
Item.Ma = (String)(rd["DH_Ma"]);
}
if (rd.FieldExists("DH_KH_Ten"))
{
Item.KH_Ten = (String)(rd["DH_KH_Ten"]);
}
if (rd.FieldExists("DH_KH_Email"))
{
Item.KH_Email = (String)(rd["DH_KH_Email"]);
}
if (rd.FieldExists("DH_KH_Mobile"))
{
Item.KH_Mobile = (String)(rd["DH_KH_Mobile"]);
}
if (rd.FieldExists("DH_KH_DiaChi"))
{
Item.KH_DiaChi = (String)(rd["DH_KH_DiaChi"]);
}
if (rd.FieldExists("DH_KH_ID"))
{
Item.KH_ID = (Guid)(rd["DH_KH_ID"]);
}
if (rd.FieldExists("DH_KH_Facebook"))
{
Item.KH_Facebook = (String)(rd["DH_KH_Facebook"]);
}
if (rd.FieldExists("DH_Facebook"))
{
Item.Facebook = (String)(rd["DH_Facebook"]);
}
if (rd.FieldExists("DH_GiaTri"))
{
Item.GiaTri = (Int32)(rd["DH_GiaTri"]);
}
if (rd.FieldExists("DH_PhiVanChuyen"))
{
Item.PhiVanChuyen = (Int32)(rd["DH_PhiVanChuyen"]);
}
if (rd.FieldExists("DH_Tong"))
{
Item.Tong = (Int32)(rd["DH_Tong"]);
}
if (rd.FieldExists("DH_GiaoHang"))
{
Item.GiaoHang = (Boolean)(rd["DH_GiaoHang"]);
}
if (rd.FieldExists("DH_NgayGiao"))
{
Item.NgayGiao = (DateTime)(rd["DH_NgayGiao"]);
}
if (rd.FieldExists("DH_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["DH_NgayTao"]);
}
if (rd.FieldExists("DH_ThanhToan"))
{
Item.ThanhToan = (Boolean)(rd["DH_ThanhToan"]);
}
if (rd.FieldExists("DH_UPS_Code"))
{
Item.UPS_Code = (String)(rd["DH_UPS_Code"]);
}
if (rd.FieldExists("DH_PaypalTx"))
{
Item.PaypalTx = (String)(rd["DH_PaypalTx"]);
}
if (rd.FieldExists("DH_Username"))
{
Item.Username = (String)(rd["DH_Username"]);
}
if (rd.FieldExists("DH_NgayDat"))
{
Item.NgayDat = (DateTime)(rd["DH_NgayDat"]);
}
if (rd.FieldExists("DH_TT_ID"))
{
Item.TT_ID = (Guid)(rd["DH_TT_ID"]);
}
if (rd.FieldExists("DH_NguonGoc_ID"))
{
Item.NguonGoc_ID = (Guid)(rd["DH_NguonGoc_ID"]);
}
if (rd.FieldExists("DH_Readed"))
{
Item.Readed = (Boolean)(rd["DH_Readed"]);
}
if (rd.FieldExists("DH_FacebookUrl"))
{
Item.FacebookUrl = (String)(rd["DH_FacebookUrl"]);
}
if (rd.FieldExists("DH_GhiChu"))
{
Item.GhiChu = (String)(rd["DH_GhiChu"]);
}
if (rd.FieldExists("DH_UuTien"))
{
Item.UuTien = (Int32)(rd["DH_UuTien"]);
}
if (rd.FieldExists("DH_NgayGiaoYeuCau"))
{
Item.NgayGiaoYeuCau = (DateTime)(rd["DH_NgayGiaoYeuCau"]);
}
if (rd.FieldExists("TT_Ten"))
{
Item.TT_Ten = (String)(rd["TT_Ten"]);
}
if (rd.FieldExists("NguonGoc_Ten"))
{
Item.NguonGoc_Ten = (String)(rd["NguonGoc_Ten"]);
}
if (rd.FieldExists("DH_SoLuong"))
{
Item.SoLuong = (Int32)(rd["DH_SoLuong"]);
}
if (rd.FieldExists("DH_Map"))
{
Item.Map = (String)(rd["DH_Map"]);
}
if (rd.FieldExists("DH_Huy"))
{
Item.Huy = (Boolean)(rd["DH_Huy"]);
}
if (rd.FieldExists("DH_TraLai"))
{
Item.TraLai = (Int32)(rd["DH_TraLai"]);
}
if (rd.FieldExists("DH_TienThuVe"))
{
Item.TienThuVe = (Int32)(rd["DH_TienThuVe"]);
}
if (rd.FieldExists("DH_KhachBuon"))
{
Item.KhachBuon = (Boolean)(rd["DH_KhachBuon"]);
}
return(Item);
}
public ActionResult Details(DatHang order)
{
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
string act = Request["act"];
string _ID = Request["ID"];
string _SoLuong = Request["SoLuong"];
string _Ten = Request["Ten"];
string _Gia = Request["Gia"];
string _Img = Request["Img"];
string _Email = Request["Email"];
string _Mobile = Request["Mobile"];
string _DiaChi = Request["DiaChi"];
string _GhiChu = Request["GhiChu"];
var gh = new GioHang();
var item = new HangHoa();
var _dele = new SendEmailDele(sendmailThongbao);
var sb = new StringBuilder();
switch (act)
{
case "add":
#region add
item = HangHoaDal.SelectById(new Guid(_ID));
gh.Add(item, _SoLuong);
break;
#endregion
case "addWishList":
#region add
if(Security.IsAuthenticated())
{
var yt = new YeuThich()
{
HH_ID = new Guid(_ID)
, ID = Guid.NewGuid()
, NgayTao = DateTime.Now
, Username = Security.Username
};
YeuThichDal.Insert(yt);
sb.Append("1");
}
else
{
sb.Append("0");
}
break;
#endregion
case "save":
#region save
var itemDh = new DatHang
{
ID=Guid.NewGuid(),
GiaoHang = false,
GiaTri = gh.Total,
KH_DiaChi = _DiaChi,
KH_Email = _Email,
KH_Mobile = _Mobile,
KH_Ten = _Ten,
NgayTao = DateTime.Now,
PhiVanChuyen = gh.ShipCost,
Readed = false,
Tong = gh.Total + gh.ShipCost,
NgayGiao = DateTime.Now,
Username = Security.Username
};
itemDh = DatHangDal.Insert(itemDh);
var itemDhCt = new DatHangChiTiet();
var sbDh = new System.Text.StringBuilder();
sbDh.AppendFormat(@"Customer: {0}<br/>Email: {1}<br/>Mobile: {2}<br/>Address: {3}<br/>Note: {4}<br/>Date of purchase: {5}<br/><h3>Chi tiết</h3>"
,_Ten,_Email,_Mobile,_DiaChi, _GhiChu,DateTime.Now);
foreach (var _ghItem in gh.List)
{
var ghItem = _ghItem.Value;
itemDhCt = new DatHangChiTiet();
itemDhCt.ID = Guid.NewGuid();
itemDhCt.DH_ID = itemDh.ID;
itemDhCt.HH_ID = new Guid(_ghItem.Key);
itemDhCt.HH_Gia = ghItem.Gia;
itemDhCt.HH_SoLuong = ghItem.SoLuong;
itemDhCt.HH_Ten = ghItem.Ten;
itemDhCt.HH_Tong = ghItem.Gia * ghItem.SoLuong;
itemDhCt.NgayTao = DateTime.Now;
DatHangChiTietDal.Insert(itemDhCt);
sbDh.AppendFormat("Item:{0} - {1}<br/>Quality: {2}<br/>Sub total: {3}<hr/>", ghItem.Ten, ghItem.Gia, ghItem.SoLuong, ghItem.Gia * ghItem.SoLuong);
}
sbDh.AppendFormat(@"Total:{0}<br/>Shipping cost: {1}<br/>Total amout: {2}"
, gh.Total, gh.ShipCost, gh.Total + gh.ShipCost);
_dele.BeginInvoke("*****@*****.**"
, string.Format("Leenaa - New Order: {0} {1} [{2}.000]", _Ten, DateTime.Now.ToString("hh:mm-dd/MM/yy"),gh.Total + gh.ShipCost)
, sbDh.ToString()
, null, null);
gh.Clear();
if(itemDh.Tong != 0)
{
itemDh.Tong = itemDh.Tong/1141;
}
sb.AppendFormat("({0})",JavaScriptConvert.SerializeObject(itemDh));
rendertext(sb, "text/plain");
break;
#endregion
case "UpSl":
#region UpSl
item = HangHoaDal.SelectById(new Guid(_ID));
gh.UpdateSl(item, _SoLuong);
break;
#endregion
case "del":
#region add
gh.Remove(_ID);
break;
#endregion
case "delWishList":
#region delWishList
if (Security.IsAuthenticated())
{
YeuThichDal.DeleteById(new Guid(_ID));
}
break;
#endregion
case "clear":
#region add
gh.Clear();
break;
#endregion
case "get":
#region get
break;
#endregion
default:
break;
}
//sb.Append(format_gioHang(gh));
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(gh));
rendertext(sb, "text/plain");
}
protected void Page_Load(object sender, EventArgs e)
{
var act = Request["act"];
var Ten = Request["Ten"];
var Ho = Request["Ho"];
var ID = Request["ID"];
var XungHo = Request["XungHo"];
var NgaySinh = Request["NgaySinh"];
var Mobile = Request["Mobile"];
var FacebookUid = Request["FacebookUid"];
var NguonGoc_ID = Request["NguonGoc_ID"];
var KhuVuc_ID = Request["KhuVuc_ID"];
var DiaChi = Request["DiaChi"];
var NgungTheoDoi = Request["NgungTheoDoi"];
var HH_ID = Request["HH_ID"];
var GhiChu = Request["GhiChu"];
var FacebookUrl = Request["FacebookUrl"];
var UuTien = Request["UuTien"];
var NgayGiao = Request["NgayGiao"];
var NgayGiaoYeuCau = Request["NgayGiaoYeuCau"];
var NgayDat = Request["NgayDat"];
NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
switch (act)
{
case "add":
#region add
if(Security.IsAuthenticated())
{
KhachHang item;
if(string.IsNullOrEmpty(ID))
{
item=new KhachHang();
item.ID = Guid.NewGuid();
item.NgayTao = DateTime.Now;
}
else
{
item = KhachHangDal.SelectById(new Guid(ID));
}
item.NguoiTao = Security.Username;
item.Ten = Ten;
item.Mobile = Mobile;
item.FacebookUid = FacebookUid;
item.DiaChi = DiaChi;
if(!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID=new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item.NgayCapNhat = DateTime.Now;
item = string.IsNullOrEmpty(ID) ? KhachHangDal.Insert(item) : KhachHangDal.Update(item);
rendertext(item.ID.ToString());
}
break;
#endregion
case "xoa":
#region add
if (Security.IsAuthenticated())
{
KhachHangDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "addAndShip":
#region add
if (Security.IsAuthenticated())
{
var item = new KhachHang
{
ID = Guid.NewGuid(),
NgayTao = DateTime.Now,
NguoiTao = Security.Username,
Ten = Ten,
Mobile = Mobile,
FacebookUid = FacebookUid,
DiaChi = DiaChi,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
};
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item = KhachHangDal.Insert(item);
var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var dh = new DatHang
{
GiaTri = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
KH_DiaChi = DiaChi,
KH_ID = item.ID,
KH_Mobile = Mobile,
KH_Ten = Ten,
Readed = false,
Tong = Convert.ToInt32(hh.GNY),
PhiVanChuyen = 0,
NgayTao = DateTime.Now,
Username = Security.Username,
GhiChu = GhiChu,
FacebookUrl = FacebookUrl,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10),
UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien)
};
if (!string.IsNullOrEmpty(NgayGiaoYeuCau))
{
dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayDat))
{
dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn"));
}
else
{
dh.NgayDat = DateTime.Now;
}
if (!string.IsNullOrEmpty(NgayGiao))
{
dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
dh.NguonGoc_ID = new Guid(NguonGoc_ID);
}
dh = DatHangDal.Insert(dh);
var dhct = new DatHangChiTiet
{
DH_ID = dh.ID,
HH_ID = hh.ID,
HH_Gia = Convert.ToInt32(hh.GNY),
HH_SoLuong = 1,
HH_Ten = hh.Ten,
HH_Tong = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
NgayTao = DateTime.Now
};
dhct = DatHangChiTietDal.Insert(dhct);
var ship = new Shipping()
{
ID = Guid.NewGuid()
, DH_ID = dh.ID
, DH_Ma = dh.Ma
, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
, DaGiao = false
, DiaChi = dh.KH_DiaChi
, HD_ID = dhct.HH_ID
, NgayGiao = DateTime.Now
, NgayTao = DateTime.Now
, NguoiTao = Security.Username
, Phi = dh.PhiVanChuyen
, Readed = false
, TraTien = false
, PhaiThu = dh.Tong
};
ship = ShippingDal.Insert(ship);
// Xuất nhập
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
var xn = XuatNhapDal.SelectByDraff(true);
xn.TVDV_ID = dh.ID;
xn.ChietKhau = 0;
xn.ChuyenDoi = false;
xn.ConNo = 0;
xn.CongTienHang = dh.Tong;
xn.DauKy = false;
xn.DienGiai = string.Format("Thêm hóa đơn bán lẻ cho đặt hàng {0}", dh.Ma);
xn.ID = Guid.NewGuid();
xn.KHO_ID = KhoHangDal.SelectAll()[0].ID;
xn.KH_ID = dh.KH_ID;
xn.KH_Ten = dh.KH_Ten;
xn.NgayCapNhat = DateTime.Now;
xn.NgayHoaDon = DateTime.Now;
xn.NgayTao = DateTime.Now;
xn.NguoiCapNhat = Security.Username;
xn.NguoiTao = Security.Username;
xn.NhanVien = Security.Username;
xn.NoiBo = false;
xn.ThanhToan = dh.Tong;
xn.TuVanVien = Security.Username;
xn.VAT = 0;
xn.Xuat = true;
xn.LOAI_ID = danhMucLoaiXuatNhap.ID;
xn = XuatNhapDal.Insert(xn);
// Xuất nhập chi tiết
var itemXnCt = new XuatNhapChiTiet
{
ID = Guid.NewGuid(),
CKTien = Convert.ToDouble(0),
CKTyLe = Convert.ToDouble(0),
DonGia = Convert.ToDouble(dhct.HH_Gia),
HH_ID = dhct.HH_ID,
GhiChu = GhiChu,
NgayCapNhat = DateTime.Now,
NguoiCapNhat = Security.Username,
SoLuong = Convert.ToDouble(dhct.HH_SoLuong),
Tong = Convert.ToDouble(dhct.HH_Tong),
VAT = Convert.ToDouble(0),
KH_ID = dh.KH_ID
};
itemXnCt = XuatNhapChiTietDal.Update(itemXnCt);
// Thu chi
var thuChi = ThuChiDal.SelectByXnId(xn.ID.ToString());
thuChi.LoaiQuy = Convert.ToInt32(0);
thuChi.P_ID = xn.KH_ID;
thuChi.NgayTao = DateTime.Now;
thuChi.SoTien = dh.Tong;
if (thuChi.ID == Guid.Empty)
{
var ndtcItem = DanhMucDal.SelectByMa("NDTC-THU-KHANGTRA");
thuChi = ThuChiDal.SelectByDraff(true);
thuChi.LoaiCandoi = 0;
thuChi.Mota = string.Format("{0}: {1}", ndtcItem.Ten, item.Ma);
thuChi.NDTC_ID = ndtcItem.ID;
thuChi.Thu = true;
thuChi.XN_ID = item.ID;
thuChi.NguoiTao = Security.Username;
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
thuChi.isCandoi = false;
ThuChiDal.Insert(thuChi);
}
else
{
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
ThuChiDal.Update(thuChi);
}
rendertext(dh.ID.ToString());
}
break;
#endregion
case "addAndHoaDon":
#region addAndHoaDon
if (Security.IsAuthenticated())
{
var item = new KhachHang
{
ID = Guid.NewGuid(),
NgayTao = DateTime.Now,
NguoiTao = Security.Username,
Ten = Ten,
Mobile = Mobile,
FacebookUid = FacebookUid,
DiaChi = DiaChi,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
};
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item = KhachHangDal.Insert(item);
var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var dh = new DatHang
{
GiaTri = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
KH_DiaChi = DiaChi,
KH_ID = item.ID,
KH_Mobile = Mobile,
KH_Ten = Ten,
Readed = false,
Tong = Convert.ToInt32(hh.GNY),
PhiVanChuyen = 0,
NgayTao = DateTime.Now,
Username = Security.Username,
GhiChu = GhiChu,
FacebookUrl = FacebookUrl,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10),
UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien)
};
if (!string.IsNullOrEmpty(NgayGiaoYeuCau))
{
dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayDat))
{
dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn"));
}
else
{
dh.NgayDat = DateTime.Now;
}
if (!string.IsNullOrEmpty(NgayGiao))
{
dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
dh.NguonGoc_ID = new Guid(NguonGoc_ID);
}
dh = DatHangDal.Insert(dh);
var dhct = new DatHangChiTiet
{
DH_ID = dh.ID,
HH_ID = hh.ID,
HH_Gia = Convert.ToInt32(hh.GNY),
HH_SoLuong = 1,
HH_Ten = hh.Ten,
HH_Tong = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
NgayTao = DateTime.Now
};
dhct = DatHangChiTietDal.Insert(dhct);
var ship = new Shipping()
{
ID = Guid.NewGuid()
,
DH_ID = dh.ID
,
DH_Ma = dh.Ma
,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
,
DaGiao = false
,
DiaChi = dh.KH_DiaChi
,
HD_ID = dhct.HH_ID
,
NgayGiao = DateTime.Now
,
NgayTao = DateTime.Now
,
NguoiTao = Security.Username
,
Phi = dh.PhiVanChuyen
,
Readed = false
,
TraTien = false
,
PhaiThu = dh.Tong
};
ship = ShippingDal.Insert(ship);
rendertext(dh.ID.ToString());
}
break;
#endregion
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var act = Request["act"];
var GhiChu = Request["GhiChu"];
var GiaTri = Request["GiaTri"];
var GiaoHang = Request["GiaoHang"];
var ID = Request["ID"];
var KH_DiaChi = Request["KH_DiaChi"];
var KH_ID = Request["KH_ID"];
var DH_ID = Request["DH_ID"];
var KH_Mobile = Request["KH_Mobile"];
var KH_Ten = Request["KH_Ten"];
var Ma = Request["Ma"];
var NguonGoc_ID = Request["NguonGoc_ID"];
var PhiVanChuyen = Request["PhiVanChuyen"];
var Readed = Request["Readed"];
var TT_ID = Request["TT_ID"];
var FacebookUrl = Request["FacebookUrl"];
var UuTien = Request["UuTien"];
var NgayGiao = Request["NgayGiao"];
var NgayGiaoYeuCau = Request["NgayGiaoYeuCau"];
var NgayDat = Request["NgayDat"];
var HH_SoLuong = Request["HH_SoLuong"];
var HH_ID = Request["HH_ID"];
var HH_Gia = Request["HH_Gia"];
var q = Request["q"];
if (string.IsNullOrEmpty(HH_SoLuong)) HH_SoLuong = "1";
GiaoHang = !string.IsNullOrEmpty(GiaoHang) ? "true" : "false";
Readed = !string.IsNullOrEmpty(Readed) ? "true" : "false";
switch (act)
{
case "add":
#region add
if (Security.IsAuthenticated())
{
DatHang item;
if (string.IsNullOrEmpty(ID))
{
item = new DatHang();
item.ID = Guid.NewGuid();
item.NgayTao = DateTime.Now;
}
else
{
item = DatHangDal.SelectById(new Guid(ID));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(TT_ID))
{
item.TT_ID = new Guid(TT_ID);
}
item.GhiChu = GhiChu;
item.FacebookUrl = FacebookUrl;
item.GiaTri = Convert.ToInt32(GiaTri);
item.KH_DiaChi = KH_DiaChi;
if (!string.IsNullOrEmpty(KH_ID))
{
item.KH_ID = new Guid(KH_ID);
}
item.KH_Mobile = KH_Mobile;
item.KH_Ten = KH_Ten;
item.Ma = Ma;
if (!string.IsNullOrEmpty(NgayGiaoYeuCau))
{
item.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayDat))
{
item.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn"));
}
else
{
item.NgayDat = DateTime.Now;
}
if (!string.IsNullOrEmpty(NgayGiao))
{
item.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn"));
}
item.PhiVanChuyen = Convert.ToInt32(PhiVanChuyen);
item.UuTien = Convert.ToInt32(UuTien);
item.Readed = Convert.ToBoolean(Readed);
item.GiaoHang = Convert.ToBoolean(GiaoHang);
item = string.IsNullOrEmpty(ID) ? DatHangDal.Insert(item) : DatHangDal.Update(item);
rendertext(item.ID.ToString());
}
break;
#endregion
case "addHang":
#region addHang
if (Security.IsAuthenticated())
{
var item = new DatHangChiTiet
{
DH_ID = new Guid(DH_ID),
HH_ID = new Guid(HH_ID),
HH_Gia = Convert.ToInt32(HH_Gia),
HH_SoLuong = Convert.ToInt32(HH_SoLuong),
ID = Guid.NewGuid()
};
item.HH_Tong = item.HH_SoLuong * item.HH_Gia;
item.NgayTao = DateTime.Now;
item = DatHangChiTietDal.Insert(item);
HangHoaItem1.Visible = true;
HangHoaItem1.Item = item;
}
break;
#endregion
case "removeHang":
#region removeHang
DatHangChiTietDal.DeleteById(new Guid(ID));
break;
#endregion
case "search":
#region get
var pagerSearch = DatHangDal.pagerNormal(string.Empty, false, null, q, Convert.ToInt32(100));
rendertext(JavaScriptConvert.SerializeObject(pagerSearch.List));
break;
#endregion
case "xoa":
#region add
if (Security.IsAuthenticated())
{
DatHangDal.DeleteById(new Guid(ID));
}
break;
#endregion
default:
break;
}
}
public static DatHang Update(DatHang item)
{
var Item = new DatHang();
var obj = new SqlParameter[32];
obj[0] = new SqlParameter("DH_ID", item.ID);
obj[1] = new SqlParameter("DH_Ma", item.Ma);
obj[2] = new SqlParameter("DH_KH_Ten", item.KH_Ten);
obj[3] = new SqlParameter("DH_KH_Email", item.KH_Email);
obj[4] = new SqlParameter("DH_KH_Mobile", item.KH_Mobile);
obj[5] = new SqlParameter("DH_KH_DiaChi", item.KH_DiaChi);
obj[6] = new SqlParameter("DH_KH_ID", item.KH_ID);
obj[7] = new SqlParameter("DH_KH_Facebook", item.KH_Facebook);
obj[8] = new SqlParameter("DH_Facebook", item.Facebook);
obj[9] = new SqlParameter("DH_GiaTri", item.GiaTri);
obj[10] = new SqlParameter("DH_PhiVanChuyen", item.PhiVanChuyen);
obj[11] = new SqlParameter("DH_Tong", item.Tong);
obj[12] = new SqlParameter("DH_GiaoHang", item.GiaoHang);
if (item.NgayGiao > DateTime.MinValue)
{
obj[13] = new SqlParameter("DH_NgayGiao", item.NgayGiao);
}
else
{
obj[13] = new SqlParameter("DH_NgayGiao", DBNull.Value);
}
if (item.NgayTao > DateTime.MinValue)
{
obj[14] = new SqlParameter("DH_NgayTao", item.NgayTao);
}
else
{
obj[14] = new SqlParameter("DH_NgayTao", DBNull.Value);
}
obj[15] = new SqlParameter("DH_ThanhToan", item.ThanhToan);
obj[16] = new SqlParameter("DH_UPS_Code", item.UPS_Code);
obj[17] = new SqlParameter("DH_PaypalTx", item.PaypalTx);
obj[18] = new SqlParameter("DH_Username", item.Username);
if (item.NgayDat > DateTime.MinValue)
{
obj[19] = new SqlParameter("DH_NgayDat", item.NgayDat);
}
else
{
obj[19] = new SqlParameter("DH_NgayDat", DBNull.Value);
}
obj[20] = new SqlParameter("DH_TT_ID", item.TT_ID);
obj[21] = new SqlParameter("DH_NguonGoc_ID", item.NguonGoc_ID);
obj[22] = new SqlParameter("DH_Readed", item.Readed);
obj[23] = new SqlParameter("DH_FacebookUrl", item.FacebookUrl);
obj[24] = new SqlParameter("DH_GhiChu", item.GhiChu);
obj[25] = new SqlParameter("DH_UuTien", item.UuTien);
if (item.NgayGiaoYeuCau > DateTime.MinValue)
{
obj[26] = new SqlParameter("DH_NgayGiaoYeuCau", item.NgayGiaoYeuCau);
}
else
{
obj[26] = new SqlParameter("DH_NgayGiaoYeuCau", DBNull.Value);
}
obj[27] = new SqlParameter("DH_Map", item.Map);
obj[28] = new SqlParameter("DH_Huy", item.Huy);
obj[29] = new SqlParameter("DH_TraLai", item.TraLai);
obj[30] = new SqlParameter("DH_KhachBuon", item.KhachBuon);
obj[31] = new SqlParameter("DH_TienThuVe", item.TienThuVe);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHang_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public int Insert(DatHang dondathang)
{
cf.DatHangs.Add(dondathang);
cf.SaveChanges();
return(dondathang.ID);
}
protected void Page_Load(object sender, EventArgs e)
{
string act = Request["act"];
string _ID = Request["ID"];
string _SoLuong = Request["SoLuong"];
string _Ten = Request["Ten"];
string _Gia = Request["Gia"];
string _Img = Request["Img"];
string _Email = Request["Email"];
string _Mobile = Request["Mobile"];
string _DiaChi = Request["DiaChi"];
string _GhiChu = Request["GhiChu"];
var gh = new GioHang();
var item = new HangHoa();
var _dele = new SendEmailDele(sendmailThongbao);
var sb = new StringBuilder();
switch (act)
{
case "add":
#region add
item = HangHoaDal.SelectById(new Guid(_ID));
gh.Add(item, _SoLuong);
break;
#endregion
case "save":
#region save
var itemDh = new DatHang
{
ID=Guid.NewGuid(),
GiaoHang = false,
GiaTri = gh.Total,
KH_DiaChi = _DiaChi,
KH_Email = _Email,
KH_Mobile = _Mobile,
KH_Ten = _Ten,
NgayTao = DateTime.Now,
PhiVanChuyen = gh.ShipCost,
Readed = false,
Tong = gh.Total + gh.ShipCost,
NgayGiao = DateTime.Now
};
itemDh = DatHangDal.Insert(itemDh);
var itemDhCt = new DatHangChiTiet();
var sbDh = new System.Text.StringBuilder();
sbDh.AppendFormat(@"Khách hàng: {0}<br/>Email: {1}<br/>Mobile: {2}<br/>Địa chỉ: {3}<br/>Ghi chú: {4}<br/>Ngày đặt hàng: {5}<br/><h3>Chi tiết</h3>"
,_Ten,_Email,_Mobile,_DiaChi, _GhiChu,DateTime.Now);
foreach (GioHangItem ghItem in gh.List.Values)
{
itemDhCt = new DatHangChiTiet();
itemDhCt.ID = Guid.NewGuid();
itemDhCt.DH_ID = itemDh.ID;
itemDhCt.HH_Gia = ghItem.Gia;
itemDhCt.HH_SoLuong = ghItem.SoLuong;
itemDhCt.HH_Ten = ghItem.Ten;
itemDhCt.HH_Tong = ghItem.Gia * ghItem.SoLuong;
itemDhCt.NgayTao = DateTime.Now;
DatHangChiTietDal.Insert(itemDhCt);
sbDh.AppendFormat("Món:{0} - {1}<br/>Số lượng: {2}<br/>Tổng: {3}<hr/>", ghItem.Ten, ghItem.Gia, ghItem.SoLuong, ghItem.Gia * ghItem.SoLuong);
}
sbDh.AppendFormat(@"Tổng:{0}<br/>Phí vận chuyển: {1}<br/>Tổng cộng: {2}"
, gh.Total, gh.ShipCost, gh.Total + gh.ShipCost);
_dele.BeginInvoke("*****@*****.**"
, string.Format("mamvui.com - Đặt hàng mới: {0} {1} [{2}.000đ]", _Ten, DateTime.Now.ToString("hh:mm-dd/MM/yy"),gh.Total + gh.ShipCost)
, sbDh.ToString()
, null, null);
gh.Clear();
break;
#endregion
case "UpSl":
#region UpSl
item = HangHoaDal.SelectById(new Guid(_ID));
gh.UpdateSl(item, _SoLuong);
break;
#endregion
case "del":
#region add
gh.Remove(_ID);
break;
#endregion
case "clear":
#region add
gh.Clear();
break;
#endregion
case "get":
#region get
break;
#endregion
default:
break;
}
//sb.Append(format_gioHang(gh));
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(gh));
rendertext(sb, "text/plain");
}
