public async Task <IActionResult> CreateItem(ITEM_KATEGOR it) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } // проверка на загрузку изоображений if (it.ITEM.IMG_URL_F != null) { string nameItem = Guid.NewGuid().ToString(); // путь к папке Files string path = "/images/item/" + nameItem + ".jpeg"; // сохраняем файл в папку Files в каталоге wwwroot using (var fileStream = new FileStream(_appEnvironment.WebRootPath + path, FileMode.Create)) { await it.ITEM.IMG_URL_F.CopyToAsync(fileStream); } it.ITEM.IMG_URL = CONSTANT.UrlHost + path; } it.Create(); return(Redirect("DetailKategor?ID_KATEGOR=" + it.KATEGOR.ID_KATEGOR)); }
public IActionResult CreateItem(string ID_KATEGOR) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } var it = new ITEM_KATEGOR() { ITEM = new ITEM(), KATEGOR = new KATEGOR() { ID_KATEGOR = ID_KATEGOR } }; return(View(it)); }
public IActionResult EditItem(string ID_ITEM_KATEGOR, string ID_ITEM) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } var it = ITEM_KATEGOR.GetITEM_ITEM_KATEGOR(ID_ITEM_KATEGOR); return(View(it)); }
public IActionResult DeleteItem(string ID_ITEM_KATEGOR, string ID_ITEM) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } ITEM_KATEGOR.Delete(ID_ITEM_KATEGOR, ID_ITEM); var referrer = Request.Headers["Referer"]; return(Redirect(referrer)); }
public IActionResult DetailKategor(string ID_KATEGOR, string NAME_KATEGOR) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } ViewBag.NAME_KATEGOR = NAME_KATEGOR; ViewBag.ID_KATEGOR = ID_KATEGOR; var it = ITEM_KATEGOR.GetITEM_KATEGORs_ADMIN(ID_KATEGOR); return(View(it)); }
public void GetItemsShop(string connectionString, RequestShopClient req) { using (SqlConnection connection = new SqlConnection(connectionString)) { ItemsShop = new List <ITEMS_SHOP>(); string sqlExpression = @"SELECT its.ID_ITEMS_SHOP, its.ID_SHOP, its.ID_ITEM_KATEGOR, its.MIN_PRICE, its.MAX_PRICE, itm.ID_ITEM, itm.NAME_ITEM, itm.NOTE_ITEM, itm.IMG_URL, kat.ID_KATEGOR, kat.NAME_KATEGOR FROM SPAVREMONT.ITEMS_SHOP its JOIN SPAVREMONT.ITEM_KATEGOR itk ON its.ID_ITEM_KATEGOR=itk.ID_ITEM_KATEGOR JOIN SPAVREMONT.ITEM itm ON itk.ID_ITEM=itm.ID_ITEM JOIN SPAVREMONT.KATEGOR kat ON itk.ID_KATEGOR=kat.ID_KATEGOR WHERE its.ID_SHOP='" + req.id_shop + @"' AND kat.ID_KATEGOR='" + req.id_kategor + @"' "; connection.Open(); SqlCommand command = new SqlCommand(); command.CommandText = sqlExpression; command.Connection = connection; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) // если есть данные { //int genreIDIndex = reader.GetOrdinal("GenreID"); //... //while... //GenreID = reader.IsDBNull(genreIDIndex) ? null : reader.GetInt32(genreIDIndex) int itsID_ITEMS_SHOPIndex = reader.GetOrdinal("ID_ITEMS_SHOP"); int itsID_SHOPIndex = reader.GetOrdinal("ID_SHOP"); int itsID_ITEM_KATEGORIndex = reader.GetOrdinal("ID_ITEM_KATEGOR"); int itsMIN_PRICEIndex = reader.GetOrdinal("MIN_PRICE"); int itsMAX_PRICEIndex = reader.GetOrdinal("MAX_PRICE"); int itmID_ITEMIndex = reader.GetOrdinal("ID_ITEM"); int itmNAME_ITEMIndex = reader.GetOrdinal("NAME_ITEM"); int itmNOTE_ITEMIndex = reader.GetOrdinal("NOTE_ITEM"); int itmIMG_URLIndex = reader.GetOrdinal("IMG_URL"); int katID_KATEGORIndex = reader.GetOrdinal("ID_KATEGOR"); int katNAME_KATEGORIndex = reader.GetOrdinal("NAME_KATEGOR"); while (reader.Read()) // построчно считываем данные { ITEM item = new ITEM { ID_ITEM = reader.GetString(itmID_ITEMIndex), IMG_URL = reader.GetString(itmIMG_URLIndex), NAME_ITEM = reader.GetString(itmNAME_ITEMIndex), NOTE_ITEM = reader.GetString(itmNOTE_ITEMIndex) }; KATEGOR kategor = new KATEGOR { ID_KATEGOR = reader.GetString(katID_KATEGORIndex), NAME_KATEGOR = reader.GetString(katNAME_KATEGORIndex) }; ITEM_KATEGOR itemKategor = new ITEM_KATEGOR { ID_ITEM_KATEGOR = reader.GetString(itsID_ITEM_KATEGORIndex), ITEM = item, KATEGOR = kategor }; ITEMS_SHOP items_shop = new ITEMS_SHOP { ID_ITEMS_SHOP = reader.GetString(itsID_ITEMS_SHOPIndex), ID_SHOP = req.id_shop, ITEM_KATEGOR = itemKategor, MAX_PRICE = reader.GetInt32(itsMAX_PRICEIndex), MIN_PRICE = reader.GetInt32(itsMIN_PRICEIndex) }; //Site = reader.IsDBNull(sSiteIndex) ? "" : reader.GetString(sSiteIndex), ItemsShop.Add(items_shop); } } //return shops; } }