/// <summary>
/// Lấy danh sách Nhóm hàng
/// </summary>
/// <param name="PK_iNhomhangID">Mã nhóm hàng</param>
/// <returns>List<tblHanghoa></returns>
public List <tblNhomhang> tblNhomhang_Select(int PK_iNhomhangID)
{
List <tblNhomhang> listNhomhang = new List <tblNhomhang>();
using (SqlConnection cnn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("sp_tblNhomhang_Select", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iNhomhangID", PK_iNhomhangID);
cnn.Open();
using (SqlDataReader rd = cmd.ExecuteReader())
{
if (rd.HasRows)
{
while (rd.Read())
{
tblNhomhang nhomhang = new tblNhomhang();
nhomhang.iNhomhangID = Convert.ToInt32(rd["PK_iNhomhangID"].ToString());
nhomhang.sTenNhomhang = rd["sTenNhomhang"].ToString();
nhomhang.sMota = rd["sMota"].ToString();
listNhomhang.Add(nhomhang);
}
rd.Close();
}
cnn.Close();
return(listNhomhang);
}
}
}
}
/// <summary>
/// Thêm Nhóm hàng
/// </summary>
/// <param name="nhomhang">tblNhomhang</param>
/// <returns>bool</returns>
public bool tblNhomhang_Insert(tblNhomhang nhomhang)
{
using (SqlConnection cnn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("sp_tblNhomhang_Insert", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iNhomhangID", nhomhang.iNhomhangID);
cmd.Parameters.AddWithValue("@sTenNhomhang", nhomhang.sTenNhomhang);
cmd.Parameters.AddWithValue("@sMota", nhomhang.sMota);
cnn.Open();
int i = cmd.ExecuteNonQuery();
cnn.Close();
return(i > 0);
}
}
}
