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);
}
