public static void Send()
{
using (TimeFliesByEntities dc = new TimeFliesByEntities(Settings.EFConnectionString))//do not use ContextHelper.DataContext as it runs in a background thread
{
DateTime fromDate = DateTime.Now.AddDays(-1);
IEnumerable<UserReminderInfo> reminders = AppUserDao.GetUsersReminderInfo(dc);
reminders = reminders.Where(o => o.IsActive
&& o.IsReminder && o.LastReminderDT.GetValueOrDefault(DateTime.MinValue) < fromDate
&& o.MaxImageDT.GetValueOrDefault(DateTime.MinValue) < fromDate);
foreach (UserReminderInfo reminder in reminders)
{
List<Images> friendImages = null;
try
{
friendImages = GetFriendImages(reminder.AccessToken, dc);
}
catch (Exception ex)
{
if (!(ex is Facebook.FacebookOAuthException))
EmailService.ErrorEmail(ex);
}
EmailService.SayCheese(reminder.UserId, reminder.Email, reminder.FullName, reminder.ImageCount, reminder.MaxImageDT, friendImages);
IEnumerable<Videos> videos = dc.Videos.Where(o => o.UserId == reminder.UserId).ToList();
foreach (Videos video in videos)
video.ServerReminderTime = DateTime.Now;
dc.SaveChanges();
}
}
}
public string ChangeDate(string imageId, string newDate)
{
try
{
using (TimeFliesByEntities dc = new TimeFliesByEntities(Settings.EFConnectionString))
{
int id = Int32.Parse(imageId);
Images image = dc.Images.FirstOrDefault(o => o.ImageId == id);
if (image == null)
return "false";
string[] datee = newDate.Split('-');
image.DateAdded = Convert.ToDateTime(datee[0] + "/" + datee[1] + "/" + datee[2] + " " + datee[3] + ":" + datee[4] + ":" + datee[5] + " " + datee[6]);
dc.SaveChanges();
return "true";
}
}
catch (Exception ex)
{
EmailService.ErrorEmail(ex);
return "error";
}
}
public string DelUnDel(string imageId, string action)
{
try
{
using (TimeFliesByEntities dc = new TimeFliesByEntities(Settings.EFConnectionString))
{
int id = Int32.Parse(imageId);
Images image = dc.Images.FirstOrDefault(o => o.ImageId == id);
if (image == null)
return "false";
if (action == "Del")
{
image.IsDelete = true;
}
else
{
image.IsDelete = false;
}
dc.SaveChanges();
}
return "true";
}
catch (Exception ex)
{
EmailService.ErrorEmail(ex);
return "error";
}
}
public string SaveEyes(string userId, string rEye, string lEye)
{
try
{
using (TimeFliesByEntities dc = new TimeFliesByEntities(Settings.EFConnectionString))
{
AppUser user = dc.User.FirstOrDefault(o => o.UserId == userId);
if (user == null)
return "User does not exist";
user.RightEye = rEye;
user.LeftEye = lEye;
dc.SaveChanges();
return "Record saved";
}
}
catch (Exception ex)
{
EmailService.ErrorEmail(ex);
return "DB error occur";
}
}
public string RevertImage(string imageId)
{
try
{
using (TimeFliesByEntities dc = new TimeFliesByEntities(Settings.EFConnectionString))
{
int id = Int32.Parse(imageId);
Images image = dc.Images.FirstOrDefault(o => o.ImageId == id);
if (image == null)
return "false";
image.IsEdit = false;
ImageHelper.GetImageUrl(image);
//image.ImagePath = "Contents/UserImages/" + image.UserId + "/" + image.ImageName + ".jpg";
dc.SaveChanges();
return "true_" + image.ImagePath;
}
/*if (CambaTv.Data.DataRepository.ImagesProvider.Update(img))
{
return "true_" + img.ImagePath;
}
else
{
return "false";
}*/
}
catch (Exception ex)
{
EmailService.ErrorEmail(ex);
return "DB error occur";
}
}
