public List <Pictures> GetAllPictures()
{
string sql = String.Format("SELECT * FROM pictures");
DataRowCollection res = Query(sql);
List <Pictures> allPictures = new List <Pictures>();
if (res.Count >= 1)
{
foreach (DataRow datarow in res)
{
Pictures pictures = new Pictures(datarow);
allPictures.Add(pictures);
}
return(allPictures);
}
else
{
return(allPictures);
}
}
public static Pictures DeSerializePictures(string pic)
{
Pictures deserializedPictures = JSONHelper.Deserialize <Pictures>(pic);
return(deserializedPictures);
}
//Pictures
public static string SerializePictures(Pictures pic)
{
string serializedPictures = JSONHelper.Serialize <Pictures>(pic);
return(serializedPictures);
}