public void updateLikes(int UserID, int addID)
{
//Add current profile to like
List <int> likeList;
SqlCommand objCommand = new SqlCommand();
//objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_GetLikes";
objCommand.Parameters.AddWithValue("@UserId", UserID);
objDB.GetDataSetUsingCmdObj(objCommand);
Byte[] byteArray;
//objDB.GetField("Likes", 0) != System.DBNull.Value
byteArray = (Byte[])objDB.GetField("Likes", 0);
BinaryFormatter deSerializer = new BinaryFormatter();
MemoryStream memStream = new MemoryStream(byteArray);
try
{
likeList = (List <int>)deSerializer.Deserialize(memStream);
}
catch
{
likeList = new List <int>();
}
likeList.Add(addID);
BinaryFormatter serializer = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
Byte[] Store;
serializer.Serialize(stream, likeList);
Store = memStream.ToArray();
objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_StoreLikes";
objCommand.Parameters.AddWithValue("@UserId", UserID);
objCommand.Parameters.AddWithValue("@Likes", Store);
objDB.DoUpdateUsingCmdObj(objCommand);
}