public IHttpActionResult PutProduct(int id, Product product) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product.ProductID) { 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 IActionResult Authentication([FromBody] Account account) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var existStudent = _context.Student.SingleOrDefault(a => a.Email == account.Email); if (existStudent == null) { Response.StatusCode = 403; return(new JsonResult("Forbidden1")); } var isValidPassword = existStudent.CheckLoginPassword(account.Password); if (isValidPassword) { MyCredential credential = new MyCredential(existStudent.Id); _context.MyCredentials.Add(credential); _context.SaveChanges(); Response.StatusCode = 200; return(new JsonResult(credential)); } Response.StatusCode = 403; return(new JsonResult("Forbidden2")); }
public IHttpActionResult PutContacto(int id, Contacto contacto) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != contacto.SivilaId) { return(BadRequest()); } db.Entry(contacto).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ContactoExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create(Models.User user) { if (ModelState.IsValid) { //Hash da Senha user.Senha = BCrypt.Net.BCrypt.HashPassword(user.Senha); user.ConfirmarSenha = user.Senha; //AesCryptoServiceProvider AesCryptoServiceProvider aes = new AesCryptoServiceProvider(); aes.BlockSize = 128; aes.KeySize = 256; aes.IV = Encoding.UTF8.GetBytes(AesIV256BD); aes.Key = Encoding.UTF8.GetBytes(AesKey256BD); aes.Mode = CipherMode.CBC; aes.Padding = PaddingMode.PKCS7; byte[] src = Encoding.Unicode.GetBytes(user.Email); //Encriptação using (ICryptoTransform encrypt = aes.CreateEncryptor()) { byte[] dest = encrypt.TransformFinalBlock(src, 0, src.Length); //Converte byte array para string de base 64 user.Email = Convert.ToBase64String(dest); } db.Users.Add(user); db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public Note AddNotes(Note note) { _dbcontext.Add(note); _dbcontext.SaveChanges(); return(note); }
public User UpdateToken(User user) { var resultUser = GetUser(user.Email); resultUser.Token = user.Token; resultUser.TokenExpiresIn = DateTime.Now.AddHours(1); _context.SaveChanges(); return(resultUser); }
public ActionResult Create([Bind(Include = "CTUSER_ID,CTUSER_LEVEL,CTUSER_TRANGTHAI")] ChiTietUs chiTietUs) { if (ModelState.IsValid) { db.ChiTietUses.Add(chiTietUs); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(chiTietUs)); }
public ActionResult Create([Bind(Include = "Id,Nome,Cnpj,Email,Telefone")] Fornecedor fornecedor) { if (ModelState.IsValid) { db.Fornecedors.Add(fornecedor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fornecedor)); }
public ActionResult Create([Bind(Include = "Id,Nome,Descricao,CorProduto,StatusProduto,IdFornecedor")] Produto produto) { if (ModelState.IsValid) { db.Produtos.Add(produto); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IdFornecedor = new SelectList(db.Fornecedors, "Id", "Nome", produto.IdFornecedor); return(View(produto)); }
public bool Create(Author author) { try { _context.Authors.Add(author); _context.SaveChanges(); return(true); } catch { return(false); } }
public bool Create(Book book) { try { _context.Books.Add(book); _context.SaveChanges(); return(true); } catch { return(false); } }
public ActionResult Create([Bind(Include = "CSCT_ID,CSCT_TenThuoc,CSCT_SoLuong,CSCT_Ngay,CS_ID,CSCT_TongTien")] ChamSocChiTiet chamSocChiTiet) { if (ModelState.IsValid) { chamSocChiTiet.CSCT_ID = autotang(db.ChamSocChiTiets.Count()); chamSocChiTiet.CS_ID = Convert.ToInt32(Session["CS_ID"]); db.ChamSocChiTiets.Add(chamSocChiTiet); db.SaveChanges(); return(RedirectToAction("Index/" + Session["CS_ID"])); } ViewBag.CS_ID = new SelectList(db.ChamSocs, "CS_ID", "CS_Name", chamSocChiTiet.CS_ID); return(View(chamSocChiTiet)); }
public ActionResult Create([Bind(Include = "Ruong_ID,User_ID,Ruong_Name,Ruong_DienTich,Ruong_MoTa")] Ruong ruong) { if (ModelState.IsValid) { ruong.Ruong_ID = autotang(db.Ruongs.Count()); ruong.User_ID = Convert.ToInt32(Session["User_ID"]); db.Ruongs.Add(ruong); db.SaveChanges(); return(RedirectToAction("Index/" + Session["User_ID"])); } ViewBag.User_ID = new SelectList(db.Users, "User_ID", "User_Name", ruong.User_ID); return(View(ruong)); }
public ActionResult Create([Bind(Include = "CS_ID,Ruong_ID,CS_Name,CS_MoTa,CS_Mua")] ChamSoc chamSoc) { if (ModelState.IsValid) { chamSoc.CS_ID = autotang(db.ChamSocs.Count()); chamSoc.Ruong_ID = Convert.ToInt32(Session["Ruong_ID"]); db.ChamSocs.Add(chamSoc); db.SaveChanges(); return(RedirectToAction("Index/" + Session["Ruong_ID"])); } ViewBag.Ruong_ID = new SelectList(db.Ruongs, "Ruong_ID", "Ruong_Name", chamSoc.Ruong_ID); return(View(chamSoc)); }
public ActionResult DeclineFriend(int id) { var requester = id; var currentUser = Convert.ToInt32(Session["UserID"]); using (Datacontext db = new Datacontext()) { var AllFriendConnections = db.Friends.ToList(); var PendingFriends = new List <Friend>(); foreach (Friend friend in AllFriendConnections) { if (friend.Accepted == false) { PendingFriends.Add(friend); } } foreach (Friend friend in PendingFriends) { if (friend.Friend1 == id && friend.Friend2 == currentUser) { db.Friends.Remove(friend); } } db.SaveChanges(); return(RedirectToAction("Friends")); } }
public ActionResult EditProfilePic(editwrapper edit) { try { using (Datacontext db = new Datacontext()) { var id = int.Parse(Session["UserID"].ToString()); var usr = db.Users.Single(u => u.Id == id); if ((edit.ProfileURL.ProfileURL.EndsWith(".jpg") || edit.ProfileURL.ProfileURL.EndsWith(".png") || edit.ProfileURL.ProfileURL.EndsWith(".img")) && edit.ProfileURL.ProfileURL != null) { usr.PictureURL = edit.ProfileURL.ProfileURL; } else { ModelState.AddModelError("", "Must be a URL from the internet ending with .jpg, .png or .img"); } db.SaveChanges(); } } catch { ModelState.AddModelError("", "Something went wrong, please try again."); return(View("EditAccount")); } return(RedirectToAction("EditAccount")); }
public void insertPost([FromBody] Posts newPost) { if (newPost.TextContent != "") { db.Post.Add(newPost); db.SaveChanges(); } }
public ActionResult Create([Bind(Include = "TH_ID,Ruong_ID,TH_Name,TH_ChiSo,TH_TienTrenDa,TH_TongTien,TH_MoTa")] ThuHoach thuHoach) { int SoDa = Convert.ToInt32(Request["TH_ChiSo"]); int tientrenda = Convert.ToInt32(Request["TH_TienTrenDa"]); if (ModelState.IsValid) { thuHoach.TH_ID = autotang(db.ThuHoaches.Count()); thuHoach.Ruong_ID = Convert.ToInt32(Session["Ruong_ID"]); thuHoach.TH_TongTien = SoDa * tientrenda; db.ThuHoaches.Add(thuHoach); db.SaveChanges(); return(RedirectToAction("Index/" + Session["Ruong_ID"])); } ViewBag.Ruong_ID = new SelectList(db.Ruongs, "Ruong_ID", "Ruong_Name", thuHoach.Ruong_ID); return(View(thuHoach)); }
public ActionResult Create([Bind(Include = "User_ID,CTUSER_ID,User_Name,User_Detail,User_TK,User_MK")] User user) { string TK = Request["User_TK"]; string MK = Request["User_MK"]; string MK1 = Request["User_MK1"]; string UserName = Request["User_Name"]; string TenTK = db.Database.SqlQuery <string>("select User_TK from Users where User_TK ='" + TK + "'").SingleOrDefault(); if (UserName.Length <= 0) { ModelState.AddModelError("", "Tên người dùng không được để trống"); } else if (TK.Length <= 0) { ModelState.AddModelError("", "Tài khoản không được để trống"); } if (TenTK != null) { ModelState.AddModelError("", "Tài khoản đã tồn tại"); } else if (MK.Length == 0 || MK1.Length == 0) { ModelState.AddModelError("", "Mật khẩu không được để trống"); } else if (MK != MK1) { ModelState.AddModelError("", "Mật khẩu xác nhận không giống nhau !@!"); } if (ModelState.IsValid) { user.User_ID = autotang(db.Users.Count()); user.CTUSER_ID = 1; user.User_MK = PassMD5.GetMD5(MK); db.Users.Add(user); db.SaveChanges(); ModelState.AddModelError("", "Đăng ký thành công !!!"); } ViewBag.CTUSER_ID = new SelectList(db.ChiTietUses, "CTUSER_ID", "CTUSER_ID", user.CTUSER_ID); return(View(user)); }
public void AddReview(Review review, double average, int amount) { _db.Reviews.Add(review); var book = (from b in _db.Books where b.BookId == review.BookId select b).SingleOrDefault(); book.ReviewScore = Math.Round((review.Rating + average * amount) / (amount + 1), 2); _db.SaveChanges(); }
public StudentsController(Datacontext datacontext) { _datacontext = datacontext; if (_datacontext.Students.Count() == 0) { _datacontext.Students.Add(new Student { Name = "Huy", ClassId = 1, Address = "Ha Dong", Email = "*****@*****.**" }); _datacontext.SaveChanges(); } }
public ClassesController(Datacontext datacontext) { _datacontext = datacontext; if (_datacontext.Classes.Count() == 0) { _datacontext.Classes.Add(new Class { Name = "AT12" }); _datacontext.SaveChanges(); } }
public static void SeedData() { var db = new Datacontext(); if (!db.Books.Any()) { var InitialBooks = new List <Book>() { //10 default books, Sindri new Book { Title = "The Hitchhiker's Guide to the Galaxy", Author = "Douglas Adams", ReleaseYear = 1979, Genre = "SciFi", ISBN = "330258648", Price = 17.99, Stock = 10, TopSeller = false, OnSale = false, Discount = 0, Image = "https://images.penguinrandomhouse.com/cover/9781400052929" }, new Book { Title = "It", Author = "Stephen King", ReleaseYear = 1986, Genre = "Horror", ISBN = "670813028", Price = 23.99, Stock = 15, TopSeller = false, OnSale = false, Discount = 0, Image = "http://cdn.collider.com/wp-content/uploads/2017/09/it-book-cover.jpg" }, new Book { Title = "The Dark Knight Returns", Author = "Frank Miller", ReleaseYear = 1986, Genre = "Comics", ISBN = "1563893428", Price = 20.99, Stock = 25, TopSeller = false, OnSale = false, Discount = 0, Image = "https://upload.wikimedia.org/wikipedia/en/7/77/Dark_knight_returns.jpg" }, new Book { Title = "The Shining", Author = "Stephen King", ReleaseYear = 1977, Genre = "Horror", ISBN = "9780385121675", Price = 10.99, Stock = 20, TopSeller = false, OnSale = false, Discount = 0, Image = "https://upload.wikimedia.org/wikipedia/en/4/4c/Shiningnovel.jpg" }, new Book { Title = "Stars in My Pocket Like Grains of Sand", Author = "Samuel R. Delany", ReleaseYear = 1984, Genre = "SciFi", ISBN = "9780553050530", Price = 27.99, Stock = 10, TopSeller = false, OnSale = false, Discount = 0, Image = "https://upload.wikimedia.org/wikipedia/en/4/4d/Stars_in_my_pocket_like_grains_of_sand.jpg" }, new Book { Title = "The Grapes of Wrath", Author = "John Steinbeck", ReleaseYear = 1939, Genre = "Drama", ISBN = "9780143039433", Price = 11.49, Stock = 7, TopSeller = false, OnSale = false, Discount = 0, Image = "https://upload.wikimedia.org/wikipedia/en/1/1f/JohnSteinbeck_TheGrapesOfWrath.jpg" }, new Book { Title = "How to Compile C Code", Author = "Bjorgvin Karason", ReleaseYear = 2013, Genre = "Educational", ISBN = "9780446310001", Price = 44.29, Stock = 13, TopSeller = false, OnSale = false, Discount = 0, Image = "https://images-na.ssl-images-amazon.com/images/I/41gpxHEh2rL._SX403_BO1,204,203,200_.jpg" }, new Book { Title = "The Hobbit, or There and Back Again", Author = "J. R. R. Tolkien", ReleaseYear = 1937, Genre = "Fantasy", ISBN = "9780547928227", Price = 27.09, Stock = 50, TopSeller = false, OnSale = false, Discount = 0, Image = "http://media.bookbub.com/wp-content/uploads/2014/12/1937.jpg" }, new Book { Title = "To Kill a Mockingbird", Author = "Harper Lee", ReleaseYear = 1960, Genre = "Drama", ISBN = "9780446310789", Price = 23.99, Stock = 15, TopSeller = false, OnSale = false, Discount = 0, Image = "https://upload.wikimedia.org/wikipedia/en/7/79/To_Kill_a_Mockingbird.JPG" }, new Book { Title = "Foundation", Author = "Isaac Asimov", ReleaseYear = 1951, Genre = "SciFi", ISBN = "553293354", Price = 25.99, Stock = 30, TopSeller = false, OnSale = false, Discount = 0, Image = "https://static.squarespace.com/static/51b3dc8ee4b051b96ceb10de/51ce6099e4b0d911b4489b79/51ce6178e4b0d911b4495446/1317432124153/1000w/Isaac%20Asimov_1951_Foundation.jpg" } }; db.AddRange(InitialBooks); db.SaveChanges(); } }
public void AddToCart(Book book, string ShoppingCartId) { var cartItem = _storeDb.Carts.SingleOrDefault( c => c.CartId == ShoppingCartId && c.BookId == book.BookId); if (cartItem == null) { //no items in cart cartItem = new Cart { CartId = ShoppingCartId, BookId = book.BookId, Count = 1, DateCreated = DateTime.Now, }; _storeDb.Carts.Add(cartItem); } else { //if the book exists in the cart, increase the quantity cartItem.Count++; } _storeDb.SaveChanges(); }
public ActionResult AddFriend(int id) { using (Datacontext db = new Datacontext()) { Friend friend = new Friend(); friend.Friend1 = Convert.ToInt32(Session["UserID"]); friend.Friend2 = id; friend.Accepted = false; db.Friends.Add(friend); db.SaveChanges(); return(RedirectToAction("FriendProfile", new { id = id })); } }
public IActionResult Register(User user) { Data_User datauser = new Data_User(); datauser.UserId = user.UserId; datauser.UserName = user.UserName; datauser.Password = user.Password; _datacontext.data_Users.Add(datauser); _datacontext.SaveChanges(); return(Content("Registration Successful , Please Login")); }
public IActionResult Post(string type, Light model) { if (model == null) { return(BadRequest()); } if (type == "light") { var rec = new Light(); rec.Status = model.Status; _db.Lights.Add(rec); _db.SaveChanges(); return(Ok()); } else { return(NotFound()); } }
public IActionResult Create([FromBody] User data) { var user = _context.Users.SingleOrDefault(x => x.UserName == data.UserName); if (user != null) { return(Ok( new{ success = "This Username Already used" } )); } _context.Users.Add(data); _context.SaveChanges(); return(Ok( new{ success = "true" } )); }
public ActionResult Save(Customer customer) { if (customer.Id == 0) { _context.Customers.Add(customer); } else { var customerInDb = _context.Customers.Single(c => c.Id == customer.Id); customerInDb.Name = customer.Name; customerInDb.BirthDate = customer.BirthDate; customerInDb.MemberShipTypeId = customer.MemberShipTypeId; customerInDb.IsSubscribedToNewsLetter = customer.IsSubscribedToNewsLetter; } _context.SaveChanges(); return(RedirectToAction("CustomerDetails", "Customers")); }
public ActionResult EditAbout(editwrapper edit) { try { using (Datacontext db = new Datacontext()) { var id = int.Parse(Session["UserID"].ToString()); var usr = db.Users.Single(u => u.Id == id); usr.About = edit.About.About; db.SaveChanges(); } } catch { ModelState.AddModelError("", "Something went wrong, please try again."); return(View("EditAccount")); } return(RedirectToAction("EditAccount")); }