public void Progress(float a_deltaTime)
{
if (!this.IsSpawned())
{
return;
}
DatabaseItem itemFromPos = this.m_inventory.GetItemFromPos(0f, 0f);
ItemDef itemDef = Items.GetItemDef(itemFromPos.type);
bool flag = itemDef.buildingIndex > 0;
if (!this.IsDead())
{
this.UpdateConditions(a_deltaTime);
this.CalculateEnergyHealthKarma(a_deltaTime);
if (this.m_attackBtnPressed)
{
if (this.m_server.IsInSpecialArea(this.GetPosition(), eAreaType.noPvp) || (flag && !Buildings.IsHarmless(itemDef.buildingIndex) && this.m_server.IsInSpecialArea(this.GetPosition(), eAreaType.noBuilding)))
{
if (Time.time > this.m_nextForbiddenEventTime)
{
this.m_server.SendSpecialEvent(this, eSpecialEvent.forbidden);
this.m_nextForbiddenEventTime = Time.time + 1f;
}
}
else if (null == this.m_vehicle)
{
this.TryAttack(itemFromPos.type, itemDef);
}
}
this.HandleRotation();
DatabaseItem itemFromPos2 = this.m_inventory.GetItemFromPos(0f, 3f);
ItemDef itemDef2 = Items.GetItemDef(itemFromPos2.type);
float num = (!Items.IsShoes(itemFromPos2.type)) ? 0f : itemDef2.healing;
num -= ((!this.HasCondition(eCondition.pain)) ? 0f : 0.2f);
this.m_char.AddSpeed(num);
if (Items.IsShoes(itemFromPos2.type) && this.m_isMoving && null == this.m_vehicle)
{
this.DamageItem(0f, 3f);
}
}
this.m_char.m_isWalking = (this.IsAttacking() || itemDef.buildingIndex > 0);
if (this.m_respawnTime > 0f && Time.time > this.m_respawnTime)
{
this.Respawn();
this.m_respawnTime = -1f;
}
for (int i = 0; i < this.m_killXp.Count; i++)
{
bool flag2 = Time.time > this.m_killXp[i].deletetime;
if ((null != this.m_killXp[i].npc && this.m_killXp[i].npc.GetHealth() == 0f) || (this.m_killXp[i].player != null && this.m_killXp[i].player.IsDead()) || flag2)
{
if (!flag2)
{
this.AddXp((int)this.m_killXp[i].xp);
}
this.m_killXp.RemoveAt(i);
break;
}
}
}
public virtual IHttpActionResult Get()
{
log.TraceFormat("Get::{0:S} requested", typeof(T).Name);
if (Attribute.GetCustomAttributes(this.GetType(), typeof(Attributes.GetAllSupportedAttribute), false) == null)
{
return(ResponseMessage(new System.Net.Http.HttpResponseMessage(System.Net.HttpStatusCode.NotImplemented)));
}
try
{
using (SqlConnection conn = new SqlConnection(Startup.ConnectionString))
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
var r = DatabaseItem <K> .GetAll <T>(conn, trans);
trans.Commit();
log.TraceFormat("{0:S} Get returning {1:N0} items.", typeof(T).FullName, r.Count);
return(Ok(r));
}
}
}
catch (Core.Exceptions.TSQLNotFoundException)
{
return(BadRequest(string.Format("Get not supported by {0:S}", typeof(T).FullName)));
}
}
private void PickupThings()
{
if (Time.time > this.m_nextPickupTime)
{
this.m_nextPickupTime = Time.time + UnityEngine.Random.Range(10f, 30f);
Vector3 vector = Vector3.zero;
DatabaseItem randomFreeWorldItem = new DatabaseItem(0, 0f, 0f, 1, false, 0, 0);
if (this.m_pickupThings)
{
this.m_server.PickupItem(null, this.m_brain);
randomFreeWorldItem = this.m_server.GetRandomFreeWorldItem();
if (randomFreeWorldItem.type != 0 && 600f < Time.time - randomFreeWorldItem.dropTime)
{
vector = new Vector3(randomFreeWorldItem.x, 0f, randomFreeWorldItem.y);
if (this.m_server.IsInSpecialArea(vector, eAreaType.noPvp))
{
vector = Vector3.zero;
}
}
}
if (Vector3.zero == vector)
{
vector = base.transform.position + new Vector3(UnityEngine.Random.Range(-100f, 100f), 0f, UnityEngine.Random.Range(-100f, 100f));
}
this.m_body.GoTo(vector);
}
}
protected override void Update()
{
if (this.m_isOnFire)
{
float time = Time.time;
this.m_decayTime -= (double)(Time.deltaTime * 9f);
if (time > this.m_nextCookTime)
{
List <DatabaseItem> freeWorldItems = this.m_server.GetFreeWorldItems();
for (int i = 0; i < freeWorldItems.Count; i++)
{
if (Items.IsCookable(freeWorldItems[i].type) && time > freeWorldItems[i].dropTime + 3f)
{
float sqrMagnitude = (base.transform.position - freeWorldItems[i].GetPos()).sqrMagnitude;
if (sqrMagnitude < 3f)
{
DatabaseItem value = freeWorldItems[i];
value.type++;
freeWorldItems[i] = value;
}
}
}
this.m_nextCookTime = Time.time + 4f;
}
}
base.Update();
}
private static void UpdateItem(
DatabaseItem item, string icon)
{
var info = (DatabaseInfo)item.Info;
if (info.HasPassword)
{
item.PasswordIcon = ThemeData
.GetImageSource("unlock");
}
else
{
item.PasswordIcon = null;
}
if (!string.IsNullOrEmpty(icon))
{
item.UpdatedIcon = ThemeData
.GetImageSource(icon);
}
else
{
item.UpdatedIcon = null;
}
}
/// <summary>
/// The global secondary index can only query one column in table. When the requirement
/// for additional filtering exist, this will reduce the database item based on
/// additional filters.
/// </summary>
/// <param name="item">one item with all collumn attributes retrieved from dynamoDB</param>
/// <param name="word">filter produces null if this item does not meet filter requirements.</param>
/// <returns></returns>
private bool FilterWord(DatabaseItem item, out string word)
{
AttributeValue wordVal = new AttributeValue();
if (this.filter != null)
{
item.TryGetValue("VowelType", out AttributeValue vowelType);
item.TryGetValue("Vowel", out AttributeValue vowel);
item.TryGetValue("Syllables", out AttributeValue syllables);
item.TryGetValue("FirstLetter", out AttributeValue firstLetter);
if (WordMatches(vowel.S, vowelType.S, syllables.S, firstLetter.S))
{
item.TryGetValue("Word", out wordVal);
word = wordVal.S;
return(true);
}
else
{
word = null;
return(false);
}
}
else
{
item.TryGetValue("Word", out wordVal);
word = wordVal.S;
return(true);
}
}
private float HandleDamage(float a_healthDif)
{
float num = a_healthDif;
if (num < -2f)
{
m_cantLogoutTime = Time.time + 20f;
DatabaseItem itemFromPos = m_inventory.GetItemFromPos(0f, 2f);
if (Items.IsBody(itemFromPos.type))
{
ItemDef itemDef = Items.GetItemDef(itemFromPos.type);
num *= itemDef.healing;
DamageItem(0f, 2f);
}
if (Mathf.Abs(num) > Random.Range(0f, 140f))
{
switch (Random.Range(0, 3))
{
case 0:
SetCondition(eCondition.bleeding, true);
break;
case 1:
SetCondition(eCondition.infection, true);
break;
case 2:
SetCondition(eCondition.pain, true);
break;
}
}
}
return(num);
}
private bool FindFreeInventorySlot(ref float a_x, ref float a_y)
{
if (HasFreeSlots())
{
for (int i = 0; i < m_maxY; i++)
{
for (int j = m_xOffset; j < m_maxX + m_xOffset; j++)
{
bool flag = false;
for (int k = 0; k < m_items.Count; k++)
{
int num = j;
DatabaseItem databaseItem = m_items[k];
if (num == (int)(databaseItem.x + 0.5f))
{
int num2 = i;
DatabaseItem databaseItem2 = m_items[k];
if (num2 == (int)(databaseItem2.y + 0.5f))
{
flag = true;
break;
}
}
}
if (!flag)
{
a_x = j;
a_y = i;
return(true);
}
}
}
}
return(false);
}
protected override void Update()
{
if (m_isOnFire)
{
float time = Time.time;
m_decayTime -= Time.deltaTime * 9f;
if (time > m_nextCookTime)
{
List <DatabaseItem> freeWorldItems = m_server.GetFreeWorldItems();
for (int i = 0; i < freeWorldItems.Count; i++)
{
DatabaseItem databaseItem = freeWorldItems[i];
if (!Items.IsCookable(databaseItem.type))
{
continue;
}
DatabaseItem databaseItem2 = freeWorldItems[i];
if (time > databaseItem2.dropTime + 3f)
{
float sqrMagnitude = (base.transform.position - freeWorldItems[i].GetPos()).sqrMagnitude;
if (sqrMagnitude < 3f)
{
DatabaseItem value = freeWorldItems[i];
value.type++;
freeWorldItems[i] = value;
}
}
}
m_nextCookTime = Time.time + 4f;
}
}
base.Update();
}
public int DeclineItemAmountByType(int a_type, int a_amount)
{
if (1 > a_amount)
{
return(0);
}
int num = a_amount;
if (IsPlayerMoney(a_type))
{
num = Mathf.Max(a_amount - m_player.m_gold, 0);
m_player.m_gold = Mathf.Max(m_player.m_gold - a_amount, 0);
}
else
{
for (int i = 0; i < m_items.Count; i++)
{
DatabaseItem databaseItem = m_items[i];
if (a_type == databaseItem.type)
{
num = DeclineItemAmount(i, num);
if (0 >= num)
{
break;
}
i--;
}
}
}
return(num);
}
private bool CollectAndStackItem(DatabaseItem a_itemToCollect, int a_invIndex)
{
if (a_invIndex >= 0 && a_invIndex < m_items.Count)
{
int type = a_itemToCollect.type;
DatabaseItem databaseItem = m_items[a_invIndex];
if (type == databaseItem.type)
{
int amount = a_itemToCollect.amount;
DatabaseItem databaseItem2 = m_items[a_invIndex];
if (amount + databaseItem2.amount <= 254)
{
DatabaseItem value = m_items[a_invIndex];
value.amount += a_itemToCollect.amount;
m_items[a_invIndex] = value;
if (null != m_sql)
{
SQLChange(m_items[a_invIndex], eDbAction.update);
}
return(true);
}
}
}
return(false);
}
public void SplitItem(Vector3 a_itemPos)
{
int itemIndexFromPos = GetItemIndexFromPos(a_itemPos.x, a_itemPos.z);
if (itemIndexFromPos <= -1)
{
return;
}
DatabaseItem databaseItem = m_items[itemIndexFromPos];
if (Items.IsStackable(databaseItem.type))
{
DatabaseItem databaseItem2 = m_items[itemIndexFromPos];
if (1 < databaseItem2.amount && HasFreeSlots())
{
DatabaseItem databaseItem3 = m_items[itemIndexFromPos];
DatabaseItem a_item = m_items[itemIndexFromPos];
DatabaseItem databaseItem4 = m_items[itemIndexFromPos];
databaseItem3.amount = databaseItem4.amount / 2;
m_items[itemIndexFromPos] = databaseItem3;
SQLChange(databaseItem3, eDbAction.update);
a_item.amount = a_item.amount / 2 + a_item.amount % 2;
CollectItem(a_item, false);
}
}
}
private void PickupNearestFood()
{
if (Time.time > this.m_nextPickupTime || (this.m_targetItemPos - base.transform.position).sqrMagnitude < 1.4f)
{
this.m_nextPickupTime = Time.time + UnityEngine.Random.Range(5f, 15f);
DatabaseItem databaseItem = this.m_server.PickupItem(null, this.m_brain);
Vector3 vector = Vector3.zero;
if (databaseItem.dropPlayerId > 0)
{
ServerPlayer playerByPid = this.m_server.GetPlayerByPid(databaseItem.dropPlayerId);
if (playerByPid != null && (playerByPid.GetPosition() - base.transform.position).sqrMagnitude < 64f)
{
this.m_masterPlayer = playerByPid;
vector = this.m_masterPlayer.GetPosition();
}
}
if (Vector3.zero == vector)
{
DatabaseItem nearestItem = this.m_server.GetNearestItem(base.transform.position, true);
this.m_targetItemPos = new Vector3(nearestItem.x, 0f, nearestItem.y);
if (nearestItem.type == 0 || (this.m_targetItemPos - base.transform.position).sqrMagnitude > 40000f)
{
vector = base.transform.position + new Vector3(UnityEngine.Random.Range(-100f, 100f), 0f, UnityEngine.Random.Range(-100f, 100f));
}
else
{
vector = this.m_targetItemPos;
}
}
this.m_body.GoTo(vector);
}
}
public DatabaseItem GetItemSQL(string SQL, string keyword, string table)
{
DatabaseItem result = new DatabaseItem();
using (SqlConnection conn = new SqlConnection(Connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@input", keyword);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DatabaseItem item = new DatabaseItem();
item.ID = Convert.ToInt32(reader[table + "id"]);
item.Name = Convert.ToString(reader[table + "name"]);
try
{
item.Description = Convert.ToString(reader[table + "description"]);
item.Website = Convert.ToString(reader[table + "website"]);
item.CategoryName = Convert.ToString(reader["categoryname"]);
item.CategoryDescription = Convert.ToString(reader["categorydescription"]);
item.Weight = Convert.ToInt32(reader[table + "weight"]);
result = item;
return(result);
}
catch (Exception e)
{
}
result = item;
}
}
return(result);
}
/// <summary>
/// +1 to Occultist
/// Or similar
/// </summary>
/// <param name="result"></param>
/// <param name="item"></param>
public static void GetSpecialMasteryStats(List <DatabaseItemStat> result, DatabaseItem item,
IEnumerable <DatabaseItem> items)
{
var stats = item.Stats;
// Special case for "+1 to occultist" etc, since its a combination of 2 stats
for (int i = 1; i <= 4; i++)
{
bool hasLevel = stats.Any(m => m.Stat.Equals("augmentMasteryLevel" + i));
bool hasClass = stats.Any(m => m.Stat.Equals("augmentMasteryName" + i));
if (hasLevel && hasClass)
{
float amount = stats.Where(m => m.Stat.Equals("augmentMasteryLevel" + i)).FirstOrDefault().Value;
string profession = stats.Where(m => m.Stat.Equals("augmentMasteryName" + i)).FirstOrDefault()
.TextValue;
var professionTag = ExtractClassFromRecord(profession, items);
result.Add(new DatabaseItemStat {
Parent = item,
Stat = "augmentMastery" + i,
Value = amount,
TextValue = professionTag
});
}
else
{
break;
}
}
}
public void SaveItem(DatabaseItem a_item)
{
lock (m_threadLock)
{
m_itemsToWrite.Add(a_item);
}
}
internal void AddItem(string key, string value)
{
DatabaseItem item = new DatabaseItem(key, value);
item.Changed += DBItem_Changed;
RawBZDBVariables.Add(key, item);
}
private void SQLRevealItems(Vector3[] a_hiPos)
{
float num = 0.5f;
for (int i = 0; i < a_hiPos.Length; i++)
{
Vector3 vector = a_hiPos[i];
List <DatabaseItem> list = new List <DatabaseItem>();
using (IDbTransaction dbTransaction = m_sqlConnection.BeginTransaction())
{
m_sqlCommand.CommandText = "SELECT type, x, y, amount, iid FROM item WHERE hidden=1 AND cid=0 AND x>" + (vector.x - num) + " AND x<" + (vector.x + num) + " AND y>" + (vector.z - num) + " AND y<" + (vector.z + num) + ";";
using (IDataReader dataReader = m_sqlCommand.ExecuteReader())
{
while (dataReader.Read())
{
DatabaseItem item = new DatabaseItem(dataReader.GetInt32(0), dataReader.GetFloat(1), dataReader.GetFloat(2), dataReader.GetInt32(3));
lock (m_threadLock)
{
m_itemAnswers.Add(item);
}
item.flag = eDbAction.delete;
item.iid = dataReader.GetInt32(4);
list.Add(item);
}
dataReader.Close();
}
dbTransaction.Commit();
}
if (list.Count > 0)
{
SQLChangeItems(list.ToArray());
}
}
}
/// <summary>
/// Maps the provided database to a hierarchical ViewModel structure with a DatabaseItem as its root.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <returns></returns>
public DatabaseItem MapSchemaToViewModel(string databasePath)
{
logger.Info("Trying to load database file at " + databasePath);
this.databasePath = databasePath;
dbHandler = new DatabaseHandler(databasePath);
TableFolderItem tableFolder = MapTables();
ViewFolderItem viewFolder = MapViews();
IndexFolderItem indexFolder = MapIndexes();
TriggerFolderItem triggerFolder = MapTriggers();
var databaseItem = new DatabaseItem()
{
DisplayName = Path.GetFileNameWithoutExtension(databasePath),
DatabasePath = databasePath
};
databaseItem.Items.Add(tableFolder);
databaseItem.Items.Add(viewFolder);
databaseItem.Items.Add(indexFolder);
databaseItem.Items.Add(triggerFolder);
logger.Info("Loaded database " + databaseItem.DisplayName + ".");
return(databaseItem);
}
public List <DatabaseItem> GetTop5WeightedTopics()
{
List <DatabaseItem> top5Topics = new List <DatabaseItem>();
try
{
using (SqlConnection conn = new SqlConnection(Connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand(getTop5WeightedTopicsSQL, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DatabaseItem item = new DatabaseItem();
item.Name = Convert.ToString(reader["name"]);
item.Weight = Convert.ToInt32(reader["weight"]);
top5Topics.Add(item);
}
}
}
catch (Exception e)
{
}
return(top5Topics);
}
private void UpdateConditions(float a_deltaTime)
{
bool flag = a_deltaTime > Random.Range(0f, 150f);
if (HasCondition(eCondition.bleeding) && flag)
{
SetCondition(eCondition.bleeding, false);
flag = false;
}
if (HasCondition(eCondition.infection) && flag)
{
SetCondition(eCondition.infection, false);
flag = false;
}
if (HasCondition(eCondition.pain) && flag)
{
SetCondition(eCondition.pain, false);
flag = false;
}
SetCondition(eCondition.starvation, m_energy < 0.01f);
if (Time.time > m_nextComplexConditionUpdate && m_inventory != null)
{
Vector3 position = GetPosition();
DatabaseItem itemFromPos = m_inventory.GetItemFromPos(0f, 2f);
bool a_state = 0.1f > m_server.GetDayLight() && !Items.IsBody(itemFromPos.type) && !m_server.IsInSpecialArea(position, eAreaType.warm) && !m_buildMan.IsNearCampfire(position);
SetCondition(eCondition.freezing, a_state);
SetCondition(eCondition.radiation, m_server.IsInSpecialArea(position, eAreaType.radiation));
m_nextComplexConditionUpdate = Time.time + 3f;
}
if (m_lastCondition != m_condition)
{
m_lastCondition = m_condition;
m_server.SendConditionUpdate(this);
}
}
private void AddRandomItem()
{
int num = 0;
num = ((m_type == eShopType.eFood) ? Items.GetRandomFood() : ((m_type == eShopType.eRareAmmo) ? Random.Range(40, 45) : ((m_type == eShopType.ePharmacy) ? Random.Range(140, 143) : ((m_type != eShopType.eResources) ? ((Random.Range(0, 8) != 0) ? Items.GetRandomType(90f) : 92) : Random.Range(130, 134)))));
DatabaseItem a_item = new DatabaseItem(num);
if (Items.HasAmountOrCondition(a_item.type))
{
a_item.amount = ((!Items.HasCondition(a_item.type)) ? Random.Range(1, 10) : Random.Range(10, 100));
if (Items.HasCondition(a_item.type))
{
a_item.amount = Random.Range(20, 100);
}
else if (Items.IsMedicine(a_item.type))
{
a_item.amount = 1;
}
else if (Items.IsResource(a_item.type))
{
a_item.amount = Random.Range(10, 50);
}
else if (Items.IsEatable(a_item.type))
{
a_item.amount = Random.Range(1, 5);
}
else
{
a_item.amount = Random.Range(1, 10);
}
}
m_container.CollectItem(a_item, false);
}
public List <DatabaseItem> CompanyInformation()
{
List <DatabaseItem> companies = new List <DatabaseItem>();
using (SqlConnection conn = new SqlConnection(Connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand(companySql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DatabaseItem company = new DatabaseItem();
company.ID = Convert.ToInt32(reader["id"]);
company.CategoryId = Convert.ToInt32(reader["categoryID"]);
company.Name = Convert.ToString(reader["name"]);
company.Description = Convert.ToString(reader["description"]);
company.Location = Convert.ToString(reader["location"]);
company.NumberOfEmployees = Convert.ToString(reader["number_of_employees"]);
company.NumberOfGrads = Convert.ToInt32(reader["number_of_grads"]);
company.NamesOfGrads = Convert.ToString(reader["names_of_grads"]);
company.Rating = Convert.ToDecimal(reader["glassdoor_rating"]);
company.Website = Convert.ToString(reader["website"]);
company.CategoryName = Convert.ToString(reader["categoryname"]);
companies.Add(company);
}
return(companies);
}
}
/// Accessor for a specific entry in the database
/// @param primaryKey the key used to lookup the entry in the database
protected async Task <DatabaseItem> GetEntryByKey(int primaryKey)
{
var getRequest = new GetItemRequest
{
TableName = tableName,
Key = new Dictionary <string, AttributeValue>
{
{ primaryPartitionKey, new AttributeValue {
N = primaryKey.ToString()
} }
}
};
DatabaseItem item = new DatabaseItem();
try
{
var response = await client.GetItemAsync(getRequest);
if (response.IsItemSet)
{
item = response.Item;
}
}
catch (Exception e)
{
log.WARN("DatabaseClient", "GetEntryByKey(int)", "EXCEPTION: " + e.Message);
}
return(item);
}
public void Setup()
{
LookupItem = new TableItem
{
DisplayName = "Name",
DatabasePath = "Database1"
};
LookupItemParent = new IndexFolderItem
{
DisplayName = "Name",
DatabasePath = "Database1",
Items = new ObservableCollection <TreeItem> {
LookupItem
}
};
LookupItemDatabase = new DatabaseItem
{
DisplayName = "Name",
DatabasePath = "Database1",
Items = new ObservableCollection <TreeItem> {
LookupItemParent
}
};
ComparisonItem = new TableItem
{
DisplayName = "Name",
DatabasePath = "Database2"
};
ComparisonItemParent = new IndexFolderItem
{
DisplayName = "Name",
DatabasePath = "Database2",
Items = new ObservableCollection <TreeItem> {
ComparisonItem
}
};
treeSaveHelperMock = new Mock <ITreeSaveHelper>();
viewModel = new MainWindowViewModel(treeSaveHelperMock.Object)
{
TreeViewItems = new ObservableCollection <TreeItem>
{
LookupItemDatabase,
new DatabaseItem
{
DisplayName = "Name",
DatabasePath = "Database2",
Items = new ObservableCollection <TreeItem>
{
ComparisonItemParent
}
}
}
};
}
/// <summary>
/// Retrieves user profile data from DynamoDB 'user-profile'
/// </summary>
public async Task GetUserProfileData()
{
DatabaseItem items = await GetEntryByKey(this.UserID);
if (items.TryGetValue(SCHEDULE_KEY, out AttributeValue dbSchedule))
{
if (items.TryGetValue(TEACH_MODE_KEY, out AttributeValue tM))
{
this.teachMode = (MODE)Enum.Parse(typeof(MODE), tM.S);
}
else
{
this.teachMode = MODE.Assess;
}
this.Schedule = int.Parse(dbSchedule.N);
await this.scopeAndSequenceDB.GetSessionDataWithNumber(this.Schedule);
log.INFO("UserProfileDB", "GetUserSchedule", "User profile exist, start the user at: " + this.Schedule);
}
else
{
await CreateNewUser();
log.INFO("UserProfileDB", "GetUserSchedule", "User profile does not exist, start the user at: " + this.Schedule);
}
this.lesson = LessonFactory.GetLesson(this.scopeAndSequenceDB.Lesson);
}
public virtual IHttpActionResult GetSecondary <SECONDARY>(SECONDARY id, int size)
{
log.TraceFormat("GetSecondary<{0:S}::{1:S}({2:S}) requested", typeof(T).Name, typeof(SECONDARY).Name, id.ToString());
try
{
T t = default(T);
using (SqlConnection conn = new SqlConnection(Startup.ConnectionString))
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
t = DatabaseItem <K> .GetBySecondary <T, SECONDARY>(conn, trans, id, size);
trans.Commit();
}
}
if (t != null)
{
return(Ok(t));
}
else
{
return(NotFound());
}
}
catch (Core.Exceptions.TSQLNotFoundException ex)
{
return(BadRequest(string.Format("Get secondary not supported by {0:S} ({1:S})", this.GetType().FullName, ex.ToString())));
}
}
public static void Select(DatabaseItem treeItem)
{
Selection.SetActiveObjectWithContext(
Create(treeItem),
null
);
}
/// <summary>
/// Regenerates the identity of this item.
/// </summary>
internal void RegenerateIdentity()
{
DatabaseItem item = (DatabaseItem)target;
EditorUtility.SetDirty(target);
string[] itemsGuiDs = AssetDatabase.FindAssets($"t:{nameof(DatabaseItem)}");
DatabaseItem[] loadedItems = new DatabaseItem[itemsGuiDs.Length];
for (var index = 0; index < itemsGuiDs.Length; index++)
{
loadedItems[index] = (DatabaseItem)AssetDatabase.LoadAssetAtPath(AssetDatabase.GUIDToAssetPath(itemsGuiDs[index]), typeof(DatabaseItem));
}
int identity = 0;
bool any = true;
while (any)
{
identity = GetRandomInt();
any = loadedItems.Any(p => p != null && p.Identity == identity);
}
item.Identity = identity;
AssetDatabase.Refresh();
AssetDatabase.SaveAssets();
}
public List <DatabaseItem> AllRequests()
{
List <DatabaseItem> RequestLists = new List <DatabaseItem>();
string checkRecord = "SELECT * FROM requests;";
using (SqlConnection conn = new SqlConnection(Connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand(checkRecord, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DatabaseItem item = new DatabaseItem();
item.ID = Convert.ToInt32(reader["id"]);
item.Name = Convert.ToString(reader["name"]);
item.CategoryName = "requests";
RequestLists.Add(item);
}
return(RequestLists);
}
}
