//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));
}
public static bool Edit(DTOBinhGa bg)
{
return(dalBinhGa.Edit(bg));
}
public static bool Add(DTOBinhGa bg)
{
return(dalBinhGa.Add(bg));
}
