// GET: Slumpiator public ActionResult Index() { //Email.SendEmail("*****@*****.**", "nicklas", "Testmail", "Hejhej"); int user_id = Convert.ToInt32(User.Identity.Name); slump slumpe = new slump(); DateTime date; date = DateTime.Now; date = slumpe.datefixer(date); slumpe.recepts = slumpe.Oldslumps(user_id, date.AddDays(-30), date.AddDays(-1)); slumpe.list = slumpe.Weeknumbers(slumpe.recepts); ViewBag.thisweek = slumpe.Oldslumps(user_id, date.AddDays(-1), date.AddDays(6)); ViewBag.date = slump.GetIso8601WeekOfYear(DateTime.Now); ViewBag.date1 = slump.GetIso8601WeekOfYear(DateTime.Now.AddDays(7)); date = DateTime.Now; date = slumpe.datefixer(date); ViewBag.nextweek = slumpe.Oldslumps(user_id, date.AddDays(6), date.AddDays(14)); return(View(slumpe)); }
public static void StartCron() { Users user = new Users(); slump checkslump = new slump(); DateTime crondate = DateTime.Now; int checkcron = ((int)crondate.DayOfWeek == 0) ? 7 : (int)crondate.DayOfWeek; List <Users> list = user.GetuserAsAdmin(checkcron, "SELECT users.user_id, users.username, users.fname, users.last_name, users.email, users.acc_active,users.roles_id,users.settings_id,users.last_login FROM public.users LEFT JOIN usersettings ON users.settings_id = usersettings.setting_id WHERE usersettings.day_of_slumpcron =@id ;"); foreach (var item in list) { DateTime date = checkslump.datefixer(DateTime.Now); date = date.Date; date = date.AddDays(7); bool check = checkslump.Checkslump(date, item.User_id); if (check) { } else { slump slumpa = new slump(); List <Receptmodels> lista = slumpa.Slumplist(item.User_id, date); if (lista[0].Id != -10) { string body = Email.Emailslumplist(item.First_name, "Här kommer nästa veckas mat. Hoppas de ska smaka!", lista); Email.SendEmail(item.email, item.First_name, "Här kommer nästa veckas mat.", body); foreach (var items in lista) { slumpa.SaveSlump(items.Id, item.User_id, items.Date, false); } } else { var getlist = new Slumpservices(); var slumplist = getlist.CreateRandomListOfRecept(); string body = Email.EmailRadomlist(item.User, "Tyvärr finns det inte tillräckligt med maträtter i din personliga lista. </br> Går gärna in och lägg till de rätter som passar dig så kan vi hjälpa dig med förslag till middag.<br> Vi skickade med några förslag", slumplist, item.User_id); Email.SendEmail(item.email, item.User, "Vi behöver din hjälp", body); } } } }