public List <Client_Contact> GetAll(Client_Contact clientContact) { List <Client_Contact> listClientContact = new List <Client_Contact>(); try { if (clientContact != null) { var predicateBuilder = this.setPredicate(clientContact); using (InDesignContext context = new InDesignContext()) { listClientContact = context.Client_Contact.AsNoTracking(). Where(predicateBuilder). OrderBy(m => m.IdClient) .ToList(); } } else { using (InDesignContext context = new InDesignContext()) { listClientContact = context.Client_Contact.AsNoTracking(). OrderBy(m => m.IdClient) .ToList(); } } } catch (Exception e) { string error = e.Message; } return(listClientContact); }
public List <ContactDto> GetAll(ContactDto contactDto) { List <ContactDto> listContactDto = new List <ContactDto>(); List <Contact> listContact = new List <Contact>(); try { if (contactDto != null) { var predicateBuilder = this.setPredicate(contactDto.contact); using (InDesignContext context = new InDesignContext()) { listContact = context.Contact.AsNoTracking(). Where(predicateBuilder). OrderBy(m => m.Id) .ToList(); } } else { using (InDesignContext context = new InDesignContext()) { listContact = context.Contact.AsNoTracking(). OrderBy(m => m.Id) .ToList(); } } listContact.ForEach(contactItem => { ContactDto contactDtoItemAdd = new ContactDto(); contactDtoItemAdd.contact = contactItem; listContactDto.Add(contactDtoItemAdd); }); } catch (Exception e) { string error = e.Message; } return(listContactDto); }
public bool Create(ContactDto contactDto) { bool isCreate = false; if (contactDto != null) { using (InDesignContext context = new InDesignContext()) { context.Contact.Add(contactDto.contact); int save = context.SaveChanges(); if (save > 0) { isCreate = true; } else { isCreate = false; } } } return(isCreate); }
public bool Update(ClientDto clientDto) { bool isUpdate = false; if (clientDto != null) { using (InDesignContext context = new InDesignContext()) { context.Client.Update(clientDto.client); int save = context.SaveChanges(); if (save > 0) { isUpdate = true; } else { isUpdate = false; } } } return(isUpdate); }
public ContactDto GetById(ContactDto contactDto) { ContactDto clientContactResponse = new ContactDto(); try { if (contactDto != null) { var predicateBuilder = this.setPredicate(contactDto.contact); using (InDesignContext context = new InDesignContext()) { clientContactResponse.contact = context.Contact.AsNoTracking(). Where(predicateBuilder). OrderBy(m => m.Id) .FirstOrDefault(); } } } catch (Exception e) { string error = e.Message; } return(clientContactResponse); }