/// <summary> /// Méthode permettant de sauvegarder un utilisateur, create ou update /// </summary> /// <param name="registered"></param> /// <param name="token"></param> /// <returns></returns> public bool SaveUser(Registered registered, Token token) { RegisteredDTO e = registered.DTO; DALWSR_Result r1 = dal.SaveUser(registered.DTO, token, CancellationToken.None); return(r1.IsSuccess); }
public DALWSR_Result SaveUser(RegisteredDTO registered, Token tokenSend, CancellationToken cancel) { string str = string.Concat(CnxString, ADR_SAVEUSER); WSR_Param p = new WSR_Param() { { "save", registered }, { "token", tokenSend } }; WSR_Result r = ConsumeWSR.Call(str, "POST", p, TypeSerializer.Json, cancel); return(new DALWSR_Result(r)); }
/// <summary> /// Méthode pour avoir les infos d'un utilisateur ayant un compte /// </summary> /// <param name="iduser"></param> /// <returns></returns> public Registered GetInfoUser(int iduser) { DALWSR_Result r1 = dal.GetUserByIdAsync(iduser, CancellationToken.None); RegisteredDTO regDto = (RegisteredDTO)r1.Data; if (regDto != null) { return(new Registered(regDto, GetStatus(regDto.StatusUser), GetTraining(regDto.TrainingUser))); } return(null); }
/// <summary> /// Constructeur pour mapper dto en Registered /// </summary> /// <param name="dto"></param> /// <param name="objstatus"></param> /// <param name="objtraining"></param> public Registered(RegisteredDTO dto, Status objstatus, Training objtraining) : this() { IdUser = dto.IdUser; ObjStatus = objstatus; ObjTraining = objtraining; NameUser = dto.NameUser; FirstnameUser = dto.FirstnameUser; EmailUser = dto.EmailUser; LoginUser = dto.LoginUser; PwdUser = TokenManager.GetPwd(Encoding.UTF8.GetString(Convert.FromBase64String(dto.PwdUser), 0, Convert.FromBase64String(dto.PwdUser).Length)); KeywordUser = dto.KeywordUser; DTO = dto; }
/// <summary> /// Constructeur par défaut /// </summary> public Registered() { dal = new DALClient(); ListRegistered = new List <Registered>(); IdUser = Int_NullValue; ObjStatus = null; NameUser = String_NullValue; ObjTraining = null; FirstnameUser = String_NullValue; EmailUser = String_NullValue; LoginUser = String_NullValue; PwdUser = String_NullValue; KeywordUser = String_NullValue; DTO = new RegisteredDTO(); }
public static bool IsTokenValid(Token token, RegisteredDTO registered) { bool result = false; long timeStamp = token.Time; DateTime ts = new DateTime(timeStamp); long date = DateTime.UtcNow.Ticks; DateTime d = new DateTime(date); int iduser = token.IdUser; bool expired = Math.Abs((d - ts).TotalMinutes) > expMinute; if (!expired) { string computedToken = GenerateTokenWS(registered.LoginUser, registered.PwdUser); result = (token.TokenSpe == computedToken); } return(result); }
public override DTOBase PopulateDTO(SqlDataReader reader) { RegisteredDTO r = new RegisteredDTO(); if (!reader.IsDBNull(Ord_IdUser)) { r.IdUser = Convert.ToInt32(reader.GetDecimal(Ord_IdUser)); } if (!reader.IsDBNull(Ord_IdStatus)) { r.StatusUser = Convert.ToInt32(reader.GetDecimal(Ord_IdStatus)); } if (!reader.IsDBNull(Ord_IdTraining)) { r.TrainingUser = Convert.ToInt32(reader.GetDecimal(Ord_IdTraining)); } if (!reader.IsDBNull(Ord_Name)) { r.NameUser = reader.GetString(Ord_Name); } if (!reader.IsDBNull(Ord_Firstname)) { r.FirstnameUser = reader.GetString(Ord_Firstname); } if (!reader.IsDBNull(Ord_Email)) { r.EmailUser = reader.GetString(Ord_Email); } if (!reader.IsDBNull(Ord_Login)) { r.LoginUser = reader.GetString(Ord_Login); } if (!reader.IsDBNull(Ord_Pwd)) { r.PwdUser = reader.GetString(Ord_Pwd); } if (!reader.IsDBNull(Ord_Keyword)) { r.KeywordUser = reader.GetString(Ord_Keyword); } r.IsNew = true; return(r); }
/// <summary> /// Méthode pour sauvegarder un utilisateur (save et update) /// </summary> /// <param name="registered"></param> public void SaveUser(ref RegisteredDTO registered) { SqlCommand command = new SqlCommand(); SqlParameter paramNewUserId = new SqlParameter(); bool isNewRecord = false; if (registered.IdUser.Equals(Common.DTOBase.Int_NullValue)) { command = GetDbSprocCommand("INSERTUSER"); paramNewUserId = CreateOutputParameter("@NEWUSERID", SqlDbType.Int); command.Parameters.Add(paramNewUserId); isNewRecord = true; } else { command = GetDbSprocCommand("UPDATEUSERS"); command.Parameters.Add(CreateParameter("@ID", registered.IdUser)); } command.Parameters.Add(CreateParameter("@IDSTATUS", registered.StatusUser)); command.Parameters.Add(CreateParameter("@IDTRAINING", registered.TrainingUser)); command.Parameters.Add(CreateParameter("@NAME", registered.NameUser, 50)); command.Parameters.Add(CreateParameter("@FIRSTNAME", registered.FirstnameUser, 50)); command.Parameters.Add(CreateParameter("@EMAIL", registered.EmailUser, 100)); command.Parameters.Add(CreateParameter("@LOGIN", registered.LoginUser, 50)); command.Parameters.Add(CreateParameter("@PASSWORD", registered.PwdUser, 1024)); command.Parameters.Add(CreateParameter("@KEYWORD", registered.KeywordUser, 50)); // Exécute la commande. command.Connection.Open(); int nb = command.ExecuteNonQuery(); command.Connection.Close(); if (nb == 1) { if (isNewRecord && nb == 1) { registered.IdUser = (int)paramNewUserId.Value; } //TODO return sur l'exécution des requetes insert et update } // S'il s'agit d'un nouvel enregistrement, attribut un nouvel id à l'objet. }
/// <summary> /// Méthode permettant d'obtenir la liste de messages par sujet /// </summary> public void GetListMessagesByTopic() { ListMessagesByTopic.Clear(); DALWSR_Result r1 = dal.GetMessagesByTopicAsync(IdTopic, CancellationToken.None); Registered reg; if (r1.Data != null) { foreach (MessageDTO item in (List <MessageDTO>)r1.Data) { DALWSR_Result r2 = dal.GetTopicByIdAsync(item.IdTopic, CancellationToken.None); TopicDTO topicDto = (TopicDTO)r2.Data; DALWSR_Result r3 = dal.GetUserByIdAsync(item.IdUser, CancellationToken.None); RegisteredDTO regDto = (RegisteredDTO)r3.Data; reg = new Registered(); reg.ObjStatus = reg.GetStatus(regDto.StatusUser); reg.ObjTraining = reg.GetTraining(regDto.TrainingUser); ListMessagesByTopic.Add(new Message(item, new Registered(regDto, reg.ObjStatus, reg.ObjTraining))); } } }
/// <summary> /// Méthode permettant d'obtenir la liste des sujets par rubrique /// </summary> public void GetListTopicsByRubric() { ListTopicsByRubric.Clear(); DALWSR_Result r1 = dal.GetTopicByRubricAsync(IdRubric, CancellationToken.None); if (r1.Data != null) { Registered reg; foreach (TopicDTO item in (List <TopicDTO>)r1.Data) { DALWSR_Result r2 = dal.GetRubricByIdAsync(item.IdRubric, CancellationToken.None); RubricDTO rubric = (RubricDTO)r2.Data; DALWSR_Result r3 = dal.GetUserByIdAsync(item.IdUser, CancellationToken.None); RegisteredDTO regDto = (RegisteredDTO)r3.Data; reg = new Registered(); reg.ObjStatus = reg.GetStatus(regDto.StatusUser); reg.ObjTraining = reg.GetTraining(regDto.TrainingUser); ListTopicsByRubric.Add(new Topic(item, new Registered(regDto, reg.ObjStatus, reg.ObjTraining), new Rubric(rubric))); } } }
public WSR_Result SaveUser(WSR_Param param) { RegisteredDTO registered = null; object data = null; WSR_Result result = null; Token token = null; result = VerifParamType(param, "token", out token); if (result == null) { //token = (Token)param["token"]; //TokenDb dbToken = new TokenDb(); //RegisteredDTO regToken = dbToken.GetInfoAuth(token); //if (TokenManager.IsTokenValid(token, regToken)) // { result = VerifParamType(param, "save", out registered); if (result == null) { registered = (RegisteredDTO)param["save"]; RegisteredDb db = new RegisteredDb(); db.SaveUser(ref registered); data = registered; return(new WSR_Result(data, true)); } else { return(result); } } else { return(result); } //} //else return result; }
/// <summary> /// Constructeur complet /// </summary> /// <param name="iduser"></param> /// <param name="objstatus"></param> /// <param name="objtraining"></param> /// <param name="nameuser"></param> /// <param name="firstnameuser"></param> /// <param name="emailuser"></param> /// <param name="loginuser"></param> /// <param name="pwduser"></param> /// <param name="keyworduser"></param> public Registered(int iduser, Status objstatus, Training objtraining, string nameuser, string firstnameuser, string emailuser, string loginuser, string pwduser, string keyworduser) : this() { IdUser = iduser; ObjStatus = objstatus; NameUser = nameuser; FirstnameUser = firstnameuser; EmailUser = emailuser; LoginUser = loginuser; PwdUser = pwduser; KeywordUser = keyworduser; DTO = new RegisteredDTO(); DTO.IdUser = iduser; DTO.StatusUser = objstatus.IdStatus; DTO.TrainingUser = objtraining.IdTraining; DTO.NameUser = nameuser; DTO.FirstnameUser = firstnameuser; DTO.EmailUser = emailuser; DTO.LoginUser = loginuser; DTO.PwdUser = TokenManager.HashPwd(LoginUser, PwdUser); DTO.KeywordUser = keyworduser; }
public Registered(RegisteredDTO dto, Status status, Training training) { this.Data = dto; this.DataStatus = status; this.DataTraining = training; }