Exemplo n.º 1
0
        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));
        }
Exemplo n.º 2
0
        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));
        }
Exemplo n.º 3
0
 public int Edit(ProjectModificationModel projectModificationModel)
 {
     return(_iProjectModificationRepository.Edit(projectModificationModel));
 }
Exemplo n.º 4
0
 public int Add(ProjectModificationModel projectModificationModel)
 {
     return(_iProjectModificationRepository.Add(projectModificationModel));
 }