private void btnsua_Click(object sender, EventArgs e)
{
if (vitri >= 0)
{
if (txttenSanPham.Text != "" && txtgiaHienTai.Text.ToString() != "")
{
//lay row hien tia
//lay ma o dong hien tai
string spid = dgvsanPham.Rows[vitri].Cells[0].Value.ToString();
//tao dto
DTO_Sanpham sp = new DTO_Sanpham(spid, txttenSanPham.Text, Convert.ToSingle(txtgiaHienTai.Text));
// sua
if (BusSP.suaSanPham(sp))
{
MessageBox.Show(" Sửa thành công.");
dgvsanPham.DataSource = BusSP.getSanPham();
}
else
{
MessageBox.Show("Sửa không thành công");
}
}
else
{
MessageBox.Show("Hãy nhập đủ thông tin");
}
}
else
{
MessageBox.Show("Chọn sản phẩm muốn sửa");
}
}
protected void grv_sp_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Chonsp")
{
string tensp = e.CommandArgument.ToString();
DTO_Sanpham sp = BUS_Sanpham.LayThongTinsp(tensp);
if (sp != null)
{
txb_masp.Text = sp.Masp;
txb_tensp.Text = sp.Tensp;
txb_giatien.Text = sp.Giatien;
txb_sltonkho.Text = sp.Soluongtonkho;
txb_thongtin.Text = sp.Thongtin;
txb_maloaisp.Text = sp.Maloaisp;
}
}
if (e.CommandName == "Xoasp")
{
string tensp = e.CommandArgument.ToString();
if (BUS_Sanpham.XoaSP(tensp))
{
//XoaForm();
LoadDSSP();
}
else
{
Response.Write("<script>alert('Xóa tài khoản thất bại');</script>");
}
}
}
protected void btn_themsp_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txb_masp.Text) || string.IsNullOrWhiteSpace(txb_tensp.Text) ||
string.IsNullOrWhiteSpace(txb_thongtin.Text) || string.IsNullOrWhiteSpace(txb_sltonkho.Text) ||
string.IsNullOrWhiteSpace(txb_giatien.Text) || string.IsNullOrWhiteSpace(txb_maloaisp.Text))
{
Response.Write("<script>alert('Phải điền dầy đủ thông tin');</script>");
}
else
{
DTO_Sanpham sp = new DTO_Sanpham();
sp.Masp = txb_masp.Text;
sp.Tensp = txb_tensp.Text;
sp.Thongtin = txb_thongtin.Text;
sp.Giatien = txb_giatien.Text;
sp.Soluongtonkho = txb_sltonkho.Text;
sp.Maloaisp = txb_maloaisp.Text;
if (BUS_Sanpham.Themsp(sp))
{
Response.Write("<script>alert('them moi san pham thanh cong');</script>");
}
else
{
Response.Write("<script>alert('them moi that bai');</script>");
}
}
}
public static bool update_soluong(DTO_Sanpham tensp)
{
string query = "update SanPham set SoLuongTonKho += 1 where TenSP = @tensp;";
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@tensp", tensp);
return(DataProvider.ExecuteUpdateQuery(query, param) == 1);
}
public static bool Suasp(DTO_Sanpham sp)
{
if (!DAO_Sanpham.KTspTonTai(sp.Tensp))
{
return(false);
}
else
{
return(DAO_Sanpham.Suasp(sp));
}
}
protected void Page_Load(object sender, EventArgs e)
{
var keyword = Request.QueryString["keyword"];
if (!Page.IsPostBack)
{
DTO_Sanpham sp = new DTO_Sanpham();
dtl_sanpham.DataSource = BUS_Sanpham.timkiemSP(keyword);
dtl_sanpham.DataBind();
}
}
public static DTO_Sanpham ConvertToDTO(DataRow dr)
{
DTO_Sanpham sp = new DTO_Sanpham();
sp.Masp = dr["MaSP"].ToString();
sp.Tensp = dr["TenSP"].ToString();
sp.Thongtin = dr["ThongTin"].ToString();
sp.Giatien = dr["GiaTien"].ToString();
sp.Soluongtonkho = dr["SoLuongTonKho"].ToString();
sp.Maloaisp = dr["MaLoaiSP"].ToString();
sp.Anhminhhoa = dr["AnhMinhHoa"].ToString();
sp.TrangThai = Convert.ToBoolean(dr["TrangThai"]);
return(sp);
}
public static bool Themsp(DTO_Sanpham sp)
{
string query = "INSERT INTO SanPham (MaSP, TenSP, GiaTien, ThongTin, SoLuongTonKho, MaLoaiSP, AnhMinhHoa, TrangThai) VALUES (@masp, @tensp, @giatien,@thongtin,@soluongton,@maloaisp,0,1)";
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@masp", sp.Masp);
param[1] = new SqlParameter("@tensp", sp.Tensp);
param[2] = new SqlParameter("@giatien", sp.Giatien);
param[3] = new SqlParameter("@thongtin", sp.Thongtin);
param[4] = new SqlParameter("@soluongton", sp.Soluongtonkho);
param[5] = new SqlParameter("@maloaisp", sp.Maloaisp);
return(DataProvider.ExecuteInsertQuery(query, param) == 1);
}
public static bool Suasp(DTO_Sanpham sp)
{
string query = "UPDATE SanPham SET MaSP = @Masp, TenSP = @Tensp, GiaTien = @Giatien,ThongTin=@ThongTin, SoLuongTonKho = @SoLuongTonKho, MaLoaiSP = @MaLoaisp, AnhMinhHoa = @AnhMinhHoa, TrangThai = @TrangThai ";
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@MaSP", sp.Masp);
param[1] = new SqlParameter("@TenSP", sp.Tensp);
param[2] = new SqlParameter("@GiaTien", sp.Giatien);
param[3] = new SqlParameter("@ThongTin", sp.Thongtin);
param[4] = new SqlParameter("@SoLuongTonKho", sp.Soluongtonkho);
param[5] = new SqlParameter("@MaLoaiSP", sp.Maloaisp);
param[6] = new SqlParameter("@AnhMinhHoa", sp.Anhminhhoa);
param[7] = new SqlParameter("@TrangThai", sp.TrangThai);
return(DataProvider.ExecuteUpdateQuery(query, param) == 1);
}
protected void btnSua_Click(object sender, EventArgs e)
{
DTO_Sanpham sp = BUS_Sanpham.LayThongTinsp(txt_tensp.Text);
sp.Tensp = txt_tensp.Text;
sp.Thongtin = txt_thongtinsp.Text;
sp.Maloaisp = txt_maloaisp.Text;
sp.Giatien = txt_giatien.Text;
sp.TrangThai = chkTrangThai.Checked;
if (BUS_Sanpham.Suasp(sp))
{
XoaForm();
loadsp();
GiaoDienThem(true);
}
else
{
Response.Write("<script>alert('Sửa san pham thất bại');</script>");
}
}
private void btnthem_Click(object sender, EventArgs e)
{
if (txttenSanPham.Text != "" && txtgiaHienTai.Text.ToString() != "")
{
//tao dto
DTO_Sanpham sp = new DTO_Sanpham(TuSinhMa(), txttenSanPham.Text, Convert.ToSingle(txtgiaHienTai.Text));
//them
if (BusSP.themSanPham(sp))
{
MessageBox.Show("Thêm sản phẩm thành công!!!");
dgvsanPham.DataSource = BusSP.getSanPham();
}
else
{
MessageBox.Show("Thêm không thành công!!!");
}
}
else
{
MessageBox.Show(" Vui lòng nhập đủ thông tin.");
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
DTO_Sanpham sp = new DTO_Sanpham();
sp.Masp = txt_masp.Text;
sp.Tensp = txt_tensp.Text;
sp.Thongtin = txt_thongtinsp.Text;
sp.Giatien = txt_giatien.Text;
sp.Soluongtonkho = txt_slton.Text;
sp.Maloaisp = txt_maloaisp.Text;
sp.TrangThai = chkTrangThai.Checked;
if (BUS_Sanpham.Themsp(sp))
{
XoaForm();
loadsp();
GiaoDienThem(true);
}
else
{
Response.Write("<script>alert('Thêm sản phẩm thất bại');</script>");
}
}
public List <DTO_Sanpham> GetData(string sql)
{
Connect();
List <DTO_Sanpham> list = new List <DTO_Sanpham>();
try
{
SqlDataReader dr = ExecuteReader(sql);
string masp;
string tensp;
double dongia;
while (dr.Read())
{
masp = dr.GetString(0);
tensp = dr.GetString(1);
dongia = dr.GetDouble(2);
DTO_Sanpham emp = new DTO_Sanpham(masp, tensp, dongia);
list.Add(emp);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
Disconnect();
}
}
//sua san pham
public bool suaSanPham(DTO_Sanpham sp)
{
try
{
_conn.Open();
string queryupdate = "update SANPHAM set tenSanPham=N'" + sp.tenSanPham + "',giaHienTai='" + sp.giaHienTai + "' where SPID ='" + sp.SPID + "' ";
SqlCommand cmd = new SqlCommand(queryupdate, _conn);
//query va kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception exx)
{
}
finally
{
//dong ket noi
_conn.Close();
}
return(false);
}
//them san pham
public bool themSanPham(DTO_Sanpham sp)
{
try
{
_conn.Open();
string queryinsert = string.Format("insert into SANPHAM(SPID,tenSanPham,giaHienTai) values ('{0}',N'{1}','{2}')", sp.SPID, sp.tenSanPham, sp.giaHienTai);
SqlCommand cmd = new SqlCommand(queryinsert, _conn);
//query va kiem tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception exx)
{
}
finally
{
//dong ket noi
_conn.Close();
}
return(false);
}
protected void grv_sp_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Chonsp")
{
string tensp = e.CommandArgument.ToString();
DTO_Sanpham sp = BUS_Sanpham.LayThongTinsp(tensp);
if (sp != null)
{
txt_masp.Text = sp.Masp;
txt_tensp.Text = sp.Tensp;
txt_giatien.Text = sp.Giatien;
txt_slton.Text = sp.Soluongtonkho;
txt_thongtinsp.Text = sp.Thongtin;
txt_maloaisp.Text = sp.Maloaisp;
img_anhminhhoa.Text = sp.Anhminhhoa;
chkTrangThai.Checked = sp.TrangThai;
GiaoDienThem(false);
}
}
if (e.CommandName == "Xoasp")
{
string tensp = e.CommandArgument.ToString();
if (BUS_Sanpham.XoaSP(tensp))
{
XoaForm();
loadsp();
}
else
{
Response.Write("<script>alert('Xóa tài sản phẩm thất bại');</script>");
}
}
}
public bool suaSanPham(DTO_Sanpham sp)
{
return(daosanpham.suaSanPham(sp));
}
public bool themSanPham(DTO_Sanpham sp)
{
return(daosanpham.themSanPham(sp));
}
