public void WriteCustomerToDB([FromBody] Customer value)
{
var db = new CustomerModelDataContext();
db.Customers.InsertOnSubmit(value);
db.SubmitChanges();
}
public List <Customer> GetAll()
{
var db = new CustomerModelDataContext();
IEnumerable <Customer> queryResult;
queryResult = db.Customers.OrderBy(o => o.CompanyId);
return(queryResult.ToList <Customer>());
}
public Customer Get(string key = null)
{
var db = new CustomerModelDataContext();
int keyValueAsInt = Int32.Parse(key);
IEnumerable <Customer> queryResult;
queryResult = db.Customers.Where(o => o.CompanyId == keyValueAsInt);
var customer = queryResult.FirstOrDefault();
return(customer);
}
public void UpdateOrderInDB([FromBody] Customer value, string key)
{
var db = new CustomerModelDataContext();
int keyValueAsInt = Int32.Parse(key);
var query = from Customer in db.Customers
where Customer.CompanyId == keyValueAsInt
select Customer;
var orderInDB = query.First();
#region changeDb
if (orderInDB.CompanyName != value.CompanyName)
{
orderInDB.CompanyName = value.CompanyName;
}
if (orderInDB.ContactPerson != value.ContactPerson)
{
orderInDB.ContactPerson = value.ContactPerson;
}
if (orderInDB.Adress != value.Adress)
{
orderInDB.Adress = value.Adress;
}
if (orderInDB.Email != value.Email)
{
orderInDB.Email = value.Email;
}
if (orderInDB.PhoneNumber != value.PhoneNumber)
{
orderInDB.PhoneNumber = value.PhoneNumber;
}
#endregion
db.SubmitChanges();
}