public bool AddRequestedSeatsToTimeslot(SeatsProcessRequest request)
{
var requestTable = new DataTable("TimeslotSeatRequest");
requestTable.Columns.Add("Row", typeof(int));
requestTable.Columns.Add("Seat", typeof(int));
requestTable.Columns.Add("Status", typeof(int));
foreach (var seatRequest in request.SeatsRequest.AddedSeats)
{
requestTable.Rows.Add(seatRequest.Row, seatRequest.Seat, request.SelectedStatus);
}
SqlParameter requestTableparameter = new SqlParameter
{
ParameterName = "@seatsRequest",
SqlDbType = SqlDbType.Structured,
Value = requestTable
};
var parameters = new[]
{
requestTableparameter,
new SqlParameter("@TimeslotId", request.TimeslotId)
};
return(DatabaseUtil.ExecuteNonQuery("AddRequestedSeatsToTimeslot", parameters) != 0);
}
void WriteValue(string key, KeyValue value)
{
string colName = null;
if (value.IntValue.HasValue)
{
colName = "IntValue";
}
else if (value.DoubleValue.HasValue)
{
colName = "DoubleValue";
}
else if (value.BoolValue != null)
{
colName = "BoolValue";
}
else if (value.StringValue != null)
{
colName = "StringValue";
}
else
{
Debug.Fail("No value in KeyValue");
}
var queryParams = CreateQueryParams(key, "@Value", value.Value);
var cmdText = string.Format(
"UPDATE KeyValueStore SET {0} = @Value WHERE ExtensionId = @ExtensionId AND [Key] = @Key",
colName);
if (DatabaseUtil.ExecuteNonQuery(cmdText, queryParams) == 1)
{
return;
}
cmdText = string.Format(
"INSERT INTO KeyValueStore (ExtensionId, [Key], {0}) VALUES (@ExtensionId, @Key, @Value)",
colName);
DatabaseUtil.ExecuteNonQuery(cmdText, queryParams);
}
public void RemoveValue(string key)
{
DatabaseUtil.ExecuteNonQuery(
"DELETE FROM KeyValueStore WHERE ExtensionId = @ExtensionId AND [Key] = @Key",
CreateQueryParams(key));
}