public PartnerStatus GetByID(int id)
{
PartnerStatus item = null;
using (StoredProcedure sp = new StoredProcedure("PartnerStatuses_GetByID"))
{
sp.Params.Add("@ID", System.Data.SqlDbType.Int).Value = id;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new PartnerStatus();
item.ID = Convert.ToInt32(r["ID"]);
item.Name = Convert.ToString(r["Name"]);
item.Description = Convert.ToString(r["Description"]);
}
}
}
return item;
}
public List<PartnerStatus> GetAll()
{
List<PartnerStatus> all = new List<PartnerStatus>();
using (StoredProcedure sp = new StoredProcedure("PartnerStatuses_GetAll"))
{
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
PartnerStatus item = new PartnerStatus();
item.ID = Convert.ToInt32(r["ID"]);
item.Name = Convert.ToString(r["Name"]);
item.Description = Convert.ToString(r["Description"]);
all.Add(item);
}
}
}
}
return all;
}