public bool ThemDonHang(DonHang donHang)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.InsertCommand = "DonHang_Insert";
sqldata.InsertParameters.Add("NgayMua", donHang.ngayMua.ToString());
sqldata.InsertParameters.Add("HoTen", donHang.HoTen.ToString());
sqldata.InsertParameters.Add("SDT", donHang.SDT.ToString());
sqldata.InsertParameters.Add("Email", donHang.Email.ToString());
sqldata.InsertParameters.Add("DiaChi", donHang.diaChi.ToString());
sqldata.InsertParameters.Add("Note", donHang.Note.ToString());
try
{
sqldata.Insert();
return(true);
}
catch
{
return(false);
}
}
public bool ThemSP(sanpham sp)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.InsertCommand = "SanPham_Insert";
sqldata.InsertParameters.Add("TenSanPham", sp.TenSP.ToString());
sqldata.InsertParameters.Add("MoTa", sp.MoTa.ToString());
sqldata.InsertParameters.Add("HinhAnh", sp.HinhAnh.ToString());
sqldata.InsertParameters.Add("Gia", sp.GiaBan.ToString());
sqldata.InsertParameters.Add("SLCon", sp.SLCon.ToString());
sqldata.InsertParameters.Add("MaDanhMuc", sp.MaDanhMuc.ToString());
sqldata.InsertParameters.Add("NgayBan", sp.ngayBan.ToString());
try
{
sqldata.Insert();
return(true);
}
catch
{
return(false);
}
}
public bool SuaSP(sanpham sanpham)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.UpdateCommand = "SanPham_Update";
sqldata.UpdateParameters.Add("MaSP", sanpham.MaSP.ToString());
sqldata.UpdateParameters.Add("MaDanhMuc", sanpham.MaDanhMuc.ToString());
sqldata.UpdateParameters.Add("MoTa", sanpham.MoTa.ToString());
sqldata.UpdateParameters.Add("HinhAnh", sanpham.HinhAnh.ToString());
sqldata.UpdateParameters.Add("Gia", sanpham.GiaBan.ToString());
sqldata.UpdateParameters.Add("SLCon", sanpham.SLCon.ToString());
sqldata.UpdateParameters.Add("TenSanPham", sanpham.TenSP.ToString());
try
{
sqldata.Update();
return(true);
}
catch
{
return(false);
}
}
public void LoadDuLieu()
{
KetNoiCSDL ketNoi = new KetNoiCSDL();
DataTable dt = ketNoi.ThucThiLenhTraVeBang("Select MaSanPham,TenSanPham,HinhAnh,SUBSTRING(MoTa, 0, 56)+'...' as MoTa,Gia, SLCon,SLBan,NgayBan from SanPham where MaDanhMuc=" + Request.QueryString["id"].ToString());
dataSanPham.DataSource = dt;
dataSanPham.DataBind();
}
protected void btnTim_Click(object sender, EventArgs e)
{
string sql = "Select MaSanPham,TenSanPham,HinhAnh,SUBSTRING(MoTa, 0, 56)+'...' as MoTa,Gia, SLCon,SLBan,NgayBan from SanPham where TenSanPham like '%" + txtTuKhoa.Text + "%'";
KetNoiCSDL ketNoi = new KetNoiCSDL();
DataTable dt = ketNoi.ThucThiLenhTraVeBang(sql);
dataSanPham.DataSource = dt;
dataSanPham.DataBind();
}
public SqlDataSource Laydulieu(string procedue)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.SelectCommand = procedue;
return(sqldata);
}
public SqlDataSource LaydulieubyID(string GiaTriParaMetter, string TenThuTuc, string TenParametter)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.SelectCommand = TenThuTuc;
sqldata.SelectParameters.Add(TenParametter, GiaTriParaMetter);
return(sqldata);
}
public void LoadDuLieu()
{
KetNoiCSDL ketNoi = new KetNoiCSDL();
DataTable dt = ketNoi.ThucThiLenhTraVeBang("Select * from SanPham where MaSanPham=" + Request.QueryString["id"].ToString());
lblTenSP.Text = dt.Rows[0][1].ToString();
lblMoTa.Text = dt.Rows[0][2].ToString();
img.ImageUrl = "~/images/" + dt.Rows[0][3].ToString();
lblGia.Text += " " + dt.Rows[0][4].ToString() + "đ";
lblSoLuongCon.Text = dt.Rows[0][5].ToString();
lblSoLuongDaBan.Text = dt.Rows[0][6].ToString();
lblNgayBan.Text = dt.Rows[0][8].ToString();
HyperLink1.NavigateUrl = "~/GioHang.aspx?ProID=" + Request.QueryString["id"].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
String hoTen = txtHoTen.Text;
String SDT = txtSDT.Text;
String email = txtEmail.Text;
String diaChi = txtDiaChi.Text;
String note = txtNote.Text;
DonHang donHang = new DonHang
{
ngayMua = DateTime.Now,
HoTen = hoTen,
SDT = SDT,
Email = email,
diaChi = diaChi,
Note = note
};
DonHangDAO DAO = new DonHangDAO();
if (!DAO.ThemDonHang(donHang))
{
Response.Write("Lỗi khi khởi tạo đơn hàng!!!!");
}
else
{
String sql = "SELECT IDENT_CURRENT('DonHang') as LastID";
KetNoiCSDL ketNoi = new KetNoiCSDL();
DataTable dt = ketNoi.ThucThiLenhTraVeBang(sql);
string maDH = dt.Rows[0][0].ToString();
if (tbGioHang.Rows.Count > 0)
{
foreach (DataRow r in tbGioHang.Rows)
{
string idSP = r["idSP"].ToString();
string SoLuong = r["SoLuong"].ToString();
DAO.ThemHang(maDH, idSP, SoLuong);
}
Session["GioHang"] = null;
Response.Write("Đặt hàng thành công!!!!");
}
}
}
}
public bool XoaDH(string id)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.DeleteCommand = "DonHang_Delete";
sqldata.DeleteParameters.Add("MaDH", id);
try
{
sqldata.Delete();
return(true);
}
catch
{
return(false);
}
}
public bool SuaDanhMuc(DanhMuc danhMuc)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.UpdateCommand = "DanhMuc_Update";
sqldata.UpdateParameters.Add("MaDanhMuc", danhMuc.Iddanhmuc.ToString());
sqldata.UpdateParameters.Add("TenDanhMuc", danhMuc.Tendanhmuc.ToString());
try
{
sqldata.Update();
return(true);
}
catch
{
return(false);
}
}
private void load_data()
{
if (Request.QueryString["ProID"] != null)
{
int idSP = int.Parse(Request.QueryString["ProID"]);
KetNoiCSDL ketNoiCSDL = new KetNoiCSDL();
DataTable dt = ketNoiCSDL.ThucThiLenhTraVeBang("select TenSanPham,Gia From SanPham WHERE MaSanPham =" + idSP);
String TenSP = dt.Rows[0][0].ToString();
int Dongia = int.Parse(dt.Rows[0][1].ToString());
int Soluong = 1;
ThemVaoGioHang(idSP, TenSP, Dongia, Soluong);
}
if (Session["GioHang"] == null)
{
Response.Redirect("GioHangRong.aspx");
}
tbGioHang = (DataTable)Session["GioHang"];
var result = tbGioHang.AsEnumerable().Sum(x => Convert.ToInt32(x["ThanhTien"]));
lblTongTien.Text = "Thành tiền: " + result.ToString() + "đ";
gvGioHang.DataSource = tbGioHang;
gvGioHang.DataBind();
}
public bool ThemHang(string maDH, string maSP, string sl)
{
SqlDataSource sqldata = new SqlDataSource();
KetNoiCSDL chuoiketnoi = new KetNoiCSDL();
sqldata.ConnectionString = chuoiketnoi.GetSetChuoiKetNoi;
sqldata.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
sqldata.InsertCommand = "ChiTietDonHang_Insert";
sqldata.InsertParameters.Add("MaDH", maDH);
sqldata.InsertParameters.Add("MaSP", maSP);
sqldata.InsertParameters.Add("SL", sl);
try
{
sqldata.Insert();
string sql = "update SanPham set SLCon=SLCon-" + sl + ", SLBan=SLBan+" + sl + " where MaSanPham=" + maSP;
chuoiketnoi.Xoa(sql);
return(true);
}
catch
{
return(false);
}
}