public void TestGetWeightTicketReport() { WeightTicketsBL weightTicketBL = new WeightTicketsBL(connectionString); WeightTicketReportFilterModel filter = new WeightTicketReportFilterModel(); filter.CicleId = 1; filter.WeightTicketType = 1; ReportData data = weightTicketBL.GetWeightTicketsReport(filter); }
public WeightTicketsReport() { InitializeComponent(); presenter = new WeightTicketReportPresenter(this); CurrentFilters = new WeightTicketReportFilterModel(); CurrentFilters.EndDateTime = DateTime.Now; CurrentFilters.StartDateTime = DateTime.Now; GridFilters.DataContext = CurrentFilters; InitializeColumnsDictionary(); }
public IHttpActionResult GetWeightTicketsReport([FromUri] WeightTicketReportFilterModel filters) { GetReportDataResponse response = new GetReportDataResponse(); try { response.ReportData = weightTicketsBL.GetWeightTicketsReport(filters); response.Success = true; } catch (Exception ex) { response.ErrorMessage = "Error. " + ex.Message; response.Success = false; } return(Ok(response)); }
public ReportData GetWeightTicketsReport(WeightTicketReportFilterModel filters) { ReportData reportData = new ReportData(); DataTable data = weightTicketsDL.GetWeightTicketsReport(filters); foreach (DataColumn column in data.Columns) { ReportDataColumn reportColumn = new ReportDataColumn(); reportColumn.Type = column.DataType; reportColumn.Name = column.ColumnName; reportData.Columns.Add(reportColumn); } foreach (DataRow row in data.Rows) { ReportDataRow reportRow = new ReportDataRow(); reportRow.Items = new List <object>(row.ItemArray); reportData.Rows.Add(reportRow); } return(reportData); }
public void TestGetWeightTicketReport() { //Test this one in prod baseUrl = @"http://lasmargaritas.azurewebsites.net/"; Token token = TokenHelper.GetToken(baseUrl, "Melvin3", "MelvinPass3"); HttpClient client = new HttpClient(); client.BaseAddress = new Uri(baseUrl); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token.access_token); WeightTicketReportFilterModel filter = new WeightTicketReportFilterModel(); filter.CicleId = 1; filter.WeightTicketType = (int)WeightTicketType.Producer; HttpResponseMessage response = client.GetAsync(string.Format("{0}?{1}", getReportAction, filter.GetUrlQuery())).Result; response.EnsureSuccessStatusCode(); GetReportDataResponse getReportDataResponse = response.Content.ReadAsAsync <GetReportDataResponse>().Result; Assert.IsTrue(getReportDataResponse.Success); Assert.IsTrue(getReportDataResponse.ReportData != null); // Assert.IsTrue(getReportDataResponse.ReportData.Count > 0); }
public DataTable GetWeightTicketsReport(WeightTicketReportFilterModel filters) { DataTable dataTable = new DataTable(); using (SqlCommand command = new SqlCommand()) { using (SqlConnection connection = new SqlConnection()) { connection.ConnectionString = ConnectionString; command.Connection = connection; command.CommandText = "spGetWeightTicketReport"; foreach (PropertyInfo prop in (from x in filters.GetType().GetProperties() select x).ToArray()) { if (prop.PropertyType == typeof(DateTime)) { command.Parameters.AddWithValue("@" + prop.Name, ((DateTime)prop.GetValue(filters)).ToUniversalTime()); } else if (prop.PropertyType == typeof(DateTime?) && ((DateTime?)prop.GetValue(filters)).HasValue) { command.Parameters.AddWithValue("@" + prop.Name, ((DateTime)prop.GetValue(filters)).ToUniversalTime()); } else { command.Parameters.AddWithValue("@" + prop.Name, prop.GetValue(filters)); } } command.CommandType = CommandType.StoredProcedure; connection.Open(); using (SqlDataAdapter adapter = new SqlDataAdapter()) { adapter.SelectCommand = command; adapter.Fill(dataTable); } } return(dataTable); } }