public async Task <IActionResult> CreateUslug(USLUG us) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } // проверка на загрузку изоображений if (us.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 us.IMG_URL_F.CopyToAsync(fileStream); } us.IMG_URL = CONSTANT.UrlHost + path; } us.Create(); return(Redirect("Uslug")); }
public IActionResult EditUslug(string ID_USLUG) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } var uslug = USLUG.GetItem(ID_USLUG); return(View(uslug)); }
/////////////////////// // Услуги /////////////////////// #region public IActionResult Uslug() { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } var uslugs = USLUG.GetUSLUGs(); return(View(uslugs)); }
///////////////////////// // Услуги магазина ///////////////////////// #region // [Authorize] public IActionResult Uslug() { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!checkCookiesUslug())// если куки не равны услугам то редиеркт на категории { return(RedirectToAction("Kategor")); } var uslugs = USLUG.GetUSLUGs(); return(View(uslugs)); }
public IActionResult DeleteUslug(string ID_USLUG) { if (!HttpContext.User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } if (!CheckAdmin()) { return(RedirectToAction("index", "Home")); } USLUG.Delete(ID_USLUG); var referrer = Request.Headers["Referer"]; return(Redirect(referrer)); }
public void GetFindUslugs(string connectionString, RequestFindUslug req) { //using настройка запроса выбора товара using (SqlConnection connection = new SqlConnection(connectionString)) { Shops_short_uslug = new List <Shop_short_Uslug>(); //////////// // ОБРАБОТКА ДАННЫХ ПЕРЕД ИНСЕРТОМ /////////// string idUslug = ""; string id_City = req.ID_City;//"6d0eb5f2-01fd-411b-9cf2-318a60b22604";// Москва int intBuyCard = 0; int TimeWayMetro = req.TimeWayMetro; string idMetro = ""; if (req.ID_uslug != null) { idUslug = req.ID_uslug; } // станции метро, если список не пустой if (req.metro != null && req.metro.Count > 0) { for (int i = 0; i < req.metro.Count; i++) { if (i > 0) { idMetro += ","; } idMetro += "'" + req.metro[i].ID_metro + "'"; } } if (req.buy_card) { intBuyCard = 1; } string whereID_Uslug = " AND usl.ID_USLUG = '" + idUslug + "'"; string whereID_CIty = "AND sh.ID_City='" + id_City + "' "; string whereTypeShop = " AND sh.ID_TYPE_SHOP='360eb5f2-0ffd-411b-9cf2-318a60b22604'";// тип оргназации услуги string whereTimeWayMetro = " AND sh.TimeWayMetro<=" + TimeWayMetro.ToString(); string whereID_metro = " AND met.ID_metro in (" + idMetro + ")"; string whereBuy_card = " AND sh.BuyCard=" + intBuyCard.ToString(); if (idUslug == "") { return; } // если оплаты за безнал нет, то тогда выводим все магазины, если есть то выводим только магазины с оплатой по карте if (intBuyCard == 0) { whereBuy_card = ""; } if (req.AllMetro) { whereID_metro = ""; } // параметр отвечает за кол-во минут ходьбы от метро до организации if (TimeWayMetro <= 0) { whereTimeWayMetro = ""; } if (String.IsNullOrEmpty(id_City)) { whereID_CIty = ""; } #region SQL query //string sqlFirstShopUnion = @" "; string sqlExpression = @" SELECT sh.ID_shop, sh.Name, sh.TimeWayMetro, met.ID_Metro, met.station, met.Color_hex, usl.ID_USLUG, usl.NAME_USLUG, usl.NOTE_USLUG, usl.IMG_URL, uss.Price FROM SPAVREMONT.SHOP sh JOIN SPAVREMONT.USLUGS_SHOP uss ON sh.ID_Shop=uss.ID_Shop JOIN SPAVREMONT.USLUG usl ON uss.ID_USLUG=usl.ID_USLUG LEFT JOIN SPAVREMONT.Metro met ON met.ID_Metro=sh.ID_metro WHERE 1=1 AND sh.VISIBLE=1 " + whereID_CIty + @" " + whereID_Uslug + @" " + whereTypeShop + @" " + whereTimeWayMetro + @" " + whereID_metro + @" " + whereBuy_card + @" GROUP BY sh.ID_shop, sh.Name, sh.TimeWayMetro, met.ID_Metro, met.station, met.Color_hex, usl.ID_USLUG, usl.NAME_USLUG, usl.NOTE_USLUG, usl.IMG_URL, uss.Price "; #endregion connection.Open(); SqlCommand command = new SqlCommand(); command.CommandText = sqlExpression; command.Connection = connection; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) // если есть данные { int sID_shopIndex = reader.GetOrdinal("ID_shop"); int sNameIndex = reader.GetOrdinal("Name"); int sTimeWayMetroIndex = reader.GetOrdinal("TimeWayMetro"); int mID_MetroIndex = reader.GetOrdinal("ID_Metro"); int mstationIndex = reader.GetOrdinal("station"); int mColor_hexIndex = reader.GetOrdinal("Color_hex"); int itmID_uslug_index = reader.GetOrdinal("ID_USLUG"); int itmNAME_uslug_index = reader.GetOrdinal("NAME_USLUG"); int itmNOTE_uslug_index = reader.GetOrdinal("NOTE_USLUG"); int itmIMG_URL_index = reader.GetOrdinal("IMG_URL"); int PRICE_Index = reader.GetOrdinal("Price"); while (reader.Read()) // построчно считываем данные { Metro metro = new Metro { ID_metro = reader.IsDBNull(mID_MetroIndex)? "": reader.GetString(mID_MetroIndex), Station = reader.IsDBNull(mstationIndex) ? "" : reader.GetString(mstationIndex), Color_Hex = reader.IsDBNull(mColor_hexIndex) ? "" : reader.GetString(mColor_hexIndex) }; USLUG item_uslug = new USLUG { ID_USLUG = reader.GetString(itmID_uslug_index), IMG_URL = reader.GetString(itmIMG_URL_index), NAME_USLUG = reader.GetString(itmNAME_uslug_index), NOTE_USLUG = reader.GetString(itmNOTE_uslug_index) }; Shop_short_Uslug item = new Shop_short_Uslug { ID_shop = reader.GetString(sID_shopIndex), Name = reader.GetString(sNameIndex), Metro = metro, TimeWayMetro = reader.GetInt32(sTimeWayMetroIndex), Uslug = item_uslug, Price = reader.GetInt32(PRICE_Index), }; Shops_short_uslug.Add(item); } } }//return shops; }
public void GetLoadFiltr(string connectionString, RequestLoadFiltrUslugs req) { using (SqlConnection connection = new SqlConnection(connectionString)) { Uslugs = new List <USLUG>(); Metros = new List <Metro>(); MetroLines = new List <Metro>(); string sqlExpression = ""; connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; //SqlDataReader reader; #region get USLUG sqlExpression = @" SELECT ID_USLUG, NAME_USLUG, NOTE_USLUG, IMG_URL FROM SPAVREMONT.USLUG "; command.CommandText = sqlExpression; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) // если есть данные { int ID_USLUG_Index = reader.GetOrdinal("ID_USLUG"); int NAME_USLUG_Index = reader.GetOrdinal("NAME_USLUG"); int NOTE_USLUG_Index = reader.GetOrdinal("NOTE_USLUG"); int IMG_URL_Index = reader.GetOrdinal("IMG_URL"); while (reader.Read()) // построчно считываем данные { USLUG item = new USLUG { ID_USLUG = reader.GetString(ID_USLUG_Index), NAME_USLUG = reader.GetString(NAME_USLUG_Index), NOTE_USLUG = reader.GetString(NOTE_USLUG_Index), IMG_URL = reader.GetString(IMG_URL_Index) }; Uslugs.Add(item); } } reader.Close(); #endregion #region get metro sqlExpression = @" SELECT m.ID_metro, m.Name_line, m.Station, m.ID_Geo, m.Color_Hex, m.ID_City FROM SPAVREMONT.METRO m JOIN SPAVREMONT.SHOP sh ON m.ID_metro=sh.ID_metro WHERE m.ID_City='" + req.ID_City + @"' AND sh.id_type_shop = '360eb5f2-0ffd-411b-9cf2-318a60b22604' GROUP BY m.ID_metro, m.Name_line, m.Station, m.ID_Geo, m.Color_Hex, m.ID_City ORDER BY m.Station ASC "; command.CommandText = sqlExpression; reader = command.ExecuteReader(); if (reader.HasRows) // если есть данные { //int genreIDIndex = reader.GetOrdinal("GenreID"); //... //while... //GenreID = reader.IsDBNull(genreIDIndex) ? null : reader.GetInt32(genreIDIndex) int ID_metro_Index = reader.GetOrdinal("ID_metro"); int Name_line_Index = reader.GetOrdinal("Name_line"); int Station_Index = reader.GetOrdinal("Station"); // int ID_Geo_Index = reader.GetOrdinal("ID_Geo"); int Color_Hex_Index = reader.GetOrdinal("Color_Hex"); // int ID_city_Index = reader.GetOrdinal("ID_City"); while (reader.Read()) // построчно считываем данные { Metro item = new Metro { ID_metro = reader.GetString(ID_metro_Index), Name_line = reader.GetString(Name_line_Index), Station = reader.GetString(Station_Index), Color_Hex = reader.GetString(Color_Hex_Index) }; Metros.Add(item); } } reader.Close(); #endregion #region get metroLine sqlExpression = @" SELECT m.Name_line, m.Color_Hex FROM SPAVREMONT.METRO m JOIN SPAVREMONT.SHOP sh ON m.ID_metro=sh.ID_metro WHERE m.ID_City='" + req.ID_City + @"' AND sh.id_type_shop = '360eb5f2-0ffd-411b-9cf2-318a60b22604' GROUP BY m.Name_line, m.Color_Hex ORDER BY m.Name_line ASC "; command.CommandText = sqlExpression; reader = command.ExecuteReader(); if (reader.HasRows) // если есть данные { int Name_line_Index = reader.GetOrdinal("Name_line"); int Color_Hex_Index = reader.GetOrdinal("Color_Hex"); int tmp_id = 0; while (reader.Read()) // построчно считываем данные { tmp_id++; Metro item = new Metro { ID_metro = tmp_id.ToString(), Station = reader.GetString(Name_line_Index), Color_Hex = reader.GetString(Color_Hex_Index) }; MetroLines.Add(item); } } // reader.Close(); #endregion }//END using Cities = City.GetCities(); }