private BusinessObjects.State MapToParents(DataRow dr)
{
BusinessObjects.State State = new BusinessObjects.State();
State.ID = Convert.ToInt32(dr["PK_State_ID"]);
State.Name = Convert.ToString(dr["State_Name"]);
State.Abbr = Convert.ToString(dr["State_Abbr"]);
State.Country = new BusinessObjects.Country() { ID = Convert.ToInt32(dr["PK_Country_ID"]), Name = Convert.ToString(dr["Country_Name"]), Icon = Convert.ToString(dr["Country_Icon"]), Image = Convert.ToString(dr["Country_Image"]) };
return State;
}
public BusinessObjects.State Read(long ID)
{
BusinessObjects.State State = new BusinessObjects.State();
List<SqlParameter> param = new List<SqlParameter>();
param.Add(new SqlParameter("@StateID", ID));
DataTable dt = Read(param.ToArray(), "SP_State_Read");
if (dt.Rows.Count > 0)
{
State = MapToParents(dt.Rows[0]);
}
return State;
}