public void Test_Tournament_Concurrency()
{
var db = new DatabaseInterface();
var t1 = db.GetTournamentById(1);
t1.Title = "Update";
//db.UpdateTournament(t1);
var t2 = db.GetTournamentById(1);
t2.Title = "Me Is Error";
var result = db.UpdateTournament(t2);
Assert.AreEqual(DbError.CONCURRENCY_ERROR, result);
}
// Event så kan ikke returne string
private static void TakeBackTradeOffer(object sender, ElapsedEventArgs e)
{
// Ældste timer er altid på position 0
int id = timersWithId.ElementAt(0).Item2;
//Try get
TradeOffer offer = DatabaseInterface.GetTradeOffer(id);
//If gotten
if (offer != null)
{
AddPlayerResources(offer.SellerResources, player.Name);
}
timersWithId.RemoveAt(0);
}
public static string DeclineTradeOffer(int id)
{
try
{
TradeOffer offer = DatabaseInterface.GetTradeOffer(id);
//DatabaseInterface.UpdatePlayerResource(offer.SellerName, offer.Type, offer.Count);
AddPlayerResources(offer.SellerResources, offer.SellerName);
SendNewMessage(new Message("Trade declined", player.Name, offer.SellerName));
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
/// <summary>
/// Costructor
/// </summary>
/// <param name="data">Database interface</param>
/// <param name="ext">Extension</param>
/// <param name="image">Tree image</param>
public FormDatabaseTree(DatabaseInterface data, string ext, Image image)
: this()
{
this.LoadControlResources();
userControlTree.Set(data, ext, image);
init();
formSearch = new FormSearch();
formSearch.Tree = userControlTree.Tree;
StaticExtensionDataWarehouse.RemoveNode += userControlTree.DeleteNodeTag;
StaticExtensionDataWarehouse.RemoveNode += (INode n) =>
{
formSearch.DeleteTag(n);
};
formSearch.OnRemoveNode += onRemoveNode;
}
public int DeleteProd(int productid)
{
int deletedprod = 0;
DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");
db.Query($"select product.id, product.name from product where product.id = {productid}",
(SqliteDataReader reader) => {
while (reader.Read())
{
deletedprod = reader.GetInt32(0);
}
});
db.Delete($"delete from product where product.id is {productid}");
return(deletedprod);
}
//[DllImport("kernel32.dll", SetLastError = true)]
//[return: MarshalAs(UnmanagedType.Bool)]
//static extern bool AllocConsole();
public static void Main(string[] args)
{
//AllocConsole();
string serverName = "";
string database = "";
string username = "";
string password = "";
Console.Write("Preset: ");
string preset = Console.ReadLine();
if (preset == "vuvm")
{
serverName = "localhost,54001";
database = "lh";
username = "******";
password = "******";
}
else if (preset == "local")
{
serverName = "193.219.91.103,14119";
database = "lh";
username = "******";
password = "******";
}
else
{
Console.Write("Server name:");
serverName = Console.ReadLine();
Console.Write("Database name:");
database = Console.ReadLine();
Console.Write("Username:"******"Password:"******"App closing...");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Convert.ToBoolean(Session["admin"]))
{
return;
}
DatabaseInterface db = new DatabaseInterface(DatabaseInterface.GenerateConnectionString());
if (Page.IsPostBack)
{
db.VoidQuery("insert into [Topic]([Order], [TopicName], [PageContent]) select iif(isnull(max([Order])), 1, max([Order]) + 1), 'New Topic', 'New Topic Page' from [Topic];", new OleDbParameter[0]);
}
topics = db.TableQuery("select [Topic].[TopicID], [TopicName], count([LessonID]) from [Topic] left join [Lesson] on [Topic].[TopicID] = [Lesson].[TopicID] group by [Topic].[TopicID], [Topic].[TopicName], [Topic].[Order] order by [Topic].[Order];", new OleDbParameter[0]);
}
public static void Initialize(DatabaseInterface db)
{
bool customersExist = false;
db.Query($"select id from customer",
(SqliteDataReader reader) => {
while (reader.Read())
{
//reader.Read() will read the result of the query stored in reader
//if there is something to read (something in the db) then set customersExist to true to exit the loop
customersExist = true;
}
//if it did run, it will exit the loop, but customers exist will now be true never executing the if block of code
//if it is immediately false, it will not run the while block, and move on to the if and seed the db
if (customersExist == false)
{
db.BulkInsert($@"
insert into customer values (null, 'Meg Ducharme', 'West Nashville', 'Nashville', 'TN', 37209, '55555555555');
insert into customer values (null, 'Kyle Ducharme', 'West Nashville', 'Nashville', 'TN', 37209, '55555555555');
insert into customer values (null, 'Meg Armstrong', 'West Nashville', 'Nashville', 'TN', 37209, '55555555555');
insert into customer values (null, 'Colleen Ducharme', 'West Nashville', 'Nashville', 'TN', 37209, '55555555555');
insert into product values (null, 'Flowers', 4, 20.50, '2017-08-10 10:55:44.000', 1);
insert into product values (null, 'Chair', 14, 29.99, '2017-08-11 10:55:44.000', 1);
insert into product values (null, 'Cup', 56, 9.99, '2017-08-09 10:55:44.000', 1);
insert into product values (null, 'Purse', 2, 129.99, '2017-08-08 10:55:44.000', 1);
insert into paymenttype values (null, 'Visa', '9826745', 1);
insert into paymenttype values (null, 'MasterCard', '9845745', 2);
insert into paymenttype values (null, 'Chase', '2116745', 1);
insert into paymenttype values (null, 'Visa', '9826745', 3);
insert into [order] values (null, '2017/08/08', '2017-08-11 10:55:44.000', 2, 1);
insert into [order] values (null, '2017/08/08', '2017-08-12 10:55:44.000', 3, 4);
insert into [order] values (null, '2017/07/08', '2017-08-15 10:55:44.000', 3, 4);
insert into [order] values (null, '2017/07/08', '2017-08-14 10:55:44.000', 1, 3);
insert into orderproduct values (null, 1, 3);
insert into orderproduct values (null, 1, 4);
insert into orderproduct values (null, 1, 5);
insert into orderproduct values (null, 2, 3);
");
}
});
}
public ActionResult AddNewRoute(List <int> stopIds, string routeName, int busId, bool startsAtWork, string driverLicense)
{
DatabaseInterface db = new DatabaseInterface();
if (!db.IsRouteNameUnique(routeName))
{
return(Json("false"));
}
int routeId;
if (startsAtWork)
{
routeId = db.GetNextLowRouteId();
}
else
{
routeId = db.GetNextHighRouteId();
}
List <Stop> stops = new List <Stop>();
foreach (int id in stopIds)
{
stops.Add(db.GetStopByStopId(id));
}
List <Route> routes = new List <Route>();
routes = db.GetAvailableRoutes();
db.AssignBusToRoute(busId, routeId);
db.AssignDriverToRoute(driverLicense, routeId);
Route route = new Route()
{
Stops = stops,
Driver = db.GetDriverByDriverLicense(driverLicense),
Name = routeName,
RouteId = routeId,
Id = ObjectId.GenerateNewId(),
Bus = db.GetBusByBusId(busId)
};
db.AddRoute(route);
return(Json(new
{
success = "true",
id = route.Id.ToString()
}));
}
public static string createPlayer(string name)
{
player = new Player(name);
try
{
DatabaseInterface.PutPlayer(name);
}
catch (Exception ex)
{
return(ex.Message);
}
//////////////// Kun for test
DatabaseInterface.UpdatePlayerResource(name, ResourceType.Wood, 2);
DatabaseInterface.UpdatePlayerResource(name, ResourceType.Clay, 1);
////////////////
return(null);
}
public MainWindow()
{
var aggregate = Path.GetInvalidFileNameChars().Aggregate("fdafasfsa/dsa:a", (result, invalidChar) =>
result.Replace(invalidChar, '_'));
InitializeComponent();
_dispatcher = Dispatcher;
if (System.Deployment.Application.ApplicationDeployment.IsNetworkDeployed)
{
Title += " v: " + System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion;
}
_databaseInterface = new DatabaseInterface();
_databaseInterface.Init();
}
/// <summary>
/// Constructor.
/// </summary>
public SvgConverterPage()
{
// Initialize page
InitializeComponent();
this.Loaded += OnPageLoad;
// Initialize data members
mContext = SynchronizationContext.Current;
mDatabase = new DatabaseInterface();
// Initialize database
if (mDatabase.Init())
{
// Load data from database
Load();
}
}
/// <summary>
/// Tests database
/// </summary>
/// <param name="data">Database</param>
/// <param name="ext">Extension</param>
public void TestData(DatabaseInterface data, string ext)
{
IDictionary <object, object> dic = data.GetItems(ext);
foreach (object o in dic.Keys)
{
string e = ext + "";
object id = o;
object ob = dic[o];
if (ob is object[])
{
ob = ((object[])ob)[0];
}
string s = ob + "";
writeHeader(ob);
TestDataItem(data, s, id, ext);
}
}
public List <Product> GetSellers(int customerid)
{
DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");
db.Query($"select product.id, product.name from product where product.customerid = {customerid}",
(SqliteDataReader reader) => {
sellersProducts.Clear();
while (reader.Read())
{
sellersProducts.Add(new Product()
{
id = reader.GetInt32(0),
Name = reader[1].ToString()
});
}
});
return(sellersProducts);
}
public bool?CheckIfProdOnOrder(int productid)
{
bool?ProdOnOrder = null;
DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");
db.Query($"select orderproduct.productId, product.customerId, `order`.paymenttypeid from product join orderproduct on orderproduct.productId = product.id and product.id = {productid} join `order` where orderproduct.orderId is `order`.id;",
(SqliteDataReader reader) => {
if (reader.HasRows)
{
ProdOnOrder = true;
}
else
{
ProdOnOrder = false;
}
});
return(ProdOnOrder);
}
public ActionResult ModifyBus(int busId)
{
DatabaseInterface db = new DatabaseInterface();
Bus bus = db.GetBusByBusId(busId);
AddBusModel model = new AddBusModel
{
StateNames = stateNames,
StateAbbreviations = stateAbbreviations,
Capacity = bus.Capacity.ToString(),
License = bus.LicensePlate,
UpdatingBus = true,
Status = bus.Status.ToString(),
State = bus.State,
BusId = busId.ToString()
};
return(PartialView("AddBus", model));
}
public ActionResult AddRoute()
{
DatabaseInterface db = new DatabaseInterface();
AddRouteModel model = new AddRouteModel()
{
AvailableBuses = db.GetAvailableBuses(),
AvailableStops = db.GetAvailableStops(),
AvailableDrivers = db.GetAvailableDrivers(),
Bus = null,
Driver = null,
Name = "",
RouteId = "",
Stops = { },
UpdatingRoute = false
};
return(PartialView("AddRoute", model));
}
private bool ChangeDatabaseInterface(IDbConfig config, string databaseName)
{
if (!controller.DatabaseExists(config, databaseName))
{
return(false);
}
DatabaseInterface dbi;
if (!dbInterfaces.TryGetValue(databaseName, out dbi))
{
dbi = new DatabaseInterface(controller, databaseName, hostString);
dbInterfaces[databaseName] = dbi;
}
Database = controller.GetDatabase(databaseName);
dbInterface = dbi;
return(true);
}
/// <summary>
/// 得到行计数数据
/// </summary>
/// <param name="TableName"></param>
/// <param name="ColumnName"></param>
/// <param name="CountNumber"></param>
/// <returns></returns>
public static Object GetSpeciaRecord(String TableName, String ColumnName, Boolean CountNumber)
{
//sql生成
SelectDBCommandBuilder sql = new SelectDBCommandBuilder();
sql.AddSelectTable(TableName);
sql.AddSelectColumn(ColumnName);
sql.SelectCount = true;
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
Object result = database.GetSpeciaRecordValue(sql.BuildCommand(), DatabaseInit.WaitTimeout);
database.Close();
return(result);
}
public static string AcceptTradeOffer(int id)
{
try {
TradeOffer offer = DatabaseInterface.GetTradeOffer(id);
//SubtractResource(offer.PriceType, offer.Price); - skal måske ikke bruges
//DatabaseInterface.UpdatePlayerResource(offer.SellerName, offer.PriceType, offer.Price);
AddPlayerResources(offer.ReceiverResources, offer.SellerName);
//DatabaseInterface.UpdatePlayerResource(player.Name, offer.PriceType, -offer.Price);
SubtractPlayerResources(offer.ReceiverResources, player.Name);
//DatabaseInterface.UpdatePlayerResource(player.Name, offer.Type, offer.Count);
AddPlayerResources(offer.SellerResources, player.Name);
SendNewMessage(new Message("Trade accepted", player.Name, offer.SellerName));
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
/// <summary>
/// 得到表中所有数据
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static DataTable GetAllDataTable(String TableName)
{
//sql生成
SelectDBCommandBuilder sql = new SelectDBCommandBuilder();
sql.AddSelectTable(TableName);
sql.AddSelectALLColumn();
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
DataSet ds = database.GetDataSet(sql.BuildCommand(), DatabaseInit.WaitTimeout);
database.Close();
return(ds.Tables[0]);
}
/// <summary>
/// 插入表中新数据
/// </summary>
/// <param name="TableName"></param>
/// <param name="ColumnName"></param>
/// <param name="Value"></param>
/// <returns></returns>
public static int InsertNewDataToTable(String TableName, Object[] Value)
{
//sql生成
InsertDBCommandBuilder sql = new InsertDBCommandBuilder();
sql.TableName = TableName;
sql.AddInsertColumn(Value);
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
int result = database.ExecueCommand(sql.BuildCommand(), DatabaseInit.WaitTimeout);
database.Close();
return(result);
}
/// <summary>
/// 得到指定条件的一个数据
/// </summary>
/// <param name="TableName"></param>
/// <param name="ColumnName"></param>
/// <param name="KeyColumnName"></param>
/// <param name="KeyValue"></param>
/// <returns></returns>
public static Object GetSpeciaRecord(String TableName, String ColumnName, String KeyColumnName, Object KeyValue)
{
//sql生成
SelectDBCommandBuilder sql = new SelectDBCommandBuilder();
sql.AddSelectTable(TableName);
sql.AddSelectColumn(ColumnName);
sql.AddWhere(WhereRelation.None, KeyColumnName, DatabaseMaster.CommandComparison.Equals, KeyValue);
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
Object result = database.GetSpeciaRecordValue(sql.BuildCommand(), DatabaseInit.WaitTimeout);
database.Close();
return(result);
}
public ActionResult ModifyRoute(String routeId)
{
DatabaseInterface db = new DatabaseInterface();
Route route = db.GetRouteByRouteId(int.Parse(routeId));
AddRouteModel model = new AddRouteModel()
{
AvailableBuses = db.GetAvailableBuses(),
AvailableStops = db.GetAvailableStops(),
AvailableDrivers = db.GetAvailableDrivers(),
Bus = route.Bus,
Driver = route.Driver,
Name = route.Name,
RouteId = routeId,
Stops = route.Stops,
UpdatingRoute = true
};
return(PartialView("AddRoute", model));
}
public void Add_User()
{
var db = new DatabaseInterface();
var user = new UserModel()
{
FirstName = "Ryan",
LastName = "Kelton",
Username = Guid.NewGuid().ToString(),
Password = "******",
SitePermission = new PermissionModel()
{
Permission = Permission.SITE_STANDARD
}
};
var result = db.AddUser(user);
Assert.AreEqual(DbError.SUCCESS, result);
}
public ActionResult AddNewStop(string location)
{
DatabaseInterface db = new DatabaseInterface();
if (!db.IsStopLocationUnique(location))
{
return(Json("false"));
}
Stop stop = new Stop()
{
Id = ObjectId.GenerateNewId(),
Location = location,
StopId = db.GetNextStopId()
};
db.SaveStop(stop);
return(Json("true"));
}
/// <summary>
/// 检查存储过程中是否存在指定内容
/// </summary>
/// <param name="ProcedureCommand"></param>
/// <param name="parameterin"></param>
/// <returns></returns>
public static Boolean CheckSpecifiedValueExist(String ProcedureCommand, ParameterClass[] parameterin)
{
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
Int32 count = Convert.ToInt32(database.GetSpeciaRecordValue(ProcedureCommand, parameterin, DatabaseInit.WaitTimeout));
database.Close();
if (count == 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 更新表中新数据
/// </summary>
/// <param name="TableName"></param>
/// <param name="ColumnName"></param>
/// <param name="Value"></param>
/// <returns></returns>
public static int UpdateNewDataToTable(String TableName, String[] ColumnName, Object[] Value, String KeyColumnName, Object KeyValue)
{
//sql生成
UpdateDBCommandBuilder sql = new UpdateDBCommandBuilder();
sql.TableName = TableName;
sql.AddUpdateColumn(ColumnName, Value);
sql.AddWhere(WhereRelation.None, KeyColumnName, DatabaseMaster.CommandComparison.Equals, KeyValue);
//数据库连接
DatabaseInterface database = DBFactory.CreateDatabase(DatabaseInit.DefaultDatabase, DatabaseInit.ConnectName, DatabaseInit.EncryptType);
database.Open();
int result = database.ExecueCommand(sql.BuildCommand(), DatabaseInit.WaitTimeout);
database.Close();
return(result);
}
public ActionResult ViewBus(string id)
{
DatabaseInterface db = new DatabaseInterface();
Bus bus = db.GetBusById(new ObjectId(id));
if (bus == null)
{
return(Json(new { error = "true" }));
}
return(PartialView("ViewBusView", new ViewBusModel()
{
LicensePlate = bus.LicensePlate,
State = bus.State,
Capacity = bus.Capacity,
Status = bus.Status == BusStatus.Active ? "Active" : "Inactive",
BusId = bus.BusId,
RouteName = bus.AssignedTo == -1 ? "" : db.GetRouteByRouteId(bus.AssignedTo).Name
}));
}
/// <summary>
/// Tests database item
/// </summary>
/// <param name="data">Data</param>
/// <param name="name">Item name</param>
/// <param name="id">Item id</param>
/// <param name="ext">Extension</param>
public void TestDataItem(DatabaseInterface data, string name, object id, string ext)
{
byte[] buffer = data.GetData(id + "", ref ext);
bool b = TestBuffer(buffer);
if (!b)
{
TestException te = new TestException(name, id, current);
current = null;
write(te);
le.Clear();
if (stopAtFirst)
{
return;
}
}
buffer = null;
GC.Collect();
}
//
// GET: /test/
public ActionResult Index()
{
DatabaseInterface DB = new DatabaseInterface();
DB.GetEntities().AddToUsers(new User() {
Mail = "*****@*****.**",
Password = "******",
Username = "******",
CreatedAt = DateTime.Now
});
DB.GetEntities().SaveChanges();
DB.GetEntities().AddToArticles(new Article() {
Title = "Owned Gauthier!",
Content = "This is an article",
CreatedAt = DateTime.Now,
Published = true,
AllowComments = true,
Highlight = true,
Slug = "owned-gauthier-",
User = (from e in DB.GetEntities().Users select e).FirstOrDefault()
});
DB.GetEntities().SaveChanges();
ViewBag.Articles = DB.GetHighlightedArticles();
return View();
}
/// <summary>
/// Start a controller
/// </summary>
/// <param name="InitiateDatabase"></param>
public BaseController(bool InitiateDatabase)
{
if (InitiateDatabase)
_database = new DatabaseInterface();
}
public PHP_CRUD_API(HttpContext context, Config config)
{
_context = context;
// defaults
if (config.DbEngine == null) {
config.DbEngine = "MySQL";
}
if (config.Method == null) {
config.Method = context.Request.HttpMethod;
}
if (config.Request == null) {
config.Request = context.Request.PathInfo;
if (config.Request == "") {
config.Request = context.Request.Path;
}
}
if (config.Get == null) {
config.Get = context.Request.QueryString;
}
if (config.Post == null) {
config.Post = context.Request.InputStream;
}
// connect
String request = config.Request.Trim ('/');
if (config.Database == null) {
config.Database = ParseRequestParameter(ref request, "a-zA-Z0-9\\-_");
}
if (config.Db == null) {
config.Db = (DatabaseInterface)Activator.CreateInstance (Type.GetType ("DataApiDotNet_Complex."+config.DbEngine),context);
if (config.Charset == null) {
config.Charset = config.Db.GetDefaultCharset();
}
config.Db.Connect(config.Hostname,config.Username,config.Password,config.Database,config.Port,config.Socket,config.Charset);
}
_db = config.Db;
_settings = new Settings{
Method = config.Method,
Request = request,
Get = config.Get,
Post = config.Post,
Database = config.Database,
TableAuthorizer = config.TableAuthorizer,
ColumnAuthorizer = config.ColumnAuthorizer,
InputSanitizer = config.InputSanitizer,
InputValidator = config.InputValidator
};
}
public static void setDatabase(DatabaseInterface toSet)
{
Database = toSet;
}
