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); }