private void PassData2dgvDeail()
{
var cons = consumptionService.GetConsumptions().ToList();
var getById = from cus in cons where cus.MeterID == id select cus;
dgvDetail.AutoGenerateColumns = false;
dgvDetail.DataSource = getById.ToList();
}
public ActionResult <List <Consumption> > Get(string category)
{
string loggedUser = User.FindFirstValue("userId");
if (loggedUser == null)
{
return(Unauthorized());
}
List <Consumption> consumptions = consumptionService.GetConsumptions(category);
return(consumptions);
}
public void LoadData()
{
IEnumerable <ConsumptionModel> Consumptions = consumptionService.GetConsumptions().Select(c => new ConsumptionModel
{
ID = c.ID,
Month = c.Month,
Year = c.Year,
CurrentReading = c.CurrentReading,
PreviousReading = c.PreviousReading,
MeterKey = c.Meter.MeterKey,
MeterID = c.Meter.ID,
CustomerName = c.Meter.Customer.CustomerName,
ConsumptionEnergy = c.ConsumptionEnergy,
UnitPrice = c.UnitPrice
});
dgvConsumption.AutoGenerateColumns = false;
dgvConsumption.DataSource = Consumptions.ToList();
month = dtp.Value.Month;
year = dtp.Value.Year;
//txtUnitPrice.Text = (1000).ToString();
txtUnitPrice.Text = string.Format("{0:0,0}", 1000);
}
private void btnLoad_Click(object sender, EventArgs e)
{
IEnumerable <ConsumptionModel> Consumptions = consumptionService.GetConsumptions().Select(c => new ConsumptionModel
{
ID = c.ID,
Month = c.Month,
Year = c.Year,
CurrentReading = c.CurrentReading,
PreviousReading = c.PreviousReading,
MeterKey = c.Meter.MeterKey,
MeterID = c.Meter.ID,
CustomerName = c.Meter.Customer.CustomerName,
ConsumptionEnergy = c.ConsumptionEnergy,
UnitPrice = c.UnitPrice,
Date = c.Date
});
/*
* var result = from con in Consumptions
* where con.Month >= Convert.ToInt16(dtpFromDate.Value.Month)
* && con.Month <= Convert.ToInt16(dtpToDate.Value.Month)
* && con.Year >= Convert.ToInt16(dtpFromDate.Value.Year)
* && con.Year <= Convert.ToInt16(dtpToDate.Value.Year)
* select con;
*/
//string fromDate = dtpFromDate.Value.Year.ToString() + "-" + dtpFromDate.Value.Month.ToString() + "-" + dtpFromDate.Value.Day.ToString();
var fromDate = new DateTime(dtpFromDate.Value.Year, dtpFromDate.Value.Month, dtpFromDate.Value.Day);
//string toDate = dtpToDate.Value.Year.ToString() + "-" + dtpToDate.Value.Month.ToString() + "-" + dtpToDate.Value.Day.ToString();
var toDate = new DateTime(dtpToDate.Value.Year, dtpToDate.Value.Month, dtpToDate.Value.Day);
var result = from con in Consumptions
where con.Date >= fromDate && con.Date <= toDate
select con;
ConsumptionModelBindingSource.DataSource = result.ToList();
//ConsumptionModelBindingSource.DataSource = Consumptions.ToList();
//Convert.ToDateTime(fromDate) && con.Date <= Convert.ToDateTime(toDate)
this.rpReceipt.RefreshReport();
}
public ActionResult GetConsumptions(DateTime?startDate = null, DateTime?endDate = null, Int32 typeId = 0)
{
List <ConsumptionDto> consumptions = _consumptionService.GetConsumptions(UserId, startDate, endDate, typeId);
return(Ok(consumptions));
}