public ActionResult DeleteFromOrderRecycle(string namep, string namecat, string username)
{
try
{
CustomRoleProvider l = new CustomRoleProvider();
bool con = l.IsUserInRole(User.Identity.Name, "User");
if (!con)
{
return(RedirectToAction("Index", "Home"));
}
using (botEntities3 bd = new botEntities3())
{
string u = User.Identity.Name;
Users user = bd.Users.Where(x => x.Email == u).First();
Token m = bd.Token.Where(x => x.UserID == user.Id).First();
OrderRecycle res = bd.OrderRecycle.Where(x => x.NameProduct == namep).Where(x => x.NameCategory == namecat).Where(x => x.TokenId == m.Id).Where(x => x.UserName == username).First();
bd.OrderRecycle.Remove(res);
bd.SaveChanges();
}
}
catch
{
}
return(RedirectToAction("OrderRecycle", "Admin"));
}
void SendMessageToAdmin(Update update, int?id)
{
string chat_id = "";
string token = ReceiveToken(update, id);
int? u;
using (botEntities3 bd = new botEntities3())
{
u = bd.Token.Where(x => x.token1 == token).FirstOrDefault().UserID;
chat_id = bd.TelegramUser.Where(x => x.UserId == u).FirstOrDefault().Username;
}
string message = "Пользователь " + update.message.contact.first_name + " сделал заказ " +
"его контактные данные " + update.message.contact.user_id + "его телефон " + update.message.contact.phone_number;
string BaseUrl = "https://api.telegram.org/bot";
string address = BaseUrl + ReceiveToken(update, id) + "/sendMessage";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("chat_id", chat_id.ToString());
nvc.Add("text", message);
using (WebClient client = new WebClient())
client.UploadValues(address, nvc);
using (botEntities3 bd = new botEntities3())
{
List <Recycle> res = bd.Recycle.Where(x => x.Token.token1 == token).Where(x => x.UserName == update.message.contact.user_id.ToString()).ToList();
for (int i = 0; i < res.Count; i++)
{
OrderRecycle ord = new OrderRecycle()
{
Dates = DateTime.Now.ToString(),
TokenId = bd.Token.Where(x => x.token1 == token).FirstOrDefault().Id,
UserName = update.message.contact.user_id.ToString(),
Token = bd.Token.Where(x => x.token1 == token).FirstOrDefault(),
NameCategory = res[i].NameCategory,
NameProduct = res[i].NameProduct
};
bd.OrderRecycle.Add(ord);
bd.SaveChanges();
}
}
}
public ActionResult DeleteShop(string email)
{
using (botEntities3 bd = new botEntities3())
{
try
{
List <Users> users = bd.Users.ToList();
List <Token> tokens = bd.Token.ToList();
List <Category> category = bd.Category.ToList();
List <Product> product = bd.Product.ToList();
List <Recycle> recyc = bd.Recycle.ToList();
Users user = bd.Users.Where(x => x.Email == email).FirstOrDefault();
Token token = bd.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
TelegramUser tguser = bd.TelegramUser.Where(x => x.UserId == user.Id).FirstOrDefault();
List <OrderRecycle> rs = null;
try
{
OrderRecycle or = bd.OrderRecycle.Where(x => x.TokenId == token.Id).FirstOrDefault();
if (or != null)
{
rs = bd.OrderRecycle.Where(x => x.TokenId == token.Id).ToList();
}
}
catch
{
}
List <Category> category_remove = new List <Category>();
List <Product> product_remove = new List <Product>();
if (category != null)
{
try
{
foreach (Category i in category)
{
if (i.TokenId == token.Id)
{
category_remove.Add(i);
foreach (Product prod in product)
{
if (prod.CategoryId == i.CategoryId)
{
product_remove.Add(prod);
}
}
}
}
}
catch
{
}
}
if (product_remove != null)
{
try
{
foreach (Product prod in product_remove)
{
bd.Product.Remove(prod);
}
}
catch
{
}
}
if (category_remove != null)
{
try
{
foreach (Category cat in category_remove)
{
bd.Category.Remove(cat);
}
}
catch { }
}
if (recyc != null)
{
try
{
foreach (Recycle rec in recyc)
{
if (rec.TokenId == token.Id)
{
bd.Recycle.Remove(rec);
}
}
}
catch
{
}
}
if (rs != null)
{
foreach (OrderRecycle j in rs)
{
bd.OrderRecycle.Remove(j);
}
}
if (tguser != null)
{
bd.TelegramUser.Remove(tguser);
}
if (token != null)
{
bd.Token.Remove(token);
}
bd.Users.Remove(user);
bd.SaveChanges();
}
catch
{
}
return(RedirectToAction("AShowShops"));
}
}
