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