public bool addProvince(AdressModel adress)
{
if (adress.province != "")
return true;
return false;
}
//Legger en province inn i databasen dersom den ikke finnes fra før
public bool addProvince(AdressModel adress)
{
return _customerDAL.addProvince(adress);
}
public bool addAdress(AdressModel adressModel)
{
if (adressModel.personID > 0)
return true;
return false;
}
//Legger til ny adresse for bruker med customerID==adressModel.customerID. Alle felter unntatt adressID må være fylt ut
public bool addAdress(AdressModel adressModel)
{
return _customerDAL.addAdress(adressModel);
}
//Legger customer inn i datatbasen
public bool add(CustomerModel IncCustomer)
{
using (var db = new CustomerContext())
{
try
{
if (!(db.Customers.Find(IncCustomer.customerID) == null))//Hvis IncCustomer har customerID som finnes fra før
return false;
if (find(IncCustomer.email) != null)//Tester om eposten er i bruk fra før
return false;
var newCustomer = new Customers()//Opretter ny customer
{
email = IncCustomer.email,
firstName = IncCustomer.firstName,
lastName = IncCustomer.lastName,
phone = IncCustomer.phone
};
newCustomer = db.Customers.Add(newCustomer);
db.SaveChanges();
IncCustomer.customerID = newCustomer.personID;//Lagrer customerID i modellen for senere bruk
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
return false;
}
}//end using
//Legger til adresser
//Sjekker om adressene er like
if (IncCustomer.payAdress.Equals(IncCustomer.adress))
{
var adressModel = new AdressModel()
{
personID = IncCustomer.customerID,
payAdress = true,
deliveryAdress = true,
zipCode = IncCustomer.zipCode,
streetName = IncCustomer.adress,
province = IncCustomer.province
};
addAdress(adressModel);
}
//Ulike adresser
else
{
var newPaymentAdress = new AdressModel()
{
personID = IncCustomer.customerID,
payAdress = true,
deliveryAdress = false,
zipCode = IncCustomer.payZipcode,
streetName = IncCustomer.payAdress,
province = IncCustomer.payProvince
};
addAdress(newPaymentAdress);
var newAdress = new AdressModel()
{
personID = IncCustomer.customerID,
payAdress = false,
deliveryAdress = true,
zipCode = IncCustomer.zipCode,
streetName = IncCustomer.adress,
province = IncCustomer.province
};
addAdress(newAdress);
}
return true;
}
//Oppdaterer customeren som har customerID lik customerModel.customerID
public bool update(CustomerModel customerModel)
{
using (var db = new CustomerContext())
{
try
{
var customer = (from c in db.Customers
where c.personID == customerModel.customerID
select c).FirstOrDefault();
if (customer == null)//tester om customeren finnes
return false;
//Persondataendring:
customer.email = customerModel.email;
customer.firstName = customerModel.firstName;
customer.lastName = customerModel.lastName;
customer.phone = customerModel.phone;
customer.users.username = customerModel.email;
db.SaveChanges();
//Adresseendring:
var adressModel = new AdressModel();
adressModel.personID = customerModel.customerID;
adressModel.deliveryAdress = true;
adressModel.payAdress = customerModel.sameAdresses;
adressModel.province = customerModel.province;
adressModel.streetName = customerModel.adress;
adressModel.zipCode = customerModel.zipCode;
addAdress(adressModel);
if (!customerModel.sameAdresses)
{
adressModel = new AdressModel();
adressModel.personID = customerModel.customerID;
adressModel.deliveryAdress = false;
adressModel.payAdress = true;
adressModel.province = customerModel.payProvince;
adressModel.streetName = customerModel.payAdress;
adressModel.zipCode = customerModel.payZipcode;
addAdress(adressModel);
}
return true;
}//emd try
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
}//end using
return false;
}
//Legger en province inn i databasen dersom den ikke finnes fra før
public bool addProvince(AdressModel adress)
{
using (var db = new CustomerContext())
{
try
{
var temp = db.Provinces.Find(adress.zipCode);
if (temp == null)
{
temp = new Provinces();
temp.province = adress.province;
temp.zipCode = adress.zipCode;
db.Provinces.Add(temp);
db.SaveChanges();
return true;
}
return false;
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
}
return false;
}
//Legger til ny adresse for bruker med customerID==adressModel.customerID. Alle felter unntatt adressID må være fylt ut
public bool addAdress(AdressModel adressModel)
{
var adressesList = new List<Adresses>();
if (adressModel.payAdress)//Lager ny betalingsadresse
{
var temp = new Adresses();
temp.payAdress = true;
temp.deliveryAdress= false;
temp.streetName = adressModel.streetName;
temp.zipCode = adressModel.zipCode;
adressesList.Add(temp);
}
if (adressModel.deliveryAdress)//lager ny leveringsadresse
{
var temp = new Adresses();
temp.payAdress = false;
temp.deliveryAdress = true;
temp.streetName = adressModel.streetName;
temp.zipCode = adressModel.zipCode;
adressesList.Add(temp);
}
using (var db = new CustomerContext())
{
try
{
/*******************Kan fjernes hvis støtte for mer enn to adresser implementeres***********************/
//Fjerner betalingsadresse og/eller leveringsadresse fra databasen dersom ny adresse er av samme type
var adresses = (from a in db.Adresses
where a.personID == adressModel.personID
select a).ToList();
foreach (var a in adresses)
foreach (var am in adressesList)
if (a.deliveryAdress == am.deliveryAdress && a.payAdress == am.payAdress)
db.Adresses.Remove(a);
/*******************************************************************************************************/
foreach (var a in adressesList)//Legger adressene inn i databasen
{
addProvince(adressModel);
a.province = db.Provinces.Find(adressModel.zipCode);
a.person = db.Customers.Find(adressModel.personID);
db.Adresses.Add(a);
}
db.SaveChanges();
return true;
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
return false;
}
}