public bool DeleteFunding(FundingObject funding)
{
try
{
Config.Conn.Execute("DELETE FROM dat_Funding WHERE FundingId = @FundingId", funding);
}
catch { return(false); }
return(true);
}
public FundingData(FundingObject fo)
{
Year = fo.Year;
FundingTypeId = fo.FundingTypeId;
Org = fo.Org;
ContractNumber = fo.ContractNumber;
Percent = fo.Percent;
DoeFundingCategoryId = fo.DoeFundingCategoryId;
GrantNumber = fo.GrantNumber;
TrackingNumber = fo.TrackingNumber;
SppCategoryId = fo.SppCategoryId;
SppApproved = fo.SppApproved;
FederalAgencyId = fo.FederalAgencyId;
ApproveNoReason = fo.ApproveNoReason;
OtherDescription = fo.OtherDescription;
CountryId = fo.CountryId;
AdditionalInfo = fo.AdditionalInfo;
ProjectArea = fo.ProjectArea;
ProjectNumber = fo.ProjectNumber;
PrincipalInvEmployeeId = fo.PrincipalInvEmployeeId;
MilestoneTrackingNumber = fo.MilestoneTrackingNumber;
}
public FundingObject SaveFunding(FundingObject funding)
{
if (funding.FundingId > 0) // Update
{
string sql = @"
UPDATE dat_Funding
SET Year = @Year,
FundingTypeId = @FundingTypeId,
Org = @Org,
ContractNumber = @ContractNumber,
[Percent] = @Percent,
DoeFundingCategoryId = @DoeFundingCategoryId,
GrantNumber = @GrantNumber,
TrackingNumber = @TrackingNumber,
SppCategoryId = @SppCategoryId,
SppApproved = @SppApproved,
FederalAgencyId = @FederalAgencyId,
ApproveNoReason = @ApproveNoReason,
OtherDescription = @OtherDescription,
CountryId = @CountryId,
AdditionalInfo = @AdditionalInfo,
ProjectArea = @ProjectArea,
ProjectNumber = @ProjectNumber,
PrincipalInvEmployeeId = @PrincipalInvEmployeeId,
MilestoneTrackingNumber = @MilestoneTrackingNumber
WHERE FundingId = @FundingId";
Config.Conn.Execute(sql, funding);
}
else
{
string sql = @"
INSERT INTO dat_Funding (
MainId,
Year,
FundingTypeId,
Org,
ContractNumber,
[Percent],
DoeFundingCategoryId,
GrantNumber,
TrackingNumber,
SppCategoryId,
SppApproved,
FederalAgencyId,
ApproveNoReason,
OtherDescription,
CountryId,
AdditionalInfo,
ProjectArea,
ProjectNumber,
PrincipalInvEmployeeId,
MilestoneTrackingNumber
)
VALUES (
@MainId,
@Year,
@FundingTypeId,
@Org,
@ContractNumber,
@Percent,
@DoeFundingCategoryId,
@GrantNumber,
@TrackingNumber,
@SppCategoryId,
@SppApproved,
@FederalAgencyId,
@ApproveNoReason,
@OtherDescription,
@CountryId,
@AdditionalInfo,
@ProjectArea,
@ProjectNumber,
@PrincipalInvEmployeeId,
@MilestoneTrackingNumber
)
SELECT CAST(SCOPE_IDENTITY() AS INT)";
funding.FundingId = Config.Conn.Query <int>(sql, funding).Single();
}
return(funding);
}