public tbl_BillingAddress GetBAddress(tbl_BillingAddress address) { using (var context = new console.Models.dream_techContext()) { return((from t in context.tbl_BillingAddress where t.billing_id == address.billing_id select t).SingleOrDefault()); } }
public tbl_BillingAddress CreateBAddress(RegisterViewModel model) { var billingrepo = new Repos.BillingAddressRepo(); var newBAddress = new tbl_BillingAddress(); newBAddress.address_line = model.AddressLine; newBAddress.suburb = model.Suburb; newBAddress.city = model.City; newBAddress.postal_code = Convert.ToInt32(model.PostalCode); newBAddress.country_id = Convert.ToInt32(model.Country); billingrepo.SaveBAddress(newBAddress); return(newBAddress); }
public bool UpdateBAddress(console.Models.tbl_BillingAddress entity) { bool result = false; using (var context = new console.Models.dream_techContext()) { tbl_BillingAddress address = (from b in context.tbl_BillingAddress where b.billing_id == entity.billing_id select b).First(); address.address_line = entity.address_line; address.suburb = entity.suburb; address.city = entity.city; address.postal_code = entity.postal_code; address.country_id = entity.country_id; result = context.SaveChanges() > 1; } return(result); }
public tbl_User CreateUser(RegisterViewModel model, tbl_CustomerContact contact, tbl_BillingAddress billing, tbl_DelivetyAddresses delivery) { var userRepo = new Repos.UserRepo(); var newUser = new tbl_User(); newUser.user_name = model.Name; newUser.user_surname = model.Surname; newUser.email_address = model.Email; newUser.password = model.Password; newUser.delivery_id = delivery.delivery_id; newUser.billing_id = billing.billing_id; newUser.contact_id = contact.contact_id; userRepo.SaveUser(newUser); return(newUser); }