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