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