public void UpdatechipRecord(string id, string fieldName, string value, Guid userId) { chip oldTcData = new chip(); var queryTcUpdate = Sql.Builder .Append("UPDATE [ProvisioningRecords].[dbo].[chips]") .Append("SET " + fieldName + "='" + value + "'") .Append("WHERE chipId ='" + id + "'"); var queryTcChangeLogUpdate = Sql.Builder .Append("SELECT * FROM [ProvisioningRecords].[dbo].[chips]") .Append("WHERE chipId ='" + id + "'"); oldTcData = _database.FirstOrDefault<chip>(queryTcChangeLogUpdate); _database.Execute(queryTcUpdate); CreateTcHistoryRecord(id, userId, fieldName, oldTcData.Description, value); }
public chip Getchip(int chipId) { chip chip = new chip(); var query = Sql.Builder .Append("SELECT *") .Append("FROM [ProvisioningRecords].[dbo].[chips]") .Append("WHERE [ProvisioningRecords].[dbo].[chips].[chipId] = '" + chipId + "'"); chip = _database.FirstOrDefault<chip>(query); return chip; }