//TARRIFS
public TarrifInfoModel AddTarrif(TarrifInfoModel newTarrif)
{
SqlParameter STAKEHOLDER_ID = new SqlParameter("@STAKEHOLDER_ID", newTarrif.STAKEHOLDER_ID);
SqlParameter TarrifAmount = new SqlParameter("@TarrifAmount", newTarrif.TarrifAmount);
SqlParameter TypeOfHouse = new SqlParameter("@TypeOfHouse", newTarrif.TypeOfHouse);
//SqlParameter Amount_Consumption = new SqlParameter("@AMOUNT_CONSUMPTION_PER_HR", newDevice.AMOUNT_CONSUMPTION_PER_HR);
_context.Database.ExecuteSqlRaw("dbo.Insert_Select_Tarrifs @STAKEHOLDER_ID, @TarrifAmount,@TypeOfHouse",
STAKEHOLDER_ID, TarrifAmount, TypeOfHouse);
return(newTarrif);
}
public TarrifInfoModel UpdateTarrif(TarrifInfoModel UpdateTarrif)
{
SqlParameter Tarrif_Id = new SqlParameter("@Tarrif_Id", UpdateTarrif.Tarrif_Id);
SqlParameter STAKEHOLDER_ID = new SqlParameter("@STAKEHOLDER_ID", UpdateTarrif.STAKEHOLDER_ID);
SqlParameter TarrifAmount = new SqlParameter("@TarrifAmount", UpdateTarrif.TarrifAmount);
SqlParameter TypeOfHouse = new SqlParameter("@TypeOfHouse", UpdateTarrif.TypeOfHouse);
//SqlParameter Amount_Consumption = new SqlParameter("@AMOUNT_CONSUMPTION_PER_HR", UpdateDevice.AMOUNT_CONSUMPTION_PER_HR);
_context.Database.ExecuteSqlRaw("dbo.Update_TarrifDetails @Tarrif_Id,@STAKEHOLDER_ID, @TarrifAmount,@TypeOfHouse",
Tarrif_Id, STAKEHOLDER_ID, TarrifAmount, TypeOfHouse);
return(UpdateTarrif);
}
public IActionResult OnPost()
{
if (ModelState.IsValid == true)
{
if (tarrifInfo.Tarrif_Id > 0)
{
tarrifInfo = _BillingData.UpdateTarrif(tarrifInfo);
}
else
{
tarrifInfo = _BillingData.AddTarrif(tarrifInfo);
}
return(RedirectToPage("/Stackholders/ViewTariff", new { tarrifInfo.Tarrif_Id }));
}
return(Page());
}
public IActionResult OnGet(int?Tarrif_ID)
{
if (Tarrif_ID.HasValue)
{
tarrifInfo = _BillingData.GetTarrifs(Tarrif_ID.Value);
}
else
{
tarrifInfo = new TarrifInfoModel();
}
if (tarrifInfo == null)
{
return(RedirectToPage("/NotFound"));
}
return(Page());
}
