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(); }