public IList <Transaction> GetTransactionsByDate(SummaryDateAndDateRangeDto dateAndDateRangeDto)
{
return(_context.Transactions.Include("Service")
.Include("Vehicle")
.Include("Branch")
.Where(a => a.DateTime.Year == dateAndDateRangeDto.DateTime.Year &&
a.DateTime.Month == dateAndDateRangeDto.DateTime.Month &&
a.DateTime.Day == dateAndDateRangeDto.DateTime.Day &&
a.BranchId == dateAndDateRangeDto.BranchId)
.ToList());
}
public List <Transaction> GetTransactionsByDateRange(SummaryDateAndDateRangeDto dateAndDateRangeDto)
{
var client = new RestClient(Resources.ConnectionString);
var request = new RestRequest("/api/transactions/gettransactionsbydaterange/", Method.POST);
var jsonObj = JsonConvert.SerializeObject(dateAndDateRangeDto);
request.AddJsonBody(jsonObj);
request.RequestFormat = DataFormat.Json;
var response = client.Execute(request);
var dataList = JsonConvert.DeserializeObject <List <Transaction> >(response.Content);
return(dataList);
}
private void btnPreview_Click(object sender, EventArgs e)
{
SummaryDateAndDateRangeDto dateAndDateRangeDto = new SummaryDateAndDateRangeDto();
if (radSelectDate.Checked)
{
dateAndDateRangeDto.DateTime = datePickerSelectDate.Value.Date;
dateAndDateRangeDto.BranchId = mainForm.UserInformation.BranchId;
SummaryList = mainForm.TransactionRepository.GetTransactionsByDate(dateAndDateRangeDto)
.Select(a => new SummaryDto
{
Id = a.Id,
DateTime = a.DateTime,
PlateNumber = a.PlateNumber,
ServiceType = a.Service.Type,
Expense = a.Service.Expense.Value,
VehicleType = a.Vehicle.Type,
Brand = a.Vehicle.Brand,
Model = a.Vehicle.Model,
Cost = a.Cost
}).ToList();
}
else
{
dateAndDateRangeDto.DateTimeFrom = datePickerDateFromRange.Value.Date;
dateAndDateRangeDto.DateTimeTo = datePickerDateToRange.Value.Date;
dateAndDateRangeDto.BranchId = mainForm.UserInformation.BranchId;
SummaryList = mainForm.TransactionRepository.GetTransactionsByDateRange(dateAndDateRangeDto)
.Select(a => new SummaryDto
{
Id = a.Id,
DateTime = a.DateTime,
PlateNumber = a.PlateNumber,
ServiceType = a.Service.Type,
Expense = a.Service.Expense.Value,
VehicleType = a.Vehicle.Type,
Brand = a.Vehicle.Brand,
Model = a.Vehicle.Model,
Cost = a.Cost
}).ToList();
}
var summaryCrystalReportForm = new SummaryCrystalReportForm(SummaryList);
summaryCrystalReportForm.ShowDialog();
}
private void LoadData()
{
SummaryDateAndDateRangeDto dateAndDateRangeDto = new SummaryDateAndDateRangeDto();
dateAndDateRangeDto.BranchId = mainForm.UserInformation.BranchId;
if (radSelectDate.Checked)
{
dateAndDateRangeDto.DateTime = datePickerSelectDate.Value.Date;
SummaryList = mainForm.TransactionRepository.GetTransactionsByDate(dateAndDateRangeDto)
.Select(a => new SummaryDto
{
Id = a.Id,
DateTime = a.DateTime,
PlateNumber = a.PlateNumber,
ServiceType = a.Service.Type,
Expense = a.Service.Expense.Value,
VehicleType = a.Vehicle.Type,
Brand = a.Vehicle.Brand,
Model = a.Vehicle.Model,
Cost = a.Cost
}).ToList();
}
else if (radSelectDateRange.Checked)
{
dateAndDateRangeDto.DateTimeFrom = datePickerDateFromRange.Value.Date;
dateAndDateRangeDto.DateTimeTo = datePickerDateToRange.Value.Date;
SummaryList = mainForm.TransactionRepository.GetTransactionsByDateRange(dateAndDateRangeDto)
.Select(a => new SummaryDto
{
Id = a.Id,
DateTime = a.DateTime,
PlateNumber = a.PlateNumber,
ServiceType = a.Service.Type,
Expense = a.Service.Expense.Value,
VehicleType = a.Vehicle.Type,
Brand = a.Vehicle.Brand,
Model = a.Vehicle.Model,
Cost = a.Cost
}).ToList();
}
}
