public void TestDbContex() { using (DbContextApp db = DbContextApp.GetDbContextApp) { TableFirst tableFirst1 = new TableFirst { A1 = 6000.ToString() }; TableFirst tableFirst2 = new TableFirst { A1 = 99999.ToString() }; db.TableFirsts.AddRange(tableFirst1, tableFirst2); db.SaveChanges(); List <TableFirst> table = db.TableFirsts.ToList(); table.ForEach(item => Console.WriteLine(item.A1 + Environment.NewLine)); db.TableFirsts.RemoveRange(db.TableFirsts.Select(item => item).ToArray()); db.SaveChanges(); if (!db.TableFirsts.Any()) { Console.WriteLine("База пуста"); } } }
public IActionResult CreateOrder(LinkOrder linkOrder) { if (ModelState.IsValid) { if (signInManager.IsSignedIn(User) == true) { SignedUserName = User.Identity.Name; user = dbContext.CustomUsers.FirstOrDefault(x => x.UserName == SignedUserName); //===================== GETS THE BALANCE OF SIGNED USER var userBalance = dbContext.Balances.FirstOrDefault(x => x.DbPassportUserModelId == user.Id); userBalance.TLBalance -= linkOrder.ProductPrice; dbContext.SaveChanges(); //==================== ADDS TRANSACTION WHEN MONEY IS SPENT UserTransaction userTransaction = new UserTransaction() { TransactionType = 2, //================ 1 for medaxil, 2 for mexaric Amount = linkOrder.ProductPrice, CurrencyType = 2, //=================== 1 for azn, 2 for try, Date = DateTime.Now, DbPassportUserModel = user }; dbContext.Transactions.Add(userTransaction); dbContext.SaveChanges(); LinkOrder dbLinkOrder = new LinkOrder() { OrderLink = linkOrder.OrderLink, ProductPrice = linkOrder.ProductPrice, ProductAmount = linkOrder.ProductAmount, OrderComment = linkOrder.OrderComment, DeliveryAddress = linkOrder.DeliveryAddress, PaymentMethod = linkOrder.PaymentMethod, DbPassportUserModel = user, OrderDate = DateTime.Now, OrderStatus = 10 }; if (dbContext.Orders.Count() > 0) { dbLinkOrder.OrderNumber = dbContext.Orders.Max(x => x.OrderNumber) + 1; } else { dbLinkOrder.OrderNumber = 1; } dbContext.Orders.Add(dbLinkOrder); dbContext.SaveChanges(); return(Json(new { redirectUrl = Url.Action("Index", "PanelPage") })); } } return(RedirectToAction("Index", "MakeOrder")); }
public IActionResult Create(addressesabroad address) { if (!ModelState.IsValid) { ModelState.AddModelError("ModelOnly", "Hamisin Doldurun"); return(View(address)); } _data.Addressesabroads.Add(address); _data.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public IActionResult Create(Questions questions) { if (!ModelState.IsValid) { ModelState.AddModelError("ModelOnly", "Hamisin Doldurun"); return(View(questions)); } _data.Questions.Add(questions); _data.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public IActionResult OnPost(string IdUsuario, string Nombre = "", string Correo = "", string MensajePersonal = "", string Sexo = "", string Accion = "ActualizarTodo", string IdServicioMensajeria = "", string DatoServicioMesajeria = "", string Descripcion = "", string URL = "") { usuario = contexto.Usuarios.Find(int.Parse(IdUsuario)); switch (Accion) { case "ActualizarTodo": //pendiente break; case "ConfigurarContacto": usuario.ConfiguraCuentaPrimeraVez = true; contexto.Usuarios.Update(usuario); contexto.SaveChanges(); break; case "AgregarContacto": var contacto = new ServicioDeMensajeria() { IdUsuario = usuario.Id, Servicio = int.Parse(IdServicioMensajeria), Dato = DatoServicioMesajeria }; contexto.ServiciosDeMensajeria.Add(contacto); contexto.SaveChanges(); break; case "GuardarMensaje": usuario.MensajePersonal = Descripcion; contexto.Usuarios.Update(usuario); contexto.SaveChanges(); break; case "img": usuario.UrlImagen = URL; contexto.Usuarios.Update(usuario); contexto.SaveChanges(); break; } return(Page()); }
public IActionResult Delete(int?id) { var data = _data.Orders.Find(id); if (data == null) { return(NotFound()); } _data.Orders.Remove(data); _data.SaveChanges(); return(RedirectToAction(nameof(OrdersIndex))); }
public IActionResult OnPost(string id, string pass, string Nombre, string Categoria, string precio, string Descripcion = "") { var ProductoNuevo = new Producto(); ProductoNuevo.Nombre = Nombre; ProductoNuevo.Descripcion = Descripcion; ProductoNuevo.Categoria = Categoria; ProductoNuevo.Precio = float.Parse(precio); ProductoNuevo.IdUsuario = int.Parse(id); ProductoNuevo.Publico = true; if (contexto.Usuarios.Find(int.Parse(id)).Password.Equals(pass)) { contexto.Productos.Add(ProductoNuevo); contexto.SaveChanges(); contexto.Entry(ProductoNuevo).GetDatabaseValues(); Id = ProductoNuevo.Id; ExistioError = false; } else { ExistioError = true; } return(Page()); }
public IActionResult OnPost(int idUsuario, string claveServ, string dato) { ServicioDeMensajeria servicio = new ServicioDeMensajeria(); servicio.Dato = dato; servicio.IdUsuario = idUsuario; switch (claveServ) { case "cel": //Numero de celular servicio.Servicio = 1; break; case "wh": //WhatsApp servicio.Servicio = 2; break; case "teleg": //Telegram servicio.Servicio = 3; break; case "fbm": //Facebook Messenger servicio.Servicio = 4; break; } contexto.ServiciosDeMensajeria.Add(servicio); contexto.SaveChanges(); contexto.Entry(servicio).GetDatabaseValues(); IdServicio = servicio.Id; return(Page()); }
public IActionResult Create(HomeSlider slider) { if (slider.Photo == null) { ModelState.AddModelError("Photo", "Sekil Yukleyin"); return(View(slider)); } string filename = slider.Photo.Save(_hosting.WebRootPath, "images/img2"); slider.Image = filename; _data.HomeSliders.Add(slider); _data.SaveChanges(); return(RedirectToAction(nameof(IndexHomeSlider))); }
public IActionResult OnPost(string email, string nombre, string sexo, string pass, string CiudadUniversitaria = "0", string Mederos = "0", string Salud = "0", string Linares = "0", string Sabinas = "0", string CienciasAgropecuarias = "0") { ErrorUsuarioExiste = (contexto.Usuarios.Any(cuenta => cuenta.Correo.Equals(email))); NombreNulo = (String.IsNullOrEmpty(nombre)); if (!ErrorUsuarioExiste && !NombreNulo) { Usuario nuevoUsuario = new Usuario(); nuevoUsuario.NombreCompleto = nombre; nuevoUsuario.Password = pass; nuevoUsuario.Correo = email; nuevoUsuario.Sexo = (sexo == "Mujer"); //true es mujer, false es hombre nuevoUsuario.CampusArray = CiudadUniversitaria + "," + Mederos + "," + Salud + "," + Linares + "," + Sabinas + "," + CienciasAgropecuarias; contexto.Usuarios.Add(nuevoUsuario); contexto.SaveChanges(); return(RedirectToPage("login", new { usuario = email, cuentaNueva = "si", nombre = nombre })); } return(Page()); }
public IActionResult Edit(int?Id, CourierDbViewModel courier) { var data = _data.CourierDeliveries.Find(courier.id); data.PhoneNumber = courier.PhoneNumber; data.DeliveredStatus = courier.DeliveredStatus; data.Street = courier.Street; data.House = courier.House; data.InvoiceComments = courier.InvoiceComments; _data.SaveChanges(); return(RedirectToAction(nameof(CourierIndex))); }
public IActionResult Create(Stores stores) { if (stores.Photo == null) { ModelState.AddModelError("Photo", "Şəkil Yükləyin"); return(View(stores)); } string filename = stores.Photo.Save(_hosting.WebRootPath, "images/img2"); stores.Image = filename; _data.Stores.Add(stores); _data.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public void Add(TimeModel model) { using (DbContextApp db = new DbContextApp()) { db.Times.Add(model); db.SaveChanges(); } }
public void Add(SeverityModel model) { using (DbContextApp db = new DbContextApp()) { db.Severities.Add(model); db.SaveChanges(); } }
public void OnPost(int idUsuario, int idContacto) { contexto.ServiciosDeMensajeria.Remove( contexto.ServiciosDeMensajeria .Single(serv => serv.IdUsuario.Equals(idUsuario) && serv.Id.Equals(idContacto)) ); contexto.SaveChanges(); }
public void Delete(SeverityModel model) { using (DbContextApp db = new DbContextApp()) { var modelToDelete = db.Severities.Single(m => m.ID == model.ID); db.Severities.Remove(modelToDelete); db.SaveChanges(); } }
public IActionResult Create(HomeNews news) { if (news.Photo == null) { ModelState.AddModelError("Photo", "Sekil Yukleyin"); return(View(news)); } string filename = news.Photo.Save(_hosting.WebRootPath, "images/img2"); news.Image = filename; news.Date = DateTime.Now; _data.HomeNews.Add(news); _data.SaveChanges(); return(RedirectToAction(nameof(IndexHomeNews))); }
public void Edit(SeverityModel model) { using (DbContextApp db = new DbContextApp()) { var modelToUpdate = db.Severities.Single(m => m.ID == model.ID); db.Entry(modelToUpdate).CurrentValues.SetValues(model); db.SaveChanges(); } }
public void OnPost(string idProducto) { Producto producto = contexto.Productos.Find(int.Parse(idProducto)); producto.Publico = !producto.Publico; contexto.Productos.Update(producto); contexto.SaveChanges(); }
public JsonResult DeleteShopContent(int id) { var deleteResult = dbContext.ShopContents.FirstOrDefault(x => x.Id == id); dbContext.ShopContents.Remove(deleteResult); var result = dbContext.SaveChanges(); return(Json(result)); }
public void OnPost(int idProducto, int idUsuario, string opinion = "", int estrellas = 1) { if (!contexto.Comentarios.Any(com => com.IdUsuario.Equals(idUsuario) && com.IdProducto.Equals(idProducto))) { Comentario comentario = new Comentario(); comentario.NumeroEstrellas = estrellas; comentario.Contenido = opinion; comentario.IdProducto = idProducto; comentario.IdUsuario = idUsuario; contexto.Comentarios.Add(comentario); contexto.SaveChanges(); } else { Comentario comentarioAModificar = contexto.Comentarios.Single(com => com.IdUsuario.Equals(idUsuario) && com.IdProducto.Equals(idProducto)); comentarioAModificar.NumeroEstrellas = estrellas; comentarioAModificar.Contenido = opinion; contexto.Comentarios.Update(comentarioAModificar); contexto.SaveChanges(); } }
public IActionResult OnPost( string id_producto, string id_usuario, string password, string nombre = "", string descripcion = "", string categoria = "", string precio = "", string accion = "default", string url = "") { //solo me asegura de que sea una peticion real if (contexto.Usuarios.Find(int.Parse(id_usuario)).Password.Equals(password)) { producto = contexto.Productos.Find(int.Parse(id_producto)); if (accion == "url_foto") { producto.UrlFoto = url; contexto.Productos.Update(producto); contexto.SaveChanges(); estado = "exito!"; } else { producto = contexto.Productos.Find(int.Parse(id_producto)); producto.Descripcion = descripcion; producto.Nombre = nombre; producto.Categoria = categoria; producto.Precio = float.Parse(precio); contexto.Productos.Update(producto); contexto.SaveChanges(); } } return(Page()); }
public IActionResult Create(About about) { if (about.Photo == null) { ModelState.AddModelError("Photo", "Şəkil Yükləyin"); return(View(about)); } if (about.BodyText == null) { ModelState.AddModelError("BodyText", "Mətn Yazın"); return(View(about)); } //Image Saved string filename = about.Photo.Save(_hosting.WebRootPath, "images/img2"); about.Image = filename; _data.Abouts.Add(about); _data.SaveChanges(); return(RedirectToAction(nameof(Index))); }
public static void ParserTxtToDbContext(IParser parser) { DbContextApp app = DbContextApp.GetDbContextApp; OneRowTxt[] modelsParser = parser.GetValueInTxtFile(); TableFirst[] tableFirsts = new TableFirst[modelsParser.Length]; for (int index = 0; index < tableFirsts.Length; index++) { tableFirsts[index] = new TableFirst { A1 = modelsParser[index].XA1, B1 = modelsParser[index].XB1, V1 = modelsParser[index].XV1, G1 = modelsParser[index].XG1, X2 = modelsParser[index].X2, X3 = modelsParser[index].X3, X4 = modelsParser[index].X4, X5 = modelsParser[index].X5, X6 = modelsParser[index].X6, X7 = modelsParser[index].X7, X8 = modelsParser[index].X8, X9 = modelsParser[index].X9, X10 = modelsParser[index].X10, X11 = modelsParser[index].X11, X12 = modelsParser[index].X12, X13 = modelsParser[index].X13, X14 = modelsParser[index].X14 } } ; app.TableFirsts.AddRange(tableFirsts); try { app.SaveChanges(); } catch (Exception exception) { Logger.Logger.Error(exception, nameof(Convert), nameof(ParserTxtToDbContext)); throw; } } #endregion }
public IActionResult OnPost(int idUsuario, string passwordActual, string passwordNueva) { var usuario = contexto.Usuarios.Find(idUsuario); if (usuario.Password.Equals(passwordActual)) { usuario.Password = passwordNueva; contexto.Usuarios.Update(usuario); contexto.SaveChanges(); TodoBien = true; } else { TodoBien = false; } return(Page()); }
//=============================================================== DELETE LINK ORDER public IActionResult DeleteLinkOrder(int id) { var order = dbContext.Orders.FirstOrDefault(x => x.id == id); dbContext.Remove(order); var result = dbContext.SaveChanges(); var balance = dbContext.Balances.FirstOrDefault(x => x.DbPassportUserModelId == order.DbPassportUserModelId); balance.TLBalance += order.ProductPrice; dbContext.SaveChanges(); return(RedirectToAction("Index")); }
public void OnPost(string idProducto, string idUsuario, string password) { contexto.Productos.Remove(contexto.Productos.Find(int.Parse(idProducto))); contexto.SaveChanges(); }
public async Task <IActionResult> CreateInvoice(CreateInvoiceViewModel createInvoiceViewModel) { if (ModelState.IsValid) { if (signInManager.IsSignedIn(User) == true) { SignedUserName = User.Identity.Name; user = dbContext.CustomUsers.FirstOrDefault(x => x.UserName == SignedUserName); } Invoice invoice = new Invoice() { StoreName = createInvoiceViewModel.StoreName, InvoiceProductType = createInvoiceViewModel.InvoiceProductType, InvoiceProductAmount = createInvoiceViewModel.InvoiceProductAmount, InvoiceProductPrice = createInvoiceViewModel.InvoiceProductPrice, InvoiceFollowCode = createInvoiceViewModel.InvoiceFollowCode, DeliveryOffice = createInvoiceViewModel.DeliveryOffice, InvoiceDate = createInvoiceViewModel.InvoiceDate, InvoiceComments = createInvoiceViewModel.InvoiceComments, InvoiceProductWeight = null, DeliveryMoney = null, InvoiceTime = DateTime.Now.ToString("HH:mm"), InvoiceStatus = 1, InvoiceCountryIndex = createInvoiceViewModel.InvoiceCountryIndex, DbPassportUserModel = user }; if (invoice.InvoiceDate == null) { invoice.InvoiceDate = DateTime.Now; } if (dbContext.Invoices.Count() > 0) { invoice.InvoiceNumber = dbContext.Invoices.Max(x => x.InvoiceNumber) + 1; } else { invoice.InvoiceNumber = 1; } //======================================== If there is any image submitted then this image is added to folder if (createInvoiceViewModel.FormFile != null) { var nameOfImage = Path.GetFileNameWithoutExtension(createInvoiceViewModel.FormFile.FileName); var extensionOfImage = Path.GetExtension(createInvoiceViewModel.FormFile.FileName); var guid = Guid.NewGuid(); var newFileName = nameOfImage + guid + extensionOfImage; var rootPath = Path.Combine(_webHost.WebRootPath, "Invoice", "InvoiceGallery", newFileName); using (var fileStream = new FileStream(rootPath, FileMode.Create)) { createInvoiceViewModel.FormFile.CopyTo(fileStream); } invoice.FileName = newFileName; } dbContext.Invoices.Add(invoice); dbContext.SaveChanges(); return(RedirectToAction("Index", "PanelPage")); } return(View()); }
public async Task <IActionResult> CreateUserSecond(PassportUserModel passportUser) { if (passportUser.agreeBox == false) { ModelState.AddModelError("agreeBox", "Zəhmət olmasa istifadəçi qaydaları ilə razı olun"); return(View(passportUser)); } if (ModelState.IsValid) { DateTime lastDateTime = new DateTime(passportUser.Year, passportUser.Month, passportUser.Day); var howManyUsers = dbContext.Users.ToList(); int customerid; if (howManyUsers.Count == 0) { customerid = 10000000; } else { customerid = dbContext.CustomUsers.Max(x => x.CustomerNumber) + 1; } DbPassportUserModel finalUser = new DbPassportUserModel() { UserName = passportUser.Email, Email = passportUser.Email, Name = passportUser.Name, Surname = passportUser.Surname, FinCode = passportUser.FinCode, SeriaNumber = passportUser.SeriaNumber, Sex = passportUser.Sex, Address = passportUser.Address, PhoneNumber = passportUser.MobilePhone, BirthdayDate = lastDateTime, CustomerNumber = customerid, Citizenship = passportUser.Citizenship }; var existedEmail = user.Users.FirstOrDefault(x => x.Email == finalUser.Email); var existedPhone = user.Users.FirstOrDefault(x => x.PhoneNumber == finalUser.PhoneNumber); var existedSeriaNumber = user.Users.FirstOrDefault(x => x.SeriaNumber == finalUser.SeriaNumber); var existedFinNumber = user.Users.FirstOrDefault(x => x.FinCode == finalUser.FinCode); if (existedEmail != null || existedPhone != null || existedSeriaNumber != null || existedFinNumber != null) { if (existedEmail != null) { ModelState.AddModelError("Email", "Belə mail istifadə olunub"); } if (existedPhone != null) { ModelState.AddModelError("MobilePhone", "Belə telefon nomrəsi istifadə olunub"); } if (existedSeriaNumber != null) { ModelState.AddModelError("SeriaNumber", "Belə seriya nömrəsi nomrəsi istifadə olunub"); } if (existedFinNumber != null) { ModelState.AddModelError("FinCode", "Belə Fin nömrəsi nomrəsi istifadə olunub"); } } else { var result = user.CreateAsync(finalUser, passportUser.Password).Result; if (result.Succeeded) { await signIn.SignInAsync(finalUser, false); var thResult = user.AddToRoleAsync(finalUser, "User").Result; if (thResult.Succeeded) { } var signedBalanceUser = dbContext.CustomUsers.FirstOrDefault(x => x.UserName == finalUser.UserName); AccountBalanceViewModel accountBalanceViewModel = new AccountBalanceViewModel() { AZNBalance = 0.00M, TLBalance = 0.00M, LastIncreasedAZNBalanceDate = DateTime.Now, DbPassportUserModel = signedBalanceUser }; dbContext.Balances.Add(accountBalanceViewModel); dbContext.SaveChanges(); var code = await user.GenerateEmailConfirmationTokenAsync(finalUser); var link = this.Url.ActionLink("EmailVerified", "Register", new { userId = finalUser.Id, code = code }); var message = new MimeMessage(); message.From.Add(new MailboxAddress("Limak", "*****@*****.**")); message.To.Add(new MailboxAddress("Code academy", finalUser.Email)); message.Subject = "Test"; string customText = $"<a href={link}> Click Me<a/>"; var bodyBuilder = new BodyBuilder(); bodyBuilder.HtmlBody = $"<a href={link}> Click Me<a/>"; message.Body = bodyBuilder.ToMessageBody(); using (var client = new SmtpClient()) { client.CheckCertificateRevocation = false; client.Connect("smtp.gmail.com", 587, false); client.Authenticate("*****@*****.**", "miko1999"); client.Send(message); } return(RedirectToAction("PleaseVerify")); } else { ModelState.AddModelError("Password", "Parolda 1 boyuk herf 1 reqem ve 1 simvol olmalidir"); } } } return(View(passportUser)); }