public ActionResult Create(Guia guia) { if (ModelState.IsValid) { db.Guia.Add(guia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(guia)); }
public ActionResult Create(Contato contato) { if (ModelState.IsValid) { db.Contato.Add(contato); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contato)); }
public ActionResult Create(Genero genero) { if (ModelState.IsValid) { db.Genero.Add(genero); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(genero)); }
public ActionResult Complete(int id) { // Validate customer owns this order bool isValid = db.Reserva.Any( o => o.OrdemId == id && o.Username == User.Identity.Name); if (isValid) { //Limpa carrinho //var cartItem = db.Carrinho.Include(cart => cart.CarrinhoId == User.Identity.Name).ToList(); var cartItem = db.Carrinho.Where(cart => cart.CarrinhoId == User.Identity.Name).ToList(); int itemCount = 0; if (cartItem != null) { if (cartItem.Count > 1) { foreach (var aux in cartItem) { aux.Count--; itemCount = cartItem.Count; db.Carrinho.Remove(aux); if (cartItem == null) { break; } } } else { db.Carrinho.Remove(cartItem.FirstOrDefault()); } // Save changes db.SaveChanges(); } //Renova Session Session.Contents.Abandon(); Session.Contents.RemoveAll(); Response.Cookies.Add(new HttpCookie("ASP.NET_SessionId")); return(View(id)); } else { return(View("Error")); } }
public ActionResult Create(Transportadora transportadora) { if (ModelState.IsValid) { db.Transportadora.Add(transportadora); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(transportadora)); }
public ActionResult Create(Veiculo veiculo) { if (ModelState.IsValid) { db.Veiculo.Add(veiculo); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TransportadoraId = new SelectList(db.Transportadora, "ID", "Nome", veiculo.TransportadoraId); return(View(veiculo)); }
public ActionResult Create(Excurcao excurcao) { if (ModelState.IsValid) { db.Excurcao.Add(excurcao); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.GeneroId = new SelectList(db.Genero, "ID", "Nome", excurcao.GeneroId); ViewBag.GuiaId = new SelectList(db.Guia, "ID", "Nome", excurcao.GuiaId); ViewBag.VeicuiloId = new SelectList(db.Veiculo, "VeiculoId", "MarcaCarro", excurcao.VeicuiloId); return(View(excurcao)); }
public dynamic PlaceOrder(Order _order) { try { Customer cus = _context.Customers.Where(w => w.Email == _order.email).FirstOrDefault(); int CustomerID = 0; if (cus == null) { Customer _objCus = new Customer(); _objCus.Name = _order.name; _objCus.Email = _order.email; _objCus.Address = _order.address; _objCus.TelephoneNo = _order.tel; _context.Customers.Add(_objCus); _context.SaveChanges(); CustomerID = _objCus.CustomerID; } else { CustomerID = cus.CustomerID; } CustomerOrder _cusOrder = new CustomerOrder(); _cusOrder.CustomerID = CustomerID; _context.CustomerOrders.Add(_cusOrder); _context.SaveChanges(); foreach (var items in _order.ItemList) { ShoppingCart cusOrder = new ShoppingCart(); cusOrder.OrderID = _cusOrder.OrderID; cusOrder.ItemID = Convert.ToInt32(items._id); cusOrder.Qty = Convert.ToInt32(items.quantity); cusOrder.Price = Convert.ToDouble(items.price); cusOrder.ItemNote = items.userNotes; _context.ShoppingCarts.Add(cusOrder); _context.SaveChanges(); } return("Your Order Place Sucessfully. Order ID : " + _cusOrder.OrderID); } catch (Exception ex) { return("Error. Error Msg : " + ex.Message); } }
public bool Update(string id, SYS_GroupLayer model) { if (model == null) { throw new ArgumentNullException(); } try { using (var context = new SystemEntities()) { var baseModel = context.SYS_GroupLayer.FirstOrDefault(f => f.ID.Equals(id)); if (baseModel == null) { throw new NullReferenceException("Không tìm thấy đối tượng trong cơ sở dữ liệu"); } else { model.ID = id; context.Entry(baseModel).CurrentValues.SetValues(model); return(context.SaveChanges() > 0); } } } catch (Exception e) { throw e; } }
public DBResult EditAll(List <User> entities) { if (entities == null) { return(DBResult.WrongParameter); } using (var db = new SystemEntities()) { foreach (var entity in entities) { if (EntityHelper.HasNullProperty(entity, new string[] { "Password" })) { return(DBResult.WrongParameter); } var user = db.User.FirstOrDefault(u => u.ID == entity.ID); if (user == null) { return(DBResult.NotFound); } var existResult = CheckExists(db.User, new string[] { "ShortID", "UserName" }, entity, true); if (existResult != DBResult.Succeed) { return(existResult); } EntityHelper.CopyEntity(entity, user, new string[] { "Password" }); } db.SaveChanges(); return(DBResult.Succeed); } }
public SYS_Layer_Account Create(SYS_Layer_Account model) { try { using (var context = new SystemEntities()) { if (model != null) { var addModel = context.SYS_Layer_Account.Add(model); var result = context.SaveChanges(); if (result > 0) { return(addModel); } else { return(null); } } else { return(null); } } } catch (Exception e) { throw e; } }
public bool Update(int id, SYS_Layer_Account model) { if (model == null) { throw new ArgumentNullException(); } try { using (var context = new SystemEntities()) { var baseModel = context.SYS_Layer_Account.FirstOrDefault(f => f.ID.Equals(id)); if (baseModel == null) { throw new NullReferenceException("Không tìm thấy đối tượng trong cơ sở dữ liệu"); } else { model.ID = id; context.Entry(baseModel).CurrentValues.SetValues(model); //context.Entry(model).State = System.Data.Entity.EntityState.Modified; //context.SYS_Layer_Account.Attach(model); return(context.SaveChanges() > 0); } } } catch (Exception e) { throw e; } }
public ActionResult PeopleForm(FormCollection values) { var order = new Ordem(); TryUpdateModel(order); try { order.Username = User.Identity.Name; order.OrderDate = DateTime.Now; //Save Order storeDB.Ordem.Add(order); storeDB.SaveChanges(); //Process the order var cart = ShoppingCart.GetCart(this.HttpContext); cart.CreateOrder(order); return(RedirectToAction("Complete", new { id = order.OrdemId })); } catch { //Invalid - redisplay with errors return(View(order)); } }
public DBResult ChangePassword(User entity) { if (entity == null || entity.ID == 0 || string.IsNullOrEmpty(entity.Password)) { return(DBResult.WrongParameter); } using (var db = new SystemEntities()) { var user = db.User.FirstOrDefault(u => u.ID == entity.ID); if (user == null) { return(DBResult.NotFound); } user.Password = entity.Password; db.SaveChanges(); return(DBResult.Succeed); } }
public SYS_Version Create(SYS_Version model) { using (var context = new SystemEntities()) { if (model != null) { var addModel = context.SYS_Version.Add(model); var result = context.SaveChanges(); if (result > 0) { return(addModel); } else { return(null); } } else { return(null); } } }
public bool Delete(int id) { try { using (var context = new SystemEntities()) { var model = context.SYS_Layer_Account.FirstOrDefault(f => f.ID.Equals(id)); if (model != null) { context.SYS_Layer_Account.Remove(model); return(context.SaveChanges() > 0); } else { return(false); } } } catch (Exception e) { throw e; } }
public bool Create(List <SYS_Logger_Layer> models) { try { using (var context = new SystemEntities()) { if (models != null && models.Count > 0) { var addModel = context.SYS_Logger_Layer.AddRange(models); var result = context.SaveChanges(); return(result > 0); } else { return(false); } } } catch (Exception e) { throw e; } }
public void SaveToDb() { context.SaveChanges(); }