public BusinessPartnerPhone GetBusinessPartnerPhone(int id) { BusinessPartnerPhone BusinessPartnerPhone = null; string queryString = selectString + "WHERE Id = @Id;"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = queryString; command.Parameters.Add(new SqlParameter("@Id", id)); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { BusinessPartnerPhone = Read(reader); } } } return(BusinessPartnerPhone); }
public static BusinessPartnerPhone ConvertToBusinessPartnerPhone(this BusinessPartnerPhoneViewModel businessPartnerPhoneViewModel) { BusinessPartnerPhone businessPartnerPhone = new BusinessPartnerPhone() { Id = businessPartnerPhoneViewModel.Id, Identifier = businessPartnerPhoneViewModel.Identifier, BusinessPartnerId = businessPartnerPhoneViewModel.BusinessPartner?.Id ?? null, Phone = businessPartnerPhoneViewModel.Phone, Mobile = businessPartnerPhoneViewModel.Mobile, Fax = businessPartnerPhoneViewModel.Fax, Email = businessPartnerPhoneViewModel.Email, ContactPersonFirstName = businessPartnerPhoneViewModel.ContactPersonFirstName, ContactPersonLastName = businessPartnerPhoneViewModel.ContactPersonLastName, Birthday = businessPartnerPhoneViewModel.Birthday, Description = businessPartnerPhoneViewModel.Description, Path = businessPartnerPhoneViewModel.Path, ItemStatus = businessPartnerPhoneViewModel.ItemStatus, Active = businessPartnerPhoneViewModel.IsActive, CreatedById = businessPartnerPhoneViewModel.CreatedBy?.Id ?? null, CompanyId = businessPartnerPhoneViewModel.Company?.Id ?? null, UpdatedAt = businessPartnerPhoneViewModel.UpdatedAt, CreatedAt = businessPartnerPhoneViewModel.CreatedAt, }; return(businessPartnerPhone); }
public BusinessPartnerPhone Delete(Guid identifier) { BusinessPartnerPhone dbEntry = context.BusinessPartnerPhones .Union(context.ChangeTracker.Entries() .Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(BusinessPartnerPhone)) .Select(x => x.Entity as BusinessPartnerPhone)) .FirstOrDefault(x => x.Identifier == identifier && x.Active == true); if (dbEntry != null) { dbEntry.Active = false; dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public BusinessPartnerPhone Create(BusinessPartnerPhone businessPartnerPhone) { if (context.BusinessPartnerPhones.Where(x => x.Identifier != null && x.Identifier == businessPartnerPhone.Identifier).Count() == 0) { businessPartnerPhone.Id = 0; businessPartnerPhone.Active = true; businessPartnerPhone.UpdatedAt = DateTime.Now; businessPartnerPhone.CreatedAt = DateTime.Now; context.BusinessPartnerPhones.Add(businessPartnerPhone); return(businessPartnerPhone); } else { // Load businessPartnerPhone that will be updated BusinessPartnerPhone dbEntry = context.BusinessPartnerPhones .FirstOrDefault(x => x.Identifier == businessPartnerPhone.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.BusinessPartnerId = businessPartnerPhone.BusinessPartnerId ?? null; dbEntry.CompanyId = businessPartnerPhone.CompanyId ?? null; dbEntry.CreatedById = businessPartnerPhone.CreatedById ?? null; // Set properties dbEntry.Phone = businessPartnerPhone.Phone; dbEntry.Mobile = businessPartnerPhone.Mobile; dbEntry.Fax = businessPartnerPhone.Fax; dbEntry.Email = businessPartnerPhone.Email; dbEntry.ContactPersonFirstName = businessPartnerPhone.ContactPersonFirstName; dbEntry.ContactPersonLastName = businessPartnerPhone.ContactPersonLastName; dbEntry.Birthday = businessPartnerPhone.Birthday; dbEntry.Description = businessPartnerPhone.Description; dbEntry.Path = businessPartnerPhone.Path; dbEntry.ItemStatus = businessPartnerPhone.ItemStatus; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
private static BusinessPartnerPhone Read(SqlDataReader reader) { BusinessPartnerPhone businessPartnerPhone = new BusinessPartnerPhone(); businessPartnerPhone.Id = Int32.Parse(reader["BusinessPartnerPhoneId"].ToString()); businessPartnerPhone.Identifier = Guid.Parse(reader["BusinessPartnerPhoneIdentifier"].ToString()); if (reader["BusinessPartnerId"] != DBNull.Value) { businessPartnerPhone.BusinessPartner = new BusinessPartner(); businessPartnerPhone.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString()); businessPartnerPhone.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString()); businessPartnerPhone.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString()); businessPartnerPhone.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString(); businessPartnerPhone.BusinessPartner.Name = reader["BusinessPartnerName"].ToString(); } if (reader["Phone"] != DBNull.Value) { businessPartnerPhone.Phone = reader["Phone"].ToString(); } if (reader["Mobile"] != DBNull.Value) { businessPartnerPhone.Mobile = reader["Mobile"].ToString(); } if (reader["Fax"] != DBNull.Value) { businessPartnerPhone.Fax = reader["Fax"].ToString(); } if (reader["Email"] != DBNull.Value) { businessPartnerPhone.Email = reader["Email"].ToString(); } if (reader["ContactPersonFirstName"] != DBNull.Value) { businessPartnerPhone.ContactPersonFirstName = reader["ContactPersonFirstName"].ToString(); } if (reader["ContactPersonLastName"] != DBNull.Value) { businessPartnerPhone.ContactPersonLastName = reader["ContactPersonLastName"].ToString(); } if (reader["Birthday"] != DBNull.Value) { businessPartnerPhone.Birthday = DateTime.Parse(reader["Birthday"].ToString()); } if (reader["Description"] != DBNull.Value) { businessPartnerPhone.Description = reader["Description"].ToString(); } if (reader["Path"] != DBNull.Value) { businessPartnerPhone.Path = reader["Path"].ToString(); } if (reader["ItemStatus"] != DBNull.Value) { businessPartnerPhone.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString()); } businessPartnerPhone.Active = bool.Parse(reader["Active"].ToString()); businessPartnerPhone.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString()); if (reader["CreatedById"] != DBNull.Value) { businessPartnerPhone.CreatedBy = new User(); businessPartnerPhone.CreatedById = Int32.Parse(reader["CreatedById"].ToString()); businessPartnerPhone.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString()); businessPartnerPhone.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString(); businessPartnerPhone.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString(); } if (reader["CompanyId"] != DBNull.Value) { businessPartnerPhone.Company = new Company(); businessPartnerPhone.CompanyId = Int32.Parse(reader["CompanyId"].ToString()); businessPartnerPhone.Company.Id = Int32.Parse(reader["CompanyId"].ToString()); businessPartnerPhone.Company.Name = reader["CompanyName"].ToString(); } return(businessPartnerPhone); }
public static BusinessPartnerPhoneViewModel ConvertToBusinessPartnerPhoneViewModelLite(this BusinessPartnerPhone businessPartnerPhone) { BusinessPartnerPhoneViewModel businessPartnerPhoneViewModel = new BusinessPartnerPhoneViewModel() { Id = businessPartnerPhone.Id, Identifier = businessPartnerPhone.Identifier, Phone = businessPartnerPhone.Phone, Mobile = businessPartnerPhone.Mobile, Fax = businessPartnerPhone.Fax, Email = businessPartnerPhone.Email, ContactPersonFirstName = businessPartnerPhone.ContactPersonFirstName, ContactPersonLastName = businessPartnerPhone.ContactPersonLastName, Birthday = businessPartnerPhone.Birthday, Description = businessPartnerPhone.Description, Path = businessPartnerPhone.Path, ItemStatus = businessPartnerPhone.ItemStatus, IsActive = businessPartnerPhone.Active, UpdatedAt = businessPartnerPhone.UpdatedAt, CreatedAt = businessPartnerPhone.CreatedAt, }; return(businessPartnerPhoneViewModel); }
public BusinessPartnerResponse Create(BusinessPartnerViewModel re) { BusinessPartnerResponse response = new BusinessPartnerResponse(); try { // Backup notes List <BusinessPartnerNoteViewModel> businessPartnerNotes = re.BusinessPartnerNotes?.ToList(); re.BusinessPartnerNotes = null; // Backup documents List <BusinessPartnerDocumentViewModel> businessPartnerDocuments = re.BusinessPartnerDocuments?.ToList(); re.BusinessPartnerDocuments = null; //Phone List <BusinessPartnerPhoneViewModel> businessPartnerPhones = re.Phones?.ToList(); re.Phones = null; //Location List <BusinessPartnerLocationViewModel> businessPartnerLocations = re.Locations?.ToList(); re.Locations = null; //Institution List <BusinessPartnerInstitutionViewModel> businessPartnerInstitutions = re.Institutions?.ToList(); re.Institutions = null; //Bank List <BusinessPartnerBankViewModel> businessPartnerBanks = re.Banks?.ToList(); re.Banks = null; //Type List <BusinessPartnerTypeViewModel> businessPartnerTypes = re.BusinessPartnerTypes?.ToList(); re.BusinessPartnerTypes = null; BusinessPartner createdBusinessPartner = unitOfWork.GetBusinessPartnerRepository().Create(re.ConvertToBusinessPartner()); // Update notes if (businessPartnerNotes != null && businessPartnerNotes.Count > 0) { // Items for create or update foreach (var businessPartnerNote in businessPartnerNotes .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerNoteViewModel>()) { businessPartnerNote.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerNote.ItemStatus = ItemStatus.Submited; BusinessPartnerNote createdBusinessPartnerNote = unitOfWork.GetBusinessPartnerNoteRepository() .Create(businessPartnerNote.ConvertToBusinessPartnerNote()); } foreach (var item in businessPartnerNotes .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerNoteViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerNoteRepository().Create(item.ConvertToBusinessPartnerNote()); unitOfWork.GetBusinessPartnerNoteRepository().Delete(item.Identifier); } } // Update documents if (businessPartnerDocuments != null && businessPartnerDocuments.Count > 0) { // Items for create or update foreach (var businessPartnerDocument in businessPartnerDocuments .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerDocumentViewModel>()) { businessPartnerDocument.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerDocument.ItemStatus = ItemStatus.Submited; BusinessPartnerDocument createdBusinessPartnerDocument = unitOfWork.GetBusinessPartnerDocumentRepository() .Create(businessPartnerDocument.ConvertToBusinessPartnerDocument()); } foreach (var item in businessPartnerDocuments .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerDocumentViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerDocumentRepository().Create(item.ConvertToBusinessPartnerDocument()); unitOfWork.GetBusinessPartnerDocumentRepository().Delete(item.Identifier); } } // Update Phone if (businessPartnerPhones != null && businessPartnerPhones.Count > 0) { // Items for create or update foreach (var businessPartnerPhone in businessPartnerPhones .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerPhoneViewModel>()) { businessPartnerPhone.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerPhone.ItemStatus = ItemStatus.Submited; BusinessPartnerPhone createdBusinessPartnerPhone = unitOfWork.GetBusinessPartnerPhoneRepository() .Create(businessPartnerPhone.ConvertToBusinessPartnerPhone()); } foreach (var item in businessPartnerPhones .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerPhoneViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerPhoneRepository().Create(item.ConvertToBusinessPartnerPhone()); unitOfWork.GetBusinessPartnerPhoneRepository().Delete(item.Identifier); } } // Update Location if (businessPartnerLocations != null && businessPartnerLocations.Count > 0) { // Items for create or update foreach (var businessPartnerLocation in businessPartnerLocations .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerLocationViewModel>()) { businessPartnerLocation.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerLocation.ItemStatus = ItemStatus.Submited; BusinessPartnerLocation createdBusinessPartnerLocation = unitOfWork.GetBusinessPartnerLocationRepository() .Create(businessPartnerLocation.ConvertToBusinessPartnerLocation()); } foreach (var item in businessPartnerLocations .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerLocationViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerLocationRepository().Create(item.ConvertToBusinessPartnerLocation()); unitOfWork.GetBusinessPartnerLocationRepository().Delete(item.Identifier); } } // Update Institution if (businessPartnerInstitutions != null && businessPartnerInstitutions.Count > 0) { // Items for create or update foreach (var businessPartnerInstitution in businessPartnerInstitutions .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerInstitutionViewModel>()) { businessPartnerInstitution.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerInstitution.ItemStatus = ItemStatus.Submited; BusinessPartnerInstitution createdBusinessPartnerInstitution = unitOfWork.GetBusinessPartnerInstitutionRepository() .Create(businessPartnerInstitution.ConvertToBusinessPartnerInstitution()); } foreach (var item in businessPartnerInstitutions .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerInstitutionViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerInstitutionRepository().Create(item.ConvertToBusinessPartnerInstitution()); unitOfWork.GetBusinessPartnerInstitutionRepository().Delete(item.Identifier); } } // Update Bank if (businessPartnerBanks != null && businessPartnerBanks.Count > 0) { // Items for create or update foreach (var businessPartnerBank in businessPartnerBanks .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerBankViewModel>()) { businessPartnerBank.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerBank.ItemStatus = ItemStatus.Submited; BusinessPartnerBank createdBusinessPartnerBank = unitOfWork.GetBusinessPartnerBankRepository() .Create(businessPartnerBank.ConvertToBusinessPartnerBank()); } foreach (var item in businessPartnerBanks .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerBankViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerBankRepository().Create(item.ConvertToBusinessPartnerBank()); unitOfWork.GetBusinessPartnerBankRepository().Delete(item.Identifier); } } // Update Type //unitOfWork.GetBusinessPartnerBusinessPartnerTypeRepository().Delete(createdBusinessPartner.Id); //foreach (var item in businessPartnerTypes) //{ // unitOfWork.GetBusinessPartnerBusinessPartnerTypeRepository().Create(createdBusinessPartner.Id, item.Id); //} if (businessPartnerTypes != null && businessPartnerTypes.Count > 0) { // Items for create or update foreach (var businessPartnerType in businessPartnerTypes .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <BusinessPartnerTypeViewModel>()) { businessPartnerType.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; businessPartnerType.ItemStatus = ItemStatus.Submited; BusinessPartnerType createdBusinessPartnerType = unitOfWork.GetBusinessPartnerTypeRepository() .Create(businessPartnerType.ConvertToBusinessPartnerType()); } foreach (var item in businessPartnerTypes .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <BusinessPartnerTypeViewModel>()) { item.BusinessPartner = new BusinessPartnerViewModel() { Id = createdBusinessPartner.Id }; unitOfWork.GetBusinessPartnerTypeRepository().Create(item.ConvertToBusinessPartnerType()); unitOfWork.GetBusinessPartnerTypeRepository().Delete(item.Identifier); } } unitOfWork.Save(); response.BusinessPartner = createdBusinessPartner.ConvertToBusinessPartnerViewModel(); response.Success = true; } catch (Exception ex) { response.BusinessPartner = new BusinessPartnerViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }