public int UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates)
{
string insertQuery = $@"UPDATE LaborCategoryRates set
UpdatedOn = @UpdatedOn ,
UpdatedBy = @UpdatedBy ,
IsDeleted = @IsDeleted ,
IsActive = @IsActive
where CategoryRateGuid = @CategoryRateGuid ";
return(_context.Connection.Execute(insertQuery, new {
UpdatedOn = laborCategoryRates.UpdatedOn,
UpdatedBy = laborCategoryRates.UpdatedBy,
IsDeleted = laborCategoryRates.IsDeleted,
IsActive = laborCategoryRates.IsActive,
CategoryRateGuid = laborCategoryRates.CategoryRateGuid
}));
}
public int AddLaborCategoryRates(LaborCategoryRates model)
{
string insertQuery = $@"INSERT INTO [dbo].[LaborCategoryRates]
(
CategoryRateGuid ,
ContractGuid ,
UploadFileName ,
IsCsv ,
CreatedOn ,
UpdatedOn ,
CreatedBy ,
UpdatedBy ,
IsDeleted ,
IsActive
)
VALUES (
@CategoryRateGuid ,
@ContractGuid ,
@UploadFileName ,
@IsCsv ,
@CreatedOn ,
@UpdatedOn ,
@CreatedBy ,
@UpdatedBy ,
@IsDeleted ,
@IsActive
)";
return(_context.Connection.Execute(insertQuery, new {
CategoryRateGuid = model.CategoryRateGuid,
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 UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates)
{
return(_iProjectRepository.UpdateLaborCategoryRates(laborCategoryRates));
}
//LaborCategoryRates
public int AddLaborCategoryRates(LaborCategoryRates laborCategoryRates)
{
return(_iProjectRepository.AddLaborCategoryRates(laborCategoryRates));
}
public int UpdateLaborCategoryRates(LaborCategoryRates laborCategoryRates)
{
return(_subcontractorBillingRatesRepository.UpdateLaborCategoryRates(laborCategoryRates));
}
