public Task <QueryResult> GetProudctSalesInfo(string productId, DateTime dateFrom, DateTime dateTo)
{
var salesQuery = new SalesQuery
{
ProductId = productId,
DateFrom = dateFrom,
DateTo = dateTo
};
return(queryBus.Send <SalesQuery, QueryResult>(salesQuery));
}
public IHttpActionResult GetAllSalesViaSearch(string employeeName, DateTime?fromDate, DateTime?toDate)
{
SalesQuery query = new SalesQuery();
query.EmployeeName = employeeName;
query.ToDate = toDate;
query.FromDate = fromDate;
var repo = PurchasesRepositoryFactory.GetRepository();
var model = repo.GetAllTotalSales(query);
return(Ok(model));
}
public IEnumerable <SalesReportRequestItem> GetAllTotalSales(SalesQuery query)
{
List <SalesReportRequestItem> request = new List <SalesReportRequestItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SalesReportSelectAllDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrWhiteSpace(query.EmployeeName))
{
cmd.Parameters.AddWithValue("@EmployeeFirstName", DBNull.Value);
cmd.Parameters.AddWithValue("@EmployeeLastName", DBNull.Value);
}
else
{
string[] names = query.EmployeeName.Split(' ');
cmd.Parameters.AddWithValue("@EmployeeFirstName", names[0]);
cmd.Parameters.AddWithValue("@EmployeeLastName", names[1]);
}
if (!query.FromDate.HasValue)
{
cmd.Parameters.AddWithValue("@FromDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FromDate", query.FromDate);
}
if (!query.ToDate.HasValue)
{
cmd.Parameters.AddWithValue("@ToDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ToDate", query.ToDate);
}
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SalesReportRequestItem currentRow = new SalesReportRequestItem();
currentRow.EmployeeId = (int)dr["EmployeeId"];
currentRow.EmployeeName = dr["EmployeeName"].ToString();
currentRow.TotalSales = (decimal)dr["TotalSales"];
currentRow.TotalVehicles = (int)dr["TotalVehicles"];
request.Add(currentRow);
}
}
}
return(request);
}
