private string queueInsertString(CustomerQueue t) { string tableName = t.GetType() == typeof(BankingQueue) ? "BankingQueue" : "Normal Queue"; string ans = "INSERT INTO" + tableName + "(QueueOwner, servers, interarrivalTime,serviceTime) OUTPUT INSERTED.ID VALUES("; ans += t.ownerID + "," + t.numServers + "," + t.interarrivalTime + "," + t.serviceTime; ans += ")"; return(ans); }
private string queueUpdateString(CustomerQueue t) { string tableName = t.GetType() == typeof(BankingQueue) ? "BankingQueue" : "Normal Queue"; return("update " + tableName + " SET QueueOwner =" + t.ownerID + ", servers =" + t.numServers + ", interarrivaltime=" + t.interarrivalTime + ", servicetime=" + t.serviceTime + "where id=" + t.id + ";"); }