public static List <GetUser> GetAllUserDS(DataSet ds)
{
List <GetUser> list = new List <GetUser>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetUser user = new GetUser();
user.Id = (int)ds.Tables[0].Rows[i]["Id"];
user.Username = ds.Tables[0].Rows[i]["Username"].ToString();
user.Password = ds.Tables[0].Rows[i]["Password"].ToString();
user.Firstname = ds.Tables[0].Rows[i]["Firstname"].ToString();
user.Lastname = ds.Tables[0].Rows[i]["Lastname"].ToString();
user.Email = ds.Tables[0].Rows[i]["Email"].ToString();
user.Address = ds.Tables[0].Rows[i]["Address"].ToString();
list.Add(user);
}
return(list);
}
public static GetUser GetUserDS(DataSet ds)
{
try {
GetUser user = new GetUser();
user.Id = (int)ds.Tables[0].Rows[0]["Id"];
user.Username = ds.Tables[0].Rows[0]["Username"].ToString();
user.Password = ds.Tables[0].Rows[0]["Password"].ToString();
user.Firstname = ds.Tables[0].Rows[0]["Firstname"].ToString();
user.Lastname = ds.Tables[0].Rows[0]["Lastname"].ToString();
user.Email = ds.Tables[0].Rows[0]["Email"].ToString();
user.Address = ds.Tables[0].Rows[0]["Address"].ToString();
return(user);
}
catch (Exception ex)
{
return(null);
}
}
public static List <GetPost> GetAllPostDS(DataSet ds)
{
List <GetPost> list = new List <GetPost>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetPost post = new GetPost();
post.Id = (int)ds.Tables[0].Rows[i]["Id"];
post.Title = ds.Tables[0].Rows[i]["Title"].ToString();
post.Content = ds.Tables[0].Rows[i]["Content"].ToString();
post.Photo = ds.Tables[0].Rows[i]["Photo"].ToString();
GetCategory category = new GetCategory();
category.Id = (int)ds.Tables[0].Rows[0]["Category"];
category.Name = ds.Tables[0].Rows[0]["Name"].ToString();
post.Category = category;
post.OnDate = (System.DateTime)ds.Tables[0].Rows[0]["OnDate"];
GetUser user = new GetUser();
user.Id = (int)ds.Tables[0].Rows[0]["ByUser"];
user.Firstname = ds.Tables[0].Rows[0]["Firstname"].ToString();
user.Lastname = ds.Tables[0].Rows[0]["Lastname"].ToString(); list.Add(post);
}
return(list);
}
