public DTOKhoSP(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Soluong = (int)dongDL["Soluong"];
dtosp = new DTOSanPham(dongDL);
//DiaChi = dongDL["DiaChi"].ToString();
}
public DTOKhoSP(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Soluong = (int)dongDL["Soluong"];
dtosp = new DTOSanPham(dongDL);
//DiaChi = dongDL["DiaChi"].ToString();
}
public DTOChiTietDonHang(DataRow dongDL)
{
//MaDH = (int)dongDL["MaDH"];
// MaSP = (int)dongDL["MaSP"];
// TenSP = dongDL["TenSP"].ToString();
// Gia = (int)dongDL["Gia"];
dtoDH = new DTODonDatHang(dongDL);
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
public DTOXLSC_HDBH(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaDH = dongDL["MaDH"].ToString();
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Gia = (int)dongDL["Gia"];
dtosp = new DTOSanPham(dongDL);
dtoDH = new DTODonDatHang(dongDL);
Soluong = (int)dongDL["Soluong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
public DTOXLSC_HDBH(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaDH = dongDL["MaDH"].ToString();
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Gia = (int)dongDL["Gia"];
dtosp = new DTOSanPham(dongDL);
dtoDH = new DTODonDatHang(dongDL);
Soluong = (int)dongDL["Soluong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
public DTOChiTietDonHang(DataRow dongDL)
{
//MaDH = (int)dongDL["MaDH"];
// MaSP = (int)dongDL["MaSP"];
// TenSP = dongDL["TenSP"].ToString();
// Gia = (int)dongDL["Gia"];
dtoDH = new DTODonDatHang(dongDL);
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
public DTOXuLyPhieuGiao(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaDH = dongDL["MaDH"].ToString();
// MaKH = (int)dongDL["MaKH"];
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Gia = (int)dongDL["Gia"];
dtoDH = new DTODonDatHang(dongDL);
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
public DTOXuLyPhieuGiao(DataRow dongDL)
{
STT = (int)dongDL["STT"];
MaDH = dongDL["MaDH"].ToString();
// MaKH = (int)dongDL["MaKH"];
MaSP = (int)dongDL["MaSP"];
TenSP = dongDL["TenSP"].ToString();
Gia = (int)dongDL["Gia"];
dtoDH = new DTODonDatHang(dongDL);
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
ThanhTien = (int)dongDL["ThanhTien"];
}
protected void btnThemSP_Click(object sender, EventArgs e)
{
XemDSKho.Visible = true;
DTOXuLyPhieuGiao dtoct = new DTOXuLyPhieuGiao();
// DTODonDatHang dtoDH = new DTODonDatHang();
dtoct.MaDH = lbMaDH.Text;
DTOSanPham dtoSP = new DTOSanPham();
dtoct.MaSP = int.Parse(ddTP.SelectedValue);
// dtoSP.TenSP = ddTP.SelectedItem.ToString();
//dtoct.dtoSP = dtoSP;
//dtoct.dtoDH = dtoDH;
//dtoSP.TenSP = ddTP.SelectedValue;
dtoct.SoLuong = int.Parse(txtSoLuong.Text);
dtoct.ThanhTien = int.Parse(lbgia.Text) * int.Parse(txtSoLuong.Text);
//BLLXuLyDonHang bll = new BLLXuLyDonHang();
//bll.ThemChiTietDH(dtoct);
DTOKhoSP dtokho = new DTOKhoSP();
dtokho.MaSP = int.Parse(ddTP.SelectedValue);
dtokho.Soluong = int.Parse(lbSLKho.Text) - int.Parse(txtSoLuong.Text);
DAO_Entity dao = new DAO_Entity();
dao.CapNhatSLKhoSP(dtokho);
DAO_Entity daokh = new DAO_Entity();
daokh.ThemPhieuGiaoHang(dtoct);
Response.Redirect(Request.RawUrl);
}
public DTOXuLySuCo(DataRow dongDL)
{
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
}
public DTOSanPham LayGiaSPTheoMa(int ma)
{
ketnoi.TaoKetNoi();
DTOSanPham dtoDH = null;
try
{
string lenh = "Select * from SanPham sp, LoaiSP l where sp.MaLoai=l.MaLoai and MaSP=@ma";
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters["@ma"].Value = ma;
DataTable bang = new DataTable();
ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi);
ketnoi.TichHopCSDL.Fill(bang);
DataRow dong = bang.Rows[0];
dtoDH = new DTOSanPham(dong);
}
catch (Exception)
{
throw;
}
finally
{
ketnoi.DongKetNoi();
}
return dtoDH;
}
// Sua TT san pham
public bool SuaSanPham(DTOSanPham dtoSP)
{
bool ketqua = false;
ketnoi.TaoKetNoi();
try
{
string lenh = "update SanPham set TenSP= @tensp, Soluong = @soluong, maloai = @maloai, gia = @gia where masp=@masp";
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@masp", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters.Add("@tensp", SqlDbType.NVarChar);
ketnoi.LenhKetNoi.Parameters.Add("@soluong", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters.Add("@gia", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters.Add("@maloai", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters["@masp"].Value = dtoSP.MaSP;
ketnoi.LenhKetNoi.Parameters["@tensp"].Value = dtoSP.TenSP;
ketnoi.LenhKetNoi.Parameters["@soluong"].Value = dtoSP.soluong;
ketnoi.LenhKetNoi.Parameters["@gia"].Value = dtoSP.Gia;
ketnoi.LenhKetNoi.Parameters["@malkh"].Value = dtoSP.dtoLoaiSP.MaLSP;
if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0)
ketqua = true;
}
catch (Exception)
{
}
finally
{
ketnoi.DongKetNoi();
}
return ketqua;
}
//DAO San Pham
//Lay du lieu tu database hien thi ra bang
public List<DTOSanPham> TimTPTheoTen(string tenTim)
{
List<DTOSanPham> dsTim = new List<DTOSanPham>();
string lenh = "Select * from SanPham SP, LoaiSP LSP where SP.MaLoai=LSP.MaLoai and SP.TenSP like @tenSP";
ketnoi.TaoKetNoi();
DataTable bang = new DataTable();
try
{
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@tenSP", SqlDbType.NVarChar);
ketnoi.LenhKetNoi.Parameters["@tenSP"].Value = "%" + tenTim + "%";
ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi);
ketnoi.TichHopCSDL.Fill(bang);
foreach (DataRow dongDL in bang.Rows)
{
DTOSanPham dtoSP = new DTOSanPham(dongDL);
dsTim.Add(dtoSP);
}
}
catch (Exception)
{
}
finally
{
ketnoi.DongKetNoi();
}
return dsTim;
}
public DTOSanPham TimTheoMaSP(int maSP)
{
DTOSanPham dtoSP = new DTOSanPham();
string lenh = "Select * from SanPham SP, LoaiSP LSP where SP.MaLoai=LSP.MaLoai and SP.MaSP = @masp";
ketnoi.TaoKetNoi();
DataTable bang = new DataTable();
try
{
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@masp", SqlDbType.Int);
ketnoi.LenhKetNoi.Parameters["@masp"].Value = maSP;
ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi);
ketnoi.TichHopCSDL.Fill(bang);
dtoSP = new DTOSanPham(bang.Rows[0]);
}
catch (Exception)
{
}
finally
{
ketnoi.DongKetNoi();
}
return dtoSP;
}
//Them sp
public bool ThemSanPham(DTOSanPham dtoSP)
{
bool ketqua = false;
ketnoi.TaoKetNoi();
try
{
string lenh = "insert into SanPham(MaSP, TenSP, LoaiSP, GiaSP) values(@masp, @tensp, @loaisp, @giasp)";
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@masp", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters.Add("@tensp", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters.Add("@loaisp", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters.Add("@giasp", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters["@masp"].Value = dtoSP.MaSP;
ketnoi.LenhKetNoi.Parameters["@tensp"].Value = dtoSP.TenSP;
ketnoi.LenhKetNoi.Parameters["@loaisp"].Value = dtoSP.dtoLoaiSP;
ketnoi.LenhKetNoi.Parameters["@giasp"].Value = dtoSP.Gia;
if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0)
ketqua = true;
}
catch (Exception)
{
}
finally
{
ketnoi.DongKetNoi();
}
return ketqua;
}
public DTOXuLySuCo(DataRow dongDL)
{
dtoSP = new DTOSanPham(dongDL);
SoLuong = (int)dongDL["SoLuong"];
}
