public bool UpdateProduct(ProductB product) { var updated = true; using (var NWEntities = new SaveWorldEntities()) { var productId = product.ProductId; var productDatabase = (from p in NWEntities.Products where p.id == productId select p).FirstOrDefault(); if (productDatabase == null) { throw new Exception("No product with ID " + product.ProductId); } productDatabase.productName = product.ProductName; productDatabase.price = product.Price; productDatabase.description = product.ProductDescription; productDatabase.minStock = product.Stock; NWEntities.Products.Attach(productDatabase); NWEntities.Entry(productDatabase).State = System.Data.Entity.EntityState.Modified; var num = NWEntities.SaveChanges(); } return(updated); }
public bool Update(BankAccountB bankAccountBefore) { bool update = true; using (var NWEntities = new SaveWorldEntities()) { var bankId = bankAccountBefore.AccountId; var accountForSave = (from p in NWEntities.BankAccounts where p.id == bankId select p).FirstOrDefault(); accountForSave.accountNo = bankAccountBefore.AccountNo; accountForSave.amount = bankAccountBefore.Amount; accountForSave.ccv = bankAccountBefore.CCV; accountForSave.expiryDate = bankAccountBefore.ExpiryDate; accountForSave.rowVersion = bankAccountBefore.RowVersion; NWEntities.BankAccounts.Attach(accountForSave); NWEntities.Entry(accountForSave).State = System.Data.Entity.EntityState.Modified; try { NWEntities.SaveChanges(); } catch { update = false; } } return(update); }
public void UpdateOrderLine(OrderLine orderLine) { using (var NWEntities = new SaveWorldEntities()) { var orderLineId = orderLine.OrderLineId; var orderLineDatabase = (from p in NWEntities.OrderLine where p.id == orderLineId select p).FirstOrDefault(); if (orderLineDatabase == null) { throw new Exception("No orderLine with ID " + orderLine.OrderLineId); } orderLineDatabase.id = orderLine.OrderLineId; orderLineDatabase.orderId = orderLine.OrderID; orderLineDatabase.price = orderLine.Price; orderLineDatabase.productId = orderLine.ProductID; orderLineDatabase.quantity = orderLine.Quantity; NWEntities.OrderLine.Attach(orderLineDatabase); NWEntities.Entry(orderLineDatabase).State = System.Data.Entity.EntityState.Modified; var num = NWEntities.SaveChanges(); } }
/* public bool IsCookieValid(string cookieId) * { * CoreValidator.ThrowIfNullOrEmpty(cookieId, nameof(cookieId)); * using (var db = new AuctionContext()) * { * return db.Users.Any(u => u.RememberToken == cookieId); * } * } */ public bool UpdateUser(UserB user) { string salted = SaltGenerator(10); string passHash = Hasher(user.Password + salted); var updated = true; using (var NWEntities = new SaveWorldEntities()) { var userId = user.UserId; var userDatabase = (from p in NWEntities.Ausers where p.id == userId select p).FirstOrDefault(); if (userDatabase == null) { throw new Exception("No user with ID " + user.UserId); } userDatabase.name = user.Name; userDatabase.email = user.Email; userDatabase.password = passHash; userDatabase.salt = salted; userDatabase.phoneno = user.Phone; userDatabase.address = user.Address; userDatabase.accountId = user.BankAccountId; NWEntities.Ausers.Attach(userDatabase); NWEntities.Entry(userDatabase).State = System.Data.Entity.EntityState.Modified; var num = NWEntities.SaveChanges(); } return(updated); }
public bool UpdateDisaster(DisasterB disaster) { var updated = true; using (var NWEntities = new SaveWorldEntities()) { var disasterId = disaster.DisasterId; var disasterDatabse = (from p in NWEntities.Disasters where p.id == disasterId select p).FirstOrDefault(); if (disasterDatabse == null) { throw new Exception("No disaster with ID " + disaster.DisasterId); } disasterDatabse.disasterName = disaster.Name; disasterDatabse.description = disaster.Description; disasterDatabse.priority = disaster.Priority; disasterDatabse.region = disaster.Region; disasterDatabse.victims = disaster.Victims; NWEntities.Disasters.Attach(disasterDatabse); NWEntities.Entry(disasterDatabse).State = System.Data.Entity.EntityState.Modified; var num = NWEntities.SaveChanges(); } return(updated); }