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