protected void Page_Load(object sender, EventArgs e)
{
BUS.SanPham sanPham = new BUS.SanPham();
maSanPham = 1;//Request.QueryString("maSanPham");
sanPham = BUS.SanPham.LaySanPhamTheoMa(maSanPham);
imgSanPham.ImageUrl = sanPham.HinhAnh;
hpTenSanPham.Text = sanPham.TenSanPham;
hpTenSanPham.NavigateUrl = "../ChiTietSanPham.aspx?maSanPham="+sanPham.MaSanPham.ToString();
lbGiaSanPham.Text = String.Format("{0:N0}",sanPham.DonGia);
lbDiemThuong.Text = sanPham.DiemThuong.ToString();
lbSoLuongSPDaBan.Text = (sanPham.SoLuongSP - sanPham.SoLuongTon).ToString();
lbSoLuongTon.Text = sanPham.SoLuongTon.ToString();
}
protected void btnDangSanPham_Click(object sender, EventArgs e)
{
BUS.SanPham sanPham = new BUS.SanPham();
sanPham.TenSanPham = txtTenSanPham.Text.Trim();
sanPham.MaDanhMuc = int.Parse(dropLoaiSanPham.SelectedItem.Value);
sanPham.DonGia = float.Parse(txtDonGia.Text);
sanPham.DiemThuong = int.Parse(txtDiemThuong.Text);
sanPham.SoLuongSP = sanPham.SoLuongTon = int.Parse(txtSoLuong.Text);
sanPham.MaNguoiNhap = (Int32)Session["Id"];
sanPham.ThoiGianBD_Ban = DateTime.Parse(dtpThoiGianBDBan.Value);
sanPham.ThoiGianKT_Ban = DateTime.Parse(dtpThoiGianKTBan.Value);
sanPham.ThoiGianBD_NhanHang = DateTime.Parse(dtpThoiGianBDNhan.Value);
sanPham.ThoiGianKT_NhanHang = DateTime.Parse(dtpThoiGianKTNhan.Value);
if (fileUpload.PostedFile != null)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Server.MapPath("Path_Product.xml"));
XmlElement xmlPath = (XmlElement)xmlDoc.SelectSingleNode("/PATH");
string savePath = MapPath(xmlPath.InnerText.Trim() + fileUpload.PostedFile.FileName);
fileUpload.PostedFile.SaveAs(savePath);
sanPham.HinhAnh = xmlPath.InnerText.Trim() + fileUpload.PostedFile.FileName;
}
else
{
sanPham.HinhAnh = "~/image-product/product_icon.jpg";
}
sanPham.ThongTinChiTiet = txtThongTinSP.Text;
int MaSanPham = SanPham.ThemSanPham(sanPham);
if (MaSanPham != -1)
{
foreach (TangPham tp in lstTangPham)
{
tp.MaSanPham = MaSanPham;
TangPham.ThemTangPham(tp);
}
pnlDangSanPham.Visible = false;
pnlThongBao.Visible = true;
lblThongBao.Text = "Thêm sản phẩm thành công.";
hpRedirect.Text = "Click vào đây để tiếp tục thêm sản phẩm.";
hpRedirect.NavigateUrl = "DangSanPham.aspx";
}
else
{
pnlDangSanPham.Visible = true;
pnlThongBao.Visible = true;
lblThongBao.Text = "Thêm sản phẩm bị lỗi.";
}
}
public static void XoaSP(SanPham obj)
{
db.XoaSP(obj);
}
public bool themSanPham(SanPham sanPham)
{
return(dal_SanPham.themSanPham(sanPham));
}
public void AddProduct_Bus(SanPham sp, DataTable dt)
{
new SanPham_DAO().AddProduct(sp, dt);
}
public void AddSPBUS(SanPham sp)
{
spDAO.AddSPDAO(sp);
}
public bool Them(SanPham sp)
{
return(SanPhamDAC.Instance.Them(sp));
}
public int Update(SanPham sp)
{
return(SPDAO.Update(sp));
}
public int Insert(SanPham obj)
{
return(dal.Insert(obj));
}
protected void Page_Load(object sender, EventArgs e)
{
// kiểm tra đã đăng nhập chưa
int iDaDangNhap = (Int32)Session["IsLogin"];
if (iDaDangNhap == 0)
{
pnlThongBao.Visible = true;
panelDatHang.Visible = false;
pnlKetQuaDatHang.Visible = false;
return;
//Response.Redirect("../Index.aspx");
}
pnlThongBao.Visible = false;
pnlKetQuaDatHang.Visible = false;
int maSanPham = 0;
if (int.TryParse((Request.QueryString["maSanPham"]),out maSanPham))
{
// sản phẩm
g_SanPham = BUS.SanPham.LaySanPhamTheoMa(maSanPham);
lblTenSanPham.Text = g_SanPham.TenSanPham;
if (!Page.IsPostBack)
{
txtSoLuongMuaSP.Text = "1";
lblThanhTien.Text = String.Format("{0:N0}", g_SanPham.DonGia);
lblTongDiemThuong.Text = g_SanPham.DiemThuong.ToString();
lblDiemThuongConLai.Text = g_SanPham.DiemThuong.ToString();
// danh sách đại lý
// bổ sung spLayDSDaiLy
List<DaiLy> lstDaiLy = DaiLy.LayDSDaiLy();
dropListDaiLy.DataTextField = "TenDaiLy";
dropListDaiLy.DataValueField = "MaDaiLy";
dropListDaiLy.DataSource = lstDaiLy;
dropListDaiLy.DataBind();
// danh sách tặng phẩm
List<TangPham> lstTangPham = TangPham.LayDSTangPhamTheoMaSP(maSanPham);
dlDanhSachTangPham.DataSource = lstTangPham;
dlDanhSachTangPham.DataBind();
}
}
else
{
Response.Redirect("Index.aspx");
}
}
public int Add(SanPham p)
{
return(SPDAO.Add(p));
}
public static bool CapNhatSanPham(SanPham sanPham)
{
return(DAO.SanPhamDAO.CapNhatSanPham(sanPham));
}
public static bool ThemSanPham(SanPham sanPham)
{
return(DAO.SanPhamDAO.ThemSanPham(sanPham));
}
public bool CapNhatSanPham(SanPham ncc)
{
return(da.CapNhatSanPham(ncc));
}
public bool ThemSanPham(SanPham ncc)
{
return(da.ThemSanPham(ncc));
}
public int Update(SanPham obj)
{
return(dal.Update(obj));
}
public DataTable SanPham_Delete(SanPham sanpham)
{
return(sanpham_dal.SanPham_Delete(sanpham));
}
/// <summary>
/// Lấy danh sách sản phẩm
/// Minh Đức : 28/5/2011
/// </summary>
/// <param name="spName">tên rpocedure</param>
/// <returns></returns>
public static List<SanPham> LayDsSanPham(string spName)
{
List<SanPham> lstSanPham = new List<SanPham>();
try
{
DataTable dt = new DataTable();
dt = SqlDataAccessHelper.ExecuteQuery(spName);
foreach (DataRow dr in dt.Rows)
{
SanPham sp = new SanPham();
sp.MaSanPham = int.Parse(dr["MaSanPham"].ToString());
sp.HinhAnh = dr["HinhAnh"].ToString();
sp.DiemThuong = int.Parse(dr["DiemThuong"].ToString());
sp.DonGia = float.Parse(dr["DonGia"].ToString());
sp.MaDanhMuc = int.Parse(dr["MaDanhMuc"].ToString());
sp.MaNguoiNhap = int.Parse(dr["MaNguoiNhap"].ToString());
sp.SoLuongSP = int.Parse(dr["SoLuongSP"].ToString());
sp.SoLuongTon = int.Parse(dr["SoLuongTon"].ToString());
sp.TenSanPham = dr["TenSanPham"].ToString();
sp.ThoiGianBD_Ban = DateTime.Parse(dr["ThoiGianBD_Ban"].ToString());
sp.ThoiGianKT_Ban = DateTime.Parse(dr["ThoiGianKT_Ban"].ToString());
sp.ThongTinChiTiet = dr["ThongTinChiTiet"].ToString();
DateTime result;
if (DateTime.TryParse(dr["ThoiGianBD_NhanHang"].ToString(), out result))
sp.ThoiGianBD_NhanHang = DateTime.Parse(dr["ThoiGianBD_NhanHang"].ToString());
else
sp.ThoiGianBD_NhanHang = DateTime.Parse("1/1/1900");
if (DateTime.TryParse(dr["ThoiGianKT_NhanHang"].ToString(), out result))
sp.ThoiGianKT_NhanHang = DateTime.Parse(dr["ThoiGianKT_NhanHang"].ToString());
else
sp.ThoiGianKT_NhanHang = DateTime.Parse("1/1/1900");
lstSanPham.Add(sp);
}
}
catch (Exception e)
{
}
return lstSanPham;
}
public bool Sua(SanPham sp)
{
return(SanPhamDAC.Instance.Sua(sp));
}
/// <summary>
/// Lấy sản phẩm theo mã
/// Minh Đức - 28/5/2011
/// </summary>
/// <param name="masanpham"></param>
/// <returns></returns>
public static SanPham LaySanPhamTheoMa(int masanpham)
{
SanPham sp = new SanPham();
try
{
List<SqlParameter> lstParam = new List<SqlParameter>();
lstParam.Add(new SqlParameter("@masanpham", masanpham));
DataTable dt = SqlDataAccessHelper.ExecuteQuery("spLaySanPhamTheoMa", lstParam);
DataRow dr = dt.Rows[0];
sp.MaSanPham = int.Parse(dr["MaSanPham"].ToString());
sp.HinhAnh = dr["HinhAnh"].ToString();
sp.DiemThuong = int.Parse(dr["DiemThuong"].ToString());
sp.DonGia = float.Parse(dr["DonGia"].ToString());
sp.MaDanhMuc = int.Parse(dr["MaDanhMuc"].ToString());
sp.MaNguoiNhap = int.Parse(dr["MaNguoiNhap"].ToString());
sp.SoLuongSP = int.Parse(dr["SoLuongSP"].ToString());
sp.SoLuongTon = int.Parse(dr["SoLuongTon"].ToString());
sp.TenSanPham = dr["TenSanPham"].ToString();
sp.ThoiGianBD_Ban = DateTime.Parse(dr["ThoiGianBD_Ban"].ToString());
sp.ThoiGianKT_Ban = DateTime.Parse(dr["ThoiGianKT_Ban"].ToString());
sp.ThongTinChiTiet = dr["ThongTinChiTiet"].ToString();
DateTime result;
if (DateTime.TryParse(dr["ThoiGianBD_NhanHang"].ToString(), out result))
sp.ThoiGianBD_NhanHang = DateTime.Parse(dr["ThoiGianBD_NhanHang"].ToString());
else
sp.ThoiGianBD_NhanHang = DateTime.Parse("1/1/1900");
if (DateTime.TryParse(dr["ThoiGianKT_NhanHang"].ToString(), out result))
sp.ThoiGianKT_NhanHang = DateTime.Parse(dr["ThoiGianKT_NhanHang"].ToString());
else
sp.ThoiGianKT_NhanHang = DateTime.Parse("1/1/1900");
}
catch (Exception e)
{
throw e;
}
return sp;
}
public bool Xoa(SanPham sp)
{
return(SanPhamDAC.Instance.Xoa(sp));
}
/// <summary>
/// Thêm sản phẩm
/// Minh Đức - 28/5/2011
/// </summary>
/// <param name="sp"></param>
/// <returns></returns>
public static int ThemSanPham(SanPham sp)
{
int res = 0;
try
{
int maSanPham = 0;
List<SqlParameter> lstParam = new List<SqlParameter>();
lstParam.Add(new SqlParameter("@tensanpham", sp.TenSanPham));
lstParam.Add(new SqlParameter("@soluongsp", sp.SoLuongSP));
lstParam.Add(new SqlParameter("@soluongton", sp.SoLuongTon));
lstParam.Add(new SqlParameter("@dongia", sp.DonGia));
lstParam.Add(new SqlParameter("@diemthuong", sp.DiemThuong));
lstParam.Add(new SqlParameter("@thoigianbd_ban", sp.ThoiGianBD_Ban));
lstParam.Add(new SqlParameter("@thoigiankt_ban", sp.ThoiGianKT_Ban));
lstParam.Add(new SqlParameter("@thoigianbd_nhanhang", sp.ThoiGianBD_NhanHang));
lstParam.Add(new SqlParameter("@thoigiankt_nhanhang", sp.ThoiGianKT_NhanHang));
lstParam.Add(new SqlParameter("@manguoinhap", sp.MaNguoiNhap));
lstParam.Add(new SqlParameter("@madanhmuc", sp.MaDanhMuc));
lstParam.Add(new SqlParameter("@hinhanh", sp.HinhAnh));
lstParam.Add(new SqlParameter("@thongtinchitiet", sp.ThongTinChiTiet));
SqlParameter param = new SqlParameter("@masanpham", maSanPham);
param.Direction = ParameterDirection.Output;
lstParam.Add(param);
if (SqlDataAccessHelper.ExecuteNoneQuery("spThemSanPham", lstParam) > 0)
{
res = int.Parse(param.Value.ToString());
}
}
catch (Exception e)
{
res = 0;
throw e;
}
return res;
}
public void UpdateSPBUS(SanPham spToUpdate)
{
spDAO.UpdateSPDAO(spToUpdate);
}
public int addProduct(SanPham sp)
{
QuanLySanPhamDAO dao = new QuanLySanPhamDAO();
return(dao.addProduct(sp));
}
public void Edit_Bus(SanPham sp, DataTable dt, int index)
{
product.Edit(sp, dt, index);
}
public int updateProduct(SanPham sp)
{
QuanLySanPhamDAO dao = new QuanLySanPhamDAO();
return(dao.updateProduct(sp));
}
public bool capNhatSanPham(SanPham sanPham)
{
return(dal_SanPham.capNhatSanPham(sanPham));
}
public DataTable SanPham_Insert(SanPham sanpham)
{
return(sanpham_dal.SanPham_Insert(sanpham));
}
public static void ThemSP(SanPham obj)
{
db.ThemSP(obj);
}
public DataTable listSanPham_MaSp(SanPham sanpham)
{
return(sanpham_dal.listSanPham_MaSp(sanpham));
}
public static void ChinhSuaSP(SanPham obj)
{
db.ChinhSuaSP(obj);
}
public SanPham GetSanPhamByID(int id)
{
SanPham sp = db.SanPhams.Where(c => c.MaSP == id).FirstOrDefault();
return(sp);
}
