public IEnumerable <SubcategoryId> GetDeleted()
{
return(Subcategories
.Where(subcategory => subcategory.Deleted)
.Select(x => new SubcategoryId(x.Id))
.ToList());
}
public IEnumerable <Subcategory> GetModified()
{
return(Subcategories
.Where(subcategory => subcategory.Deleted)
.Select(x => Subcategory.Create(new SubcategoryId(x.Id), x.Name, x.Category))
.ToList());
}
public string AddItem(int UserID, string Base64, string ItemImg, int[] ColorIDArray, int[] SeasonIDArray, int SubcategoryID, int RateID, string ItemMeasure, string ItemCompany, string ItemComment)
{
Users user = new Users(UserID);
Subcategories subcategory = new Subcategories(SubcategoryID);
List <ColorOfItem> colorsOfItem = new List <ColorOfItem>();
foreach (var ColorID in ColorIDArray)
{
colorsOfItem.Add(new ColorOfItem(new Colors(ColorID)));
}
List <SeasonOfItem> seasonsOfItem = new List <SeasonOfItem>();
foreach (var SeasonID in SeasonIDArray)
{
seasonsOfItem.Add(new SeasonOfItem(new Seasons(SeasonID)));
}
Rates rate = new Rates(RateID);
Items item = new Items(ItemImg, colorsOfItem, seasonsOfItem, rate, ItemMeasure, ItemCompany, ItemComment);
return(new JavaScriptSerializer().Serialize(Operations.AddItem(user, item, subcategory, Base64)));
}
public async Task <IActionResult> Edit(int id, [Bind("SubId,SubName,CatId")] Subcategories subcategories)
{
if (id != subcategories.SubId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(subcategories);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubcategoriesExists(subcategories.SubId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CatId"] = new SelectList(_context.Categories, "CatId", "CatName", subcategories.CatId);
return(View(subcategories));
}
private List <WargameUnit> GetUnits(List <CollectionItemValueHolder> references)
{
var units = new List <WargameUnit>();
instanceIdToUnitId = GetInstanceIdToUnitIdMap(references);
unitIdToUnit = new Dictionary <uint, WargameUnit>();
unitIdToTransports = new Dictionary <uint, List <uint> >();
unitUpgradeTree = new Dictionary <uint, uint>(); //<unit, next unit>
BuildUnitUpgradeTree();
foreach (var reference in references)
{
NdfMap map = (NdfMap)reference.Value;
var unit = GetUnit(map);
uint unitId = (uint)((NdfUInt32)map.Key.Value).Value;
unitIdToTransports[unitId] = GetTransportsIds(unit);
var rawCategory = GetCategory(unit);
Categories category = categories.ContainsKey(rawCategory) ? categories[rawCategory] : Categories.UNKNOWN;
var modulesProperty = unit.PropertyValues.Where(p => p.Property.Name == "Modules").First();
var modules = (NdfCollection)modulesProperty.Value;
var filteredList = modules.Where(m => ((NdfStringReference)((NdfString)((NdfMap)m.Value).Key.Value).Value).Value == "TypeUnit").First();
var tModuleSelector = ((NdfObjectReference)((MapValueHolder)((NdfMap)filteredList.Value).Value).Value).Instance;
var defaultProperty = tModuleSelector.PropertyValues.Where(p => p.Property.Name == "Default").First();
var typeUnitModuleDescriptor = ((NdfObjectReference)defaultProperty.Value).Instance;
var filtersProperty = typeUnitModuleDescriptor.PropertyValues.Where(p => p.Property.Name == "Filters").First();
var subCategoryLocalizationHash = "None";
if (filtersProperty.Value.GetType() == typeof(NdfMapList))
{
subCategoryLocalizationHash = ((NdfCollection)((MapValueHolder)((NdfMap)((NdfMapList)filtersProperty.Value)[0].Value).Value).Value)[0].Value.ToString();
}
Subcategories subcategory = subcategories.ContainsKey(subCategoryLocalizationHash) ? subcategories[subCategoryLocalizationHash] : Subcategories.NONE;
var wUnit = new WargameUnit(unitId, GetNumberOfCards(unit), category, subcategory, GetYear(unit), GetCountry(unit), IsPrototype(unit), IsCommander(unit), GetName(unit));
wUnit.AvailableVeterancy.AddRange(GetAvailableVeterancy(unit));
List <Specializations> specs = GetAvailableSpecializations(unit);
foreach (var spec in specs)
{
wUnit.Specializations.Add(spec);
}
units.Add(wUnit);
unitIdToUnit[unitId] = wUnit;
}
foreach (var unit in units)
{
foreach (var transportId in unitIdToTransports[unit.UnitId])
{
unit.Transports.Add(unitIdToUnit[transportId]);
}
}
return(units);
}
public void AddSubcategory()
{
JobSubcategory item = new JobSubcategory();
item.JobCategory = SelectedCategory;
JobSubcategoryRepository.Instance.SetItem(item);
Subcategories.Add(item);
SelectedSubcategory = item;
}
public void AddSubcategory(Subcategory subcategory)
{
var subcategories = new Subcategories()
{
Id = subcategory.Id,
Category = subcategory.Category,
Name = subcategory.ToString()
};
context.Subcategories.Add(subcategories);
}
/// <summary>
/// Level of detailed information in this object (as we usually get data shaped objects and those are cached).
/// 0: no details
/// 1: subcategories
/// 2: courses
/// </summary>
/// <returns>A byte with the level of detailed information in this object.</returns>
public byte GetDetailLevel()
{
if (Courses.Any())
{
return(2);
}
if (Subcategories.Any())
{
return(1);
}
return(0);
}
public async Task <IActionResult> Create([Bind("SubId,SubName,CatId")] Subcategories subcategories)
{
if (ModelState.IsValid)
{
_context.Add(subcategories);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CatId"] = new SelectList(_context.Categories, "CatId", "CatName", subcategories.CatId);
return(View(subcategories));
}
public void FilterSubcategories()
{
var categoryId = SelectedCategory.Id;
var subcategories = AllSubcategories.Where(a => a.CategoryId == categoryId).ToList();
Subcategories.Clear();
foreach (var item in subcategories)
{
Subcategories.Add(item);
}
;
}
public void DeleteSubcategory()
{
if (SelectedSubcategory == null)
{
return;
}
JobSubcategoryRepository.Instance.RemoveItem(SelectedSubcategory);
Subcategories.Remove(SelectedSubcategory);
SubcategoryName = "";
SubcategoryDescription = "";
}
void ITwentyThreeParsable.Load(System.Xml.XmlReader reader)
{
if (reader.LocalName != "category")
{
UtilityMethods.CheckParsingException(reader);
}
while (reader.MoveToNextAttribute())
{
switch (reader.LocalName)
{
case "name":
CategoryName = reader.Value;
break;
case "path":
Path = reader.Value;
break;
case "pathids":
PathIds = reader.Value;
break;
default:
UtilityMethods.CheckParsingException(reader);
break;
}
}
reader.Read();
while (reader.LocalName == "subcat" || reader.LocalName == "group")
{
if (reader.LocalName == "subcat")
{
var c = new Subcategory();
((ITwentyThreeParsable)c).Load(reader);
Subcategories.Add(c);
}
else
{
var s = new Group();
((ITwentyThreeParsable)s).Load(reader);
Groups.Add(s);
}
}
// Skip to next element (if any)
reader.Skip();
}
public WargameUnit(uint unitId, uint cards, Categories category, Subcategories subcategory, uint year, string country, bool isPrototype, bool isCommander, string name)
{
UnitId = unitId;
Cards = cards;
Category = category;
Subcategory = subcategory;
Year = year;
Country = country;
IsPrototype = isPrototype;
IsCommander = isCommander;
Name = name;
Transports = new List <WargameUnit>();
AvailableVeterancy = new List <uint>();
Specializations = new HashSet <Specializations>();
}
public ActionResult AddCategories(Subcategories uc)
{
try
{
_sbcontext.Add(uc);
_sbcontext.SaveChanges();
ViewBag.message = uc.CName + "has successfully registered";
return(RedirectToAction(""));
}
catch (Exception e)
{
ViewBag.message = uc.CName + "Registration failed";
}
return(View());
}
public void Search()
{
if (!string.IsNullOrWhiteSpace(SearchText))
{
MakeAllCategories(visible: false);
foreach (var item in Subcategories.Where(x => x.Name.Equals(SearchText) ||
x.Category.Equals(SearchText)))
{
item.Visible = true;
}
}
else
{
MakeAllCategories(visible: true);
}
}
/// <summary>
/// The populate categories.
/// </summary>
/// <param name="category">
/// The category.
/// </param>
private void populateCategories(Category_V02 category)
{
var prodList = new List <UICategoryProduct>();
prodList = getAllProducts(category, category, prodList);
if (prodList != null)
{
Subcategories.DataSource = prodList;
Subcategories.DataBind();
refreshBreadcrumbs();
}
else
{
LoggerHelper.Error(string.Format("No category found for {0}", CategoryDropdown.SelectedValue));
}
}
public async Task Init()
{
var categories = await _categoryService.Get <IList <CategoryDto> >();
AllSubcategories = await _subcategoryService.Get <IList <SubcategoryDto> >();
Categories.Clear();
Subcategories.Clear();
foreach (var item in categories)
{
Categories.Add(item);
}
foreach (var item in AllSubcategories)
{
Subcategories.Add(item);
}
}
private void SearchBySubcategoryName(string name)
{
Subcategories.Clear();
if (!string.IsNullOrEmpty(name) || !string.IsNullOrWhiteSpace(name))
{
foreach (Category c in allSubcategories)
{
if (c.Name.ToUpper().Contains(name.ToUpper()))
{
Subcategories.Add(c);
}
}
}
else
{
foreach (Category c in allSubcategories)
{
Subcategories.Add(c);
}
}
}
static public object RegisterUser(Users user)
{
SqlDataReader sdr = null;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "RegisterUser";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@UserEmail", user.UserEmail));
cmd.Parameters.Add(new SqlParameter("@UserPass", user.UserPass));
cmd.Parameters.Add(new SqlParameter("@UserFirstName", user.UserFirstName));
cmd.Parameters.Add(new SqlParameter("@UserLastName", user.UserLastName));
cmd.Parameters.Add(new SqlParameter("@GenderID", user.Gender.GenderID));
cmd.Connection = getCon();
sdr = cmd.ExecuteReader();
user = null;
if (sdr.Read())
{
Genders gender = new Genders(int.Parse(sdr["GenderID"].ToString()), sdr["GenderName"].ToString());
user = new Users(int.Parse(sdr["UserID"].ToString()), sdr["UserEmail"].ToString(), sdr["UserPass"].ToString(), sdr["UserFirstName"].ToString(), sdr["UserLastName"].ToString(), gender);
}
else
{
return(null);
}
List <Categories> categories = new List <Categories>();
sdr.NextResult();
while (sdr.Read())
{
Subcategories subcategory = new Subcategories(int.Parse(sdr["SubcategoryID"].ToString()), sdr["SubcategoryName"].ToString());
Categories category = new Categories(int.Parse(sdr["CategoryID"].ToString()), sdr["CategoryName"].ToString(), subcategory);
categories.Add(category);
}
List <Colors> colors = new List <Colors>();
sdr.NextResult();
while (sdr.Read())
{
Colors color = new Colors(int.Parse(sdr["ColorID"].ToString()), sdr["ColorName"].ToString());
colors.Add(color);
}
List <Seasons> seasons = new List <Seasons>();
sdr.NextResult();
while (sdr.Read())
{
Seasons season = new Seasons(int.Parse(sdr["SeasonID"].ToString()), sdr["SeasonName"].ToString());
seasons.Add(season);
}
List <Rates> rates = new List <Rates>();
sdr.NextResult();
while (sdr.Read())
{
Rates rate = new Rates(int.Parse(sdr["RateID"].ToString()), sdr["RateName"].ToString());
rates.Add(rate);
}
return(new { user, categories, colors, seasons, rates });
}
catch (Exception e)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
sdr.Close();
con.Close();
}
}
return(null);
}
static public Items AddItem(Users user, Items itemFromWeb, Subcategories subcategory, string Base64)
{
string imgRef;
if (Base64 != "")
{
File.WriteAllBytes(HttpContext.Current.Server.MapPath(@"~/images/" + itemFromWeb.ItemImg), Convert.FromBase64String(Base64));
imgRef = @"http://185.60.170.14/plesk-site-preview/ruppinmobile.ac.il/site05/images/" + itemFromWeb.ItemImg;
}
else
{
imgRef = "";
}
SqlDataReader sdr = null;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@UserID", user.UserID));
cmd.Parameters.Add(new SqlParameter("@ItemImg", imgRef));
cmd.Parameters.Add(new SqlParameter("@SubcategoryID", subcategory.SubcategoryID));
cmd.Parameters.Add(new SqlParameter("@RateID", itemFromWeb.Rate.RateID));
cmd.Parameters.Add(new SqlParameter("@ItemMeasure", itemFromWeb.ItemMeasure));
cmd.Parameters.Add(new SqlParameter("@ItemCompany", itemFromWeb.ItemCompany));
cmd.Parameters.Add(new SqlParameter("@ItemComment", itemFromWeb.ItemComment));
cmd.Connection = getCon();
sdr = cmd.ExecuteReader();
subcategory = null;
Rates rate = null;
Items item = null;
if (sdr.Read())
{
subcategory = new Subcategories(int.Parse(sdr["SubcategoryID"].ToString()), sdr["SubcategoryName"].ToString());
Categories category = new Categories(int.Parse(sdr["CategoryID"].ToString()), sdr["CategoryName"].ToString(), subcategory);
rate = new Rates(int.Parse(sdr["RateID"].ToString()), sdr["RateName"].ToString());
item = new Items(int.Parse(sdr["ItemID"].ToString()), sdr["ItemImg"].ToString(), category, rate, sdr["ItemMeasure"].ToString(), sdr["ItemCompany"].ToString(), sdr["ItemComment"].ToString());
}
else
{
return(null);
}
sdr.Close();
foreach (var ColorOfItem in itemFromWeb.ColorsOfItem)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertColorToItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
cmd.Parameters.Add(new SqlParameter("@ColorID", ColorOfItem.Color.ColorID));
cmd.ExecuteNonQuery();
}
sdr.Close();
foreach (var SeasonOfItem in itemFromWeb.SeasonsOfItem)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSeasonToItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
cmd.Parameters.Add(new SqlParameter("@SeasonID", SeasonOfItem.Season.SeasonID));
cmd.ExecuteNonQuery();
}
sdr.Close();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllColorsOfItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
sdr = cmd.ExecuteReader();
List <ColorOfItem> colorsOfItems = new List <ColorOfItem>();
while (sdr.Read())
{
Colors color = new Colors(int.Parse(sdr["ColorID"].ToString()), sdr["ColorName"].ToString());
ColorOfItem coi = new ColorOfItem(int.Parse(sdr["ItemID"].ToString()), color);
colorsOfItems.Add(coi);
}
sdr.Close();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllSeasonsOfItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
sdr = cmd.ExecuteReader();
List <SeasonOfItem> seasonsOfItems = new List <SeasonOfItem>();
while (sdr.Read())
{
Seasons season = new Seasons(int.Parse(sdr["SeasonID"].ToString()), sdr["SeasonName"].ToString());
SeasonOfItem soi = new SeasonOfItem(int.Parse(sdr["ItemID"].ToString()), season);
seasonsOfItems.Add(soi);
}
item.ColorsOfItem = colorsOfItems;
item.SeasonsOfItem = seasonsOfItems;
return(item);
}
catch (Exception e)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
sdr.Close();
con.Close();
}
}
return(null);
}
static public object LoginUser(Users user)
{
SqlDataReader sdr = null;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "LoginUser";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@UserEmail", user.UserEmail));
cmd.Parameters.Add(new SqlParameter("@UserPass", user.UserPass));
cmd.Connection = getCon();
sdr = cmd.ExecuteReader();
List <ColorOfItem> colorsOfItems = new List <ColorOfItem>();
while (sdr.Read())
{
Colors color = new Colors(int.Parse(sdr["ColorID"].ToString()), sdr["ColorName"].ToString());
ColorOfItem coi = new ColorOfItem(int.Parse(sdr["ItemID"].ToString()), color);
colorsOfItems.Add(coi);
}
sdr.NextResult();
List <SeasonOfItem> seasonsOfItems = new List <SeasonOfItem>();
while (sdr.Read())
{
Seasons season = new Seasons(int.Parse(sdr["SeasonID"].ToString()), sdr["SeasonName"].ToString());
SeasonOfItem soi = new SeasonOfItem(int.Parse(sdr["ItemID"].ToString()), season);
seasonsOfItems.Add(soi);
}
sdr.NextResult();
List <Items> items = new List <Items>();
while (sdr.Read())
{
int itemIDFromDB = int.Parse(sdr["ItemID"].ToString());
List <ColorOfItem> listOfColors = colorsOfItems.FindAll(Item => Item.ItemID == itemIDFromDB);
List <SeasonOfItem> listOfSeasons = seasonsOfItems.FindAll(Item => Item.ItemID == itemIDFromDB);
Subcategories subcategory = new Subcategories(int.Parse(sdr["SubcategoryID"].ToString()), sdr["SubcategoryName"].ToString());
Categories category = new Categories(int.Parse(sdr["CategoryID"].ToString()), sdr["CategoryName"].ToString(), subcategory);
Rates rate = new Rates(int.Parse(sdr["RateID"].ToString()), sdr["RateName"].ToString());
Items item = new Items(int.Parse(sdr["ItemID"].ToString()), sdr["ItemImg"].ToString(), category, listOfColors, listOfSeasons, rate, sdr["ItemMeasure"].ToString(), sdr["ItemCompany"].ToString(), sdr["ItemComment"].ToString());
items.Add(item);
}
user = null;
sdr.NextResult();
if (sdr.Read())
{
Genders gender = new Genders(int.Parse(sdr["GenderID"].ToString()), sdr["GenderName"].ToString());
user = new Users(int.Parse(sdr["UserID"].ToString()), sdr["UserEmail"].ToString(), sdr["UserPass"].ToString(), sdr["UserFirstName"].ToString(), sdr["UserLastName"].ToString(), gender);
}
else
{
return(null);
}
List <Categories> categories = new List <Categories>();
sdr.NextResult();
while (sdr.Read())
{
Subcategories subcategory = new Subcategories(int.Parse(sdr["SubcategoryID"].ToString()), sdr["SubcategoryName"].ToString());
Categories category = new Categories(int.Parse(sdr["CategoryID"].ToString()), sdr["CategoryName"].ToString(), subcategory);
categories.Add(category);
}
List <Colors> colors = new List <Colors>();
sdr.NextResult();
while (sdr.Read())
{
Colors color = new Colors(int.Parse(sdr["ColorID"].ToString()), sdr["ColorName"].ToString());
colors.Add(color);
}
List <Seasons> seasons = new List <Seasons>();
sdr.NextResult();
while (sdr.Read())
{
Seasons season = new Seasons(int.Parse(sdr["SeasonID"].ToString()), sdr["SeasonName"].ToString());
seasons.Add(season);
}
List <Rates> rates = new List <Rates>();
sdr.NextResult();
while (sdr.Read())
{
Rates rate = new Rates(int.Parse(sdr["RateID"].ToString()), sdr["RateName"].ToString());
rates.Add(rate);
}
return(new { user, items, categories, colors, seasons, rates });
}
catch (Exception e)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
sdr.Close();
con.Close();
}
}
return(null);
}
public void SaveNewSubcategory(Subcategory model)
{
Subcategories.Add(model);
SaveChanges();
}
public Category GetCategoryForSubcategory(int id)
{
return(Subcategories.First(sub => sub.ID == id)?.Category);
}
public void DeleteSubcategory(Subcategory subcategory)
{
Subcategories.Remove(subcategory);
SaveChanges();
}
public void SetWeigth(Subcategories category, double weigth)
{
subCategoryWeights[category] = weigth;
}
public virtual void AddSubCategory(Category category)
{
Subcategories.Add(category);
category.Parent = this;
}
static public Items EditItem(Items itemFromWeb, Subcategories subcategory, string Base64, string OldItemImg)
{
string imgRef;
if (Base64 == OldItemImg) // המשתמש לא לקח תמונה חדשה
{
imgRef = OldItemImg; // תשאיר את התמונה הקודמת
}
else
{
if (OldItemImg != "") // התמונה הקודמת היא תמונה אמיתית
{
string nameOfImg = "~";
if (OldItemImg.Contains(@"/images/"))
{
for (int i = 0; i < OldItemImg.Length; i++)
{
if (OldItemImg[i] == '/' && OldItemImg[i + 1] == 'i' && OldItemImg[i + 2] == 'm' && OldItemImg[i + 3] == 'a' && OldItemImg[i + 4] == 'g' && OldItemImg[i + 5] == 'e' && OldItemImg[i + 6] == 's' && OldItemImg[i + 7] == '/')
{
nameOfImg += OldItemImg.Substring(i);
break;
}
}
}
File.Delete(HttpContext.Current.Server.MapPath(nameOfImg)); // תמחק אותה
// שים תמונה חדשה
File.WriteAllBytes(HttpContext.Current.Server.MapPath(@"~/images/" + itemFromWeb.ItemImg), Convert.FromBase64String(Base64));
imgRef = @"http://185.60.170.14/plesk-site-preview/ruppinmobile.ac.il/site05/images/" + itemFromWeb.ItemImg;
}
else // התמונה הקודמת היא דיפולט
{
if (Base64 != "") // יש תמונה חדשה
{
File.WriteAllBytes(HttpContext.Current.Server.MapPath(@"~/images/" + itemFromWeb.ItemImg), Convert.FromBase64String(Base64));
imgRef = @"http://185.60.170.14/plesk-site-preview/ruppinmobile.ac.il/site05/images/" + itemFromWeb.ItemImg;
}
else // אין תמונה חדשה
{
imgRef = OldItemImg;
}
}
}
SqlDataReader sdr = null;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "EditItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", itemFromWeb.ItemID));
cmd.Parameters.Add(new SqlParameter("@ItemImg", imgRef));
cmd.Parameters.Add(new SqlParameter("@SubcategoryID", subcategory.SubcategoryID));
cmd.Parameters.Add(new SqlParameter("@RateID", itemFromWeb.Rate.RateID));
cmd.Parameters.Add(new SqlParameter("@ItemMeasure", itemFromWeb.ItemMeasure));
cmd.Parameters.Add(new SqlParameter("@ItemCompany", itemFromWeb.ItemCompany));
cmd.Parameters.Add(new SqlParameter("@ItemComment", itemFromWeb.ItemComment));
cmd.Connection = getCon();
sdr = cmd.ExecuteReader();
subcategory = null;
Rates rate = null;
Items item = null;
if (sdr.Read())
{
subcategory = new Subcategories(int.Parse(sdr["SubcategoryID"].ToString()), sdr["SubcategoryName"].ToString());
Categories category = new Categories(int.Parse(sdr["CategoryID"].ToString()), sdr["CategoryName"].ToString(), subcategory);
rate = new Rates(int.Parse(sdr["RateID"].ToString()), sdr["RateName"].ToString());
item = new Items(int.Parse(sdr["ItemID"].ToString()), sdr["ItemImg"].ToString(), category, rate, sdr["ItemMeasure"].ToString(), sdr["ItemCompany"].ToString(), sdr["ItemComment"].ToString());
}
else
{
return(null);
}
sdr.Close();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "RemoveColorsAndSeasonsFromItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
cmd.ExecuteNonQuery();
sdr.Close();
foreach (var ColorOfItem in itemFromWeb.ColorsOfItem)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertColorToItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
cmd.Parameters.Add(new SqlParameter("@ColorID", ColorOfItem.Color.ColorID));
cmd.ExecuteNonQuery();
}
sdr.Close();
foreach (var SeasonOfItem in itemFromWeb.SeasonsOfItem)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertSeasonToItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
cmd.Parameters.Add(new SqlParameter("@SeasonID", SeasonOfItem.Season.SeasonID));
cmd.ExecuteNonQuery();
}
sdr.Close();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllColorsOfItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
sdr = cmd.ExecuteReader();
List <ColorOfItem> colorsOfItems = new List <ColorOfItem>();
while (sdr.Read())
{
Colors color = new Colors(int.Parse(sdr["ColorID"].ToString()), sdr["ColorName"].ToString());
ColorOfItem coi = new ColorOfItem(int.Parse(sdr["ItemID"].ToString()), color);
colorsOfItems.Add(coi);
}
sdr.Close();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllSeasonsOfItem";
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@ItemID", item.ItemID));
sdr = cmd.ExecuteReader();
List <SeasonOfItem> seasonsOfItems = new List <SeasonOfItem>();
while (sdr.Read())
{
Seasons season = new Seasons(int.Parse(sdr["SeasonID"].ToString()), sdr["SeasonName"].ToString());
SeasonOfItem soi = new SeasonOfItem(int.Parse(sdr["ItemID"].ToString()), season);
seasonsOfItems.Add(soi);
}
item.ColorsOfItem = colorsOfItems;
item.SeasonsOfItem = seasonsOfItems;
return(item);
}
catch (Exception e)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
sdr.Close();
con.Close();
}
}
return(null);
}
public Subcategory GetSubcategory(int id) => Subcategories.Find(id);
protected string ReturnToSubcategoryDetails(int id, string name)
{
return($"/{Subcategories.ToLower()}/{nameof(SubcategoriesController.Details).ToLower()}/{id}?name={name}");
}
public Subcategory GetSubcategory(int id)
{
return(Subcategories.First(sub => sub.ID == id));
}
