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