public int RemoveOrder(int oid) { var po = db.ORDERPLACED.Where(op => op.OderId == oid).FirstOrDefault(); db.ORDERPLACED.Remove(po); db.SaveChanges(); return(2000); }
public int AddAddress(ADDRESSES address, int uid) { //var address = new ADDRESSES(); address.UserId = uid; db.ADDRESSES.Add(address); db.SaveChanges(); return(2002); }
public int ModifyProduct(int oid) { var dataO = from o in db.ORDERPLACED where o.OderId == oid join p in db.PRODUCTS on o.ProductId equals p.ProductId join u in db.USERS on o.UserId equals u.UserId select new { p.ProductName, p.Price, p.Path, u.FirstName, u.LastName, o.UserId, o.TotalAmount, o.OrderedQuantity, o.OrderDate, o.Address, o.ModeOfPayment, o.ProductId, o.OrderNo, }; var data = dataO.FirstOrDefault(); if (data != null) { ORDERSHISTORY oh = new ORDERSHISTORY(); oh.ProductName = data.ProductName; oh.Price = data.Price; oh.UserId = data.UserId; oh.CustomerName = data.FirstName + " " + data.LastName; oh.TotalAmount = data.TotalAmount; oh.Quantity = data.OrderedQuantity; oh.OrderDate = data.OrderDate; oh.DiliveryAddress = data.Address; oh.ModeOfPayment = data.ModeOfPayment; oh.ProductId = data.ProductId; oh.DeliveryDate = DateTime.Now; oh.OrderNo = data.OrderNo; oh.OrderStatus = "Delivered"; oh.Path = data.Path; db.ORDERSHISTORY.Add(oh); db.SaveChanges(); var dataD = db.ORDERPLACED.Find(oid); db.ORDERPLACED.Remove(dataD); db.SaveChanges(); return(1); } return(0); }
public int AddAddress(ADDRESSES address) { if (address == null) { return(4004); } else { db.ADDRESSES.Add(address); db.SaveChanges(); return(2002); } }
public int AddProduct(PRODUCTS product) { if (product == null) { return(0); } else { product.Status = "Active"; db.PRODUCTS.Add(product); db.SaveChanges(); return(1); } }
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 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); }
public int Register(USERS user) { var data = db.USERS.Where(u => u.EmailId == user.EmailId).FirstOrDefault(); if (data != null) { return(4000); } if (user != null) { user.Role = "customer"; user.TimeStamp = DateTime.Now; user.Password = Hash.Hashing(user.Password); db.USERS.Add(user); db.SaveChanges(); return(2000); } return(4004); }