public bool AddUnitCategory(clsUnitCategory info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddUnitCategory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@UnitCategoryID", info.strUnitCategoryID);
cmd.Parameters.AddWithValue("@UnitCategoryDescription", info.strDesc);
cmd.Parameters.AddWithValue("@ID", info.id);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <clsUnitCategory> GetAllUnitCategoryInfo()
{
List <clsUnitCategory> lst = new List <clsUnitCategory>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetUnitCategory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var info = new clsUnitCategory();
info.strUnitCategoryID = reader["UnitCategoryID"].ToString();
info.strDesc = reader["UnitCategoryDescription"].ToString();
info.id = Convert.ToInt32(reader["ID"]);
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
