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