public bool UpdateLoaiCongvan(LoaiCongvanEntity loaiCongvan)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spSualoaicongvan", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iLoaicongvanID", loaiCongvan.PK_iLoaicongvanID);
cmd.Parameters.AddWithValue("@sTenLoaicongvan", loaiCongvan.STenloaicongvan);
int i = cmd.ExecuteNonQuery();
cnn.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public List <LoaiCongvanEntity> GetAllLoaiCongvan()
{
List <LoaiCongvanEntity> glstLoaiCongvan = new List <LoaiCongvanEntity>();
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spGetAllLoaiCongvan", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dar = cmd.ExecuteReader();
if (dar.HasRows)
{
while (dar.Read())
{
LoaiCongvanEntity loaiCongvan = new LoaiCongvanEntity();
loaiCongvan.PK_iLoaicongvanID = Convert.ToInt64(dar["PK_iLoaicongvanID"]);
loaiCongvan.STenloaicongvan = dar["sTenLoaicongvan"].ToString();
glstLoaiCongvan.Add(loaiCongvan);
}
}
cnn.Close();
return(glstLoaiCongvan);
}
}
