public Response RemoveOldRefreshTokens(string email, double daysRemoveTokenRevokedTimeOut)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.TOKEN_ACTUALIZACION_Delete");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@DIAS_REVOCAR_TOKEN", daysRemoveTokenRevokedTimeOut);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@ROWCOUNT"])));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response InsertIfNotexist(Core.Entity.Client client)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_InsertIfNotexist");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", client.Email);
storeProcedure.AddParameter("@CLIE_CI_VC", client.Ci);
storeProcedure.AddParameter("@CLIE_CI_EXPEDICION_VC", client.CiExpedition);
storeProcedure.AddParameter("@CLIE_CLAVE_VC", client.Password);
storeProcedure.AddParameter("@CLIE_TERMINOS_Y_CONDICIONES_ACEPTADOS_BT", client.AcceptTerms);
storeProcedure.AddParameter("@CLIE_TOKEN_VERIFICACION_EMAIL_VC", client.VerificationTokenEmail);
storeProcedure.AddParameter("@CLIE_ROL_IN", 1);
storeProcedure.AddParameter("@CLIE_USUARIO_CREACION_VC", client.CreationUser);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Id = Convert.ToInt64(dataTable.Rows[0]["CLIE_CLIENTE_ID_BI"]),
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataTable.Rows[0]["CLIE_CI_VC"].ToString(),
CiExpedition = dataTable.Rows[0]["CLIE_CI_EXPEDICION_VC"].ToString(),
VerificationTokenEmail = dataTable.Rows[0]["CLIE_TOKEN_VERIFICACION_EMAIL_VC"].ToString(),
};
return(Response.Success(result));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("AlreadyRegisteredEmail"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "AlreadyRegisteredEmail"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "Sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response UpdateRegistrationComplete(Core.Entity.Client client, string userModification)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateRegistrationComplete");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", client.Email);
storeProcedure.AddParameter("@CLIE_NOMBRE_COMPLETO_VC", client.NameComplete);
storeProcedure.AddParameter("@CLIE_GENERO_VC", client.Gender);
storeProcedure.AddParameter("@CLIE_FECHA_NACIMIENTO_DT", client.Birthdate);
storeProcedure.AddParameter("@CLIE_EDAD_IN", client.Age);
storeProcedure.AddParameter("@CLIE_DEPARTAMENTO_VC", client.Department);
storeProcedure.AddParameter("@CLIE_CIUDAD_VC", client.City);
storeProcedure.AddParameter("@CLIE_DIRECCION_VC", client.Address);
storeProcedure.AddParameter("@CLIE_NUMERO_CELULAR_VC", client.CellPhone);
storeProcedure.AddParameter("@CLIE_NUMERO_FIJO_VC", client.Phone);
storeProcedure.AddParameter("@CLIE_NIVEL_EDUCACION_VC", client.EducationLevel);
storeProcedure.AddParameter("@CLIE_DISCAPACIDAD_BT", client.Disability);
storeProcedure.AddParameter("@CLIE_TIPO_DISCAPACIDAD_VC", client.TypeDisability);
storeProcedure.AddParameter("@CLIE_NOMBRE_REFERENCIA_VC", client.ReferenceName);
storeProcedure.AddParameter("@CLIE_CELULAR_REFERENCIA_VC", client.ReferencePhone);
storeProcedure.AddParameter("@CLIE_USUARIO_MODIFICACION_VC", userModification);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@ROWCOUNT"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@ROWCOUNT"].ToString())));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorRegistrationComplete"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorRegistrationComplete"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "Sql"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response RefreshTokenUpdate(string email, string ipAddress, string refreshToken, string newRefreshToken)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.TOKEN_ACTUALIZACION_RefreshTokenUpdate");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@TOAC_IP_REVOCACION_TOKEN_VC", ipAddress);
storeProcedure.AddParameter("@TOAC_TOKEN_VC", refreshToken);
storeProcedure.AddParameter("@TOAC_TOKEN_REEMPLAZADO_TOKEN_VC", newRefreshToken);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
NameComplete = dataTable.Rows[0]["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 0 ? Role.Admin : Role.User,
IsVerified = Convert.ToBoolean(dataTable.Rows[0]["CLIE_ESTADO_VERIFICACION_BT"]),
CompleteRegister = Convert.ToBoolean(dataTable.Rows[0]["CLIE_REGISTRO_COMPLETO_BT"])
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorGeneredTokeRefresh"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorGeneredTokeRefresh"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "Sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetAllProducts()
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("dbo.PRODUCT_GetAllProducts");
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
ProductResponse result = new ProductResponse();
result.Products.AddRange(from DataRow dataRow in dataTable.Rows
let product = new ProductResponse.Product()
{
Code = dataRow["Code"].ToString(),
Name = dataRow["Name"].ToString(),
Description = dataRow["Description"].ToString(),
Category = dataRow["Category"].ToString(),
Cost = Convert.ToInt64(dataRow["Cost"]),
Price = Convert.ToInt64(dataRow["Price"]),
ImageUrl = dataRow["ImageUrl"].ToString(),
}
select product);
return(Response.Success(result));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("AlreadyRegisteredEmail"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "AlreadyRegisteredEmail"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "Sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response Insert(Core.Entity.RefreshToken refreshToken)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.TOKEN_ACTUALIZACION_Insert");
storeProcedure.AddParameter("@TOAC_TOKEN_VC", refreshToken.Token);
storeProcedure.AddParameter("@TOAC_FECHA_EXPIRACION_TOKEN", refreshToken.Expires);
storeProcedure.AddParameter("@TOAC_IP_CREACION_TOKEN_VC", refreshToken.CreatedByIp);
storeProcedure.AddParameter("@TOAC_USUARIO_CREACION_VC", refreshToken.CreationUser);
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", refreshToken.EmailClient);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.RefreshToken result = new Core.Entity.RefreshToken
{
EmailClient = refreshToken.EmailClient,
Token = dataTable.Rows[0]["TOAC_TOKEN_VC"].ToString(),
Expires = DateTime.ParseExact(dataTable.Rows[0]["TOAC_FECHA_EXPIRACION_TOKEN_DT"].ToString(), "M/d/yyyy h:m:s tt", CultureInfo.InvariantCulture)
};
return(Response.Success(result));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("ErrorGeneredTokeRefresh"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "ErrorGeneredTokeRefresh"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "sql"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetAnswerAndQuestions(int idModule)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.MODULO_GetAnswerAndQuestions");
storeProcedure.AddParameter("@MODU_NUMERO_MODULO_IN", idModule);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (!dataTable.Rows[0]["RESULTADO"].ToString().Equals("01"))
{
QuestionAswerResponse questionAswerResponse = new QuestionAswerResponse();
questionAswerResponse.Questions.AddRange(from DataRow dataRow in dataTable.Rows
let question = new QuestionAswerResponse.Question()
{
IdQuestion = Convert.ToInt64(dataRow["PREG_PREGUNTA_ID_BI"]),
FieldType = dataRow["PREG_TIPO_CAMPO_VC"].ToString(),
QuestionEvalute = dataRow["PREG_PREGUNTA_VC"].ToString(),
QuestionDetail = dataRow["PREG_PREGUNTA_DESCRIPCION_VC"].ToString(),
AnswerWithoutProcess = dataRow["RESPUESTAS"].ToString()
}
select question);
return(Response.Success(questionAswerResponse));
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("ModuleNotRegistred"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "ModuleNotRegistred"));
}
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response Insert(Core.Entity.ConsumptionHistory consumptionHistory)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.HISTORIAL_CONSUMO_API_ECOFUTURO_Insert");
storeProcedure.AddParameter("@HIAE_WEAP_NOMBRE_VC", consumptionHistory.ApiName);
storeProcedure.AddParameter("@HIAE_HOST_VC", consumptionHistory.Host);
storeProcedure.AddParameter("@HIAE_ID_CORRELACION_VC", consumptionHistory.CorrelationId);
storeProcedure.AddParameter("@HIAE_APP_USUARIO_ID_VC", consumptionHistory.AppUserId);
storeProcedure.AddParameter("@HIAE_SOLICITUD_VC", consumptionHistory.Request);
storeProcedure.AddParameter("@HIAE_FECHA_SOLICITUD_DT", consumptionHistory.DateRequest);
storeProcedure.AddParameter("@HIAE_RESPUESTA_VC", consumptionHistory.Response);
storeProcedure.AddParameter("@HIAE_FECHA_RESPUESTA_DT", consumptionHistory.DateResponse);
storeProcedure.AddParameter("@HIAE_CODIGO_RESPUESTA_VC", consumptionHistory.CodeResponse);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@IDENTITY"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@IDENTITY"].ToString())));
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response Authenticate(Core.Entity.User user)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.USUARIO_Authenticate");
storeProcedure.AddParameter("@USWA_USUARIO_NOMBRE_VC", user.UserName);
storeProcedure.AddParameter("@USWA_CONTRASENA_VB", user.Password);
storeProcedure.AddParameter("@USWA_PUBLICA_UN", user.Public);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].Equals("00"))
{
return(Response.Success(new Core.Entity.User()
{
Id = Convert.ToInt64(dataTable.Rows[0]["USWA_USUARIO_WEP_API_ID_BI"].ToString()),
UserName = dataTable.Rows[0]["USWA_USUARIO_NOMBRE_VC"].ToString(),
Public = dataTable.Rows[0]["USWA_TOKEN_PUBLICO_UN"].ToString(),
Status = dataTable.Rows[0]["USWA_ESTADO_VC"].ToString()
}));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("NotAuthenticated"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "NotAuthenticated"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("NotUnauthorized"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "NotUnauthorized"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response UpdateClientForgotPassword(string email, string resetToken)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateClientForgotPassword");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@CLIE_RESTABLECER_TOKEN_VERIFICACION_EMAIL_VC", resetToken);
storeProcedure.AddParameter("@CLIE_FECHA_EXPIRACION_TOKEN_RESTABLECER_DT", DateTime.UtcNow.AddDays(1));
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
ResetToken = dataTable.Rows[0]["CLIE_RESTABLECER_TOKEN_VERIFICACION_EMAIL_VC"].ToString()
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorGeneredTokeRefresh"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorGeneredTokeRefresh"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response Authorize(Core.Entity.UserPolicy userPolicy, Core.Entity.Policy policy)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.USUARIO_POLITICA_Authorize");
storeProcedure.AddParameter("@USPO_USUA_ID_BI", userPolicy.IdUser);
storeProcedure.AddParameter("@USPO_APP_USUARIO_ID_VC", userPolicy.AppUserId);
storeProcedure.AddParameter("@POLI_NOMBRE_VC", policy.Name);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].Equals("00"))
{
return(Response.Success(new Core.Entity.UserPolicy()
{
Status = dataTable.Rows[0]["USPO_ESTADO_BT"].ToString()
}));
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("NotAuthenticated"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "NotAuthenticated"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("NotUnauthorized"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "NotUnauthorized"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetClientCompleteRegistration(string email)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateByEmailForChangePassword");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorResetPassword"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorResetPassword"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public bool Run(string connectionString, int timeout)
{
if (Items.Count > 0)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
foreach (var item in Items)
{
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(item.Name, sqlConnection);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.CommandTimeout = timeout;
foreach (var item1 in item.Items)
{
if (item1.Value == null)
{
sqlDataAdapter.SelectCommand.Parameters.AddWithValue(item1.Name, DBNull.Value);
}
else
{
sqlDataAdapter.SelectCommand.Parameters.AddWithValue(item1.Name, item1.Value);
}
}
sqlDataAdapter.SelectCommand.Transaction = sqlTransaction;
sqlDataAdapter.SelectCommand.ExecuteNonQuery();
}
sqlTransaction.Commit();
Error = string.Empty;
return(true);
}
catch (Exception ex)
{
Logger.Fatal("Message: {0}; Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
sqlTransaction.Rollback();
Error = ex.Message;
return(false);
}
}
else
{
return(true);
}
}
public Response InsertClientAnswerValidate(string email, long idAnswer, long idQuestion, bool state, double scoreAnswer, string userCreation)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_RESPUESTA_InsertClientAnswerValidate");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@REUS_RESPUESTA_ID_BI", idAnswer);
storeProcedure.AddParameter("@RESP_PREGUNTA_ID_BI", idQuestion);
storeProcedure.AddParameter("@RESP_ESTADO_RESPUESTA_CORRECTA_BT", state);
storeProcedure.AddParameter("@REUS_PUNTAJE_OBTENIDO_DC", scoreAnswer);
storeProcedure.AddParameter("@REUS_USUARIO_CREACION_VC", userCreation);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@IDENTITY"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@IDENTITY"].ToString())));
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Success(0));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetModuleEndDate(string email)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_MODULO_GetModuleEndDate");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].Equals("00"))
{
return(Response.Success(new Core.Entity.CustomModuleEndDate
{
Day = dataTable.Rows[0]["DIA"].ToString(),
Month = dataTable.Rows[0]["MES"].ToString()
}));
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", Response.CommentMenssage("ParticipantDoesNotExist"), SerializeJson.ToObject(dataTable));
return(Response.Error("ParticipantDoesNotExist"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotFinishAllTheModules"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotFinishAllTheModules"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response RevokeToken(string token, string ipAddress)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.TOKEN_ACTUALIZACION_RevokeToken");
storeProcedure.AddParameter("@TOAC_TOKEN_VC", token);
storeProcedure.AddParameter("@TOAC_IP_REVOCACION_TOKEN_VC", ipAddress);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@ROWCOUNT"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@ROWCOUNT"].ToString())));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorRevokeToken"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorRevokeToken"));
}
}
else
{
Logger.Error("Message: {0} StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
else
{
Logger.Debug("Message: {0} DataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(dataTable, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response UpdateByVerifyEmmail(string token, string userMotification)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_UpdateByVerifyEmmail");
storeProcedure.AddParameter("@CLIE_TOKEN_VERIFICACION_EMAIL_VC", token);
storeProcedure.AddParameter("@CLIE_USUARIO_MODIFICACION_VC", userMotification);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (Convert.ToInt32(dataTable.Rows[0]["@@ROWCOUNT"]) > 0)
{
return(Response.Success(Convert.ToInt64(dataTable.Rows[0]["@@ROWCOUNT"].ToString())));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorVerifyemail"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorVerifyemail"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("Sql"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "Sql"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public bool Run(string connectionString, int timeout)
{
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlCommand sqlCommand = new SqlCommand(Name, sqlConnection)
{
CommandType = CommandType.StoredProcedure,
CommandTimeout = timeout
};
foreach (var item in Items)
{
if (item.Value == null)
{
sqlCommand.Parameters.AddWithValue(item.Name, DBNull.Value);
}
else
{
sqlCommand.Parameters.AddWithValue(item.Name, item.Value);
}
}
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
Error = string.Empty;
return(true);
}
catch (SqlException ex)
{
Logger.Fatal("Message: {0}; Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
Error = ex.Message;
sqlConnection.Close();
return(false);
}
}
public DataTable ReturnData(string connectionString, int timeOut)
{
DataTable dataTable = new DataTable();
SqlConnection sqlConnection = new SqlConnection(connectionString);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(Name, sqlConnection);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.CommandTimeout = timeOut;
foreach (var item in Items)
{
if (item.Value == null)
{
sqlDataAdapter.SelectCommand.Parameters.AddWithValue(item.Name, DBNull.Value);
}
else
{
sqlDataAdapter.SelectCommand.Parameters.AddWithValue(item.Name, item.Value);
}
}
try
{
sqlConnection.Open();
sqlDataAdapter.Fill(dataTable);
Error = string.Empty;
}
catch (SqlException ex)
{
Logger.Fatal("Message: {0}; Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
Error = ex.Message;
}
finally
{
sqlConnection.Close();
}
return(dataTable);
}
public Response SendEmail(string to, string subject, string withOriginMessage, string withoutOriginMessage, string header, string origin, string link, string token = "", string numberModule = "", string coupon = "", string contestDate = "")
{
Response response = new Response();
string finalMessage = "";
if (!Validate.ToEmail(to))
{
var validate = Response.Error(to, "InvalidEmail");
response.Data = null;
response.Message = validate.Message;
response.State = validate.State;
return(response);
}
MailAddress _fromMailAddress = new MailAddress(_from);
MailMessage message = new MailMessage();
if (_flagEnableUserPassword)
{
var basicCredential = new NetworkCredential(_user, _password);
_client.UseDefaultCredentials = false;
_client.EnableSsl = true;
_client.Credentials = basicCredential;
_client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
}
if (!string.IsNullOrEmpty(origin))
{
finalMessage = _message.Replace("@message", withOriginMessage);
}
else
{
finalMessage = _message.Replace("@message", withoutOriginMessage);
}
message.Subject = subject;
message.IsBodyHtml = true;
message.From = _fromMailAddress;
var bodyMessage = "";
foreach (var item in to.Split(';'))
{
if (!string.IsNullOrEmpty(item))
{
message.To.Add(item);
bodyMessage = finalMessage.Replace("@email", item).Replace("@link", link).Replace("@Bussines", _from).Replace("@header", header).Replace("@token", token).Replace("@numeroModulo", numberModule).Replace("@cupon", coupon).Replace("@fecha", contestDate);
message.Body = bodyMessage;
/*AlternateView view = AlternateView.CreateAlternateViewFromString(bodyMessage, null, MediaTypeNames.Text.Html);
*
* LinkedResource resource = new LinkedResource(string.Format(@"{0}/Resources/MailImages/header-bg.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)),"image/png");
* resource.ContentId = "id1";
* resource.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource);
*
* LinkedResource resource2 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/module-completed.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource2.ContentId = "id2";
* resource2.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource2);
*
* LinkedResource resource3 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/bg-mail.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource3.ContentId = "id3";
* resource3.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource3);
*
* LinkedResource resource4 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/click-logo.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource4.ContentId = "id4";
* resource4.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource4);
*
* LinkedResource resource5 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/ecofuturo-logo.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource5.ContentId = "id5";
* resource5.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource5);
*
* LinkedResource resource6 = new LinkedResource(string.Format(@"{0}/Resources/MailImages/bg-ticket.png", Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory)), "image/png");
* resource6.ContentId = "id6";
* resource6.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;
* view.LinkedResources.Add(resource6);
*
* message.AlternateViews.Add(view);
* bodyMessage = "";*/
}
}
ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;
try
{
_client.Send(message);
return(Response.Success(true));
}
catch (Exception ex)
{
Logger.Error("Message: {0}; Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(to, "InvalidEmail"));
}
}
public Response InsertClientModuleAnswers(string email, int numberModule, string userCreation)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_MODULO_InsertClientModuleAnswers");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@MODU_NUMERO_MODULO_IN", numberModule);
storeProcedure.AddParameter("@CLIE_USUARIO_CREACION_VC", userCreation);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (!dataTable.Rows[0]["RESULTADO"].Equals("03"))
{
if (!dataTable.Rows[0]["RESULTADO"].Equals("02"))
{
if (!dataTable.Rows[0]["RESULTADO"].Equals("01"))
{
return(Response.Success(new Core.Entity.Coupon
{
CouponRegistred = dataTable.Rows[0]["CLMO_CUPON_VC"].ToString(),
CouponNumber = dataTable.Rows[0]["MODU_NUMERO_MODULO_IN"].ToString()
}));
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Error("CouponAlreadyRegistered"));
}
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Error("ClientFinallyModule"));
}
}
else
{
Logger.Error("Message: {0}; DataTable: {1}", "", SerializeJson.ToObject(dataTable));
return(Response.Error("ModuleNotRegistred"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ModuleNotRegistred"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ModuleNotRegistred"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetWinners()
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetWinnerbyModule");
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
WinnersdResponse result = new WinnersdResponse();
result.Winners.AddRange(from DataRow dataRow in dataTable.Rows
let winner = new WinnersdResponse.Winner()
{
Position = Convert.ToInt32(dataRow["POSITION"]),
Email = dataRow["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataRow["CLIE_CI_VC"].ToString(),
NameComplete = dataRow["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Gender = dataRow["CLIE_GENERO_VC"].ToString(),
Birthdate = Convert.ToDateTime(dataRow["CLIE_FECHA_NACIMIENTO_DT"]),
Age = Convert.ToInt32(dataRow["CLIE_EDAD_IN"]),
Department = dataRow["CLIE_DEPARTAMENTO_VC"].ToString(),
City = dataRow["CLIE_CIUDAD_VC"].ToString(),
Address = dataRow["CLIE_DIRECCION_VC"].ToString(),
CellPhone = dataRow["CLIE_NUMERO_CELULAR_VC"].ToString(),
Phone = Convert.ToString(dataRow["CLIE_NUMERO_FIJO_VC"]),
EducationLevel = dataRow["CLIE_NIVEL_EDUCACION_VC"].ToString(),
Disability = Convert.ToBoolean(dataRow["CLIE_DISCAPACIDAD_BT"]),
TypeDisability = Convert.ToString(dataRow["CLIE_TIPO_DISCAPACIDAD_VC"]),
ReferenceName = Convert.ToString(dataRow["CLIE_NOMBRE_REFERENCIA_VC"]),
ReferenceCellphone = Convert.ToString(dataRow["CLIE_CELULAR_REFERENCIA_VC"]),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 1 ? "User" : "Admin",
CompleteRegister = Convert.ToBoolean(dataRow["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataRow["MODULO_ACTUAL"]),
NumberModuleFinished = Convert.ToInt32(dataRow["NUMERO_MODULOS_TERMINADOS"]),
ModulesFinishComplete = dataRow["MODULOS_TERMINADOS"].ToString()
}
select winner);
List <WinnersdResponse.Winner.FinishedModule> addfinishedModules = new List <WinnersdResponse.Winner.FinishedModule>();
foreach (var winner in result.Winners)
{
if (string.IsNullOrEmpty(winner.ModulesFinishComplete))
{
break;
}
foreach (string module in winner.ModulesFinishComplete.Split("@"))
{
var finishModule = module.Split(":");
winner.FinishedModules.Add(new WinnersdResponse.Winner.FinishedModule
{
ModuleNumber = Convert.ToInt32(finishModule[0]),
Coupon = finishModule[1].ToString()
});
}
}
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ErrorGetWinners"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ErrorGetWinners"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetInformationClient(string email)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetInformationClient");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
List <MyInformationResponse.FinishedModule> addfinishedModules = new List <MyInformationResponse.FinishedModule>();
if (!string.IsNullOrEmpty(dataTable.Rows[0]["MODULOS_TERMINADOS"].ToString()))
{
addfinishedModules.AddRange(from string item in dataTable.Rows[0]["MODULOS_TERMINADOS"].ToString().Split("@")
let moduleFinish = new MyInformationResponse.FinishedModule()
{
ModuleNumber = Convert.ToInt32(item.Substring(0, item.IndexOf(":"))),
Coupon = item.Substring(item.IndexOf(":") + 1)
}
select moduleFinish);
}
MyInformationResponse result = new MyInformationResponse
{
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Ci = dataTable.Rows[0]["CLIE_CI_VC"].ToString(),
NameComplete = dataTable.Rows[0]["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Gender = dataTable.Rows[0]["CLIE_GENERO_VC"].ToString(),
Birthdate = Convert.ToDateTime(dataTable.Rows[0]["CLIE_FECHA_NACIMIENTO_DT"]),
Age = Convert.ToInt32(dataTable.Rows[0]["CLIE_EDAD_IN"]),
Department = dataTable.Rows[0]["CLIE_DEPARTAMENTO_VC"].ToString(),
City = dataTable.Rows[0]["CLIE_CIUDAD_VC"].ToString(),
Address = dataTable.Rows[0]["CLIE_DIRECCION_VC"].ToString(),
CellPhone = dataTable.Rows[0]["CLIE_NUMERO_CELULAR_VC"].ToString(),
Phone = dataTable.Rows[0]["CLIE_NUMERO_FIJO_VC"].ToString(),
EducationLevel = dataTable.Rows[0]["CLIE_NIVEL_EDUCACION_VC"].ToString(),
Disability = Convert.ToBoolean(dataTable.Rows[0]["CLIE_DISCAPACIDAD_BT"]),
TypeDisability = Convert.ToString(dataTable.Rows[0]["CLIE_TIPO_DISCAPACIDAD_VC"]),
ReferenceName = dataTable.Rows[0]["CLIE_NOMBRE_REFERENCIA_VC"].ToString(),
ReferenceCellphone = dataTable.Rows[0]["CLIE_CELULAR_REFERENCIA_VC"].ToString(),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 1 ? "User" : "Admin",
CompleteRegister = Convert.ToBoolean(dataTable.Rows[0]["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataTable.Rows[0]["MODULO_ACTUAL"]),
finishedModules = addfinishedModules
};
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("ParticipantDoesNotExist"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "ParticipantDoesNotExist"));
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}
public Response GetClientValitated(string email, string password)
{
try
{
StoreProcedure storeProcedure = new StoreProcedure("weco.CLIENTE_GetClientValitated");
storeProcedure.AddParameter("@CLIE_CORREO_ELECTRONICO_VC", email);
storeProcedure.AddParameter("@CLIE_CLAVE_VC", password);
DataTable dataTable = storeProcedure.ReturnData(_connection, _timeOut);
Logger.Debug("StoreProcedure: {0} DataTable: {1}", SerializeJson.ToObject(storeProcedure), SerializeJson.ToObject(dataTable));
if (storeProcedure.Error.Length <= 0)
{
if (dataTable.Rows.Count > 0)
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("00"))
{
Core.Entity.Client result = new Core.Entity.Client
{
NameComplete = dataTable.Rows[0]["CLIE_NOMBRE_COMPLETO_VC"].ToString(),
Email = dataTable.Rows[0]["CLIE_CORREO_ELECTRONICO_VC"].ToString(),
Password = dataTable.Rows[0]["CLIE_CLAVE_VC"].ToString(),
Role = Convert.ToInt32(dataTable.Rows[0]["CLIE_ROL_IN"]) == 0 ? Role.Admin : Role.User,
IsVerified = Convert.ToBoolean(dataTable.Rows[0]["CLIE_ESTADO_VERIFICACION_BT"]),
CompleteRegister = Convert.ToBoolean(dataTable.Rows[0]["CLIE_REGISTRO_COMPLETO_BT"]),
CurrentModule = Convert.ToInt32(dataTable.Rows[0]["MODULO_ACTUAL"])
};
if (BC.Verify(password, result.Password))
{
return(Response.Success(result));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
if (dataTable.Rows[0]["RESULTADO"].ToString().Equals("02"))
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("AccountNotValidated"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "AccountNotValidated"));
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
}
else
{
Logger.Error("Message: {0}; dataTable: {1}", Response.CommentMenssage("NotLogin"), SerializeJson.ToObject(dataTable));
return(Response.Error(null, "NotLogin"));
}
}
else
{
Logger.Error("Message: {0}; StoreProcedure.Error: {1}", Response.CommentMenssage("Sql"), storeProcedure.Error);
return(Response.Error(storeProcedure.Error, "Sql"));
}
}
catch (Exception ex)
{
Logger.Error("Message: {0} Exception: {1}", ex.Message, SerializeJson.ToObject(ex));
return(Response.Error(ex, "Error"));
}
}