public async Task <IActionResult> ImgsShop(ImgsShopVM VM)
{
if (!HttpContext.User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
if (ModelState.IsValid)
{
string URL_foto = await LoadIMG("vitrina", VM.IMG_formFile);
if (!String.IsNullOrEmpty(URL_foto))
{
IMG_Shop iMG_Shop = new IMG_Shop
{
ID_SHOP = VM.ID_SHOP,
Type = "VITRINA",
Url = URL_foto
};
iMG_Shop.Create();
}
}
var referrer = Request.Headers["Referer"];
return(Redirect(referrer));
//return RedirectToAction("ImgsShop", "admpanel");
}
/*
*
* private void _GetShops(string connectionString)
* {
*
* using (SqlConnection connection = new SqlConnection(connectionString))
* {
* Shops = new List<Shop>();
*
* string sqlExpression = @"SELECT
* s.ID_shop,
* s.Type,
* s.Name,
* s.Phone,
* s.Site,
* s.Adress,
* m.ID_Metro,
* m.station,
* m.Color_hex,
* (
* SELECT sum(CC.Count_star) AS avg_star FROM SPAVREMONT.Comment_client CC
* WHERE CC.ID_SHOP=S.ID_shop
* AND CC.visible=1
* ) AS AVG_Star,
* (
* SELECT count(*) AS count_feedback FROM SPAVREMONT.Comment_client CC
* WHERE CC.ID_SHOP=S.ID_shop
* AND CC.visible=1
* ) AS Count_feedback
*
* FROM SPAVREMONT.Shop s
* JOIN SPAVREMONT.Metro m ON s.ID_Metro=m.ID_Metro
* WHERE s.Type='Магазин'
* ";
*
* connection.Open();
* SqlCommand command = new SqlCommand();
* command.CommandText = sqlExpression;
* command.Connection = connection;
* SqlDataReader reader = command.ExecuteReader();
*
*
*
*
* while (reader.Read()) // построчно считываем данные
* {
* Metro metro = new Metro
* {
* ID_metro = reader.GetString(mID_MetroIndex),
* Station = reader.GetString(mstationIndex),
* Color_Hex = reader.GetString(mColor_hexIndex)
* };
*
* // подсчет среднего кол-во звезд
* double _avg_star = reader.IsDBNull(AVG_StarIndex) ? 0 : (double)reader.GetInt32(AVG_StarIndex);
* int _Count_feedback = reader.IsDBNull(Count_feedbackIndex) ? 0 : reader.GetInt32(Count_feedbackIndex);
*
* int tmp = _Count_feedback;
* if (_Count_feedback == 0)
* tmp = 1;
* _avg_star = _avg_star / tmp;// округление до2 знаков
*
*
* Shop item = new Shop
* {
* ID_shop = reader.GetString(sID_shopIndex),
* Type = reader.GetString(sTypeIndex),
* Name = reader.GetString(sNameIndex),
* Phone = reader.GetString(sPhoneIndex),
* Adress = reader.GetString(sAdressIndex),
* Metro = metro,
* Site = reader.IsDBNull(sSiteIndex) ? "" : reader.GetString(sSiteIndex),
* AVG_Star = Math.Round(_avg_star, 1),
* Count_feedback = _Count_feedback
*
* };
* Shops.Add(item);
* }
*
* //return shops;
* }
*
* SqlParameter[] parameters = new SqlParameter[]
* {
* new SqlParameter(@"ID_SHOP",SqlDbType.NVarChar) { Value =ID_SHOP }
* };
*
#region sql
*
* string sqlText = $@"
* SELECT
* s.ID_shop,
* s.Type,
* s.Name,
* s.Phone,
* s.Site,
* s.Adress,
* m.ID_Metro,
* m.station,
* m.Color_hex,
* (
* SELECT sum(CC.Count_star) AS avg_star FROM SPAVREMONT.Comment_client CC
* WHERE CC.ID_SHOP=S.ID_shop
* AND CC.visible=1
* ) AS AVG_Star,
* (
* SELECT count(*) AS count_feedback FROM SPAVREMONT.Comment_client CC
* WHERE CC.ID_SHOP=S.ID_shop
* AND CC.visible=1
* ) AS Count_feedback
*
* FROM SPAVREMONT.Shop s
* JOIN SPAVREMONT.Metro m ON s.ID_Metro=m.ID_Metro
* WHERE s.Type='Магазин'
*
* ";
*
#endregion
*
* DataTable dt = new DataTable();// при наличии данных
* // получаем данные из запроса
* dt = ExecuteSqlGetDataTableStatic(sqlText, parameters);
*
*
* foreach (DataRow row in dt.Rows)
* {
*
* // попали в цикл, значит авторизовались, т.к. такой пользователь существует
* IMG_Shop img = new IMG_Shop
* {
* Date_add = (DateTime)row["Date_add"],
* Deleted = (bool)row["Deleted"],
* ID_IMG_Shop = (long)row["ID_IMG_Shop"],
* ID_SHOP = (string)row["ID_SHOP"],
* Type = (string)row["Type"],
* Url = (string)row["Url"]
* };
*
* iMG_Shops.Add(img);
* }
*
* }
*
*/
private void GetShopIMGs(string ID_SHOP)
{
List <IMG_Shop> iMG_Shops = new List <IMG_Shop>();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter(@"ID_SHOP", SqlDbType.NVarChar)
{
Value = ID_SHOP
}
};
#region sql
string sqlText = $@"
SELECT TOP(10)
[ID_IMG_SHOP]
,[ID_SHOP]
,[Url]
,[Type]
,[Deleted]
,[Date_add]
FROM [SPAVREMONT].[IMG_Shop]
WHERE 1=1
AND Deleted=0
AND ID_SHOP=@ID_SHOP
AND Type='VITRINA'
ORDER BY Date_add DESC
";
#endregion
DataTable dt = new DataTable(); // при наличии данных
// получаем данные из запроса
dt = ExecuteSqlGetDataTableStatic(sqlText, parameters);
foreach (DataRow row in dt.Rows)
{
// попали в цикл, значит авторизовались, т.к. такой пользователь существует
IMG_Shop img = new IMG_Shop
{
Date_add = (DateTime)row["Date_add"],
Deleted = (bool)row["Deleted"],
ID_IMG_Shop = (long)row["ID_IMG_Shop"],
ID_SHOP = (string)row["ID_SHOP"],
Type = (string)row["Type"],
Url = (string)row["Url"]
};
iMG_Shops.Add(img);
}
//return iMG_Shops;
}
public IActionResult ImgsShopDelete(long ID_IMG)
{
Shop shop = new Shop(User.Identity.Name);
IMG_Shop.Delete(ID_IMG, shop.ID_shop);
return(RedirectToAction("ImgsShop"));
}
public IActionResult ImgsShopDelete(long ID_IMG, string ID_SHOP)
{
if (!HttpContext.User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
//Shop shop = new Shop(User.Identity.Name);
IMG_Shop.Delete(ID_IMG, ID_SHOP);
var referrer = Request.Headers["Referer"];
return(Redirect(referrer));
}
public IActionResult AccountShop(string ID_Shop)
{
if (!HttpContext.User.Identity.IsAuthenticated)
{
return(RedirectToAction("Login", "Account"));
}
if (!CheckAdmin())
{
return(RedirectToAction("index", "Home"));
}
List <City> cities = City.GetCities();
Shop shop = Shop.GetItemAdmin(ID_Shop);
List <Metro> metros = Metro.GetCities(shop.City.ID_City);
List <TimeWayMetroClass> timeWayMetros = TimeWayMetroClass.GetTimewayMetro();
List <IMG_Shop> imgsShop = IMG_Shop.GetShopIMGs(ID_Shop);
// предустановка комбо боксов, в первом списке будут текущие значения
cities.Insert(0, shop.City);
timeWayMetros.Insert(0, new TimeWayMetroClass()
{
minutes = shop.TimeWayMetro, Comment = shop.TimeWayMetro.ToString()
});
if (shop.Metro != null)
{
metros.Insert(0, shop.Metro);
}
AccountShopVM accountShop = new AccountShopVM()
{
Shop = shop,
Citys = cities,
Metros = metros,
timeWayMetros = timeWayMetros,
iMG_Shops = imgsShop
};
return(View(accountShop));
}
public async Task <IActionResult> ImgsShop(ImgsShopVM VM)
{
if (ModelState.IsValid)
{
string URL_foto = await LoadIMG("vitrina", VM.IMG_formFile);
if (!String.IsNullOrEmpty(URL_foto))
{
IMG_Shop iMG_Shop = new IMG_Shop
{
ID_SHOP = VM.ID_SHOP,
Type = "VITRINA",
Url = URL_foto
};
iMG_Shop.Create();
}
}
return(RedirectToAction("ImgsShop"));
}
public ImgsShopVM(string ID_SHOP)
{
iMG_Shops = IMG_Shop.GetShopIMGs(ID_SHOP);
this.ID_SHOP = ID_SHOP;
}
