public Support SupportIDataReader(IDataReader dr)
{
DataAccess.Support obj = new DataAccess.Support();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Tel = (dr["Tel"] is DBNull) ? string.Empty : dr["Tel"].ToString();
obj.Type = (dr["Type"] is DBNull) ? string.Empty : dr["Type"].ToString();
obj.Nick = (dr["Nick"] is DBNull) ? string.Empty : dr["Nick"].ToString();
obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
obj.GroupSupportId = (dr["GroupSupportId"] is DBNull) ? string.Empty : dr["GroupSupportId"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
obj.Location = (dr["Location"] is DBNull) ? string.Empty : dr["Location"].ToString();
return(obj);
}
public List <Support> Support_GetByAll(string Lang)
{
List <DataAccess.Support> list = new List <DataAccess.Support>();
DataAccess.Support obj = new DataAccess.Support();
DbCommand cmd = db.GetStoredProcCommand("sp_Support_GetByAll", Lang);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.SupportIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
