public Language LanguageIDataReader(IDataReader dr)
{
DataAccess.Language obj = new DataAccess.Language();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString();
obj.Folder = (dr["Folder"] is DBNull) ? string.Empty : dr["Folder"].ToString();
obj.Default = (dr["Default"] is DBNull) ? string.Empty : dr["Default"].ToString();
obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
return(obj);
}
public List <Language> Language_GetByAll()
{
List <DataAccess.Language> list = new List <DataAccess.Language>();
DataAccess.Language obj = new DataAccess.Language();
DbCommand cmd = db.GetStoredProcCommand("sp_Language_GetByAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.LanguageIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
