public Task <int> Login(Login data) { try { Task <int> result; using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } var query = $"Select dbo.LOGIN(N'{data.Username}', N'{data.Password}');"; using (var cmd = new SqlCommand(query, conn)) { result = Task.FromResult((int)cmd.ExecuteScalar()); } } return(result); } catch (Exception e) { Console.WriteLine(e); return(Task.FromResult(-4)); } }
public Task <bool> DeleteProductPrice(int priceId) { try { using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } using (var cmd = new SqlCommand("ELIMINA_PRECIO", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PRECIO", SqlDbType.Int).Value = priceId; cmd.ExecuteNonQuery(); conn.Close(); } } return(Task.FromResult(true)); } catch (Exception e) { Console.WriteLine(e); return(Task.FromResult(false)); } }
public Task <bool?> ExistTransacction(string transactionId) { try { Task <bool?> result; using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } var query = $"Select dbo.EXISTE_TRANSACCION(N'{transactionId}');"; using (var cmd = new SqlCommand(query, conn)) { result = Task.FromResult((bool?)cmd.ExecuteScalar()); } } return(result); } catch (Exception) { return(null); } }
public Task <DataSet> TotalUsers() { try { DataSet ds = new DataSet(); using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } string query = $@"SELECT * FROM V_ADMINISTRADORES;"; using (var cmd = new SqlCommand(query, conn)) { using (var adapter = new SqlDataAdapter(cmd)) { adapter.Fill(ds); } } } return(Task.FromResult(ds)); } catch (Exception) { return(null); } }
public Task <bool> Register(Register register) { try { using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } using (var cmd = new SqlCommand("REGISTRO", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@USUARIO", SqlDbType.NVarChar).Value = register.Username; cmd.Parameters.Add("@CLAVE", SqlDbType.NVarChar).Value = register.Password; cmd.Parameters.Add("@PREGUNTA", SqlDbType.Int).Value = register.Question; cmd.Parameters.Add("@RESPUESTA", SqlDbType.NVarChar).Value = register.Answer; cmd.ExecuteNonQuery(); conn.Close(); } } return(Task.FromResult(true)); } catch (Exception e) { Console.WriteLine(e); return(Task.FromResult(false)); } }
public Task <bool> UpdateUserStatus(UserStatus userStatus) { try { using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } using (var cmd = new SqlCommand("ACTUALIZA_ESTADO_ADMINISTRADOR", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@USUARIO", SqlDbType.NVarChar).Value = userStatus.Username; cmd.Parameters.Add("@ESTADO", SqlDbType.Bit).Value = userStatus.NewStatus; cmd.ExecuteNonQuery(); conn.Close(); } } return(Task.FromResult(true)); } catch (Exception) { return(Task.FromResult(false)); } }
public Task <List <LineType> > LineTypeList() { try { DataSet ds = new DataSet(); using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } string query = "SELECT * FROM V_TIPO_LINEA_CLIENTE;"; using (var cmd = new SqlCommand(query, conn)) { using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) { adapter.Fill(ds); } } } return(Task.FromResult(ConvertToList_LineType(ds))); } catch (Exception) { return(null); } }
public Task <UsersList> ReturnUserStatus(int pkUser) { try { UsersList user = new UsersList(); using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } string query = $"SELECT * FROM RETORNA_ESTADO_ADMINISTRADOR({pkUser});"; using (var cmd = new SqlCommand(query, conn)) { cmd.CommandType = CommandType.Text; var dr = cmd.ExecuteReader(); while (dr.Read()) { user.PkCode = dr.GetInt32(0); user.Username = dr.GetString(1); user.Status = dr.GetBoolean(2); } } } return(Task.FromResult(user)); } catch (Exception) { return(null); } }