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