public ImageInfoEntity AddImageInfo(ImageInfoInputModel imageInfo, string freeUrl, string freeSuccess) { // checking if something went wrong in email sending process bool ok = true; bool emailSent = false; if (freeSuccess.ToLower() == "sent") { emailSent = true; } else { ok = false; } // Create the entity to add to the database. ImageInfoEntity newEnt = new ImageInfoEntity() { imageGUID = imageInfo.imageGUID, email = imageInfo.email, timeStamp = imageInfo.timeStamp, hasFreeEmailBeenSent = emailSent, hasPremiumEmailBeenSent = false, success = ok, hasImageBeenBought = false, premiumUrl = imageInfo.Url, freeUrl = freeUrl }; _context.imageInfo.Add(newEnt); _context.SaveChanges(); return(newEnt); }
public ActionResult Save(ProductSold model) { var result = false; try { if (model.Id > 0) //Updating { ProductSold pro = db.ProductSolds.SingleOrDefault(x => x.Id == model.Id); if (model.ProductId == 0) //Changes not made for this field --- put a check here isempty isnull (value will be sent null from form if it has not been changed) if valkue is changed in form modal it will apear here { pro.ProductId = pro.ProductId; } else { pro.ProductId = model.ProductId; } if (model.CustomerId == 0) { pro.CustomerId = pro.CustomerId; } else { pro.CustomerId = model.CustomerId; } if (model.StoreId == 0) { pro.StoreId = pro.StoreId; } else { pro.StoreId = model.StoreId; } pro.DateSold = model.DateSold; db.Entry(pro).State = EntityState.Modified; db.SaveChanges(); result = true; } else //Adding { ProductSold pro = new ProductSold(); pro.ProductId = model.ProductId; pro.CustomerId = model.CustomerId; pro.StoreId = model.StoreId; pro.DateSold = model.DateSold; db.ProductSolds.Add(pro); db.SaveChanges(); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "id,nombre,edad,sexoId")] persona persona) { if (ModelState.IsValid) { db.personas.Add(persona); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.sexoId = new SelectList(db.sexos, "id", "Nsexo", persona.sexoId); return(View(persona)); }
public IHttpActionResult SetImagesOrder(IEnumerable <ProjectImages> images) { foreach (var img in images) { var DbImage = db.ProjectImages.Where(li => li.Id == img.Id).FirstOrDefault(); DbImage.SortOrder = img.SortOrder; } db.SaveChanges(); return(Ok()); }
public IActionResult Index(Customer cc) { try { var usr = _dbc.Customer.FromSqlRaw($"SELECT * FROM customer WHERE Username = '******' "); var email = _dbc.Customer.FromSqlRaw($"SELECT * FROM customer WHERE Uemail = '{cc.Uemail}' "); if (usr.FirstOrDefault() != null) { ViewBag.message = "The username " + cc.Username + " already exists!"; } else if (email.FirstOrDefault() != null) { ViewBag.message = "The email " + cc.Uemail + " already exists!"; } else { cc.Active = "1"; cc.Pwd = Encipher(cc.Pwd, 3); cc.enabled = false; _dbc.Add(cc); _dbc.SaveChanges(); ViewBag.message = "The User " + cc.Username + " Is Saved Successfully!"; } return(View()); } catch (Exception sqlerror) { ViewBag.message = sqlerror; } return(View()); }
public IActionResult Create(Report r) { _dbc.Add(r); _dbc.SaveChanges(); return(Redirect("/Home")); }
public void CreateBlogResponse(BlogResponse response) { try { _context.BlogResponses.Add(response); _context.SaveChanges(); } catch (Exception) { } }
public override void OnActionExecuted(System.Web.Http.Filters.HttpActionExecutedContext actionExecutedContext) { var principal = actionExecutedContext.ActionContext.RequestContext.Principal; if(principal != null) { using (var db = new databaseContext()) { var dbUser = (from b in db.AspNetUsers where b.UserName == principal.Identity.Name select b).First(); dbUser.LastActivity = DateTime.Now; db.SaveChanges(); } } }
public BlogEntry CreateBlogEntry(string title, string contents) //string username { var entry = new BlogEntry { Title = title, Contents = contents, //Author = username, //PostedDate = DateTime.Now, }; entry = _context.BlogEntries.Add(entry).Entity; _context.SaveChanges(); return(entry); }
public ActionResult EditOffer(Offer offer) { if (ModelState.IsValid) { _context.Update(offer); _context.SaveChanges(); return(RedirectToAction(nameof(GetOffer))); } return(View(offer)); }
private string checkout() { var currentUserId = HttpContext.Session.GetInt32("UserId"); var cart = _db.Cart.Where(x => x.UserId.Equals(currentUserId)).FirstOrDefault(); var number_generator = new Random(); var cartItems = _db.CartItem.Where(x => x.ShoppingCartId.Equals(cart.CartId)).ToList(); var OrderID = number_generator.Next(100000, 999999); foreach (var x in cartItems) { var addOrder = new OrderDetails { ProductId = x.ProductId, Quantity = x.Quantity, UnitPrice = x.ProductPrice, CustomerID = cart.UserId, Discount = 0, TransactionId = OrderID, ProductName = x.ProductTitle }; _db.OrderDetails.Add(addOrder); _db.SaveChanges(); _db.Entry <OrderDetails>(addOrder).State = EntityState.Detached; } var connectionStringBuilder = new SqliteConnectionStringBuilder(); connectionStringBuilder.DataSource = "./database.db"; var connection = new SqliteConnection(connectionStringBuilder.ConnectionString); connection.Open(); var selectCmd = connection.CreateCommand(); //selectCmd.CommandText = "select * from products where title = '100' or '1' = '1'"; selectCmd.CommandText = $"delete from CartItem where ShoppingCartId = {cart.CartId}"; var result = selectCmd.ExecuteNonQuery(); ViewBag.CheckoutOk = "Successful"; return(ViewBag.CheckoutOk); }
public void Insert(T obj) { context.Set <T>().Add(obj); context.SaveChanges(); }