public PhonebookNote GetPhonebookNote(int id) { PhonebookNote PhonebookNote = 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()) { PhonebookNote = Read(reader); } } } return(PhonebookNote); }
public static List <PhonebookNoteViewModel> ConvertToPhonebookNoteViewModelList(this IEnumerable <PhonebookNote> PhonebookNotes) { List <PhonebookNoteViewModel> PhonebookNoteViewModels = new List <PhonebookNoteViewModel>(); foreach (PhonebookNote PhonebookNote in PhonebookNotes) { PhonebookNoteViewModels.Add(PhonebookNote.ConvertToPhonebookNoteViewModel()); } return(PhonebookNoteViewModels); }
private static PhonebookNote Read(SqlDataReader reader) { PhonebookNote PhonebookNote = new PhonebookNote(); PhonebookNote.Id = Int32.Parse(reader["PhonebookNoteId"].ToString()); PhonebookNote.Identifier = Guid.Parse(reader["PhonebookNoteIdentifier"].ToString()); if (reader["PhonebookId"] != DBNull.Value) { PhonebookNote.Phonebook = new Phonebook(); PhonebookNote.PhonebookId = Int32.Parse(reader["PhonebookId"].ToString()); PhonebookNote.Phonebook.Id = Int32.Parse(reader["PhonebookId"].ToString()); PhonebookNote.Phonebook.Identifier = Guid.Parse(reader["PhonebookIdentifier"].ToString()); PhonebookNote.Phonebook.Code = reader["PhonebookCode"].ToString(); PhonebookNote.Phonebook.Name = reader["PhonebookName"].ToString(); } if (reader["Note"] != DBNull.Value) { PhonebookNote.Note = reader["Note"].ToString(); } if (reader["NoteDate"] != DBNull.Value) { PhonebookNote.NoteDate = DateTime.Parse(reader["NoteDate"].ToString()); } if (reader["ItemStatus"] != DBNull.Value) { PhonebookNote.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString()); } PhonebookNote.Active = bool.Parse(reader["Active"].ToString()); PhonebookNote.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString()); if (reader["CreatedById"] != DBNull.Value) { PhonebookNote.CreatedBy = new User(); PhonebookNote.CreatedById = Int32.Parse(reader["CreatedById"].ToString()); PhonebookNote.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString()); PhonebookNote.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString(); PhonebookNote.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString(); } if (reader["CompanyId"] != DBNull.Value) { PhonebookNote.Company = new Company(); PhonebookNote.CompanyId = Int32.Parse(reader["CompanyId"].ToString()); PhonebookNote.Company.Id = Int32.Parse(reader["CompanyId"].ToString()); PhonebookNote.Company.Name = reader["CompanyName"].ToString(); } return(PhonebookNote); }
public PhonebookNote Delete(Guid identifier) { PhonebookNote dbEntry = context.PhonebookNotes .Union(context.ChangeTracker.Entries() .Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(PhonebookNote)) .Select(x => x.Entity as PhonebookNote)) .FirstOrDefault(x => x.Identifier == identifier && x.Active == true); if (dbEntry != null) { dbEntry.Active = false; dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public static PhonebookNoteViewModel ConvertToPhonebookNoteViewModelLite(this PhonebookNote PhonebookNote) { PhonebookNoteViewModel PhonebookNoteViewModel = new PhonebookNoteViewModel() { Id = PhonebookNote.Id, Identifier = PhonebookNote.Identifier, Note = PhonebookNote.Note, NoteDate = PhonebookNote.NoteDate, ItemStatus = PhonebookNote.ItemStatus, IsActive = PhonebookNote.Active, UpdatedAt = PhonebookNote.UpdatedAt, CreatedAt = PhonebookNote.CreatedAt, }; return(PhonebookNoteViewModel); }
public PhonebookNote Create(PhonebookNote PhonebookNote) { if (context.PhonebookNotes.Where(x => x.Identifier != null && x.Identifier == PhonebookNote.Identifier).Count() == 0) { PhonebookNote.Id = 0; PhonebookNote.Active = true; PhonebookNote.UpdatedAt = DateTime.Now; PhonebookNote.CreatedAt = DateTime.Now; context.PhonebookNotes.Add(PhonebookNote); return(PhonebookNote); } else { // Load PhonebookNote that will be updated PhonebookNote dbEntry = context.PhonebookNotes .FirstOrDefault(x => x.Identifier == PhonebookNote.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.PhonebookId = PhonebookNote.PhonebookId ?? null; dbEntry.CompanyId = PhonebookNote.CompanyId ?? null; dbEntry.CreatedById = PhonebookNote.CreatedById ?? null; // Set properties dbEntry.Note = PhonebookNote.Note; dbEntry.NoteDate = PhonebookNote.NoteDate; dbEntry.ItemStatus = PhonebookNote.ItemStatus; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public static PhonebookNote ConvertToPhonebookNote(this PhonebookNoteViewModel PhonebookNoteViewModel) { PhonebookNote PhonebookNote = new PhonebookNote() { Id = PhonebookNoteViewModel.Id, Identifier = PhonebookNoteViewModel.Identifier, PhonebookId = PhonebookNoteViewModel.Phonebook?.Id ?? null, Note = PhonebookNoteViewModel.Note, NoteDate = PhonebookNoteViewModel.NoteDate, ItemStatus = PhonebookNoteViewModel.ItemStatus, Active = PhonebookNoteViewModel.IsActive, CreatedById = PhonebookNoteViewModel.CreatedBy?.Id ?? null, CompanyId = PhonebookNoteViewModel.Company?.Id ?? null, UpdatedAt = PhonebookNoteViewModel.UpdatedAt, CreatedAt = PhonebookNoteViewModel.CreatedAt, }; return(PhonebookNote); }
public static PhonebookNoteViewModel ConvertToPhonebookNoteViewModel(this PhonebookNote PhonebookNote) { PhonebookNoteViewModel PhonebookNoteViewModel = new PhonebookNoteViewModel() { Id = PhonebookNote.Id, Identifier = PhonebookNote.Identifier, Phonebook = PhonebookNote.Phonebook?.ConvertToPhonebookViewModelLite(), Note = PhonebookNote.Note, NoteDate = PhonebookNote.NoteDate, ItemStatus = PhonebookNote.ItemStatus, IsActive = PhonebookNote.Active, CreatedBy = PhonebookNote.CreatedBy?.ConvertToUserViewModelLite(), Company = PhonebookNote.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = PhonebookNote.UpdatedAt, CreatedAt = PhonebookNote.CreatedAt, }; return(PhonebookNoteViewModel); }
public PhonebookResponse Create(PhonebookViewModel re) { PhonebookResponse response = new PhonebookResponse(); try { // Backup notes List <PhonebookNoteViewModel> PhonebookNotes = re.PhonebookNotes?.ToList(); re.PhonebookNotes = null; // Backup documents List <PhonebookDocumentViewModel> PhonebookDocuments = re.PhonebookDocuments?.ToList(); re.PhonebookDocuments = null; // Backup phone List <PhonebookPhoneViewModel> PhonebookPhones = re.PhonebookPhones?.ToList(); re.PhonebookPhones = null; Phonebook createdPhonebook = unitOfWork.GetPhonebookRepository().Create(re.ConvertToPhonebook()); // Update notes if (PhonebookNotes != null && PhonebookNotes.Count > 0) { // Items for create or update foreach (var PhonebookNote in PhonebookNotes .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookNoteViewModel>()) { PhonebookNote.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; PhonebookNote.ItemStatus = ItemStatus.Submited; PhonebookNote createdPhonebookNote = unitOfWork.GetPhonebookNoteRepository() .Create(PhonebookNote.ConvertToPhonebookNote()); } foreach (var item in PhonebookNotes .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookNoteViewModel>()) { item.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; unitOfWork.GetPhonebookNoteRepository().Create(item.ConvertToPhonebookNote()); unitOfWork.GetPhonebookNoteRepository().Delete(item.Identifier); } } // Update documents if (PhonebookDocuments != null && PhonebookDocuments.Count > 0) { // Items for create or update foreach (var PhonebookDocument in PhonebookDocuments .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookDocumentViewModel>()) { PhonebookDocument.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; PhonebookDocument.ItemStatus = ItemStatus.Submited; PhonebookDocument createdPhonebookDocument = unitOfWork.GetPhonebookDocumentRepository() .Create(PhonebookDocument.ConvertToPhonebookDocument()); } foreach (var item in PhonebookDocuments .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookDocumentViewModel>()) { item.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; unitOfWork.GetPhonebookDocumentRepository().Create(item.ConvertToPhonebookDocument()); unitOfWork.GetPhonebookDocumentRepository().Delete(item.Identifier); } } // Update Phones if (PhonebookPhones != null && PhonebookPhones.Count > 0) { // Items for create or update foreach (var PhonebookPhone in PhonebookPhones .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookPhoneViewModel>()) { PhonebookPhone.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; PhonebookPhone.ItemStatus = ItemStatus.Submited; PhonebookPhone createdPhonebookPhone = unitOfWork.GetPhonebookPhoneRepository() .Create(PhonebookPhone.ConvertToPhonebookPhone()); } foreach (var item in PhonebookPhones .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookPhoneViewModel>()) { item.Phonebook = new PhonebookViewModel() { Id = createdPhonebook.Id }; unitOfWork.GetPhonebookPhoneRepository().Create(item.ConvertToPhonebookPhone()); unitOfWork.GetPhonebookPhoneRepository().Delete(item.Identifier); } } unitOfWork.Save(); response.Phonebook = createdPhonebook.ConvertToPhonebookViewModel(); response.Success = true; } catch (Exception ex) { response.Phonebook = new PhonebookViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }