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