public static DatHangChiTiet Insert(DatHangChiTiet item)
{
var Item = new DatHangChiTiet();
var obj = new SqlParameter[8];
obj[0] = new SqlParameter("DHCT_ID", item.ID);
obj[1] = new SqlParameter("DHCT_DH_ID", item.DH_ID);
obj[2] = new SqlParameter("DHCT_HH_ID", item.HH_ID);
obj[3] = new SqlParameter("DHCT_HH_Ten", item.HH_Ten);
obj[4] = new SqlParameter("DHCT_HH_SoLuong", item.HH_SoLuong);
obj[5] = new SqlParameter("DHCT_HH_Gia", item.HH_Gia);
obj[6] = new SqlParameter("DHCT_HH_Tong", item.HH_Tong);
if (item.NgayTao > DateTime.MinValue)
{
obj[7] = new SqlParameter("DHCT_NgayTao", item.NgayTao);
}
else
{
obj[7] = new SqlParameter("DHCT_NgayTao", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHangChiTiet_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static DatHangChiTiet SelectById(Guid DHCT_ID)
{
var Item = new DatHangChiTiet();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("DHCT_ID", DHCT_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHangChiTiet_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static DatHangChiTiet getFromReader(IDataReader rd)
{
var Item = new DatHangChiTiet();
if (rd.FieldExists("DHCT_ID"))
{
Item.ID = (Guid)(rd["DHCT_ID"]);
}
if (rd.FieldExists("DHCT_DH_ID"))
{
Item.DH_ID = (Guid)(rd["DHCT_DH_ID"]);
}
if (rd.FieldExists("DHCT_HH_ID"))
{
Item.HH_ID = (Guid)(rd["DHCT_HH_ID"]);
}
if (rd.FieldExists("DHCT_HH_Ten"))
{
Item.HH_Ten = (String)(rd["DHCT_HH_Ten"]);
}
if (rd.FieldExists("DHCT_HH_SoLuong"))
{
Item.HH_SoLuong = (Int32)(rd["DHCT_HH_SoLuong"]);
}
if (rd.FieldExists("DHCT_HH_Gia"))
{
Item.HH_Gia = (Int32)(rd["DHCT_HH_Gia"]);
}
if (rd.FieldExists("DHCT_HH_Tong"))
{
Item.HH_Tong = (Int32)(rd["DHCT_HH_Tong"]);
}
if (rd.FieldExists("DHCT_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["DHCT_NgayTao"]);
}
Item._HangHoa = HangHoaDal.getFromReader(rd);
return(Item);
}
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");
}
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;
}
}
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");
}
