public void Add(Usuario usuario)
{
var transaction = _context.Database.BeginTransaction();
try{
usuario.Criacao = DateTime.Now;
usuario.Desativado = 0;
usuario.Senha = TrataHash.GeraMD5Hash(usuario.Senha);
if ((_context.Usuario.Where(x => x.Email == usuario.Email).DefaultIfEmpty().First() == null))
{
_context.Usuario.Add(usuario);
_context.SaveChanges();
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
catch (Exception e) {
Console.WriteLine("Erro");
Console.WriteLine(e);
transaction.Rollback();
return;
}
}
public void Add(Setor setor)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var Log = new Log()
{
Usuario_Logado = "Post Setor",
Acao = "Inclusão de Setor",
Rotina = "Setor Post",
Data_Hora = DateTime.Now
};
_context.log.Add(Log);
_context.setor.Add(setor);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine("Erro");
Console.WriteLine(e);
transaction.Rollback();
}
}
}
public Restaurant AddRestaurant(Restaurant newRestaurant)
{
_context.Restaurants.Add(newRestaurant);
_context.SaveChanges();
return(newRestaurant);
}
public void EditPost(string id, string text)
{
int Id = int.Parse(id.Split('_')[2]);
_context.Posts.First(x => x.Id == Id).Text = text;
_context.SaveChanges();
}
public void Add(Porteiro porteiro)
{
var transaction = _context.Database.BeginTransaction();
try{
porteiro.pessoa.Criacao = DateTime.Now;
porteiro.pessoa.Digital = Util.Util.geraDigital();
porteiro.usuario.Criacao = DateTime.Now;
porteiro.usuario.Tipo = 1;
porteiro.usuario.Desativado = 0;
porteiro.usuario.Senha = TrataHash.GeraMD5Hash(porteiro.usuario.Senha);
if ((_context.Usuario.Where(x => x.Email == porteiro.usuario.Email).DefaultIfEmpty().First() == null) &&
(_context.Pessoa.Where(x => x.Cpf == porteiro.pessoa.Cpf).DefaultIfEmpty().First() == null))
{
_context.Usuario.Add(porteiro.usuario);
_context.Pessoa.Add(porteiro.pessoa);
_context.Porteiro.Add(porteiro);
_context.SaveChanges();
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
catch (Exception e) {
Console.WriteLine("Erro");
Console.WriteLine(e);
transaction.Rollback();
return;
}
}
public void Add(Motorista motorista)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
//Caso o apelido não seja informado receberá o primeiro nome
//Apenas um teste, procurar um forma melhor de realizar este procedimento
if (string.IsNullOrEmpty(motorista.Apelido))
{
string[] nome = motorista.Nome.Split(" ");
for (int i = 0; i < nome.Length; i++)
{
motorista.Apelido = nome[0];
}
}
motorista.Desativado = 0;
_context.Motorista.Add(motorista);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine("Erro");
Console.WriteLine(e);
transaction.Rollback();
return;
}
}
}
public void Add(Pacientes pacientes)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var Log = new Log()
{
Usuario_Logado = "Pacientes",
Acao = "Inclusão",
Rotina = "01Usu",
Data_Hora = DateTime.Now
};
_context.pacientes.Add(pacientes);
_context.log.Add(Log);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
Console.WriteLine("Erro");
Console.WriteLine(e);
transaction.Rollback();
}
}
}
public IActionResult addProduct([Bind("Title, Description, Price")] Product produit, List <IFormFile> photos, List <int> Categories)
{
foreach (IFormFile image in photos)
{
string imageFile = Path.Combine("wwwroot", "images", produit.Title + "-" + Path.GetFileName(image.FileName));
string urlImage = "http://" + Request.Host + "/images/" + produit.Title + "-" + Path.GetFileName(image.FileName);
//var stream = System.IO.File.Create(imageFile);
//image.CopyTo(stream);
//stream.Close();
BinaryReader reader = new BinaryReader(image.OpenReadStream());
serviceImage.SaveImage(reader.ReadBytes((int)image.Length), imageFile, 250, 250);
Image img = new Image {
UrlImage = urlImage
};
data.Images.Add(img);
data.SaveChanges();
produit.Images.Add(new ImageProduit {
Product = produit, Image = img
});
}
foreach (int c in Categories)
{
produit.Categories.Add(new ProductCategorie {
Categorie = data.Categories.Find(c), Product = produit
});
}
data.Products.Add(produit);
data.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ID)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Post()
{
var dataForm = Request.Form;
Contact c = new Contact();
c.Nom = dataForm["Nom"].ToString();
c.Prenom = dataForm["Prenom"].ToString();
c.Email = dataForm["Email"].ToString();
var file = Request.Form.Files[0];
if (file.Length > 0)
{
var pathFolder = Path.Combine("wwwroot", "avatar", Path.GetFileName(file.FileName));
FileStream s = new FileStream(pathFolder, FileMode.Create);
c.UrlImage = "http://" + Request.Host + "/avatar/" + Path.GetFileName(file.FileName);
file.CopyTo(s);
s.Close();
data.Contacts.Add(c);
if (data.SaveChanges() >= 1)
{
return(Ok(new { message = "contact ajouté", error = false, contactId = c.Id }));
}
else
{
return(Ok(new { message = "erreur serveur", error = true }));
}
}
else
{
return(Ok(new { message = "erreur upload", error = true }));
}
}
public void Add(Pessoa pessoa)
{
var transaction = _context.Database.BeginTransaction();
try{
pessoa.Criacao = DateTime.Now;
pessoa.Digital = Util.Util.geraDigital();
if ((_context.Pessoa.Where(x => x.Cpf == pessoa.Cpf).DefaultIfEmpty().First() == null))
{
_context.Pessoa.Add(pessoa);
_context.SaveChanges();
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
catch (Exception e) {
Console.WriteLine("Erro Salvar");
Console.WriteLine(e);
transaction.Rollback();
return;
}
}
public void DeleteList(object s, RoutedEventArgs e) // ------------------- DELETE data in List
{
var ListToDelete = (s as FrameworkElement).DataContext as Datalist;
_context.Datalists.Remove(ListToDelete);
_context.SaveChanges();
}
public ActionResult AddUser()
{
IFormFile avatar = Request.Form.Files[0];
UserApi user = new UserApi();
if (avatar.Length > 0)
{
string pathFolder = Path.Combine("wwwroot", "avatar", Path.GetFileName(avatar.FileName));
FileStream s = new FileStream(pathFolder, FileMode.Create);
user.AvatarUrl = "http://" + Request.Host + "/avatar/" + Path.GetFileName(avatar.FileName);
avatar.CopyTo(s);
s.Close();
}
user.FirstName = Request.Form["firstName"].ToString();
user.LastName = Request.Form["lastName"].ToString();
user.Password = Request.Form["password"].ToString();
user.Email = Request.Form["email"].ToString();
user.Role = 1;
data.Users.Add(user);
if (data.SaveChanges() > 0)
{
return(Ok(new { error = false, userId = user.Id }));
}
else
{
return(StatusCode(500));
}
}
public ActionResult Post()
{
var dataform = Request.Form;
User u = new User();
u.Login = dataform["Login"].ToString();
u.FirstName = dataform["FirstName"].ToString();
u.LastName = dataform["LastName"].ToString();
u.Email = dataform["Email"].ToString();
u.Password = dataform["Password"].ToString();
var file = Request.Form.Files[0];
if (file.Length > 0)
{
var pathFolder = Path.Combine("wwwroot", "images", Path.GetFileName(file.FileName));
FileStream s = new FileStream(pathFolder, FileMode.Create);
u.Image = "http:" + Request.Host + "/images/" + Path.GetFileName(file.FileName);
file.CopyTo(s);
s.Close();
dataDbContext.Users.Add(u);
if (dataDbContext.SaveChanges() <= 1)
{
return(Ok(new { message = "Utilisateur ajouté", error = false, u.Id }));
}
else
{
return(Ok(new { message = "erreur serveur ", error = true }));
}
}
else
{
return(Ok(new { message = "erreur upload", error = true }));
}
}
public MerchantVM Add(MerchantVM mvm)
{
Merchant merchant = new Merchant();
merchant.CompanyName = mvm.CompanyName;
merchant.ProprietorName = mvm.ProprietorName;
merchant.Password = mvm.Password;
merchant.Mobile = mvm.Mobile;
merchant.AlternativeMobile = mvm.AlternativeMobile;
merchant.FbLink = mvm.FbLink;
merchant.Address = mvm.Address;
merchant.WebSiteName = mvm.WebSiteName;
merchant.BankAccount = mvm.BankAccount;
merchant.BussinessType = mvm.BussinessType;
merchant.Location = mvm.Location;
merchant.AccountHolderName = mvm.AccountHolderName;
merchant.District = mvm.District;
merchant.BankName = mvm.BankName;
merchant.BranchName = mvm.BranchName;
merchant.RoutingNumber = mvm.RoutingNumber;
db.Merchants.Add(merchant);
db.SaveChanges();
mvm.MerchantID = merchant.MerchantID;
return(mvm);
}
public async Task <IReadOnlyList <ProductType> > CreateProductTypeAsync(ProductType productType)
{
var types = _context.ProductTypes;
_context.Add(productType);
_context.SaveChanges();
return(await _context.ProductTypes.ToListAsync());
}
public void DeleteContentsByInternalCaptions(IEnumerable <string> internalCaptions)
{
var contentsToRemove = from x in _context.Content
where internalCaptions.Contains(x.InternalCaption)
select x;
_context.Content.RemoveRange(contentsToRemove);
_context.SaveChanges();
}
public IActionResult PutNote(int id, [FromBody] Note note)
{
if (!ModelState.IsValid)
{
return(HttpBadRequest(ModelState));
}
if (id != note.NoteId)
{
return(HttpBadRequest());
}
try
{
if (note.TagsToAdd != "" && note.TagsToAdd != null && note.TagsToAdd != note.TagsAsSingleString)
{
List <string> newTags = note.TagsToAdd.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries).ToList();
if (db.Notes.Where(x => AllowAccess(x.AuthorId, User.GetUserId())).Include(x => x.NoteTags).ThenInclude(x => x.Tag).ToList().Any(x => Functions.CheckIfListsAreEqual(x.ArrayWithTagsNames, newTags) && x.NoteId != note.NoteId))
{
return(HttpBadRequest("Notatka o tych tagach ju¿ istnieje"));
}
else
{
var dbNote = db.Notes.Where(x => AllowAccess(x.AuthorId, User.GetUserId())).Include(x => x.NoteTags).FirstOrDefault(x => x.NoteId == note.NoteId);
if (dbNote == null)
{
return(HttpBadRequest("Edytowana notatka nie istnieje"));
}
db.NoteTags.RemoveRange(dbNote.NoteTags.ToList());
//Functions.DisplayTrackedEntities(db.ChangeTracker);
db.SaveChanges();
dbNote.NoteTags = TagsToAddToTags(note).NoteTags;
//Functions.DisplayTrackedEntities(db.ChangeTracker);
db.SaveChanges();
}
}
}
catch (DbUpdateConcurrencyException)
{
if (!NoteExists(id))
{
return(HttpNotFound());
}
else
{
throw;
}
}
catch (Exception e)
{
Trace.WriteLine(e);
}
return(new HttpStatusCodeResult(StatusCodes.Status204NoContent));
}
//Find a Note by its ID and delete it
public void DestroyNote(int ID)
{
Note note = _context.Notes.FirstOrDefault(n => n.ID == ID);
if (note != null)
{
_context.Notes.Remove(note);
_context.SaveChanges();
}
}
public async Task <ActionResult> CreateItem(MainPageProduct mainPageProduct)
{
await _context.MainPageProducts.AddAsync(mainPageProduct);
_context.SaveChanges();
var products = await _context.MainPageProducts.ToListAsync();
return(Ok(products));
}
public ActionResult Create([Bind(Include = "ProductId,Name,Weight,Price")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ColorVM Add(ColorVM cvm)
{
Color color = new Color();
color.Name = cvm.Name;
db.Colors.Add(color);
db.SaveChanges();
cvm.ID = color.ID;
return(cvm);
}
// POST api/genres
// Método para salvar um novo gênero
public IHttpActionResult Post([FromBody] Genre entity)
{
// Seta a Data de Criação para este momento
entity.DataCriacao = DateTime.Now;
// Adiciona no banco de dados
dataDbContext.Genres.Add(entity);
// Salva as mudanças feitas no banco de dados
dataDbContext.SaveChanges();
// Retorna o id da entidade recém criada
return(Ok(entity.ID));
}
public ActionResult Create([Bind(Include = "CartId,DateAndTime")] Cart cart)
{
if (ModelState.IsValid)
{
db.Cart.Add(cart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cart));
}
public User Create(User user, string password)
{
CreatePasswordHash(password, out var passwordHash, out var passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
_context.Users.Add(user);
_context.SaveChanges();
return(user);
}
public ProductRatingVM Add(ProductRatingVM rvm)
{
ProductRating productRating = new ProductRating();
productRating.ProductID = rvm.ProductID;
productRating.Star = rvm.Star;
db.ProductRatings.Add(productRating);
db.SaveChanges();
rvm.ID = productRating.ID;
return(rvm);
}
public OrderStatusVM Add(OrderStatusVM svm)
{
OrderStatus orderStatus = new OrderStatus();
orderStatus.Caption = svm.Caption;
orderStatus.IsActive = svm.IsActive;
db.OrderStatuses.Add(orderStatus);
db.SaveChanges();
svm.ID = orderStatus.ID;
return(svm);
}
public BrandVM Add(BrandVM bvm)
{
Brand brand = new Brand();
brand.BandName = bvm.BandName;
brand.CategoryID = bvm.CategoryID;
brand.ParentBandID = bvm.ParentBandID;
db.Brands.Add(brand);
db.SaveChanges();
bvm.ID = brand.ID;
return(bvm);
}
/// <summary>
/// Create a new Movie, using MoviePostModel
/// </summary>
/// <param name="movie">New Movie object</param>
/// <returns></returns>
public Movie Create(MoviePostModel movie)
{
Movie convertedMovie = MoviePostModel.ToMovie(movie);
if (convertedMovie == null)
{
return(null);
}
Context.Movies.Add(convertedMovie);
Context.SaveChanges();
return(convertedMovie);
}
public ActionResult Create([Bind(Include = "CartItemId,Amount,CartId,ProductId")] CartItem cartItem)
{
if (ModelState.IsValid)
{
db.CartItem.Add(cartItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CartId = new SelectList(db.Cart, "CartId", "CartId", cartItem.CartId);
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name", cartItem.ProductId);
return(View(cartItem));
}
