public Task <GetDataAsync> Read_List_Log(Data_Log data_Log) { throw new NotImplementedException(); }
async Task <GetDataAsync> IGetDataAsync.Read_List_Log(Data_Log data_Log) { var task = Task.Factory.StartNew(() => { DataTable dataTable = new DataTable(); Connection connection = new Connection(); SqlCommand sqlCommand = new SqlCommand() { CommandText = "[dbo].[Read_List_Log]", CommandType = CommandType.StoredProcedure, Connection = connection.connectionString }; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter() { SelectCommand = sqlCommand }; SqlParameter parameterStart_FechaRegistro = new SqlParameter { SqlDbType = SqlDbType.DateTime, ParameterName = "@Start_FechaRegistro", Value = data_Log.Start_FechaRegistro }; sqlCommand.Parameters.Add(parameterStart_FechaRegistro); SqlParameter parameterEnd_FechaRegistro = new SqlParameter { SqlDbType = SqlDbType.DateTime, ParameterName = "@End_FechaRegistro", Value = data_Log.End_FechaRegistro }; sqlCommand.Parameters.Add(parameterEnd_FechaRegistro); SqlParameter paramIdUser_Empresa = new SqlParameter() { SqlDbType = SqlDbType.Int, ParameterName = "@IdUser_Empresa", Value = data_Log.IdUser_Empresa }; sqlCommand.Parameters.Add(paramIdUser_Empresa); connection.Connect(); sqlDataAdapter.Fill(dataTable); connection.Disconnect(); DataRow row; List <Data_Log> data_Logs = new List <Data_Log>(); Data_Log log; for (int i = 0; i < dataTable.Rows.Count; i++) { row = dataTable.Rows[i]; log = new Data_Log(); log.Fecha = Convert.ToDateTime(row["Fecha"].ToString()); log.Comentario = row["Comentario"].ToString(); log.DetalleError = row["DetalleError"].ToString(); log.Selectable = false; data_Logs.Add(log); } var getDataAsync = new GetDataAsync() { Data_Logs = data_Logs }; return(getDataAsync); }); return(await task); }