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