public int Edit(ProjectModificationModel projectModificationModel)
{
string updateQuery = @"Update ProjectModification set
ProjectGuid = @ProjectGuid ,
ModificationNumber = @ModificationNumber ,
EnteredDate = @EnteredDate ,
EffectiveDate = @EffectiveDate ,
AwardAmount = @AwardAmount ,
POPStart = @POPStart ,
POPEnd = @POPEnd ,
Description = @Description ,
UploadedFileName = @UploadedFileName ,
ModificationTitle = @ModificationTitle ,
IsAwardAmount = @IsAwardAmount ,
IsFundingAmount = @IsFundingAmount ,
IsPop = @IsPop ,
FundingAmount = @FundingAmount ,
UpdatedOn = @UpdatedOn ,
UpdatedBy = @UpdatedBy ,
IsActive = @IsActive ,
IsDeleted = @IsDeleted
where ProjectModificationGuid = @ProjectModificationGuid";
return(_context.Connection.Execute(updateQuery, projectModificationModel));
}
public int Add(ProjectModificationModel projectModificationModel)
{
string insertQuery = @"INSERT INTO [dbo].[ProjectModification]
(
ProjectModificationGuid ,
ProjectGuid ,
ModificationNumber ,
EnteredDate ,
EffectiveDate ,
AwardAmount ,
POPStart ,
POPEnd ,
Description ,
UploadedFileName ,
ModificationTitle ,
IsAwardAmount ,
IsFundingAmount ,
IsPop ,
FundingAmount ,
CreatedOn ,
UpdatedOn ,
CreatedBy ,
UpdatedBy ,
IsActive ,
IsDeleted
)
VALUES (
@projectModificationGuid ,
@projectGuid ,
@ModificationNumber ,
@EnteredDate ,
@EffectiveDate ,
@AwardAmount ,
@POPStart ,
@POPEnd ,
@Description ,
@UploadedFileName ,
@ModificationTitle ,
@IsAwardAmount ,
@IsFundingAmount ,
@IsPop ,
@FundingAmount ,
@CreatedOn ,
@UpdatedOn ,
@CreatedBy ,
@UpdatedBy ,
@IsActive ,
@IsDeleted
)";
return(_context.Connection.Execute(insertQuery, projectModificationModel));
}
public int Edit(ProjectModificationModel projectModificationModel)
{
return(_iProjectModificationRepository.Edit(projectModificationModel));
}
public int Add(ProjectModificationModel projectModificationModel)
{
return(_iProjectModificationRepository.Add(projectModificationModel));
}