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