public void UpdateClientContact(string token, [FromBody] Client_Contact updatedClientContact)
{
try
{
var userId = context.GetUserIDSession(token).SingleOrDefault().UserID;
var originalClientContact = context.Client_Contacts
.Where(x => x.ContactID == updatedClientContact.ContactID)
.SingleOrDefault();
var properties = typeof(Client_Contact).GetProperties();
//update entity properties
foreach (var p in properties)
{
p.SetValue(originalClientContact, p.GetValue(updatedClientContact));
}
originalClientContact.DateLastUpdated = DateTime.Now;
originalClientContact.LastUpdatedByUserID = userId;
context.SubmitChanges();
}
catch (Exception e)
{
ExceptionLog.LogException(e);
}
}
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 async Task<IHttpActionResult> PostProfil(Client_Contact contact)
{
try
{
await repositoryClient.SaveClientContactAsync(contact);
}
catch (Exception er)
{
}
return Ok();
}
private Expression <Func <Client_Contact, bool> > setPredicate(Client_Contact clientContact)
{
var predicateBuilder = PredicateBuilder.True <Client_Contact>();
if (clientContact.IdClient != 0)
{
predicateBuilder = predicateBuilder.And(m => m.IdClient == clientContact.IdClient);
}
if (clientContact.IdContact != 0)
{
predicateBuilder = predicateBuilder.And(m => m.IdContact == clientContact.IdContact);
}
return(predicateBuilder);
}
public void RemoveClientContact(string token, [FromBody] Client_Contact clientContact)
{
try
{
var deleteClientContact = context.Client_Contacts
.Where(x => x.ContactID == clientContact.ContactID)
.SingleOrDefault();
context.Client_Contacts.DeleteOnSubmit(deleteClientContact);
context.SubmitChanges();
}
catch (Exception e)
{
ExceptionLog.LogException(e);
}
}
public void AddClientContact(string token, [FromBody] Client_Contact clientContact)
{
try
{
var userId = context.GetUserIDSession(token).SingleOrDefault().UserID;
clientContact.DateLastUpdated = DateTime.Now;
clientContact.LastUpdatedByUserID = userId;
//pass clientContact with the clientId set once linked to client record
context.Client_Contacts.InsertOnSubmit(clientContact);
context.SubmitChanges();
}
catch (Exception e)
{
ExceptionLog.LogException(e);
}
}
public bool Update(Client_Contact clientContact)
{
bool isUpdate = false;
if (clientContact != null)
{
using (InDesignContext context = new InDesignContext())
{
context.Client_Contact.Update(clientContact);
int save = context.SaveChanges();
if (save > 0)
{
isUpdate = true;
}
else
{
isUpdate = false;
}
}
}
return(isUpdate);
}
public Client_Contact GetById(Client_Contact clientContact)
{
Client_Contact clientContactResponse = new Client_Contact();
try
{
if (clientContact != null)
{
var predicateBuilder = this.setPredicate(clientContact);
using (InDesignContext context = new InDesignContext())
{
clientContactResponse = context.Client_Contact.AsNoTracking().
Where(predicateBuilder).
OrderBy(m => m.IdClient)
.FirstOrDefault();
}
}
}
catch (Exception e)
{
string error = e.Message;
}
return(clientContactResponse);
}
public async Task<int> SaveClientContactAsync(Client_Contact client)
{
if (client.ClientId == 0)
{
context.Clients_Contacts.Add(client);
}
else
{
Client_Contact dbEntry = context.Clients_Contacts.Find(client.ClientId);
if(dbEntry != null)
{
dbEntry.actif = true;
dbEntry.Charte = DateTime.Now;
dbEntry.Cle_Conf = client.Cle_Conf;
dbEntry.Date_Naissance = client.Date_Naissance;
dbEntry.Defaut = client.Defaut;
dbEntry.Fonction = client.Fonction;
dbEntry.Image = client.Image;
dbEntry.Nom = client.Nom;
dbEntry.Prenom = client.Prenom;
dbEntry.Remarque = client.Remarque;
dbEntry.Service = client.Service;
dbEntry.Supprime = DateTime.Now;
dbEntry.Telephone = client.Telephone;
dbEntry.TypeImage = client.TypeImage;
dbEntry.Statut = client.Statut;
dbEntry.Etablissement.ClientRaisonSocial.Raison_Social = client.Etablissement.ClientRaisonSocial.Raison_Social;
dbEntry.Etablissement.ClientRaisonSocial.Logo = client.Etablissement.ClientRaisonSocial.Logo;
dbEntry.Etablissement.ClientRaisonSocial.LogoType = client.Etablissement.ClientRaisonSocial.LogoType;
dbEntry.Etablissement.ClientRaisonSocial.Slogan = client.Etablissement.ClientRaisonSocial.Slogan;
dbEntry.Etablissement.ClientRaisonSocial.Url_Validation = client.Etablissement.ClientRaisonSocial.Url_Validation;
// dbEntry.Etablissement.ClientRaisonSocial.Statut. = client.Etablissement.ClientRaisonSocial.Statut;
/* Client_Etablissement dbEtablissement = context.Clients_Etablissements.Find(client.Etablissement.Id_Etablissement);
if(dbEtablissement != null)
{
Client_Raison_Sociale dbSocial = context.Client_Raison_Sociale.Find(dbEtablissement.ClientRaisonSocial);
if (dbSocial != null)
{
dbSocial.Duns = dbEntry.Etablissement.ClientRaisonSocial.Duns;
dbSocial.Abonnement = dbEntry.Etablissement.ClientRaisonSocial.Abonnement;
dbSocial.Background = dbEntry.Etablissement.ClientRaisonSocial.Background;
dbSocial.BackgroundType = dbEntry.Etablissement.ClientRaisonSocial.BackgroundType;
dbSocial.Date_Creation = dbEntry.Etablissement.ClientRaisonSocial.Date_Creation;
dbSocial.Date_Validation = dbEntry.Etablissement.ClientRaisonSocial.Date_Validation;
dbSocial.Domaine = dbEntry.Etablissement.ClientRaisonSocial.Domaine;
dbSocial.Slogan = dbEntry.Etablissement.ClientRaisonSocial.Slogan;
dbSocial.Statut = dbEntry.Etablissement.ClientRaisonSocial.Statut;
dbSocial.Url_Validation = dbEntry.Etablissement.ClientRaisonSocial.Url_Validation;
dbSocial.Raison_Social = dbEntry.Etablissement.ClientRaisonSocial.Raison_Social;
dbEntry.Etablissement.ClientRaisonSocial = dbSocial;
}
}
dbEntry.Etablissement.Actif = true;
dbEntry.Etablissement.National = null;
dbEntry.Etablissement.Siege = true;
dbEntry.Etablissement.Supprime = false;
dbEntry.Etablissement.ClientRaisonSocial.Abonnement = null;
dbEntry.Etablissement.ClientRaisonSocial.Statut = null;*/
}
}
return await context.SaveChangesAsync();
}
