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