public IList select_allhoa()
{
ArrayList list = new ArrayList();
string conn = ConfigurationManager.ConnectionStrings["Ketnoi"].ToString();
SqlConnection objConn = new SqlConnection(conn);
objConn.Open();
SqlCommand objComm = new SqlCommand("Xem_loaihang", objConn);
objComm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = objComm.ExecuteReader();
LoaiHangInfo hoa = null;
while (dr.Read())
{
hoa = new LoaiHangInfo();
if (!dr.IsDBNull(0))
{
hoa.maloai = dr.GetString(0);
}
if (!dr.IsDBNull(1))
{
hoa.tenloai = dr.GetString(1);
}
list.Add(hoa);
}
dr.Close();
objConn.Close();
return(list);
}
public int insertLoai(LoaiHangInfo loaihang)
{
int i = 0;
string conn = ConfigurationManager.ConnectionStrings["STR"].ToString();
SqlConnection objConn = new SqlConnection(conn);
objConn.Open();
SqlCommand objComm = new SqlCommand("insert_loaihanghoa1", objConn);
objComm.CommandType = CommandType.StoredProcedure;
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@maloai", SqlDbType.Int),
new SqlParameter("@tenloai", SqlDbType.NVarChar)
};
parms[0].Value = loaihang.maloai;
parms[1].Value = loaihang.tenloai;
objComm.Parameters.AddRange(parms);
i = objComm.ExecuteNonQuery();
objConn.Close();
return(i);
}
