예제 #1
0
        public int UpdateEmployeeBillingRates(EmployeeBillingRates employeeBillingRates)
        {
            string insertQuery = $@"UPDATE EmployeeBillingRates set 
                                                    UpdatedOn              =           @UpdatedOn,
                                                    UpdatedBy              =           @UpdatedBy,
                                                    IsDeleted              =           @IsDeleted,
                                                    IsActive               =           @IsActive
                                                     where BillingRateGuid =           @BillingRateGuid ";

            return(_context.Connection.Execute(insertQuery, new {
                UpdatedOn = employeeBillingRates.UpdatedOn,
                UpdatedBy = employeeBillingRates.UpdatedBy,
                IsDeleted = employeeBillingRates.IsDeleted,
                IsActive = employeeBillingRates.IsActive,
                BillingRateGuid = employeeBillingRates.BillingRateGuid
            }));
        }
예제 #2
0
        public int AddEmployeeBillingRates(EmployeeBillingRates model)
        {
            string insertQuery = $@"INSERT INTO [dbo].[EmployeeBillingRates]
                                                                   (
                                                                        BillingRateGuid	                ,
                                                                        ContractGuid				    ,
                                                                        UploadFileName					,
                                                                        IsCsv                           ,
                                                                        CreatedOn				        ,
                                                                        UpdatedOn		                ,
                                                                        CreatedBy                       ,
                                                                        UpdatedBy				        ,
                                                                        IsDeleted				        ,
                                                                        IsActive				       
                                                                    )
                                  VALUES (
                                                                        @BillingRateGuid     ,
                                                                        @ContractGuid        ,
                                                                        @UploadFileName      ,
                                                                        @IsCsv               ,
                                                                        @CreatedOn           ,
                                                                        @UpdatedOn           ,
                                                                        @CreatedBy           ,
                                                                        @UpdatedBy           ,
                                                                        @IsDeleted           ,
                                                                        @IsActive               
                                                                )";

            return(_context.Connection.Execute(insertQuery, new {
                BillingRateGuid = model.BillingRateGuid,
                ContractGuid = model.ContractGuid,
                UploadFileName = model.UploadFileName,
                IsCsv = model.IsCsv,
                CreatedOn = model.CreatedOn,
                UpdatedOn = model.UpdatedOn,
                CreatedBy = model.CreatedBy,
                UpdatedBy = model.UpdatedBy,
                IsDeleted = model.IsDeleted,
                IsActive = model.IsActive
            }));
        }
예제 #3
0
 public int UpdateEmployeeBillingRates(EmployeeBillingRates employeeBillingRates)
 {
     return(_employeeBillingRatesRepository.UpdateEmployeeBillingRates(employeeBillingRates));
 }
예제 #4
0
 public int AddEmployeeBillingRates(EmployeeBillingRates employeeBillingRates)
 {
     return(_employeeBillingRatesRepository.AddEmployeeBillingRates(employeeBillingRates));
 }