public static List <BusinessPartnerDocumentViewModel> ConvertToBusinessPartnerDocumentViewModelList(this IEnumerable <BusinessPartnerDocument> businessPartnerDocuments) { List <BusinessPartnerDocumentViewModel> BusinessPartnerDocumentViewModels = new List <BusinessPartnerDocumentViewModel>(); foreach (BusinessPartnerDocument BusinessPartnerDocument in businessPartnerDocuments) { BusinessPartnerDocumentViewModels.Add(BusinessPartnerDocument.ConvertToBusinessPartnerDocumentViewModel()); } return(BusinessPartnerDocumentViewModels); }
public BusinessPartnerDocument Delete(Guid identifier) { BusinessPartnerDocument dbEntry = context.BusinessPartnerDocuments .Union(context.ChangeTracker.Entries() .Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(BusinessPartnerDocument)) .Select(x => x.Entity as BusinessPartnerDocument)) .FirstOrDefault(x => x.Identifier == identifier); if (dbEntry != null) { dbEntry.Active = false; dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public BusinessPartnerDocument Create(BusinessPartnerDocument BusinessPartnerDocument) { if (context.BusinessPartnerDocuments.Where(x => x.Identifier != null && x.Identifier == BusinessPartnerDocument.Identifier).Count() == 0) { BusinessPartnerDocument.Id = 0; BusinessPartnerDocument.Active = true; BusinessPartnerDocument.CreatedAt = DateTime.Now; BusinessPartnerDocument.UpdatedAt = DateTime.Now; context.BusinessPartnerDocuments.Add(BusinessPartnerDocument); return(BusinessPartnerDocument); } else { // Load item that will be updated BusinessPartnerDocument dbEntry = context.BusinessPartnerDocuments .FirstOrDefault(x => x.Identifier == BusinessPartnerDocument.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.BusinessPartnerId = BusinessPartnerDocument.BusinessPartnerId ?? null; dbEntry.CompanyId = BusinessPartnerDocument.CompanyId ?? null; dbEntry.CreatedById = BusinessPartnerDocument.CreatedById ?? null; // Set properties dbEntry.Name = BusinessPartnerDocument.Name; dbEntry.CreateDate = BusinessPartnerDocument.CreateDate; dbEntry.Path = BusinessPartnerDocument.Path; dbEntry.ItemStatus = BusinessPartnerDocument.ItemStatus; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public static BusinessPartnerDocument ConvertToBusinessPartnerDocument(this BusinessPartnerDocumentViewModel businessPartnerDocumentViewModel) { BusinessPartnerDocument BusinessPartnerDocument = new BusinessPartnerDocument() { Id = businessPartnerDocumentViewModel.Id, Identifier = businessPartnerDocumentViewModel.Identifier, BusinessPartnerId = businessPartnerDocumentViewModel.BusinessPartner?.Id ?? null, Name = businessPartnerDocumentViewModel.Name, CreateDate = businessPartnerDocumentViewModel.CreateDate, Path = businessPartnerDocumentViewModel.Path, ItemStatus = businessPartnerDocumentViewModel.ItemStatus, Active = businessPartnerDocumentViewModel.IsActive, CreatedById = businessPartnerDocumentViewModel.CreatedBy?.Id ?? null, CompanyId = businessPartnerDocumentViewModel.Company?.Id ?? null, CreatedAt = businessPartnerDocumentViewModel.CreatedAt, UpdatedAt = businessPartnerDocumentViewModel.UpdatedAt }; return(BusinessPartnerDocument); }
public static BusinessPartnerDocumentViewModel ConvertToBusinessPartnerDocumentViewModelLite(this BusinessPartnerDocument businessPartnerDocument) { BusinessPartnerDocumentViewModel BusinessPartnerDocumentViewModel = new BusinessPartnerDocumentViewModel() { Id = businessPartnerDocument.Id, Identifier = businessPartnerDocument.Identifier, Name = businessPartnerDocument.Name, CreateDate = businessPartnerDocument.CreateDate, Path = businessPartnerDocument.Path, ItemStatus = businessPartnerDocument.ItemStatus, IsActive = businessPartnerDocument.Active, UpdatedAt = businessPartnerDocument.UpdatedAt, CreatedAt = businessPartnerDocument.CreatedAt }; return(BusinessPartnerDocumentViewModel); }
public List <BusinessPartnerDocument> GetBusinessPartnerDocuments(int companyId) { List <BusinessPartnerDocument> BusinessPartnerDocuments = new List <BusinessPartnerDocument>(); string queryString = "SELECT BusinessPartnerDocumentId, BusinessPartnerDocumentIdentifier, " + "BusinessPartnerId, BusinessPartnerIdentifier, BusinessPartnerCode, BusinessPartnerName, " + "Name, CreateDate, Path, ItemStatus, " + "Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, " + "CompanyId, CompanyName " + "FROM vBusinessPartnerDocuments " + "WHERE CompanyId = @CompanyId AND Active = 1;"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = queryString; command.Parameters.Add(new SqlParameter("@CompanyId", companyId)); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { BusinessPartnerDocument businessPartnerDocument; while (reader.Read()) { businessPartnerDocument = new BusinessPartnerDocument(); businessPartnerDocument.Id = Int32.Parse(reader["BusinessPartnerDocumentId"].ToString()); businessPartnerDocument.Identifier = Guid.Parse(reader["BusinessPartnerDocumentIdentifier"].ToString()); if (reader["BusinessPartnerId"] != DBNull.Value) { businessPartnerDocument.BusinessPartner = new BusinessPartner(); businessPartnerDocument.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString()); businessPartnerDocument.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString()); businessPartnerDocument.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString()); businessPartnerDocument.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString(); businessPartnerDocument.BusinessPartner.Name = reader["BusinessPartnerName"].ToString(); } if (reader["Name"] != DBNull.Value) { businessPartnerDocument.Name = reader["Name"].ToString(); } if (reader["CreateDate"] != DBNull.Value) { businessPartnerDocument.CreateDate = DateTime.Parse(reader["CreateDate"].ToString()); } if (reader["Path"] != DBNull.Value) { businessPartnerDocument.Path = reader["Path"].ToString(); } if (reader["ItemStatus"] != DBNull.Value) { businessPartnerDocument.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString()); } businessPartnerDocument.Active = bool.Parse(reader["Active"].ToString()); businessPartnerDocument.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString()); if (reader["CreatedById"] != DBNull.Value) { businessPartnerDocument.CreatedBy = new User(); businessPartnerDocument.CreatedById = Int32.Parse(reader["CreatedById"].ToString()); businessPartnerDocument.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString()); businessPartnerDocument.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString(); businessPartnerDocument.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString(); } if (reader["CompanyId"] != DBNull.Value) { businessPartnerDocument.Company = new Company(); businessPartnerDocument.CompanyId = Int32.Parse(reader["CompanyId"].ToString()); businessPartnerDocument.Company.Id = Int32.Parse(reader["CompanyId"].ToString()); businessPartnerDocument.Company.Name = reader["CompanyName"].ToString(); } BusinessPartnerDocuments.Add(businessPartnerDocument); } } } return(BusinessPartnerDocuments); //List<BusinessPartnerDocument> BusinessPartnerDocuments = context.BusinessPartnerDocuments // .Include(x => x.BusinessPartner) // .Include(x => x.Company) // .Include(x => x.CreatedBy) // .Where(x => x.Active == true && x.CompanyId == companyId) // .AsNoTracking() // .ToList(); //return BusinessPartnerDocuments; }
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); }