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 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 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 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 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 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 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 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 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 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 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 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 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 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 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"));
}
}
static void Main(string[] args)
{
LogDetail logDetail = GetLogDetail("Starting application");
Logger.WriteDiagnosticLog(logDetail);
var perfTracker = new PerformanceTracker("FullLogging.Console_Execution", string.Empty, logDetail.UserName, logDetail.Location, logDetail.Product, logDetail.Layer);
//try
//{
// var forcedException = new Exception("Something bad has happened!");
// forcedException.Data.Add("input param", "nothing to see here");
// throw forcedException;
//}
//catch (Exception ex)
//{
// logDetail = GetLogDetail(string.Empty, ex);
// Logger.WriteErrorLog(logDetail);
//}
var fullLoggingConnection = ConfigurationManager.ConnectionStrings["FullLoggingConnection"].ToString();
using (var db = new SqlConnection(fullLoggingConnection))
{
db.Open();
try
{
//RAW ADO.NET
//var adoCommand = new SqlCommand("uspCreateCustomer", db);
//adoCommand.CommandType = System.Data.CommandType.StoredProcedure;
//adoCommand.Parameters.Add(new SqlParameter("@Name", "asdadsadasdadsadadasdsad"));
//adoCommand.Parameters.Add(new SqlParameter("@TotalPurchases", 12000));
//adoCommand.Parameters.Add(new SqlParameter("@TotalReturns", 100.50M));
//adoCommand.ExecuteNonQuery();
var customADO = new StoreProcedure(db, "uspCreateCustomer");
customADO.AddParameter("@Name", "stadasdasudahdusahdua");
customADO.AddParameter("@TotalPurchases", 12000);
customADO.AddParameter("@TotalReturns", 100.50M);
customADO.ExecuteNonQuery();
}
catch (Exception ex)
{
var exceptionLogDetail = GetLogDetail(string.Empty, ex);
Logger.WriteErrorLog(exceptionLogDetail);
}
}
logDetail = GetLogDetail("used full logging console.");
Logger.WriteUsageLog(logDetail);
logDetail = GetLogDetail("Stopping app");
Logger.WriteDiagnosticLog(logDetail);
perfTracker.Stop();
}
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"));
}
}
