public void AddOrder(InternetOrder order) { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); string sql = "INSERT INTO Order (ClientId, Completed, IpAddress) Values (@ClientId, @Completed, @IpAddress);"; cnn.Execute(sql, new { ClientId = order.ClientId, Completed = 0, IpAddress = order.IpAddress }); SQLiteCommand Command = new SQLiteCommand("select last_insert_rowid()", cnn); Int64 LastRowID64 = (Int64)Command.ExecuteScalar(); int orderId = (int)LastRowID64; sql = "INSERT INTO OrderObject (Amount, ObjectId, OrderId) Values (@Amount, @ObjectId, @OrderId);"; foreach (var orderObj in order.Objects) { cnn.Execute(sql, new { Amount = orderObj.Amount, ObjectId = orderObj.ObjectId, OrderId = orderId }); } } }
public List <Order> GetAllOrders() { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } var orders = new List <Order>(); using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); var ordersWithoutProducts = cnn.Query <Order>("SELECT * FROM PlaceOrder").ToList(); foreach (Order order in ordersWithoutProducts) { order.Objects = cnn.Query <OrderObject>("SELECT * FROM OrderObject WHERE OrderId = @OrderId", new { OrderId = order.Id }) .ToList(); orders.Add(order); } } return(orders); }
public void AddObject(Object obj) { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); string sql = "INSERT INTO Object (Description, Price, InStock) Values (@Description, @Price, @InStock);"; cnn.Execute(sql, obj); } }
public void AddClient(Client client) { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); string sql = "INSERT INTO Client (Name, Address) Values (@Name, @Address);"; cnn.Execute(sql, client); } }
public List <Object> GetAllObjects() { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } var objects = new List <Object>(); using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); objects = cnn.Query <Object>("SELECT * FROM Object").ToList(); } return(objects); }
public void AddInternetClient(InternetClient InternetClient) { if (!File.Exists(BaseRepo.DbFIle)) { BaseRepo.CreateDatabase(); } using (var cnn = BaseRepo.DbConnection()) { cnn.Open(); string sql = "INSERT INTO Client (Name, Address) Values (@Name, @Address);"; cnn.Execute(sql, InternetClient); SQLiteCommand Command = new SQLiteCommand("select last_insert_rowid()", cnn); Int64 LastRowID64 = (Int64)Command.ExecuteScalar(); int id = (int)LastRowID64; sql = "INSERT INTO InternetClient (ClientId, IpAddress) Values (@ClientId, @IpAddress)"; cnn.Execute(sql, new { ClientId = id, IpAddress = InternetClient.IpAddress, }); } }
public static void Main(string[] args) { BaseRepo.CreateDatabase(); PrepareBasicData(); new UserInterface().Start(); }