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