public void UpdateField(FieldDTO fieldDTO) { try { Field field = ConvertFieldDTOToField(fieldDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Fields.Attach(field); dbContext.Entry(field).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void UpdateBusiness(BusinessDTO businessDTO) { try { Business business = ConvertBusinessDTOToBusiness(businessDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Businesses.Attach(business); dbContext.Entry(business).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public FieldDTO AddField(FieldDTO fieldDTO) { try { Field field = ConvertFieldDTOToField(fieldDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Fields.Add(field); dbContext.SaveChanges(); } return(ConvertFieldToFieldDTO(field)); } catch (Exception) { throw; } }
public int AddUser_Payment(User_PaymentDTO user_paymentDTO) { try { User_Payment user_payment = ConvertUser_PaymentDTOToUser_Payment(user_paymentDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.User_Payment.Add(user_payment); dbContext.SaveChanges(); } return(user_payment.User_Payment_Id); } catch (Exception) { throw; } }
public BranchDTO AddBranch(BranchDTO branchDTO) { try { Branch branch = ConvertBranchDTOToBranch(branchDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Branches.Add(branch); dbContext.SaveChanges(); } return(ConvertBranchToBranchDTO(branch)); } catch (Exception) { throw; } }
public int AddBusiness(BusinessDTO businessDTO) { try { Business business = ConvertBusinessDTOToBusiness(businessDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Businesses.Add(business); dbContext.SaveChanges(); } return(business.Business_Id); } catch (Exception) { throw; } }
public int AddReservation(ReservationDTO reservationDTO) { try { Reservation reservation = ConvertReservationDTOToReservation(reservationDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Reservations.Add(reservation); dbContext.SaveChanges(); } return(reservation.Reservation_Id); } catch (Exception) { throw; } }
public void RemoveField(int fieldID) { try { Field field = new Field() { Field_Id = fieldID }; using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Fields.Attach(field); dbContext.Fields.Remove(field); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void RemoveUser_Payment(int user_paymentID) { try { User_Payment user_payment = new User_Payment() { User_Payment_Id = user_paymentID }; using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.User_Payment.Attach(user_payment); dbContext.User_Payment.Remove(user_payment); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void RemoveBranch(int branchID) { try { Branch branch = new Branch() { Branch_Id = branchID }; using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Branches.Attach(branch); dbContext.Branches.Remove(branch); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void RemoveBusiness(int businessID) { try { Business business = new Business() { Business_Id = businessID }; using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Businesses.Attach(business); dbContext.Businesses.Remove(business); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void RemoveReservation(int reservationID) { try { Reservation reservation = new Reservation() { Reservation_Id = reservationID }; using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Reservations.Attach(reservation); dbContext.Reservations.Remove(reservation); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public void UpdateUser(UserDTO userDTO) { try { User user = ConvertUserDTOToUser(userDTO); user.Password = Encryption.Encrypt(user.Password, encryptionKey); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { if (user.Phones != null) { foreach (Phone phone in user.Phones) { if (phone.Phone_Id != 0) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Modified; } else { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Added; } } List <int> phones = user.Phones.Select(y => y.Phone_Id).ToList(); List <Phone> toBeDeletedPhones = dbContext.Phones.Where(x => !phones.Contains(x.Phone_Id) && x.User_Id == userDTO.User_Id).ToList(); foreach (Phone phone in toBeDeletedPhones) { dbContext.Entry(phone).State = System.Data.Entity.EntityState.Deleted; } } if (user.Address != null) { dbContext.Entry(user.Address).State = System.Data.Entity.EntityState.Modified; } dbContext.Users.Attach(user); dbContext.Entry(user).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public UserDTO AddUser(UserDTO userDTO) { try { User user = ConvertUserDTOToUser(userDTO); user.Password = Encryption.Encrypt(user.Password, encryptionKey); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Users.Add(user); dbContext.SaveChanges(); } userDTO = ConvertUserToUserDTO(user); userDTO.Password = Encryption.Decrypt(userDTO.Password, encryptionKey); return(userDTO); } catch (Exception) { throw; } }
public List <BranchDTO> AddBranches(List <BranchDTO> branches) { try { foreach (BranchDTO branchDTO in branches) { Branch branch = ConvertBranchDTOToBranch(branchDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { dbContext.Branches.Add(branch); dbContext.SaveChanges(); } branchDTO.Branch_Id = branch.Branch_Id; } } catch (Exception) { throw; } return(branches); }
public void UpdateBranch(BranchDTO branchDTO) { try { Branch branch = ConvertBranchDTOToBranch(branchDTO); using (RampUpProjectEntities dbContext = new RampUpProjectEntities(rampConnectionString)) { UpdatePhones(branchDTO, branch, dbContext); UpdateFields(branchDTO, branch, dbContext); if (branch.Address != null) { dbContext.Entry(branch.Address).State = System.Data.Entity.EntityState.Modified; } dbContext.Branches.Attach(branch); dbContext.Entry(branch).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } catch (Exception) { throw; } }