public int AddToCart(int pid, int uid) { if (uid == -1) { return(-1); } PRODUCTS product = db.PRODUCTS.Find(pid); if (product == null) { return(4004); } CART chk = db.CARTs.Where(c => c.UserId == uid && c.ProductId == pid).FirstOrDefault(); CART cartobj = new CART(); if (chk == null) { cartobj.UserId = uid; cartobj.ProductId = product.ProductId; cartobj.ItemQuantity = 1; db.CARTs.Add(cartobj); db.SaveChanges(); return(2000); } else { chk.ItemQuantity += 1; db.Entry(chk).State = EntityState.Modified; db.SaveChanges(); return(2001); } }
public int EditProfile(USERS user) { var oldentry = db.USERS.Find(user.UserId); if (user.DateOfBirth != null) { oldentry.DateOfBirth = user.DateOfBirth; } if (user.Gender != null) { oldentry.Gender = user.Gender; } if (user.FirstName != null) { oldentry.FirstName = user.FirstName; } if (user.LastName != null) { oldentry.LastName = user.LastName; } if (user.PhoneNo != null) { oldentry.PhoneNo = user.PhoneNo; } if (user.EmailId != null && oldentry.EmailId != user.EmailId) { var data = db.USERS.Where(u => u.EmailId == user.EmailId).FirstOrDefault(); if (data != null) { return(4000); } else { oldentry.EmailId = user.EmailId; } } if (user.Password != null) { oldentry.Password = Hash.Hashing(user.Password); } if (user.Question != null) { oldentry.Question = user.Question; } if (user.Answer != null) { oldentry.Answer = user.Answer; } if (user.Role == "admin") { oldentry.Role = "admin"; } db.Entry(oldentry).State = EntityState.Modified; db.SaveChanges(); return(2002); }
public async Task <IActionResult> PutUSERS([FromRoute] int id, [FromBody] USERS uSERS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != uSERS.UserId) { return(BadRequest()); } _context.Entry(uSERS).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!USERSExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public int ModifyProduct(PRODUCTS product) { var oldentry = db.PRODUCTS.Where(p => p.ProductId == product.ProductId).FirstOrDefault(); if (product == null) { return(0); } else { oldentry.ProductName = product.ProductName; oldentry.Price = product.Price; oldentry.Path = product.Path; oldentry.TagLine = product.TagLine; oldentry.ProductShortDiscription = product.ProductShortDiscription; oldentry.Category = product.Category; db.Entry(oldentry).State = EntityState.Modified; db.SaveChanges(); return(1); } }
public int ModifyAddress(ADDRESSES address) { if (address == null) { return(0); } else { db.Entry(address).State = EntityState.Modified; db.SaveChanges(); return(1); } }
public int ModifyUser(int uid) { var data = db.ORDERPLACED.Find(uid); if (data.OrderStatus == "Active") { data.OrderStatus = "Deactive"; } else { data.OrderStatus = "Active"; } db.Entry(data).State = EntityState.Modified; db.SaveChanges(); return(1); }