//Thêm sinh viên
public bool Add(DTOCaLam cl)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaCa", cl.MaCa);
sqlP[1] = new SqlParameter("@TenCa", cl.TenCa);
return(dalGeneric.execNonQuery("insertCaLam", sqlP));
}
//Thêm sinh viên
public bool Add(DTOCongViec cv)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaCV", cv.MaCV);
sqlP[1] = new SqlParameter("@TenCV", cv.TenCV);
return(dalGeneric.execNonQuery("insertCongViec", sqlP));
}
//Thêm sinh viên
public bool Add(DTONuocSX nsx)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaNSX", nsx.MaNSX);
sqlP[1] = new SqlParameter("@TenNSX", nsx.TenNSX);
return(dalGeneric.execNonQuery("insertNSX", sqlP));
}
//Thêm sinh viên
public bool Add(DTOLoaiGa lg)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaLoai", lg.MaLoai);
sqlP[1] = new SqlParameter("@TenLoai", lg.TenLoai);
return(dalGeneric.execNonQuery("insertLoaiGa", sqlP));
}
//Thêm sinh viên
public bool Add(DTOMau m)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@MaMau", m.MaMau);
sqlP[1] = new SqlParameter("@TenMau", m.TenMau);
return(dalGeneric.execNonQuery("insertMau", sqlP));
}
//Thêm sinh viên
public bool Add(DTOKhoiLuong kl)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@MaKL", kl.MaKL);
return(dalGeneric.execNonQuery("insertKhoiLuong", sqlP));
}
//Thêm sinh viên
public bool Add(DTONhaCungCap ncc)
{
SqlParameter[] sqlP = new SqlParameter[4];
sqlP[0] = new SqlParameter("@MaNCC", ncc.MaNCC);
sqlP[1] = new SqlParameter("@TenNCC", ncc.TenNCC);
sqlP[2] = new SqlParameter("@DiaChi", ncc.DiaChi);
sqlP[3] = new SqlParameter("@DienThoai", ncc.DienThoai);
return(dalGeneric.execNonQuery("insertNCC", sqlP));
}
public bool Add(DTOKhachHang kh)
{
SqlParameter[] sqlP = new SqlParameter[4];
sqlP[0] = new SqlParameter("@MaKH", kh.MaKH);
sqlP[1] = new SqlParameter("@TenKH", kh.TenKH);
sqlP[2] = new SqlParameter("@DiaChi", kh.DiaChi);
sqlP[3] = new SqlParameter("@DienThoai", kh.DienThoai);
return(dalGeneric.execNonQuery("insertKH", sqlP));
}
//Thêm sinh viên
public bool Add(DTOHDBan hdb)
{
SqlParameter[] sqlP = new SqlParameter[5];
sqlP[0] = new SqlParameter("@SoHDB", hdb.SoHDB);
sqlP[1] = new SqlParameter("@MaNV", hdb.MaNV);
sqlP[2] = new SqlParameter("@NgayBan", hdb.NgayBan);
sqlP[3] = new SqlParameter("@MaKH", hdb.MaKH);
sqlP[4] = new SqlParameter("@TongTien", hdb.TongTien);
return(dalGeneric.execNonQuery("insertHDB", sqlP));
}
//Thêm sinh viên
public bool Add(DTOChiTietHDB cthdb)
{
SqlParameter[] sqlP = new SqlParameter[5];
sqlP[0] = new SqlParameter("@SoHDB", cthdb.SoHDB);
sqlP[1] = new SqlParameter("@MaBinh", cthdb.MaBinh);
sqlP[2] = new SqlParameter("@SoLuong", cthdb.SoLuong);
sqlP[3] = new SqlParameter("@GiamGia", cthdb.GiamGia);
sqlP[4] = new SqlParameter("@ThanhTien", cthdb.ThanhTien);
return(dalGeneric.execNonQuery("insertCTHDB", sqlP));
}
//Thêm sinh viên
public bool Add(DTOHDNhap hdn)
{
SqlParameter[] sqlP = new SqlParameter[5];
sqlP[0] = new SqlParameter("@SoHDN", hdn.SoHDN);
sqlP[1] = new SqlParameter("@MaNV", hdn.MaNV);
sqlP[2] = new SqlParameter("@NgayNhap", hdn.NgayNhap);
sqlP[3] = new SqlParameter("@MaNCC", hdn.MaNCC);
sqlP[4] = new SqlParameter("@TongTien", hdn.TongTien);
return(dalGeneric.execNonQuery("insertHDN", sqlP));
}
//Thêm sinh viên
public bool Add(DTOChiTietHDN cthdn)
{
SqlParameter[] sqlP = new SqlParameter[6];
sqlP[0] = new SqlParameter("@SoHDN", cthdn.SoHDN);
sqlP[1] = new SqlParameter("@MaBinh", cthdn.MaBinh);
sqlP[2] = new SqlParameter("@SoLuong", cthdn.SoLuong);
sqlP[3] = new SqlParameter("@DonGia", cthdn.DonGia);
sqlP[4] = new SqlParameter("@GiamGia", cthdn.GiamGia);
sqlP[5] = new SqlParameter("@ThanhTien", cthdn.ThanhTien);
return(dalGeneric.execNonQuery("insertCTHDN", sqlP));
}
//Thêm sinh viên
public bool Add(DTONhanVien nv)
{
SqlParameter[] sqlP = new SqlParameter[8];
sqlP[0] = new SqlParameter("@MaNV", nv.MaNV);
sqlP[1] = new SqlParameter("@TenNV", nv.TenNV);
sqlP[2] = new SqlParameter("@GioiTinh", nv.GioiTinh);
sqlP[3] = new SqlParameter("@NgaySinh", nv.NgaySinh);
sqlP[4] = new SqlParameter("@DiaChi", nv.DiaChi);
sqlP[5] = new SqlParameter("@DienThoai", nv.DienThoai);
sqlP[6] = new SqlParameter("@MaCa", nv.MaCa);
sqlP[7] = new SqlParameter("@MaCV", nv.MaCV);
return(dalGeneric.execNonQuery("insertNhanVien", sqlP));
}
//Thêm sinh viên
public bool Add(DTOBinhGa bg)
{
SqlParameter[] sqlP = new SqlParameter[12];
sqlP[0] = new SqlParameter("@MaBinh", bg.MaBinh);
sqlP[1] = new SqlParameter("@TenBinh", bg.TenBinh);
sqlP[2] = new SqlParameter("@MaKL", bg.MaKL);
sqlP[3] = new SqlParameter("@MaLoai", bg.MaLoai);
sqlP[4] = new SqlParameter("@MaMau", bg.MaMau);
sqlP[5] = new SqlParameter("@MaNSX", bg.MaNSX);
sqlP[6] = new SqlParameter("@SoLuong", bg.SoLuong);
if (bg.DonGiaNhap == 0)
{
sqlP[7] = new SqlParameter("@DonGiaNhap", SqlDbType.BigInt);
sqlP[7].Value = DBNull.Value;
}
else
{
sqlP[7] = new SqlParameter("@DonGiaNhap", bg.DonGiaNhap);
}
if (bg.DonGiaNhap == 0)
{
sqlP[8] = new SqlParameter("@DonGiaBan", SqlDbType.BigInt);
sqlP[8].Value = DBNull.Value;
}
else
{
sqlP[8] = new SqlParameter("@DonGiaBan", bg.DonGiaBan);
}
sqlP[9] = new SqlParameter("@ThoiGianBaoHanh", bg.ThoiGianBH);
if (bg.Anh == null)
{
sqlP[10] = new SqlParameter("@Anh", SqlDbType.Image);
sqlP[10].Value = DBNull.Value;
}
else
{
sqlP[10] = new SqlParameter("@Anh", bg.Anh);
}
if (bg.GhiChu == null)
{
sqlP[11] = new SqlParameter("@GhiChu", SqlDbType.NVarChar);
sqlP[11].Value = DBNull.Value;
}
else
{
sqlP[11] = new SqlParameter("@GhiChu", bg.GhiChu);
}
return(dalGeneric.execNonQuery("insertBinhGa", sqlP));
}