public string GetConfirmationCode(string username, string password, string email) //retorna JSON { string response = string.Empty; EngineProyect Funcion = new EngineProyect(); if (username == null || username == string.Empty || password == null || password == string.Empty || email == null || email == string.Empty) { return(response = Funcion.BuildingVerificationCode(string.Empty, HttpStatusCode.NotImplemented.ToString()));//Modelo incompleto 501 } EngineDb Metodo = new EngineDb(); bool resultado = Metodo.GetUser(username, password, email); if (!resultado) { return(response = Funcion.BuildingVerificationCode(string.Empty, HttpStatusCode.ExpectationFailed.ToString()));//No existe el usuario 417 } string code = Funcion.NumberFactory(); CodeToVerification model = new CodeToVerification(); model = Funcion.BuildingVerificationCode(username, password, email, code, false); EngineDb Entidad = new EngineDb(this.context); resultado = Entidad.InsertCodeToVerification(model); if (!resultado) { return(response = Funcion.BuildingVerificationCode(string.Empty, HttpStatusCode.Conflict.ToString()));//No inserto el codigo 409 } return(response = Funcion.BuildingVerificationCode(code, HttpStatusCode.OK.ToString())); }
public CodeToVerification BuildingVerificationCode(string username, string password, string email, string code, bool status) { CodeToVerification R = new CodeToVerification() { Username = username, Password = ConvertirBase64(username + password), Email = email, SendDate = DateTime.UtcNow, VerificationDate = DateTime.UtcNow, Status = status, Code = code, }; return(R); }
public bool InsertCodeToVerification(CodeToVerification model) { bool resultado = false; try { context.CodeToVerification.Add(model); context.SaveChanges(); resultado = true; } catch { return(resultado); } return(resultado); }
public string PutActivateAcount([FromBody] CodeToVerification act)//retorna JSON { string response = string.Empty; EngineProyect Funcion = new EngineProyect(); if (act.Username == null || act.Username == string.Empty || act.Password == null || act.Password == string.Empty || act.Email == null || act.Email == string.Empty || act.Code == null || act.Code == string.Empty) { return(response = Funcion.BuildingVerificationCode(string.Empty, HttpStatusCode.NotImplemented.ToString())); } EngineDb Metodo = new EngineDb(); bool resultado = false; resultado = Metodo.PutActivateAccount(act); if (!resultado) { return(response = Funcion.BuildingVerificationCode(act.Code, HttpStatusCode.Conflict.ToString()));//No Actualizo el codigo 409 } return(response = Funcion.BuildingVerificationCode(act.Code, HttpStatusCode.OK.ToString())); }
public bool PutActivateAccount(CodeToVerification model) { bool resultado = false; using (Conexion) { Conexion.Open(); SqlCommand command = new SqlCommand(EngineData.PutActivateAccount, Conexion); command.CommandType = CommandType.StoredProcedure; command.Parameters.Clear(); command.Parameters.AddWithValue("@Password", Funcion.ConvertirBase64(model.Username + model.Password)); command.Parameters.AddWithValue("@Email", model.Email); command.Parameters.AddWithValue("@Code", model.Code); command.Parameters.AddWithValue("@VerificationDate", DateTime.UtcNow); command.Parameters.AddWithValue("@Status", model.Status); resultado = (bool)command.ExecuteScalar(); Conexion.Close(); } return(resultado); }