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