public int CheckDuplicateFarClauseNumber(FarClause farClause)
{
string sql = $"SELECT Count(1) FROM FarClause WHERE Number = @Number and FarClauseGuid != @FarClauseGuid ";
var result = _context.Connection.QuerySingle <int>(sql, new { Number = farClause.Number, FarClauseGuid = farClause.FarClauseGuid });
return(result);
}
public void Edit(FarClause farClause)
{
string updateQuery = $@"Update FarClause set
Number = @Number ,
Title = @Title ,
Paragraph = @Paragraph ,
UpdatedBy = @UpdatedBy
where FarClauseGuid = @FarClauseGuid ";
_context.Connection.Execute(updateQuery, farClause);
}
public void Add(FarClause farClause)
{
string insertQuery = $@"INSERT INTO [dbo].[FarClause]
(
FarClauseGuid,
Number ,
Title ,
Paragraph ,
UpdatedBy ,
IsDeleted
)
VALUES (
@FarClauseGuid ,
@Number ,
@Title ,
@Paragraph ,
@UpdatedBy ,
@IsDeleted
)";
_context.Connection.Execute(insertQuery, farClause);
}
public void Edit(FarClause farClause)
{
_farClauseRepository.Edit(farClause);
}
public int CheckDuplicateFarClauseNumber(FarClause farClause)
{
return(_farClauseRepository.CheckDuplicateFarClauseNumber(farClause));
}
public void Add(FarClause farClause)
{
_farClauseRepository.Add(farClause);
}
