/** * Si l'utilisateur n'est pas actif : activer * Sinon rien faire */ public Boolean ActivateUser(string token) { PublicUser user = _tokenHelper.ValidateVerificationToken(token); user = _context.PublicUser.First(x => x.Id == user.Id); if (user != null) { if (user.EstActive == false) { user.EstActive = true; try { _context.SaveChanges(); return(true); } catch { } } } return(false); }
public JObject SaveDevisInformation(JObject j, string token) { dynamic res = new JObject(); DevisInformation devis = null; // try // { int id = j["Devis"]["Id"].ToObject <int>(); //Il s'agit bien d'une modification d'un devis var requ = j["Devis"]; if (id != -1) { devis = _context.DevisInformation.First(d => d.Id == id); if (requ["nombrePoste"] != null) { devis.NbrPoste = requ["nombrePoste"].ToObject <int>(); } if (requ["nombreContrat"] != null) { devis.NbrContrat = requ["nombreContrat"].ToObject <int>(); } if (requ["logCompta"] != null) { devis.LogCompta = requ["logCompta"].ToObject <Softwares>().Name; } if (requ["LogGestion"] != null) { devis.LogGestion = requ["LogGestion"].ToObject <Softwares>().Name; } if (requ["lettragePart"] != null) { devis.LettragePartiel = requ["lettragePart"].ToObject <int>(); } if (requ["clotureFacture"] != null) { devis.ClotureFacture = requ["clotureFacture"].ToObject <int>(); } if (requ["preLettrage"] != null) { devis.PreLettrage = requ["preLettrage"].ToObject <int>(); } if (requ["volumetrie"] != null) { devis.Volumetrie = requ["volumetrie"].ToObject <int>(); } if (requ["mdrVRTS"] != null) { devis.MdrPrcntVirts = requ["mdrVRTS"].ToObject <int>(); } if (requ["mdrLCM"] != null) { devis.MdrPrcntTrtSaccept = requ["mdrLCM"].ToObject <int>(); } if (requ["mdrBOR"] != null) { devis.MdrPrcntTrtAaccept = requ["mdrBOR"].ToObject <int>(); } if (requ["mdrCHQ"] != null) { devis.MdrPrcntChq = requ["mdrCHQ"].ToObject <int>(); } if (requ["mdrAutre"] != null) { devis.MdrPrcntAutres = requ["mdrAutre"].ToObject <int>(); } _context.SaveChanges(); res.saved = true; } //Il s'agit d'une nouvelle insertion d'un devis else { using (var transaction = _context.Database.BeginTransaction()) { int idPublicUser = _tokenHelper.getSidToken(token); PublicUser user = _context.PublicUser.Include(u => u.Contact).Where(t => t.Id == idPublicUser).First(); // Console.WriteLine("PUBLIC USER ====> " + user.Username); Comptes cpt = _context.CompteContact.Select(t => t.IdCptNavigation).Where(p => p.MainContactId == user.Contact.Id).FirstOrDefault(); Console.WriteLine("COMPTE ID ====> " + cpt.Id); devis = new DevisInformation(); if (requ["nombrePoste"] != null) { devis.NbrPoste = requ["nombrePoste"].ToObject <int>(); } if (requ["nombreContrat"] != null) { devis.NbrContrat = requ["nombreContrat"].ToObject <int>(); } if (requ["logCompta"] != null) { devis.LogCompta = requ["logCompta"].ToObject <Softwares>().Name; } if (requ["LogGestion"] != null) { devis.LogGestion = requ["LogGestion"].ToObject <Softwares>().Name; } if (requ["lettragePart"] != null) { devis.LettragePartiel = requ["lettragePart"].ToObject <int>(); } if (requ["clotureFacture"] != null) { devis.ClotureFacture = requ["clotureFacture"].ToObject <int>(); } if (requ["preLettrage"] != null) { devis.PreLettrage = requ["preLettrage"].ToObject <int>(); } if (requ["volumetrie"] != null) { devis.Volumetrie = requ["volumetrie"].ToObject <int>(); } if (requ["mdrVRTS"] != null) { devis.MdrPrcntVirts = requ["mdrVRTS"].ToObject <int>(); } if (requ["mdrLCM"] != null) { devis.MdrPrcntTrtSaccept = requ["mdrLCM"].ToObject <int>(); } if (requ["mdrBOR"] != null) { devis.MdrPrcntTrtAaccept = requ["mdrBOR"].ToObject <int>(); } if (requ["mdrCHQ"] != null) { devis.MdrPrcntChq = requ["mdrCHQ"].ToObject <int>(); } if (requ["mdrAutre"] != null) { devis.MdrPrcntAutres = requ["mdrAutre"].ToObject <int>(); } devis.IdCpt = cpt.Id; _context.DevisInformation.Add(devis); _context.SaveChanges(); transaction.Commit(); res.newId = devis.Id; res.saved = true; } } // } /* catch (Exception e) * { * res.saved = false; * res.error = e.Message; * throw; * } * finally * { * res.time = DateTime.Now.ToString("HH:mm:ss - dd/MM/yyyy"); * }*/ Console.WriteLine("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"); return(res); }