public int UpdateContractWBS(ContractWBS contractWBS)
{
string insertQuery = $@"UPDATE ContractWBS set
UpdatedOn = @UpdatedOn,
UpdatedBy = @UpdatedBy,
IsDeleted = @IsDeleted,
IsActive = @IsActive
where ContractWBSGuid = @ContractWBSGuid ";
return(_context.Connection.Execute(insertQuery, new {
UpdatedOn = contractWBS.UpdatedOn,
UpdatedBy = contractWBS.UpdatedBy,
IsDeleted = contractWBS.IsDeleted,
IsActive = contractWBS.IsActive,
ContractWBSGuid = contractWBS.ContractWBSGuid
}));
}
public int AddContractWBS(ContractWBS model)
{
string insertQuery = $@"INSERT INTO ContractWBS (
ContractWBSGuid,
ContractGuid,
UploadFileName,
IsCsv,
CreatedOn,
UpdatedOn,
CreatedBy,
UpdatedBy,
IsDeleted,
IsActive
)
VALUES (
@ContractWBSGuid,
@ContractGuid,
@UploadFileName,
@IsCsv,
@CreatedOn,
@UpdatedOn,
@CreatedBy,
@UpdatedBy,
@IsDeleted,
@IsActive
)";
return(_context.Connection.Execute(insertQuery, new {
ContractWBSGuid = model.ContractWBSGuid,
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 UpdateContractWBS(ContractWBS ContractWBS)
{
return(_iProjectRepository.UpdateContractWBS(ContractWBS));
}
//ContractWBS
public int AddContractWBS(ContractWBS ContractWBS)
{
return(_iProjectRepository.AddContractWBS(ContractWBS));
}
public int UpdateContractWBS(ContractWBS ContractWBS)
{
return(_contractWBSRepository.UpdateContractWBS(ContractWBS));
}
public int AddContractWBS(ContractWBS ContractWBS)
{
return(_contractWBSRepository.AddContractWBS(ContractWBS));
}
