public BillingsInfoModel Add(BillingsInfoModel newDevice)
{
SqlParameter Subscriber_ID = new SqlParameter("@Subscriber_ID", newDevice.SUBSCRIBER_ID);
SqlParameter STAKEHOLDER_ID = new SqlParameter("@STAKEHOLDER_ID", newDevice.STAKEHOLDER_ID);
SqlParameter Usage_Duration = new SqlParameter("@USAGE_DURATION", newDevice.USAGE_DURATION);
SqlParameter Monthly_Duration = new SqlParameter("@MONTHLY_DURATION_PER_HR", newDevice.MONTHLY_DURATION_PER_HR);
SqlParameter Amount_Consumption = new SqlParameter("@AMOUNT_CONSUMPTION_PER_HR", newDevice.AMOUNT_CONSUMPTION_PER_HR);
_context.Database.ExecuteSqlRaw("dbo.Insert_Select_AllBillings @Subscriber_ID,@STAKEHOLDER_ID, @USAGE_DURATION,@MONTHLY_DURATION_PER_HR,@AMOUNT_CONSUMPTION_PER_HR",
Subscriber_ID, STAKEHOLDER_ID, Usage_Duration, Monthly_Duration, Amount_Consumption);
return(newDevice);
}
public BillingsInfoModel Delete(int id)
{
SqlParameter Device_IDs = new SqlParameter("@BillingsId", id);
BillingsInfoModel DeleteBilling = _context.billingsInfos
.FromSqlRaw <BillingsInfoModel>("dbo.GetBillings_ById @BillingsId", Device_IDs)
.ToList().FirstOrDefault();
if (DeleteBilling != null)
{
_context.Database.ExecuteSqlRaw("dbo.Delete_Billings @BillingsId", Device_IDs);
}
return(DeleteBilling);
}
public BillingsInfoModel Update(BillingsInfoModel UpdateDevice)
{
SqlParameter Billings_Id = new SqlParameter("@Billings_Id", UpdateDevice.Billings_Id);
SqlParameter Device_Id = new SqlParameter("@DEviceId", UpdateDevice.DEviceId);
SqlParameter Subscriber_ID = new SqlParameter("@Subscriber_ID", UpdateDevice.SUBSCRIBER_ID);
SqlParameter STAKEHOLDER_ID = new SqlParameter("@STAKEHOLDER_ID", UpdateDevice.STAKEHOLDER_ID);
SqlParameter Usage_Duration = new SqlParameter("@USAGE_DURATION", UpdateDevice.USAGE_DURATION);
SqlParameter Monthly_Duration = new SqlParameter("@MONTHLY_DURATION_PER_HR", UpdateDevice.MONTHLY_DURATION_PER_HR);
SqlParameter Amount_Consumption = new SqlParameter("@AMOUNT_CONSUMPTION_PER_HR", UpdateDevice.AMOUNT_CONSUMPTION_PER_HR);
_context.Database.ExecuteSqlRaw("dbo.Update_Billings @Billings_Id,@DEviceId,@Subscriber_ID,@STAKEHOLDER_ID, @USAGE_DURATION,@MONTHLY_DURATION_PER_HR,@AMOUNT_CONSUMPTION_PER_HR",
Billings_Id, Device_Id, Subscriber_ID, STAKEHOLDER_ID, Usage_Duration, Monthly_Duration,
Amount_Consumption);
//var deviceInfo = _context.deviceInfos.Attach(UpdateDevice);
//UpdateDevice.Transaction_Date = DateTime.UtcNow;
//deviceInfo.State = EntityState.Modified;
//_context.SaveChanges();
return(UpdateDevice);
}
public IEnumerable <BillingsInfoModel> CountDevices(BillingsInfoModel device)
{
throw new NotImplementedException();
}
