public async Task <IActionResult> Update(string jsonObject) { try { _response = await _service.UpdateTypeProduit(jsonObject); if (_response.IsSuccessStatusCode) { Result = await _response.Content.ReadAsAsync <ObjetRetour>(); if (Result.Etat) { return(Json(new { ok = true, message = "Mise à réalisée avec succès!" })); } else { return(Json(new { ok = false, message = Result.Message })); } } else { return (Json( new { ok = false, message = string.Format("{0} : {1}", _response.StatusCode, _response.RequestMessage) })); } } catch (Exception ex) { return(Json(new { ok = false, message = ex.Message })); } }
public async Task <ObjetRetour> GetUsers(decimal id, string token) { var retour = new ObjetRetour(); try { if (_commun.ConnexionValide(token) == (int)enumEtat.Valide) { retour.Contenu = await _service.Tbuser.FindByConditionAync(a => a.IdUser == id); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } catch (Exception ex) { retour.Etat = false; retour.Message = ex.Message; _logger.LogError(ex.Message); } return(retour); }
public ObjetRetour AddReceptionProduit(ReceptionProduitDto value) { var retour = new ObjetRetour(); try { if (_commun.GetConnexionValide(value.Token, _strIP) == (int)enumEtat.Valide) { _service.ReceptionProduit.Create(value.ToModel()); retour.Etat = true; _logger.LogInformation($"SUCCESS"); } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInformation($"Token non valide!"); } } catch (Exception ex) { _logger.LogError(ex.Message); retour.Etat = false; retour.Message = ex.Message; } return(retour); }
[HttpPost]//GetStatutPaiement public async Task <JsonResult> GetStatutPaiement(string jsonObject) { try { var ic = JObject.Parse(jsonObject); var operateur = (int)ic["operateur"]; var OrderId = (string)ic["OrderId"]; if (operateur == 2) { _response = await Api.Url.GetAsync("/api/Operation/GetStatutPaiementMoov?orderId=" + OrderId); } else { _response = await Api.Url.GetAsync("/api/Operation/GetStatutPaiementOrange?orderId=" + OrderId); } if (_response.IsSuccessStatusCode) { //Update paiement var querySql = new Sql("SELECT * FROM TB_PAIEMENT WHERE ORDERID = '" + OrderId + "'"); var UpdatePaiement = _db.Fetch <PaiementDto>(querySql).FirstOrDefault(); Result = JsonConvert.DeserializeObject <ObjetRetour>(_response.Content.ReadAsStringAsync().Result); if (Result.Etat) { //UpdatePaiement.STATUT_PAIEMENT = 2;//Payer if (UpdatePaiement.STATUT_PAIEMENT != 2) { var sql = new Sql("UPDATE TB_PAIEMENT SET STATUT_PAIEMENT = '" + 2 + "', DATE_MODIFICATION = '" + DateTime.Now + "' WHERE ROWIDAUTO = '" + UpdatePaiement.ROWIDAUTO + "'"); _db.Execute(sql); } return(Json(new { ok = true, message = Result.Message }, JsonRequestBehavior.AllowGet)); } else { //UpdatePaiement.STATUT_PAIEMENT = 3;//Echec var sql = new Sql("UPDATE TB_PAIEMENT SET STATUT_PAIEMENT = '" + 3 + "', DATE_MODIFICATION = '" + DateTime.Now + "' WHERE ROWIDAUTO = '" + UpdatePaiement.ROWIDAUTO + "'"); _db.Execute(sql); return(Json(new { ok = false, message = Result.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { ok = false, message = string.Format("{0}: {1}", _response.StatusCode, _response.RequestMessage), JsonRequestBehavior.AllowGet })); } } catch (Exception ex) { //_logger.LogError(ex.Message); return(Json(new { ok = false, message = ex.Message })); } }
public async Task <ObjetRetour> InsertUsers(TbuserDto value) { var retour = new ObjetRetour(); try { if (value != null) { if (_commun.ConnexionValide(value.Token) == (int)enumEtat.Valide) { var pass = clsSecurityHash.getSHA256(value.Password); value.Password = pass; var agent = _service.Tbagent.FindByCondition(a => a.Matricule == value.Matricule).FirstOrDefault(); if (agent != null) { value.AgentId = agent.AgentId; value.StatusCode = (int)EtatAgent.EnFonction; await _service.Tbuser.CreateAsync(value.ToModel()); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } else { retour.Message = $"Agent Inexistant!"; retour.Etat = false; _logger.LogInfo($"Agent Inexistant!"); } } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } else { retour.Message = $"Parametre non valide!"; retour.Etat = false; _logger.LogInfo($"Parametre non valide!"); } } catch (Exception ex) { retour.Etat = false; retour.Message = ex.Message; _logger.LogError(ex.Message); } return(retour); }
public ObjetRetour InitialiserMotDePasse(LoginModel login) { var retour = new ObjetRetour(); try { if (login != null) { if (_commun.ConnexionValide(login.Token) == (int)enumEtat.Valide) { var user = _service.Tbuser.FindByCondition(u => u.IdUser == login.UserId).FirstOrDefault(); user.Password = clsSecurityHash.getSHA256("123456"); //user..DateDerniereModificationPassword = DateTime.Now; user.DateDerniereModificationPassword = DateTime.Now; _service.Tbuser.Update(user); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } else { retour.Message = $"Parametre non valide!"; retour.Etat = false; _logger.LogInfo($"Parametre non valide!"); } } catch (Exception ex) { _logger.LogError(ex.Message); retour.Etat = true; retour.Message = ex.Message; } return(retour); }
//private InfoUserModel getinfoUser(TbuserDto connexion) //{ // var retour = new InfoUserModel(); // return retour; //} //public ObjetRetour ModifierMotDePasse(LoginModel login) //{ // throw new NotImplementedException(); //} //public Task<ObjetRetour> GetAllUsers(string token) //{ // throw new NotImplementedException(); //} //public Task<ObjetRetour> GetUsers(int id, string token) //{ // throw new NotImplementedException(); //} //public Task<ObjetRetour> InsertUsers(TbuserDto value) //{ // throw new NotImplementedException(); //} //public Task<ObjetRetour> InsertListUsers(List<TbuserDto> value) //{ // throw new NotImplementedException(); //} //public ObjetRetour MajUsers(TbuserDto value) //{ // throw new NotImplementedException(); //} //public ObjetRetour MajListUsers(List<TbuserDto> value) //{ // throw new NotImplementedException(); //} //public ObjetRetour DeleteUsers(TbuserDto value) //{ // throw new NotImplementedException(); //} //public ObjetRetour DeleteListUsers(List<TbuserDto> values) //{ // throw new NotImplementedException(); //} public ObjetRetour ModifierMotDePasse(LoginModel login) { var retour = new ObjetRetour(); try { if (_commun.ConnexionValide(login.Token) == (int)enumEtat.Valide) { var pass = clsSecurityHash.getSHA256(login.OldPassword); var user = _service.Tbuser.FindByCondition(u => u.LoginUser == login.Login && u.Password == pass).FirstOrDefault(); if (user.Password == pass) { user.Password = clsSecurityHash.getSHA256(login.Password); _service.Tbuser.Update(user); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } else { retour.Message = $"Ancien mot de passe incorrect!"; retour.Etat = false; _logger.LogInfo($"Ancien mot de passe incorrect!"); } } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } catch (Exception ex) { _logger.LogError(ex.Message); retour.Etat = false; retour.Message = ex.Message; } return(retour); }
public ObjetRetour DeleteUsers(TbuserDto value) { var retour = new ObjetRetour(); try { if (_commun.ConnexionValide(value.Token) == (int)enumEtat.Valide) { try { _service.Tbuser.Delete(value.ToModel()); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } catch (Microsoft.EntityFrameworkCore.DbUpdateException ex) { value.StatusCode = (int)EtatAgent.Supprimer; _service.Tbuser.Update(value.ToModel()); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); retour.Message = ex.Message; } } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } catch (Exception ex) { _logger.LogError(ex.Message); retour.Etat = false; retour.Message = ex.Message; } return(retour); }
[HttpPost]//NotifPaiementOrange public ObjetRetour NotifPaiementOrange(NotifClientModel value) { var retour = new ObjetRetour(); try { if (value != null) { var querySql = new Sql("SELECT * FROM TB_PAIEMENT WHERE ORDERID = '" + value.orderId + "'"); var UpdatePaiement = _db.Fetch <PaiementDto>(querySql).FirstOrDefault(); if (value.status == "SUCCESS" || value.status == "Successful") { //UpdatePaiement.STATUT_PAIEMENT = 2;//Payer if (UpdatePaiement.STATUT_PAIEMENT != 2) { var sql = new Sql("UPDATE TB_PAIEMENT SET STATUT_PAIEMENT = '" + 2 + "', DATE_MODIFICATION = '" + DateTime.Now + "' WHERE ORDERID = '" + value.orderId + "'"); _db.Execute(sql); } retour.Etat = true; retour.Message = $"SUCCESS: PAIEMENT EFFECTUE AVEC SUCCES"; //_logger.LogInfo($"SUCCESS: PAIEMENT EFFECTUE AVEC SUCCES"); } else { retour.Message = $"Notification non valide! Statut : " + value.status; retour.Etat = false; //_logger.LogInfo($"Notification non valide! Statut : " + value.status); } } } catch (Exception ex) { retour.Etat = false; retour.Message = ex.Message; //_logger.LogError(ex.Message); } return(retour); }
public async Task <IActionResult> Get(string jsonObject) { try { _response = await _service.GetTypeProduit(jsonObject); if (_response.IsSuccessStatusCode) { Result = await _response.Content.ReadAsAsync <ObjetRetour>(); if (Result.Etat) { var DecompressResult = JsonConvert.DeserializeObject <TypeProduitDto>(Result.Contenu.ToString()); return(Json(new { ok = true, Data = DecompressResult, message = Result.Message })); } else { return(Json(new { ok = false, message = Result.Message })); } } else { return (Json( new { ok = false, message = string.Format("{0}: {1}", _response.StatusCode, _response.RequestMessage) })); } } catch (Exception ex) { return(Json(new { ok = false, message = ex.Message })); } }
public ObjetRetour Login(LoginModel login) { if (login == null) { return(new ObjetRetour()); } var retour = new ObjetRetour(); try { string pass = ""; pass = clsSecurityHash.getSHA256(login.Password); var user = _service.Tbuser.FindByCondition(u => u.LoginUser == login.Login && u.Password == pass).FirstOrDefault(); if (user == null) { retour.Etat = false; retour.Message = "Login ou mot de passe non valide!"; retour.Contenu = new LoginModel(); return(retour); } if (user.Password == pass) { var secretKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(Startup.SecretKey)); var signinCredentials = new SigningCredentials(secretKey, SecurityAlgorithms.HmacSha256); var tokeOptions = new JwtSecurityToken( issuer: Startup.Issuer,// TODO adresse de deploiement du service audience: _strIP, claims: new List <Claim>(), expires: DateTime.Now.AddMinutes(10),//TODO Duree du Token signingCredentials: signinCredentials ); var tokenString = new JwtSecurityTokenHandler().WriteToken(tokeOptions); var connexion = new Connexion() { AdresseIpSource = _strIP, Bsucces = true, DateConnexion = DateTime.Now, DateLastConnexion = DateTime.Now, Token = tokenString, UserId = (int)user.IdUser }; _service.Connexion.Create(connexion); var profil = _service.Tbprofil.FindByCondition(p => p.ProfilId == user.ProfilId).FirstOrDefault(); var habilitations = _service.Tbhabilitation.FindByCondition(h => h.ProfilId == profil.ProfilId); var lstIdMenus = habilitations.Select(m => m.MenuId).ToList(); var menuUsers = _service.Tbmenu.FindByCondition(mp => lstIdMenus.Contains(mp.MenuId)); var info = new InfoUserModel(); var loginModel = new LoginModel(); loginModel.UserId = (int)user.IdUser; loginModel.UserName = user.NomPrenUser; loginModel.Login = user.LoginUser; loginModel.Token = tokenString; info.Login = loginModel; info.Menus = new List <MenuModel>(); var vueMenuParent = menuUsers.Where(m => m.IdParent == null).OrderBy(o => o.OrdreMenu).ToList(); foreach (var menuUser in vueMenuParent) { var menup = new MenuModel(); menup.MenuParent = ModelFromDto(menuUser); menup.Menu = LstModelFromDto(menuUsers.Where(me => me.IdParent == menuUser.MenuId).OrderBy(o => o.OrdreMenu).ToList()); info.Menus.Add(menup); } // info = getinfoUser(user); _service.Save(); retour.Contenu = info; retour.Message = $"SUCCESS"; retour.Etat = true; _logger.LogInfo($"SUCCESS"); } } catch (Exception ex) { retour.Etat = false; retour.Message = ex.Message; _logger.LogError(ex.Message); } return(retour); }
public ObjetRetour MajUsers(TbuserDto value) { var retour = new ObjetRetour(); try { if (value != null) { if (_commun.ConnexionValide(value.Token) == (int)enumEtat.Valide) { var agent = _service.Tbagent.FindByCondition(a => a.Matricule == value.Matricule).FirstOrDefault(); if (agent != null) { var user = _service.Tbuser.FindByCondition(u => u.IdUser == value.IdUser).FirstOrDefault(); if (user != null) { user.IdUser = value.IdUser; user.CodUser = value.CodUser; user.LoginUser = value.LoginUser; user.NomPrenUser = value.NomPrenUser; user.NumTel = value.NumTel; user.SexUser = value.SexUser; user.AdrUser = value.AdrUser; user.Password = value.Password; user.DatFonc = value.DatFonc; user.IdTypeUser = value.IdTypeUser; user.ProfilId = value.ProfilId; user.AgentId = value.AgentId; user.DateDebutValidite = value.DateDebutValidite; user.DateFinValidite = value.DateFinValidite; user.DateDerniereModificationPassword = value.DateDerniereModificationPassword; user.InitUserPassword = value.InitUserPassword; user.NbreEchecsOuvertureSession = value.NbreEchecsOuvertureSession; user.DateDerniereConnexion = value.DateDerniereConnexion; user.DerniereConnexionReussie = value.DerniereConnexionReussie; user.DateDernierVerrouillage = value.DateDernierVerrouillage; user.Email = value.Email; user.StatutSession = value.StatutSession; user.Hostname = value.Hostname; user.ModifieLe = value.ModifieLe; user.ModifiePar = value.ModifiePar; user.StateCode = value.StateCode; user.StatusCode = value.StatusCode; user.DateCreation = value.DateCreation; _service.Tbuser.Update(user); _service.Save(); retour.Etat = true; _logger.LogInfo($"SUCCESS"); } else { retour.Message = $"Tbuser Inexistant!"; retour.Etat = false; _logger.LogInfo($"Tbuser Inexistant!"); } } else { retour.Message = $"Agent Inexistant!"; retour.Etat = false; _logger.LogInfo($"Agent Inexistant!"); } } else { retour.Message = $"Token non valide!"; retour.Etat = false; _logger.LogInfo($"Token non valide!"); } } else { retour.Message = $"Parametre non valide!"; retour.Etat = false; _logger.LogInfo($"Parametre non valide!"); } } catch (Exception ex) { _logger.LogError(ex.Message); retour.Etat = false; retour.Message = ex.Message; } return(retour); }
public ObjetRetour LoginMobile(string codeEquipement) { if (string.IsNullOrEmpty(codeEquipement)) { return(new ObjetRetour()); } var retour = new ObjetRetour(); try { var equipement = _service.Equipement.FindByCondition(e => e.CodeEq == codeEquipement).FirstOrDefault(); if (equipement == null) { retour.Etat = false; retour.Message = "Equipement non habilité!"; return(retour); } if (equipement != null) { var secretKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(Startup.SecretKey)); var signinCredentials = new SigningCredentials(secretKey, SecurityAlgorithms.HmacSha256); var tokeOptions = new JwtSecurityToken( issuer: Startup.Issuer,// TODO adresse de deploiement du service audience: _strIP, claims: new List <Claim>(), expires: DateTime.Now.AddMinutes(10),//TODO Duree du Token signingCredentials: signinCredentials ); var tokenString = new JwtSecurityTokenHandler().WriteToken(tokeOptions); var connexion = new Connexion() { AdresseIpSource = _strIP, Bsucces = true, DateConnexion = DateTime.Now, DateLastConnexion = DateTime.Now, Token = tokenString, Equipementid = equipement.Equipementid }; _service.Connexion.Create(connexion); // info = getinfoUser(user); _service.Save(); retour.Contenu = tokenString; retour.Message = $"SUCCESS"; retour.Etat = true; _logger.LogInfo($"SUCCESS"); } } catch (Exception ex) { retour.Etat = false; retour.Message = ex.Message; _logger.LogError(ex.Message); } return(retour); }
public async Task <JsonResult> AddParticipant(string jsonObject, int Operateur) { try { var ObjectParticipant = JsonConvert.DeserializeObject <ParticipantDto>(jsonObject); ObjectParticipant.DateCreation = DateTime.Now; var currentEvent = Session["CurrentEvent"] as CurrentEventModel; var retour = _db.Insert <ParticipantDto>("TB_PARTICPANT", "rowid", ObjectParticipant); //var NewParticipant = _db.Fetch<ParticipantDto>(new Sql().Select("*").From("TB_PARTICPANT").Where("Telephone = @telephone","DateCreation = @dateCreation", new { telephone = ObjectParticipant.Telephone, dateCreation = ObjectParticipant.DateCreation })).FirstOrDefault(); //string stringSql = string.Format("SELECT * FROM TB_PARTICPANT WHERE Telephone = '{0}' AND DateCreation = '{1}'", ObjectParticipant.Telephone, Convert.ToDateTime(ObjectParticipant.DateCreation)); var stringSql = "SELECT * FROM TB_PARTICPANT WHERE Telephone = '" + ObjectParticipant.Telephone + "' AND DateCreation >= '" + Convert.ToDateTime(ObjectParticipant.DateCreation) + "'"; var query = new Sql(stringSql); var NewParticipant = _db.Fetch <ParticipantDto>(query).FirstOrDefault(); if (NewParticipant != null) { var NewParticiper = new ParticiperDto() { rowidparticipant = NewParticipant.rowid, rowidevenement = currentEvent.ROWID, dateparticipation = DateTime.Now }; var result = _db.Insert <ParticiperDto>("TB_PARTICIPER", "rowid", NewParticiper); if (currentEvent.ESTPAYANT == true) { //Création du orderid string orderid = null; Random random = new Random(); var orders = random.Next(1000, 10000); var dt = DateTime.Now.ToShortTimeString().Replace("/", ""); var id = orders.ToString() + dt.Replace(":", ""); orderid = "ASC_" + id; var codePlateforme = "Asc00123"; if (Operateur == 2) { _response = await Api.Url.GetAsync("/api/Operation/InitierPaiementMoov?montant=" + currentEvent.TARIF + "&CodePlateForme=" + codePlateforme + "&orderid=" + orderid); } else { _response = await Api.Url.GetAsync("/api/Operation/InitierPaiementOrange?montant=" + currentEvent.TARIF + "&CodePlateForme=" + codePlateforme + "&orderid=" + orderid); } if (_response.IsSuccessStatusCode) { Result = JsonConvert.DeserializeObject <ObjetRetour>(_response.Content.ReadAsStringAsync().Result); if (Result.Etat) { var DecompressResult = JsonConvert.DeserializeObject <RetourPaiement>(Result.Contenu.ToString()); //initiation du paiement var querySql = new Sql("SELECT * FROM TB_PARTICIPER WHERE rowidevenement = '" + NewParticiper.rowidevenement + "' AND rowidparticipant = '" + NewParticiper.rowidparticipant + "'"); var NewQuery = _db.Fetch <ParticiperDto>(querySql).FirstOrDefault(); var NewPaiement = new PaiementDto() { ID_PARTICIPER = NewQuery.rowid, MONTANT = currentEvent.TARIF, STATUT_PAIEMENT = 1,//initier DATE_PAIEMENT = DateTime.Now, DATE_MODIFICATION = DateTime.Now, ORDERID = DecompressResult.orderId }; _db.Insert <PaiementDto>("TB_PAIEMENT", "ROWIDAUTO", NewPaiement); return(Json(new { ok = true, data = DecompressResult, aPayer = 1, url = "/Accueil", message = "Votre réservation est enregistrée, Veuillez terminer le processus SVP!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { ok = false, message = Result.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { ok = false, message = string.Format("{0}: {1}", _response.StatusCode, _response.RequestMessage), JsonRequestBehavior.AllowGet })); } } else { return(Json(new { ok = true, aPayer = 0, url = "/Accueil", message = "Votre réservation a bien été enregistrée" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { ok = false, message = "Echec de la réservation pour cet évènement !" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { ok = false, message = ex.Message })); } }