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
}));
}
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
}));
}
public int UpdateEmployeeBillingRates(EmployeeBillingRates employeeBillingRates)
{
return(_employeeBillingRatesRepository.UpdateEmployeeBillingRates(employeeBillingRates));
}
public int AddEmployeeBillingRates(EmployeeBillingRates employeeBillingRates)
{
return(_employeeBillingRatesRepository.AddEmployeeBillingRates(employeeBillingRates));
}