public PhotoStats PhotoDetails(int photoId)
{
PhotoStats photoStats = new PhotoStats();
SqlCommand cmd = new SqlCommand("Select * from allPhotos where PhotoID=@pid", sqlConnection);
cmd.Parameters.AddWithValue("@pid", photoId);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sqlConnection.Open();
sda.Fill(dt);
sqlConnection.Close();
foreach (DataRow dr in dt.Rows)
{
photoStats = new PhotoStats
{
PhotoID = Convert.ToInt32(dr["PhotoId"]),
LikedBy = Convert.ToString(dr["Likedby"]),
DisLikedBy = Convert.ToString(dr["Dislikedby"]),
LovedBy = Convert.ToString(dr["Lovedby"])
}
}
;
return(photoStats);
}
public bool UpdateFame(PhotoStats newphotostat, PhotoStats currentPhotoStats)
{
SqlCommand cmd = new SqlCommand("RecordFame", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@todayLikes", newphotostat.Likes - currentPhotoStats.Likes);
cmd.Parameters.AddWithValue("@todayDislikes", newphotostat.Dislikes - currentPhotoStats.Dislikes);
cmd.Parameters.AddWithValue("@todayHearts", newphotostat.Loves - currentPhotoStats.Loves);
cmd.Parameters.AddWithValue("@photoid", currentPhotoStats.PhotoID);
sqlConnection.Open();
int i = cmd.ExecuteNonQuery();
sqlConnection.Close();
return(true);
}
public PhotoStats RecordStats(string email, int id, char action)
{
PhotoStats newphotostat = new PhotoStats();
try {
PhotoStats currentPhotoStats = photoStatsRepository.PhotoDetails(id);
bool result = photoStatsRepository.RecordStatistics(email, id, action);
if (result)
{
newphotostat = photoStatsRepository.PhotoDetails(id);
photoStatsRepository.UpdateFame(newphotostat, currentPhotoStats);
}
}
catch (Exception e) { }
return(newphotostat);
}
public string RecordStats(int id, char action)
{
string email = Session["Email"].ToString();
PhotoStats photoStats = photoStatsService.RecordStats(email, id, action);
if (photoStats != null)
{
Stats stats = new Stats()
{
Success = true, Loves = photoStats.Loves, Stat = "Nostats", Likes = photoStats.Likes, Dislikes = photoStats.Dislikes
};
if (photoStats.LikedBy.IndexOf("," + Session["UserID"] + ",") > -1)
{
stats.Stat = "L"; //ViewBag.my_Stat = "Liked";
}
else if (photoStats.DisLikedBy.IndexOf("," + Session["UserID"] + ",") > -1)
{
stats.Stat = "D"; //ViewBag.my_Stat = "Disliked";
}
else if (photoStats.LovedBy.IndexOf("," + Session["UserID"] + ",") > -1)
{
stats.Stat = "H";//ViewBag.my_Stat = "Loved";
}
else
{
stats.Stat = "No Stat"; //ViewBag.my_stat = "No stat";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(stats));
}
else
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new Stats()
{
Success = false
}));
}
}
