internal static void ChangeAnimalDiet(Animal animal) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); Animal newAnimal = new Animal(); DietPlan diet = new DietPlan(); UserInterface.DisplayUserOptions("What DietPlanId would you like to change the animal to?"); int newDiet = UserInterface.GetIntegerData(); diet = db.DietPlans.Where(d => d.DietPlanId == newDiet).FirstOrDefault(); if (diet == null) { UserInterface.DisplayUserOptions("That diet plan does not exist. Press any key to continue."); Console.ReadLine(); return; } newAnimal = db.Animals.Where(a => a.AnimalId == animal.AnimalId).FirstOrDefault(); newAnimal.DietPlanId = newDiet; try { db.SubmitChanges(); UserInterface.DisplayUserOptions("Diet plan changed. Press any key to continue."); Console.ReadLine(); } catch (Exception e) { Console.WriteLine(e); } }
public static int GetDiet() { HumaneSocietyDataContext context = new HumaneSocietyDataContext(); string food = UserInterface.GetStringData("food", "the animal's"); int amount = UserInterface.GetIntegerData("food amount", "the animal's"); bool dietExists = context.DietPlans.Any(d => d.food == food && d.amount == amount); if (dietExists == false) { DietPlan dietPlanToAdd = new DietPlan(); dietPlanToAdd.food = food; dietPlanToAdd.amount = amount; context.DietPlans.InsertOnSubmit(dietPlanToAdd); try { context.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); } } var dietKey = (from d in context.DietPlans where food == d.food && amount == d.amount select d.ID).FirstOrDefault(); return(dietKey); } //System.Nullable<int> animal.diet
// GET: DietPlans/Details/5 public ActionResult Details(int?id) { DietViewModel dvm = new DietViewModel(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DietPlan dietPlan = db.DietPlans.Find(id); if (dietPlan == null) { return(HttpNotFound()); } dvm.dietPlan = dietPlan; int category = db.DietPlans.Find(id).Category; IList <WorkOut> workOut = db.WorkOuts.Where(w => w.Category == category).ToList(); dvm.workOuts = workOut; IList <DayPerWeek> dayPerWeeks = db.DayPerWeeks.ToList(); dvm.dayPerWeeks = dayPerWeeks; IList <Resource> resources = db.Resources.ToList(); dvm.resources = resources; return(View(dvm)); }
internal static int GetDietPlanId(string dietPlanName) { DietPlan dietPlan = db.DietPlans.Where(d => d.Name == dietPlanName).Single(); int dietPlanId = dietPlan.DietPlanId; return(dietPlanId); }
internal static void UpdateDiet(int dietId) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); DietPlan diet = new DietPlan(); diet = db.DietPlans.Where(d => d.DietPlanId == dietId).FirstOrDefault(); if (diet == null) { UserInterface.DisplayUserOptions("That DietId does not exist. Press any button to continue."); Console.ReadLine(); return; } diet.Name = UserInterface.GetStringData("name?", "the updated diet`s"); diet.FoodType = UserInterface.GetStringData("food type?", "the updated diet`s"); diet.FoodAmountInCups = UserInterface.GetIntegerData("serving amount?", "the updated diet`s"); try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); } }
public void Create_AreGeneratedDailyDietPlansValid(int startYear, int startMonth, int startDay, int endYear, int endMonth, int endDay) { DateTime startDate = new DateTime(startYear, startMonth, startDay); DateTime endDate = new DateTime(endYear, endMonth, endDay); var newDietPlan = new DietPlan { Id = 1, StartDate = startDate, EndDate = endDate, }; var dietPlanRepositoryMock = new Mock <IDietPlanRepository>(); var sut = new DietPlanService(dietPlanRepositoryMock.Object); DietPlan createResult = sut.Create(newDietPlan); TimeSpan duration = endDate - startDate + new TimeSpan(1, 0, 0, 0); createResult.DailyDietPlanList.Count.Should().Be(duration.Days); foreach (var dailyDietPlan in createResult.DailyDietPlanList) { TimeSpan daysFromStart = new TimeSpan(dailyDietPlan.DayNumber - 1); dailyDietPlan.Date.Should().Be(startDate + daysFromStart); } }
public static void UpdateDietPlan(int dietPlanId) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); DietPlan oldDP = db.DietPlans.Where(d => d.DietPlanId == dietPlanId).Single(); Console.WriteLine("What would you like to change? \n Diet Name = 1 \n Food Type = 2 \n Amount of food in cups = 3 \n All = 4"); int decision = UserInterface.GetIntegerData(); switch (decision) { case 1: oldDP.Name = UserInterface.GetUserInputWithOutput($"\nCurrent Diet Plan Name is {oldDP.Name}. What would you like to rename it to?"); break; case 2: oldDP.FoodType = UserInterface.GetUserInputWithOutput($"\nCurrent Diet Plan Food Type is {oldDP.FoodType}. What would you like to change it to?"); break; case 3: Console.WriteLine($"\nCurrent Diet Plan Cups of Food Amount is {oldDP.FoodAmountInCups} What would you like to change it to?"); oldDP.FoodAmountInCups = UserInterface.GetIntegerData(); break; case 4: oldDP.Name = UserInterface.GetUserInputWithOutput($"Current Diet Plan Name is {oldDP.Name}. What would you like to rename it to?"); oldDP.FoodType = UserInterface.GetUserInputWithOutput($"\nCurrent Diet Plan Food Type is {oldDP.FoodType}. What would you like to change it to?"); Console.WriteLine($"\nCurrent Diet Plan Cups of Food Amount is {oldDP.FoodAmountInCups} What would you like to change it to?"); oldDP.FoodAmountInCups = UserInterface.GetIntegerData(); break; } db.SubmitChanges(); }
internal static int GetDietPlanId(string dietPlanName) { DietPlan dp = db.DietPlans.Where(d => d.Name == dietPlanName).FirstOrDefault(); int DpID = dp.DietPlanId; return(DpID); }
public IActionResult Edit(DietPlan dietPlan) { var poco = DietPlanViewModelToPOCO(dietPlan); Update(poco); return(RedirectToAction("Index")); }
//SaveDietPlan() saves DietPlan in the database public DietPlan SaveDietPlan(DietPlanModel dietPlan) { //open a connection to a database FitnesspointDatabase using (var context = new FitnesspointDatabaseEntities()) { //Creating DietPlan object and assigning data using DietPlanModel class DietPlan dietPlan1 = new DietPlan() { Slots = dietPlan.Slots, FoodType = dietPlan.FoodType, FatRatio = dietPlan.FatRatio, CarbsRatio = dietPlan.CarbsRatio, ProteinRatio = dietPlan.ProteinRatio, TotalCalorie = dietPlan.FatRatio + dietPlan.CarbsRatio + dietPlan.ProteinRatio, UserId = dietPlan.UserId }; //add dietPlan1 to the database DietPlan using model DietPlan context.DietPlans.Add(dietPlan1); //save the changes to the database context.SaveChanges(); return(dietPlan1); } }
private void TransferModelToTaskItem(DietPlan dietPlan) { TodayTasks = new List<DietPlanTaskItem>(); foreach (var subDietPlan in dietPlan.SubDietPlans) { DietPlanTaskItem dietPlanTaskItem = new DietPlanTaskItem() { Id = subDietPlan.Id, Score = subDietPlan.Score, StartTime = subDietPlan.StartTime }; FoodTaskList foodTasks = new FoodTaskList(); //FoodTaskItem[] foodTasks = new FoodTaskItem[] { }; foreach (var dietPlanItem in subDietPlan.DietPlanItems) { FoodTaskItem foodTaskItem = new FoodTaskItem() { Id = dietPlanItem.Id, Amount = (int)dietPlanItem.Amount, Calorie = (int)dietPlanItem.Food.Calorie, FoodName = dietPlanItem.Food.Name }; foodTasks.Add(foodTaskItem); } dietPlanTaskItem.FoodTasks = foodTasks; TodayTasks.Add(dietPlanTaskItem); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Breakfast,Lunch,Dinner,Snacks")] DietPlan dietPlan) { if (id != dietPlan.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(dietPlan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DietPlanExists(dietPlan.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(dietPlan)); }
public ActionResult Create(DietPlan newDietPlan) { var dateValidation = _validator.Validate(newDietPlan); dateValidation.AddToModelState(ModelState, null); if (!dateValidation.IsValid) { return(View(newDietPlan)); } if (!ModelState.IsValid) { return(View(newDietPlan)); } try { var username = Username; newDietPlan.UserId = UserId; _dietPlanService.Create(newDietPlan, username); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public void CreateDietPlanSuccessTest() { //// Arranage var dietPlan = new DietPlan { Name = "First Test", Information = "success diet plan", PersonId = 12 }; var addedDietPlan = new DAL.Models.DietPlans { Name = "First Test", Information = "success diet plan", PersonId = 12, Id = 1 }; _genericAccess.Setup(access => access.Add(It.IsAny <DAL.Models.DietPlans>())).Returns(addedDietPlan); //// Act var returned = _service.create(dietPlan); //// Assert _genericAccess.Verify(access => access.Add(It.IsAny <DAL.Models.DietPlans>()), Times.Once); Assert.Equal(addedDietPlan.Id, returned.Id); }
private void TransferModelToTaskItem(DietPlan dietPlan) { TodayTasks = new List <DietPlanTaskItem>(); foreach (var subDietPlan in dietPlan.SubDietPlans) { DietPlanTaskItem dietPlanTaskItem = new DietPlanTaskItem() { Id = subDietPlan.Id, Score = subDietPlan.Score, StartTime = subDietPlan.StartTime }; FoodTaskList foodTasks = new FoodTaskList(); //FoodTaskItem[] foodTasks = new FoodTaskItem[] { }; foreach (var dietPlanItem in subDietPlan.DietPlanItems) { FoodTaskItem foodTaskItem = new FoodTaskItem() { Id = dietPlanItem.Id, Amount = (int)dietPlanItem.Amount, Calorie = (int)dietPlanItem.Food.Calorie, FoodName = dietPlanItem.Food.Name }; foodTasks.Add(foodTaskItem); } dietPlanTaskItem.FoodTasks = foodTasks; TodayTasks.Add(dietPlanTaskItem); } }
public ActionResult Edit(int id, DietPlan dietPlan) { var dateValidation = _validator.Validate(dietPlan); dateValidation.AddToModelState(ModelState, null); if (!dateValidation.IsValid) { return(View(dietPlan)); } if (!ModelState.IsValid) { return(View(dietPlan)); } try { var username = Username; _dietPlanService.Edit(id, dietPlan, username); return(RedirectToAction(nameof(Index))); } catch { return(View(dietPlan)); } }
public DietPlan Create(DietPlan newDietPlan, string username) { newDietPlan.DailyDietPlanList = new List <DailyDietPlan>(); if (ListAllDietPlans(newDietPlan.UserId).Count == 0) { newDietPlan.PlanNo = 1; } else { newDietPlan.PlanNo = ListAllDietPlans(newDietPlan.UserId).Max(d => d.PlanNo) + 1; } for (var i = 0; i < newDietPlan.Duration.Days; i++) { newDietPlan.DailyDietPlanList.Add(new DailyDietPlan() { DayNumber = i + 1, Date = newDietPlan.StartDate + new TimeSpan(i, 0, 0, 0), ProductListForDay = new List <ProductInDietPlan>() } ); } _dietPlanRepository.InsertDietPlan(newDietPlan); var client = _httpClientFactory.CreateClient(); var action = CreateAction(ActionType.AddedDietPlan, newDietPlan.Id, newDietPlan.DailyDietPlanList.Count, username, newDietPlan.CaloriesPerDay); client.PostAsync("https://localhost:5001/VirtusFit/plan/dietplan", new StringContent(JsonSerializer.Serialize(action), Encoding.UTF8, "application/json")); return(newDietPlan); }
public void SendTasks(DietPlan dietPlan, Action <ResponseMessage, DietPlan> callback) { if (_connectionStore.IsConnectionEstablished) { TransferModelToTaskItem(dietPlan); var scheduleItems = new ScheduleItemCollection(); foreach (var taskItem in TodayTasks) { var scheduleItem = new ScheduleItem() { UserId = dietPlan.User.Id, ConnectionId = _connectionStore.ConnectionId, StartTime = taskItem.StartTime, Message = TransferTaskItemToXml(taskItem) }; scheduleItems.Add(scheduleItem); } AsychronousLoadHelper.AsychronousCall(() => { var scheduleService = new ScheduleService(); var response = scheduleService.AddSchedule(scheduleItems); callback(response, dietPlan); }); } }
public static DietPlan GetDietPlan(string species) { //Ryan DietPlan dietPlan = (from d in context.DietPlans where d.DietPlanId.Equals(species) select d).First(); return(dietPlan); }
public void SendTasks(DietPlan dietPlan, Action<ResponseMessage, DietPlan> callback) { if (_connectionStore.IsConnectionEstablished) { TransferModelToTaskItem(dietPlan); var scheduleItems = new ScheduleItemCollection(); foreach (var taskItem in TodayTasks) { var scheduleItem = new ScheduleItem() { UserId = dietPlan.User.Id, ConnectionId = _connectionStore.ConnectionId, StartTime = taskItem.StartTime, Message = TransferTaskItemToXml(taskItem) }; scheduleItems.Add(scheduleItem); } AsychronousLoadHelper.AsychronousCall(() => { var scheduleService = new ScheduleService(); var response = scheduleService.AddSchedule(scheduleItems); callback(response, dietPlan); }); } }
private void UpdateDietPlan() { Console.WriteLine("What diet plan would you like to change?"); int amountOfDietPlans = Query.DisplayAndCountAllDietPlans(); string userInput = Console.ReadLine(); try { int dietPlanId = Convert.ToInt32(userInput); UserInterface.DisplayAboutToUpdate(); DietPlan dietPlan = new DietPlan(); if (amountOfDietPlans >= dietPlanId) { dietPlan.Name = UserInterface.GetStringDataWithoutIs("set the name to", "would you like to"); dietPlan.FoodType = UserInterface.GetStringDataWithoutIs("set the food type to", "would you like to"); dietPlan.FoodAmountInCups = int.Parse(UserInterface.GetStringData("you would like to set for this diet plan", "amount of food in cups")); Query.UpdateDietPlan(dietPlan, dietPlanId); return; } else { UserInterface.DisplayUserOptions("Input not accepted please try again"); UpdateDietPlan(); return; } } catch { UserInterface.DisplayUserOptions("Input not accepted please try again"); UpdateDietPlan(); return; } }
internal static DietPlan GetDietPlan() { HumaneSocietyDataContext DB = new HumaneSocietyDataContext(); DietPlan newDietPlan = new DietPlan(); int exists = CheckDietPlans(); if (exists != 0) { CheckDietPlans(); } else { Console.WriteLine("This diet plan does not exist yet. You will need to enter some information."); Console.WriteLine("What is the name of the diet plan?"); var newDietPlanName = Console.ReadLine(); Console.WriteLine("What type of food does this animal eat?"); var newDietPlanFood = Console.ReadLine(); Console.WriteLine("How much food (in cups) does this animal consume?"); var newDietPlanFoodAmount = Int32.Parse(Console.ReadLine()); newDietPlan.Name = newDietPlanName; newDietPlan.FoodType = newDietPlanFood; newDietPlan.FoodAmountInCups = newDietPlanFoodAmount; DB.SubmitChanges(); } return(newDietPlan); }
internal static int?GetDietPlanId() { Console.WriteLine("What is the Diet Plan ID?"); string dietPlanName = Console.ReadLine(); string diet = UserInterface.GetStringData("diet", "the animal's"); int amount = UserInterface.GetIntegerData("amount", "the animal's"); try { var query = (from dietPlan in db.DietPlans where dietPlan.FoodType == diet select dietPlan.ID).First(); return((int)query); } catch { DietPlan newDP = new DietPlan { FoodType = diet, amount = amount }; db.DietPlans.InsertOnSubmit(newDP); return(newDP.DietPlanId); } }
public override void SaveContent(object obj) { try { ShowLoader(); DietPlan dietPlan = Item as DietPlan; dietPlan.BranchId = SessionManager.BranchId; DataTable dtPlanDetails = new DataTable(); dtPlanDetails.Columns.Add(new DataColumn("MealTimeId", typeof(int))); dtPlanDetails.Columns.Add(new DataColumn("D_Mon", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Tue", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Wed", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Thu", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Fri", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Sat", typeof(string))); dtPlanDetails.Columns.Add(new DataColumn("D_Sun", typeof(string))); if (dietPlan.DietPlanDetails != null && dietPlan.DietPlanDetails.Count > 0) { foreach (DietPlanDetails plandetails in dietPlan.DietPlanDetails) { DataRow dr = dtPlanDetails.NewRow(); dr["MealTimeId"] = plandetails.MealTime.MealTimeId; dr["D_Mon"] = plandetails.D_Mon; dr["D_Tue"] = plandetails.D_Tue; dr["D_Wed"] = plandetails.D_Wed; dr["D_Thu"] = plandetails.D_Thu; dr["D_Fri"] = plandetails.D_Fri; dr["D_Sat"] = plandetails.D_Sat; dr["D_Sun"] = plandetails.D_Sun; dtPlanDetails.Rows.Add(dr); } } int MealTimeId = new DietPlanDao().DietPlanInsUpd(dietPlan, dtPlanDetails, SessionManager.UserId); if (MealTimeId > 0) { IsDialogOpen = false; HideLoader(); StartIndex = 1; RefreshItems(); new Toaster().ShowSuccess("Diet Plan Saved successfully."); } else { HideLoader(); new Toaster().ShowError("Error occured while saving."); } } catch (Exception) { HideLoader(); new Toaster().ShowError("Error occured while saving."); } }
public DietPlan DietPlanById(int dietPlanId) { DietPlan dietPlan = null; try { var param = new DbParam[1]; param[0] = new DbParam("@DietPlanId", dietPlanId, SqlDbType.Int); DataSet ds = Db.GetDataSet("SP_DIETPLAN_BY_ID", param); if (ds != null && ds.Tables.Count > 1) { dietPlan = new DietPlan(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { dietPlan = new DietPlan(); dietPlan.DietPlanId = Db.ToInteger(row["DietPlanId"]); dietPlan.PlanName = Db.ToString(row["PlanName"]); dietPlan.IsActive = Db.ToBoolean(row["IsActive"]); } } if (ds.Tables[1].Rows.Count > 0) { IList <DietPlanDetails> dietPlanDetails = new List <DietPlanDetails>(); foreach (DataRow row in ds.Tables[1].Rows) { DietPlanDetails dietPlanDetail = new DietPlanDetails(); dietPlanDetail.MealTime.MTime = Db.ToDateTime(row["MealTime"]); dietPlanDetail.MealTime.MealTimeId = Db.ToInteger(row["MealTimeId"]); dietPlanDetail.D_Mon = Db.ToString(row["D_Mon"]); dietPlanDetail.D_Tue = Db.ToString(row["D_Tue"]); dietPlanDetail.D_Wed = Db.ToString(row["D_Wed"]); dietPlanDetail.D_Thu = Db.ToString(row["D_Thu"]); dietPlanDetail.D_Fri = Db.ToString(row["D_Fri"]); dietPlanDetail.D_Sat = Db.ToString(row["D_Sat"]); dietPlanDetail.D_Sun = Db.ToString(row["D_Sun"]); dietPlanDetails.Add(dietPlanDetail); } dietPlan.DietPlanDetails = dietPlanDetails; } } } catch (Exception ex) { //CommonFunctions.LogError(ex, ErrorLog.LogSeverity.Error); } return(dietPlan); }
public ActionResult DeleteConfirmed(int id) { DietPlan dietPlan = db.DietPlan.Find(id); db.DietPlan.Remove(dietPlan); db.SaveChanges(); return(RedirectToAction("Index")); }
internal static void AddDietPlanId(string dietPlanName) { DietPlan newDietPlan = new DietPlan(); newDietPlan.Name = dietPlanName; db.DietPlans.InsertOnSubmit(newDietPlan); db.SubmitChanges(); }
public IActionResult CreateNew(int creatorId, string creatorName) { var viewModel = new DietPlan { PersonId = creatorId, CreatorName = creatorName }; return(View(viewModel)); }
private static void AddNewDiet(string foodType, int foodAmount) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); DietPlan newDietPlan = new DietPlan(); newDietPlan.food = foodType; newDietPlan.amount = foodAmount; db.DietPlans.InsertOnSubmit(newDietPlan); db.SubmitChanges(); }
internal static void UpdateDietPlan(DietPlan dietPlan, int dietPlanIdNum) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); DietPlan dietPlanToUpdate = db.DietPlans.Where(d => d.DietPlanId == dietPlanIdNum).Single(); dietPlanToUpdate.Name = dietPlan.Name; dietPlanToUpdate.FoodType = dietPlan.FoodType; dietPlanToUpdate.FoodAmountInCups = dietPlan.FoodAmountInCups; db.SubmitChanges(); }
// END CUT HERE // BEGIN CUT HERE public static void Main() { try { DietPlan ___test = new DietPlan(); ___test.run_test(-1); } catch (Exception e) { //Console.WriteLine(e.StackTrace); Console.WriteLine(e.ToString()); } }
internal static DietPlan GetDietPlan() { DietPlan dietPlan = new DietPlan(); dietPlan.DietPlanId = UserInterface.GetIntegerData(); dietPlan.Name = UserInterface.GetStringData("species", "the animal's"); dietPlan.FoodType = UserInterface.GetStringData("food type", "the animal's"); dietPlan.FoodAmountInCups = UserInterface.GetIntegerData(); return(dietPlan); }
// END CUT HERE // BEGIN CUT HERE public static void Main() { try { DietPlan ___test = new DietPlan(); ___test.run_test(-1); } catch(Exception e) { //Console.WriteLine(e.StackTrace); Console.WriteLine(e.ToString()); } }