/// <summary>
/// Deletes the budget chapter.
/// </summary>
/// <param name="fixedAssetHousingReport">The budget chapter.</param>
/// <returns>System.String.</returns>
public string DeleteFixedAssetHousingReport(FixedAssetHousingReportEntity fixedAssetHousingReport)
{
const string sql = @"uspDelete_FixedAssetHousingReport";
object[] parms = { "@FixedAssetHousingReportID", fixedAssetHousingReport.FixedAssetHousingReportId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified budget chapter.
/// </summary>
/// <param name="fixedAssetHousingReport">The budget chapter.</param>
/// <returns>System.Object[][].</returns>
private object[] Take(FixedAssetHousingReportEntity fixedAssetHousingReport)
{
return(new object[]
{
"@FixedAssetHousingReportID", fixedAssetHousingReport.FixedAssetHousingReportId,
"@AreaOfBuilding", fixedAssetHousingReport.AreaOfBuilding,
"@WorkingArea", fixedAssetHousingReport.WorkingArea,
"@HousingArea", fixedAssetHousingReport.HousingArea,
"@GuestHouseArea", fixedAssetHousingReport.GuestHouseArea,
"@OccupiedArea", fixedAssetHousingReport.OccupiedArea,
"@OtherArea", fixedAssetHousingReport.OtherArea,
"@AccountingValue", fixedAssetHousingReport.AccountingValue,
"@Attachments", fixedAssetHousingReport.Attachments
});
}
/// <summary>
/// Updates the budget chapter.
/// </summary>
/// <param name="fixedAssetHousingReport">The budget chapter.</param>
/// <returns>System.String.</returns>
public string UpdateFixedAssetHousingReport(FixedAssetHousingReportEntity fixedAssetHousingReport)
{
const string sql = "uspUpdate_FixedAssetHousingReport";
return(Db.Update(sql, true, Take(fixedAssetHousingReport)));
}
/// <summary>
/// Inserts the budget chapter.
/// </summary>
/// <param name="fixedAssetHousingReport">The budget chapter.</param>
/// <returns>System.Int32.</returns>
public int InsertFixedAssetHousingReport(FixedAssetHousingReportEntity fixedAssetHousingReport)
{
const string sql = "uspInsert_FixedAssetHousingReport";
return(Db.Insert(sql, true, Take(fixedAssetHousingReport)));
}
