public List <FriendLinkInfo> GetDataByCategoryId(int fc_id)
{
List <FriendLinkInfo> infos = new List <FriendLinkInfo>();
IDataReader reader = db.GetDataByID(fc_id).CreateDataReader();
while (reader.Read())
{
infos.Add(FriendLinkInfo.Populate(reader));
}
return(infos);
}
public List <FriendLinkInfo> GetSortingWithDelete(int fc_id, int f_sorting)
{
List <FriendLinkInfo> infos = new List <FriendLinkInfo>();
IDataReader reader = db.GetkSortingWithDelete(fc_id, f_sorting).CreateDataReader();
while (reader.Read())
{
infos.Add(FriendLinkInfo.Populate(reader));
}
return(infos);
}
public FriendLinkInfo GetDataById(int f_id)
{
FriendLinkInfo info = new FriendLinkInfo();
IDataReader reader = db.GetDataById(f_id).CreateDataReader();
if (reader.Read())
{
info = FriendLinkInfo.Populate(reader);
}
return(info);
}
public int InsertSortingWithCategory(int fc_id)
{
FriendLinkInfo info = new FriendLinkInfo();
IDataReader reader = db.InsertSorting(fc_id).CreateDataReader();
if (reader.Read())
{
info = FriendLinkInfo.Populate(reader);
return(info.f_sorting + 1);
}
return(1);
}