public ActionResult ToAll(string title, string text)
{
using (botEntities3 bd = new botEntities3())
{
string u = User.Identity.Name;
Users user = bd.Users.Where(x => x.Email == u).First();
Token k = bd.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
string username = user.TelegramUser.Where(x => x.UserId == user.Id).FirstOrDefault().Username;
List <Recycle> rec = bd.Recycle.Where(x => x.TokenId == k.Id).ToList();
string split = "";
if (username != null)
{
for (int i = 0; i < rec.Count; i++)
{
if (split.Contains(rec[i].UserName))
{
continue;
}
split += rec[i].UserName;
SendMessage(k.token1, text, rec[i].UserName);
}
}
}
return(View("ToAllSuccess"));
}
public string ShowMyBuy()
{
string answer = "Ваш заказ: \n\n";
List <Recycle> p;
int count = 0;
List <Product> m = new List <Product>();
using (botEntities3 bd = new botEntities3())
{
p = bd.Recycle.Where(x => x.TokenId == TokenIds).Where(x => x.UserName == username).ToList();
for (int i = 0; i < p.Count; i++)
{
try
{
string namecat = p[i].NameCategory;
string nameprod = p[i].NameProduct;
Product k = bd.Product.Where(x => x.ProductName == nameprod).Where(x => x.Category.NameCategory == namecat).First();
m.Add(k);
}
catch
{
}
}
}
// return m.Count().ToString();
foreach (Product v in m)
{
answer += v.ProductName + " " + v.ProductPrice + " руб";
answer += Environment.NewLine;
count += v.ProductPrice;
}
answer += "Итого " + count.ToString() + " руб";
return(answer);
}
public async Task <HttpResponseMessage> SendPhotoIputFile(Update update, int?id, string answer, string replyMarkup)
{
string from = "";
string token = ReceiveToken(update, id);
int? u;
using (botEntities3 bd = new botEntities3())
{
u = bd.Token.Where(x => x.token1 == token).FirstOrDefault().UserID;
from = bd.TelegramUser.Where(x => x.UserId == u).FirstOrDefault().Username;
}
string pathToPhoto = HostingEnvironment.MapPath("~/Images/01.jpg");
string BaseUrl = "https://api.telegram.org/bot";
using (MultipartFormDataContent form = new MultipartFormDataContent())
{
string url = BaseUrl + ReceiveToken(update, id) + "/sendPhoto";
string fileName = pathToPhoto.Split('\\').Last();
if (replyMarkup != "")
{
form.Add(new StringContent(replyMarkup, Encoding.UTF8), "reply_markup");
}
form.Add(new StringContent(from.ToString(), Encoding.UTF8), "chat_id");
form.Add(new StringContent(answer.ToString(), Encoding.UTF8), "caption");
using (FileStream fileStream = new FileStream(pathToPhoto, FileMode.Open, FileAccess.Read))
{
form.Add(new StreamContent(fileStream), "photo", fileName);
using (HttpClient client = new HttpClient())
await client.PostAsync(url, form);
}
return(null);
}
}
public ActionResult ShowShop()
{
List <Parser> parse = new List <Parser>();
CustomRoleProvider l = new CustomRoleProvider();
bool con = l.IsUserInRole(User.Identity.Name, "User");
bool admin = l.IsUserInRole(User.Identity.Name, "Admin");
if (admin)
{
return(RedirectToAction("Andex", "Admin"));
}
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();
List <Token> k = bd.Token.Where(x => x.UserID == user.Id).ToList();
foreach (Token m in k)
{
List <Category> list = m.Category.ToList();
for (int i = 0; i < list.Count; i++)
{
Parser px = new Parser(list[i]);
px.p = list[i].Product.ToList();
parse.Add(px);
}
}
}
return(View(parse));
}
public ActionResult ImportFromExcel(HttpPostedFileBase upload)
{
Users user;
Token k;
using (botEntities3 bd = new botEntities3())
{
string u = User.Identity.Name;
user = bd.Users.Where(x => x.Email == u).First();
k = bd.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
}
string o = "";
if (upload != null)
{
// получаем имя файла
string fileName = System.IO.Path.GetFileName(upload.FileName);
// сохраняем файл в папку Files в проекте
string path = Path.Combine(Server.MapPath("~/Images"), fileName);
upload.SaveAs(path);
o = ImportFile(user.Id, k.Id, fileName);
}
SetWebHook(k.token1, k.Id);
return(View("ImportSucess"));
}
string MainMenu(Update update, int?id, out string reply_markup)
{
List <Category> list;
string token = "";
int i = 0;
using (botEntities3 bd = new botEntities3())
{
list = bd.Category.Where(x => x.Token.Id == id).ToList();
token = ReceiveToken(update, id);
}
InlineKeyboard keyboard = new InlineKeyboard();
foreach (Category k in list)
{
keyboard.AddButton(new InlineKeyboardButton(
k.NameCategory
), i++ / 2);
}
AddRecycle(keyboard, "", "", update, id);
AddMainButtons(keyboard, update, id);
reply_markup = JsonConvert.SerializeObject(keyboard);
return("Все категории");
}
public ActionResult DeleteFromRecycle(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();
Recycle res = bd.Recycle.Where(x => x.NameProduct == namep).Where(x => x.NameCategory == namecat).Where(x => x.TokenId == m.Id).Where(x => x.UserName == username).First();
bd.Recycle.Remove(res);
bd.SaveChanges();
}
}
catch
{
}
return(RedirectToAction("ShowRecycle", "Admin"));
}
private string RecivePassword(Update update)
{
try
{
using (botEntities3 bd = new botEntities3())
{
TelegramUser tg = bd.TelegramUser.Where(x => x.Username == update.callback_query.from.id.ToString()).FirstOrDefault();
if (tg == null)
{
return("Вы еще не зареистрированы");
}
Users users = bd.Users.Where(x => x.Id == tg.UserId).FirstOrDefault();
if (users != null)
{
return("Ваш пароль " + users.Passwords + " Ваш логин " + " " + users.Email);
}
else
{
return("Вы еще не зарегистрированы");
}
}
}
catch
{
return("Вы еще не зареистрированы");
}
}
public ActionResult ShowRecycle()
{
CustomRoleProvider l = new CustomRoleProvider();
bool con = l.IsUserInRole(User.Identity.Name, "User");
if (!con)
{
return(RedirectToAction("Index", "Home"));
}
List <List <Recycle> > res = new List <List <Recycle> >();
using (botEntities3 bd = new botEntities3())
{
string u = User.Identity.Name;
Users user = bd.Users.Where(x => x.Email == u).First();
List <Token> k = bd.Token.Where(x => x.UserID == user.Id).ToList();
foreach (var z in k)
{
res.Add(bd.Recycle.Where(x => x.TokenId == z.Id).ToList());
}
}
return(View(res));
}
public ActionResult ShowShop(string namep, string namecat)
{
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();
Product p = bd.Product.Where(x => x.ProductName == namep).Where(x => x.Category.NameCategory == namecat).Where(x => x.Category.TokenId == m.Id).FirstOrDefault();
if (p != null)
{
if (p.Counts > 0)
{
p.Counts = p.Counts - 1;
bd.SaveChanges();
}
if (p.Counts == 0)
{
bd.Product.Remove(p);
bd.SaveChanges();
}
}
Category cat = bd.Category.Where(x => x.NameCategory == namecat).Where(x => x.TokenId == m.Id).First();
if (cat.Product.Count == 0)
{
bd.Category.Remove(cat);
bd.SaveChanges();
return(RedirectToAction("ShowShop", "Admin"));
}
}
return(RedirectToAction("ShowShop", "Admin"));
}
string ReceiveToken(Update update, int?id)
{
string token;
using (botEntities3 bot = new botEntities3())
token = bot.Token.Where(x => x.Id == id).First().token1;
return(token);
}
public void DeleteElement(string category, string product)
{
using (botEntities3 bd = new botEntities3())
{
bd.Recycle.Remove(bd.Recycle.Where(x => x.NameProduct == product).Where(x => x.NameCategory == category).First());
bd.SaveChanges();
}
}
public ActionResult DeleteMes(int id)
{
using (botEntities3 bd = new botEntities3())
{
Form k = bd.Form.Where(x => x.Id == id).FirstOrDefault();
bd.Form.Remove(k);
bd.SaveChanges();
}
return(RedirectToAction("ShowForm"));
}
public ActionResult DeleteEmail(string email)
{
using (botEntities3 bd = new botEntities3())
{
Sub subscrib = bd.Sub.Where(x => x.Email == email).First();
bd.Sub.Remove(subscrib);
bd.SaveChanges();
return(RedirectToAction("ShowSubscribers"));
}
}
public ActionResult Login(LoginModel model)
{
//if (User.Identity.IsAuthenticated)
//{
// CustomRoleProvider l = new CustomRoleProvider();
// bool con = l.IsUserInRole(User.Identity.Name, "User");
// bool con2 = l.IsUserInRole(User.Identity.Name, "Admin");
// if (con)
// {
// return RedirectToAction("ShowShop", "Admin");
// }
// else
// {
// if (con2)
// return RedirectToAction("AShowShops", "Admin");
// }
//}
if (ModelState.IsValid)
{
// поиск пользователя в бд
Users user = null;
string a;
using (botEntities3 db = new botEntities3())
{
user = db.Users.FirstOrDefault(u => u.Email == model.Name && u.Passwords == model.Password);
if (user == null)
{
return(View("LoginWrong", model));
}
a = user.Roles.Names;
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Name, true);
if (a == "User")
{
return(RedirectToAction("ShowShop", "Admin"));
}
else
{
if (a == "Admin")
{
return(RedirectToAction("AShowShops", "Admin"));
}
}
}
else
{
return(View("LoginWrong", model));
}
}
return(View("LoginWrong", model));
}
string Shop(string category, string nameProduct, Update update, int?id, out string reply_markup)
{
//string category = shop.Split(' ')[0];
//string nameProduct = shop.Split(' ').Length < 2 ? "" : shop.Split(' ')[1];
string answer = "!";
reply_markup = "";
List <Category> cat = null;
List <Product> p = null;
// SendMessage(update.callback_query.from.id, category , ReceiveToken(update, id));
using (botEntities3 bd = new botEntities3())
{
try
{
cat = bd.Category.Where(x => x.Token.Id == id).ToList();
p = cat.Where(x => x.NameCategory == category).First().Product.ToList();
if (nameProduct == "")
{
nameProduct = p[0].ProductName;
}
}
catch
{
// SendMessage(update.callback_query.from.id, "БД УПало", ReceiveToken(update, id));
}
}
InlineKeyboard keyboard = new InlineKeyboard();
int i = 0;
foreach (Product k in p)
{
if (nameProduct == k.ProductName)
{
continue;
}
keyboard.AddButton(new InlineKeyboardButton(
k.ProductName, k.Category.NameCategory + " " + k.ProductName), i++ / 2);
}
AddRecycle(keyboard, category, nameProduct, update, id);
Product chooseProduct = p.Where(x => x.ProductName == nameProduct).First();
if (chooseProduct.ProductPhoto == null)
{
chooseProduct.ProductPhoto = "";
}
answer = "Стоимость товара " + chooseProduct.ProductPrice + "руб" + Environment.NewLine + "Описание" + " " + chooseProduct.ProductDescription + chooseProduct.ProductPhoto;
keyboard.AddButton(new InlineKeyboardButton("⬅️ Назад", "about"));
AddMainButtons(keyboard, update, id);
reply_markup = JsonConvert.SerializeObject(keyboard);
return(answer);
}
public string ChangeMyBuy(out string reply_markup)
{
reply_markup = "";
List <Recycle> p;
List <Product> m = new List <Product>();
string[] ar;
using (botEntities3 bd = new botEntities3())
{
p = bd.Recycle.Where(x => x.TokenId == TokenIds).Where(x => x.UserName == username).ToList();
ar = new string[p.Count];
for (int i = 0; i < p.Count; i++)
{
try
{
string namecat = p[i].NameCategory;
string nameprod = p[i].NameProduct;
Product k = bd.Product.Where(x => x.ProductName == nameprod).Where(x => x.Category.NameCategory == namecat).First();
ar[i] = k.Category.NameCategory;
m.Add(k);
}
catch
{
}
}
}
if (m.Count == 0)
{
return("Выберете пункт меню");
}
InlineKeyboard keyboard = new InlineKeyboard();
int o = 0;
for (int i = 0; i < p.Count; i++)
{
try
{
o++;
keyboard.AddButton(new InlineKeyboardButton("Удалить " + m[i].ProductName + "(" + ar[i] + ")" + " цена " + m[i].ProductPrice +
" 1 шт", "корзина удалить " + ar[i] + " " + m[i].ProductName));
}
catch
{
}
}
this.Count = o;
keyboard.AddButton(new InlineKeyboardButton("Оформить", "корзина оформить"));
keyboard.AddButton(new InlineKeyboardButton("⬅️ Назад", "about"));
reply_markup = JsonConvert.SerializeObject(keyboard);
return("Изменение заказа");
}
string ImportFile(int userId, int tokenID, string fileName)
{
try
{
var package = new ExcelPackage(new FileInfo(Path.Combine(Server.MapPath("~/Images"), fileName)));
ExcelWorksheet workSheet = package.Workbook.Worksheets[1];
for (int i = workSheet.Dimension.Start.Row + 2; i <= workSheet.Dimension.End.Row; i++)
{
int j = workSheet.Dimension.Start.Column + 1;
ImportElement ie = new ImportElement();
ie.Category = workSheet.Cells[i, j].Value.ToString();
ie.Name = workSheet.Cells[i, ++j].Value.ToString();
string s = workSheet.Cells[i, ++j].Value.ToString();
ie.Price = int.Parse(s);
ie.Description = workSheet.Cells[i, ++j].Value.ToString();
ie.Photo = workSheet.Cells[i, ++j].Value.ToString();
ie.Count = int.Parse(workSheet.Cells[i, ++j].Value.ToString());
using (botEntities3 db = new botEntities3())
{
Users user = db.Users.Where(x => x.Id == userId).First();
Token k = db.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
Category c = db.Category.Where(x => x.NameCategory == ie.Category).Where(x => x.TokenId == k.Id).FirstOrDefault();
if (c == null)
{
c = new Category()
{
NameCategory = ie.Category, CategoryId = user.Id, TokenId = tokenID
};
db.Category.Add(c);
db.SaveChanges();
}
db.Product.Add(new Product()
{
Category = c, CategoryId = user.Id, ProductDescription = ie.Description, ProductName = ie.Name, ProductPrice = ie.Price, ProductPhoto = ie.Photo, Counts = ie.Count
});
db.SaveChanges();
}
}
}
catch
{
}
return("ок");
}
public void AddBuy(string NameCategorys, string NameProducts)
{
using (botEntities3 bd = new botEntities3())
{
bd.Recycle.Add(new Recycle()
{
NameCategory = NameCategorys,
NameProduct = NameProducts,
TokenId = TokenIds,
UserName = username, Dates = DateTime.Now.ToString()
});
bd.SaveChanges();
}
}
public TelegramRecycle(Update update, int?id)
{
if (update.callback_query == null)
{
this.username = update.message.from.id.ToString();
}
else
{
this.username = update.callback_query.from.id.ToString();
}
TokenIds = (int)id;
using (botEntities3 bd = new botEntities3())
{
Count = bd.Recycle.Where(x => x.UserName == username).Where(x => x.TokenId == TokenIds).ToList().Count;
}
}
bool Checked(Update update)
{
using (botEntities3 bd = new botEntities3())
{
try
{
TelegramUser tg = bd.TelegramUser.Where(x => x.Username == update.callback_query.from.id.ToString()).First();
if (tg != null)
{
return(false);
}
}
catch
{
return(true);
}
return(true);
}
}
public ActionResult ShowForm()
{
using (botEntities3 bd = new botEntities3())
{
bool con = false;
//если это админ или обычный пользователь
CustomRoleProvider l = new CustomRoleProvider();
con = l.IsUserInRole(User.Identity.Name, "Admin");
if (con)
{
List <Form> mes = bd.Form.ToList();
return(View(mes));
}
else
{
return(View("Index", "Home"));
}
}
}
public ActionResult ShowSubscribers()
{
using (botEntities3 bd = new botEntities3())
{
bool con = false;
//если это админ или обычный пользователь
CustomRoleProvider l = new CustomRoleProvider();
con = l.IsUserInRole(User.Identity.Name, "Users");
if (!con)
{
List <Sub> subcribers = bd.Sub.ToList();
return(View(subcribers));
}
else
{
return(View("Index", "Home"));
}
}
}
public ActionResult Subscr(Sub contact)
{
if (contact.Email == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
//beginform
using (botEntities3 bd = new botEntities3())
{
Sub c = new Sub()
{
Email = contact.Email
};
bd.Sub.Add(c);
bd.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
}
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 Subscribe(Form con)
{
if (con.Email == null || con.Mesages == null || con.Names == null || con.Titles == null)
{
return(RedirectToAction("Index", "Home"));
}
else
{
//beginform
using (botEntities3 bd = new botEntities3())
{
Form form = new Form()
{
Email = con.Email,
Mesages = con.Mesages,
Names = con.Names,
Titles = con.Titles
};
bd.Form.Add(form);
bd.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
}
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"));
}
}
public ActionResult AShowShops()
{
CustomRoleProvider l = new CustomRoleProvider();
bool con = l.IsUserInRole(User.Identity.Name, "Admin");
if (!con)
{
return(View("Index", "Home"));
}
using (botEntities3 bd = new botEntities3())
{
try {
List <ShopsModel> shops = new List <ShopsModel>();
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 <Category> category_list = new List <Category>();
List <Product> product_list = new List <Product>();
foreach (Users temp_user in users)
{
string k = null;
try
{
k = temp_user.TelegramUser.Where(x => x.UserId == temp_user.Id).FirstOrDefault().BotChannel;
}
catch
{
if (k == null)
{
k = " ";
}
}
if (k == null)
{
k = " ";
}
string name = temp_user.Email;
string nameShop = k;
Token temp_tokens = new Token();
for (int i = 0; i < tokens.Count; i++)
{
if (temp_user.Id == tokens.ElementAt(i).UserID)
{
temp_tokens = tokens.ElementAt(i);
break;
}
}
category_list = new List <Category>();
product_list = new List <Product>();
foreach (Category temp_category in category)
{
if (temp_tokens.Id == temp_category.TokenId)
{
foreach (Product prod in product)
{
if (prod.CategoryId == temp_category.CategoryId)
{
product_list.Add(prod);
}
}
}
}
shops.Add(new ShopsModel(nameShop, name, product_list));
}
return(View(shops));
}
catch
{
}
return(View());
}
}
private string Register(Update update)
{
// поиск пользователя в бдhttp://botshop.azurewebsites.net/Account/Login
Users user = null;
string answer = "";
using (botEntities3 db = new botEntities3())
{
try
{
Token tok = db.Token.Where(x => x.token1 == update.message.text).FirstOrDefault();
if (tok != null)
{
return("Такой токен уже есть в нашей системе");
}
TelegramUser u = db.TelegramUser.Where(x => x.Username == update.message.from.id.ToString()).FirstOrDefault();
if (u != null)
{
user = db.Users.FirstOrDefault(x => x.Id == u.UserId);
return("У вас уже есть магазин");
}
}
catch
{
user = null;
}
}
if (user != null)
{
using (botEntities3 db = new botEntities3())
{
Token t = new Token();
t.token1 = update.message.text;
t.UserID = user.Id;
db.Token.Add(t);
db.SaveChanges();
}
answer += "Магазин успешно добавлен";
return(answer);
}
else
{
string em = "";
string pas = "";
Random ran = new Random();
for (int i = 0; i < 4; i++)
{
em += (char)ran.Next('a', 'z');
pas += (char)ran.Next('a', 'z');
}
try
{
int count;
using (botEntities3 db = new botEntities3())
{
count = db.Users.Count() + 10;
em += db.Users.Count().ToString() + "@bot.ru";
user = new Users()
{
Email = em,
RoleId = 1,
Passwords = pas,
Id = count
};
db.Users.Add(user);
db.SaveChanges();
}
using (botEntities3 db = new botEntities3())
{
TelegramUser t = new TelegramUser();
// count = db.Users.Where(x => x.Id == count).First().;
t.UserId = count;
t.Username = update.message.from.id.ToString();
t.BotChannel = getBotInfo(update.message.text);
db.TelegramUser.Add(t);
db.SaveChanges();
}
using (botEntities3 db = new botEntities3())
{
Token k = new Token();
k.token1 = update.message.text;
k.UserID = count;
db.Token.Add(k);
db.SaveChanges();
}
return("Регистрация прошла успешно" + Environment.NewLine + " Ваш логин:" + " " + em + " Ваш пароль " + pas + Environment.NewLine
+ " Используйте эти данные для входа в систему " + @"http://botshop.azurewebsites.net/Account/Login");
}
catch
{
return("Неверные входные данные");
}
// answer = "Вы успешно зарегистрировались" + " " + "Ваш логин " + em;
}
}
public ActionResult AddElement(string category, string nameproduct, string description, string price, string count, HttpPostedFileBase upload)
{
Users user;
Token k;
using (botEntities3 bd = new botEntities3())
{
string u = User.Identity.Name;
user = bd.Users.Where(x => x.Email == u).FirstOrDefault();
k = bd.Token.Where(x => x.UserID == user.Id).FirstOrDefault();
}
string o = "";
string path = " ";
string fileName = " ";
string ps = "";
try
{
if (upload != null)
{
// получаем имя файла
fileName = System.IO.Path.GetFileName(upload.FileName);
Random rnd = new Random();
ps = "";
for (int i = 0; i < 3; i++)
{
ps += (char)rnd.Next('a', 'z');
}
// сохраняем файл в папку Files в проекте
ps = ps + fileName;
path = Path.Combine(Server.MapPath("~/Images"), ps);
upload.SaveAs(path);
}
;
string path1 = $@"<a href=""http://botshop.azurewebsites.net/Images/{ps}""> </a>";
using (botEntities3 db = new botEntities3())
{
Category c = db.Category.Where(x => x.NameCategory == category).Where(x => x.TokenId == k.Id).FirstOrDefault();
if (c == null)
{
c = new Category()
{
NameCategory = category, CategoryId = user.Id, TokenId = k.Id
};
db.Category.Add(c);
db.SaveChanges();
}
db.Product.Add(new Product()
{
Category = c, CategoryId = user.Id, ProductDescription = description, ProductName = nameproduct, ProductPrice = int.Parse(price), ProductPhoto = path1, Counts = int.Parse(count)
});
db.SaveChanges();
}
return(View("AddElementS"));
}
catch
{
return(View("AddElementF"));
}
}
