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"; } }