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