public List <OutfitViewModel> getOutfits(int userId) { string connectionString = config.GetConnectionString("DefaultConnection"); MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand mySqlCommand = new MySqlCommand(); List <OutfitViewModel> outfits = new List <OutfitViewModel>(); try { conn.Open(); //opening DB connection mySqlCommand.Connection = conn; mySqlCommand.CommandText = "get_outfits"; mySqlCommand.CommandType = CommandType.StoredProcedure; mySqlCommand.Parameters.Add(new MySqlParameter("_user_id", userId)); MySqlDataReader reader = mySqlCommand.ExecuteReader(); while (reader.Read()) { OutfitViewModel outfit = getOutfitViewModelFromReader(reader); outfits.Add(outfit); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } finally { conn.Close(); //closing DB connection } return(outfits); }
// GET: Outfits/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Outfit outfit = db.Outfits.Find(id); if (outfit == null) { return(HttpNotFound()); } ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BotName", outfit.BottomID); ViewBag.OccasionID = new SelectList(db.Occasions, "OccasionID", "OccasionName", outfit.OccasionID); ViewBag.SeasonID = new SelectList(db.Seasons, "SeasonID", "SeasonName", outfit.SeasonID); ViewBag.ShoesID = new SelectList(db.Shoes, "ShoesID", "ShoeName", outfit.ShoesID); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName", outfit.TopID); OutfitViewModel outfitViewModel = new OutfitViewModel { Outfit = outfit, AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel)); }
// GET: Outfits/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Outfit outfit = db.Outfits.Find(id); if (outfit == null) { return(HttpNotFound()); } ViewBag.BottomId = new SelectList(db.Bottoms, "BottomId", "BottomName", outfit.BottomId); ViewBag.ShoeId = new SelectList(db.Shoes, "ShoeId", "ShoeName", outfit.ShoeId); ViewBag.TopId = new SelectList(db.Tops, "TopId", "TopName", outfit.TopId); OutfitViewModel outfitViewModel = new OutfitViewModel { Outfit = outfit, // Look up all accessories, then converts them into // SelectListItem objects AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryId.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel)); }
// GET: Outfits/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Outfit outfit = db.Outfits.Find(id); if (outfit == null) { return(HttpNotFound()); } var outfitViewModel = new OutfitViewModel { Outfit = outfit, AllAccessories = from a in db.Accessories select new SelectListItem { Text = a.AccessoryName, Value = a.AccessoryId.ToString() } }; ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BottomName", outfit.BottomID); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "ShoeName", outfit.ShoeID); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName", outfit.TopID); return(View(outfitViewModel)); //return View(); }
// GET: Outfits/Create public ActionResult Create(int?id) { Outfit outfit = new Outfit(); if (outfit == null) { return(HttpNotFound()); } ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "Name", outfit.BottomID); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "Name", outfit.ShoeID); ViewBag.TopID = new SelectList(db.Tops, "TopID", "Name", outfit.TopID); OutfitViewModel outfitViewModel = new OutfitViewModel { Outfit = outfit, AllAccessories = from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.Name } }; return(View(outfitViewModel)); }
private OutfitViewModel getOutfitViewModelFromReader(MySqlDataReader reader) { OutfitViewModel outfitViewModel = new OutfitViewModel(); outfitViewModel.outfitName = reader["outfit_name"].ToString(); outfitViewModel.clothPicString = Encoding.UTF8.GetString((byte[])reader["cloth_picture"]); return(outfitViewModel); }
/// <summary> /// Returns the List of Outfits /// </summary> /// <returns></returns> public OutfitViewModel Index() { var myData = new OutfitViewModel(); myData.OutfitList = repository.Index(); return(myData); }
public ActionResult Edit([Bind(Include = "OutfitID,OutfitName,TopID,BottomID,ShoeID")] Outfit outfit, List <int> AllAccessories) { if (ModelState.IsValid) { //Changing the entity will not longer work //db.Entry(outfit).State = EntityState.Modified; //Place the data for the assigned outfit into a variable "existing..." var existingOutfit = db.Outfits.Find(outfit.OutfitID); //assigning the data bound form user to the variable we created above existingOutfit.TopID = outfit.TopID; existingOutfit.BottomID = outfit.BottomID; existingOutfit.ShoeID = outfit.ShoeID; //Wipe out all previous accessory choices so no need for logic to determine which //accessories the user previously chose vs. currently chose existingOutfit.Accessories.Clear(); foreach (int accessoryID in AllAccessories) { //find the accessory by its ID and add it to the existing outfit existingOutfit.Accessories.Add(db.Accessories.Find(accessoryID)); } db.SaveChanges(); return(RedirectToAction("Index")); } //If invalid it runds code below var outfitViewModel = new OutfitViewModel { Outfit = outfit, AllAccessories = from a in db.Accessories select new SelectListItem { Text = a.AccessoryName, Value = a.AccessoryId.ToString() } }; ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BottomName", outfit.BottomID); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "ShoeName", outfit.ShoeID); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName", outfit.TopID); return(View(outfitViewModel)); }
public ActionResult Create([Bind(Include = "OutfitID,OutfitName,TopID,BottomID,ShoeID")] Outfit outfit, List <int> AllAccessories) { if (ModelState.IsValid) { //Changing the entity will not longer work //db.Entry(outfit).State = EntityState.Modified; //Place the data for new outfit we bound into the variable "newOutfit" var newOutfit = db.Outfits.Add(outfit); //Place the data from the top, bottom, and shoes we bound into the new outfit newOutfit.TopID = outfit.TopID; newOutfit.BottomID = outfit.BottomID; newOutfit.ShoeID = outfit.ShoeID; //loop through each accessory that was bound foreach (int accessoryID in AllAccessories) { //find the accessory by its ID and add it to the new outfit newOutfit.Accessories.Add(db.Accessories.Find(accessoryID)); } db.SaveChanges(); return(RedirectToAction("Index")); } //If invalid it runs code below ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BottomName"); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "ShoeName"); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName"); OutfitViewModel outfitViewModel2 = new OutfitViewModel { //Looks up all acessories then AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel2)); }
// GET: Outfits/Create public ActionResult Create() { ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BottomName"); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "ShoeName"); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName"); OutfitViewModel outfitViewModel = new OutfitViewModel { //Looks up all acessories then AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel)); }
// GET: Outfits/Create public ActionResult Create() { Outfit outfit = new Outfit(); ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BotName"); ViewBag.OccasionID = new SelectList(db.Occasions, "OccasionID", "OccasionName"); ViewBag.SeasonID = new SelectList(db.Seasons, "SeasonID", "SeasonName"); ViewBag.ShoesID = new SelectList(db.Shoes, "ShoesID", "ShoeName"); ViewBag.TopID = new SelectList(db.Tops, "TopID", "TopName"); OutfitViewModel outfitViewModel = new OutfitViewModel { Outfit = outfit, AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel)); }
// GET: Outfits/Create public ActionResult Create() { Outfit outfit = new Outfit(); ViewBag.BottomID = new SelectList(db.Bottoms, "BottomID", "BottomName"); ViewBag.ShoeID = new SelectList(db.Shoes, "ShoeID", "ShoeName"); ViewBag.TopID = new SelectList(db.Tops, "TopId", "TopName"); OutfitViewModel outfitViewModel = new OutfitViewModel { Outfit = outfit, // Look up all accessories, then converts them into // SelectListItem objects AllAccessories = (from a in db.Accessories select new SelectListItem { Value = a.AccessoryID.ToString(), Text = a.AccessoryName }) }; return(View(outfitViewModel)); }