private IEnumerable <ITable> _FetchTables() { var query = $@"SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE FROM [{Name}].[INFORMATION_SCHEMA].[TABLES]"; var result = DatabaseSystem.ExecuteQuery(query); foreach (DataRow row in result.DataSet.Tables[0].Rows) { TableType tableType; switch ((string)row[2]) { case "BASE TABLE": tableType = TableType.Table; break; case "VIEW": tableType = TableType.View; break; default: continue; } yield return(new SqlServerTable(this, (string)row[0], (string)row[1], tableType)); } }
protected void Page_Load(object sender, EventArgs e) { Debug.WriteLine(loaded); if (!IsPostBack) { String productId = null; loaded = true; if (!String.Equals(Request.QueryString["productID"], null)) { productId = Request.QueryString["productID"]; } Product product = DatabaseSystem.GetInstance().GetProductForId(productId); if (product == null) { return; } FillDropDown(); Categories.SelectedValue = product.categoryId; ProductTitle.Value = product.title; ShortDesc.Value = product.shortDescription; LongDesc.Value = product.longDescription; Price.Value = product.price; } }
/// <summary> /// Sqlite local database ( FOR TESTS ) /// </summary> public FinishingSystemContext() { ConnectionStringProp = LocalSqlite; dbSysem = DatabaseSystem.Sqlite; //ConnectionStringProp = LocalSqlServer; //dbSysem = DatabaseSystem.SqlServer; }
public async Task <SystemSucceededTask> CreateSystem(CreateSystemViewModel model, string userName) { if (_configurationTypeRepository.GetById(model.ConfigTypeId) == null) { _logger.ErrorLog("Could not create system " + model.Name, "Create Database System", string.Empty, userName); return(SystemSucceededTask.Failed("Could not create system " + model.Name + "" + ", Please select a configuration", string.Empty, false, true)); } if (_vendorRepository.GetById(model.VendorId) == null) { _logger.ErrorLog("Could not create system " + model.Name, "Create Database System", string.Empty, userName); return(SystemSucceededTask.Failed("Could not create system {model.Name}, Please select a vendor", string.Empty, false, true)); } if (_dataBaseEnvironment.GetById(model.EnvironmentId) == null) { _logger.ErrorLog("Could not create system " + model.Name, "Create Database System", string.Empty, userName); return(SystemSucceededTask.Failed("Could not create system {model.Name}, Please select an rnvironment", string.Empty, false, true)); } try { var dbSysten = new DatabaseSystem() { Name = model.Name, Description = model.Description, Active = model.Active, ConfigurationType = _configurationTypeRepository.GetById(model.ConfigTypeId), Vendor = _vendorRepository.GetById(model.VendorId), DatabaseEnvironment = _dataBaseEnvironment.GetById(model.EnvironmentId) }; _systemRepository.Add(dbSysten); await _systemRepository.SaveChangesAsync(); _logger.InformationLog("Create Database System " + model.Name + " successfully", "Create Database System", string.Empty, userName); return(SystemSucceededTask.Success("Database System " + model.Name + " created succesfully")); } catch (Exception ex) { if (ex.InnerException.Source.Contains("sql")) { _logger.ErrorLog(ex.Message, "Create Database System", ex.InnerException.Message, userName); return(SystemSucceededTask.Failed("Could not create system " + model.Name, ex.InnerException.Message, false, true)); } _logger.ErrorLog(ex.Message, "Create Database System", ex.InnerException.Message, userName); return(SystemSucceededTask.Failed("Could not create system " + model.Name, ex.InnerException.Message, false, true)); } }
public ActionResult ProductView(int id = -1) { if (id == -1) { return(RedirectToAction("Index")); } ViewBag.product = DatabaseSystem.GetInstance().GetProductForId(id); return(View()); }
public ActionResult LogOut() { foreach (Product p in ((User)Session["User"]).cart.contents) { DatabaseSystem.GetInstance().Add(p.ProductID, p.Quantity); } Session["User"] = null; return(RedirectToAction("Index", "Products")); }
private void ContinueHandler() { DatabaseSystem.testFunc(); StartCoroutine(FadeOutCoroutine(MainMenu.GetComponent <S_MainMenu>().ChildCanvasGroup, MainMenu, () => { // Create a lambda for instantiating our equipment menu at the end EquipmentMenu = Instantiate(EquipmentMenuObjectType); GameObject EquipmentChildPanel = EquipmentMenu.transform.GetChild(0).gameObject; Assert.IsNotNull(EquipmentChildPanel); StartCoroutine(FadeInCoroutine(EquipmentChildPanel.GetComponent <CanvasGroup>())); })); }
public TableSystemV2Tests() { var container = new ServiceContainer(); container.Register <ITableSystem, TableSystemV2>(); container.Register <IStoreSystem, InMemoryStoreSystem>(); var system = new DatabaseSystem(container, new Configuration()); system.Start(); database = system.CreateDatabase("testdb", new Configuration(), new IDatabaseFeature[0]); }
public void AddRecentConnectionString(DatabaseSystem system, Database database) { RecentConnectionString connectionString = new RecentConnectionString(system, database); if (!RecentConnectionStrings.Contains(connectionString)) { RecentConnectionStrings.Insert(0, connectionString); const int maxCount = 20; if (RecentConnectionStrings.Count > maxCount) { RecentConnectionStrings.RemoveRange(maxCount, RecentConnectionStrings.Count - maxCount); } } }
public String Remove(int id, int quantity) { Product p = DatabaseSystem.GetInstance().GetProductForId(id); if (!((User)Session["User"]).cart.Remove(id, quantity)) { return("Unable to remove " + p.Title + " from your cart"); } if (!DatabaseSystem.GetInstance().Add(id, quantity)) { return("Unable to remove " + p.Title + " from your cart"); } return("Removed " + quantity + " of " + p.Title + " from your cart"); }
public String Add(int id, int quantity) { if (Object.Equals(Session["User"], null)) { Session["User"] = new User(); } Product p = DatabaseSystem.GetInstance().GetProductForId(id); if (!DatabaseSystem.GetInstance().Remove(id, quantity)) { return("Unable to add " + p.Title + " to your cart"); } ((User)Session["User"]).cart.Add(id, quantity); return("Added " + quantity + " of " + p.Title + " to your cart"); }
private void FillDropDown() { List <Category> categoryList = DatabaseSystem.GetInstance().GetCategories(); foreach (Category category in categoryList) { if (Categories.Items.FindByValue(category.categoryId) != null) { continue; } ListItem item = new ListItem(); item.Text = category.title; item.Value = category.categoryId; Categories.Items.Add(item); } }
private void FillDropDown() { List <Product> products = DatabaseSystem.GetInstance().GetProducts(); foreach (Product category in products) { if (Products.Items.FindByValue(category.categoryId) != null) { continue; } ListItem item = new ListItem(); item.Text = category.title; item.Value = category.productId; Products.Items.Add(item); } }
public ActionResult LogIn(String username, String password) { User u = DatabaseSystem.GetInstance().AuthenticateUser(username, password); if (!Object.Equals(u, null)) { if (!Object.Equals(Session["User"], null)) { u.ImportCart(((User)Session["User"]).cart); } Session["User"] = u; return(RedirectToAction("Index", "Products")); } ViewBag.error = "Username or password is incorrect"; return(View()); }
public async Task SendMessageTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Message message = new Message("unitTest1", "unitTest1", "unitTestMessage"); Activity activity = new Activity(); activity.ActivityId = "99"; activity.ActivityName = "unitTest2"; activity.HomeOwnerId = "unitTest1"; activity.ActivityDate = "2020/02/02"; activity.ActivityNote = "unitTest"; activity.NumberOfPeople = "3"; await databaseSystem.InsertActivity(activity); Assert.IsTrue(await databaseSystem.SendMessage("99", message)); await databaseSystem.Delete("99", "Activity"); }
protected void Page_Load(object sender, EventArgs e) { String productId = Request.QueryString["productID"]; if (!loaded) { loaded = true; //confirm success if (DatabaseSystem.GetInstance().DeleteProduct(productId)) { status.Text = "Product Successfully deleted!"; } else { status.Text = "Unable to remove product!"; } } }
public async Task UpdateActivityTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Dictionary <string, string> testValue = new Dictionary <string, string>(); testValue.Add("ActivityId", "99"); testValue.Add("ActivityName", "unitTest2"); testValue.Add("HomeOwnerId", "unitTest1"); testValue.Add("ActivityDate", "1998/02/11"); testValue.Add("ActivityNote", "unitTest"); testValue.Add("NumberOfPeople", "3"); var result = await databaseSystem.UpdateActivity("99", testValue); await databaseSystem.Delete("99", "Activity"); Assert.IsTrue(result); }
public async Task InsertActivityTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Activity activity = new Activity(); activity.ActivityId = "99"; activity.ActivityName = "unitTest2"; activity.HomeOwnerId = "unitTest1"; activity.ActivityDate = "2020/02/02"; activity.ActivityNote = "unitTest"; activity.NumberOfPeople = "3"; var result = await databaseSystem.InsertActivity(activity); await databaseSystem.Delete("99", "Activity"); Assert.IsTrue(result); }
/// <summary> /// Sqlserver or Sqlite local connections ( FOR TESTS ) /// </summary> /// <param name="system"></param> public HostManagerContext(DatabaseSystem system) { switch (system) { case DatabaseSystem.SqlServer: ConnectionStringProp = LocalSqlServer; break; case DatabaseSystem.Sqlite: ConnectionStringProp = LocalSqlite; break; default: break; } dbSysem = system; }
public ActionResult Register(User user) { User u = DatabaseSystem.GetInstance().GetUserForId(user.Username); if (u != null) { ViewBag.error = "Username already taken"; return(View("Index")); } else if (!DatabaseSystem.GetInstance().RegisterUser(user)) { ViewBag.error = "Unable to save user information to database"; return(View("Index")); } Session["User"] = user; return(RedirectToAction("Index", "Products"));; }
public async Task UpdateMemberInfoTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Member member = new Member(); member.MemberId = "unitTest4"; member.MemberName = "zxczxc"; member.Password = "******"; member.Phone = "0326598741"; member.Birthday = "10/10/1659"; member.Sexuality = "女"; var result = await databaseSystem.UpdateMemberInfo(member); await databaseSystem.Delete("unitTest4", "Member"); Assert.IsTrue(result); }
protected void Upload_Image_Click(object sender, EventArgs e) { String jquery; String message = null; String imageUrl = Server.MapPath("~/" + "images/product_images/" + File_Upload_Image.FileName); String productId = Products.SelectedValue; if (File_Upload_Image.HasFile) { try { File_Upload_Image.SaveAs(imageUrl); //save image info to database here if (DatabaseSystem.GetInstance().UploadImage(productId, imageUrl)) { message = "Successfully uploaded image!"; } } catch (Exception) { message = "Unable to upload image!"; } } else { message = "Unable to upload image!"; } jquery = @"<script> $(function() { bootbox.alert('" + message + @"', function() {}); }); </script>"; Upload_Status.Controls.Add(new LiteralControl(jquery)); }
public async Task InitializationActivityDataTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Activity activity = new Activity(); activity.ActivityId = "99"; activity.ActivityName = "unitTest2"; activity.HomeOwnerId = "unitTest1"; activity.ActivityDate = "2020/02/02"; activity.ActivityNote = "unitTest"; activity.NumberOfPeople = "3"; await databaseSystem.InsertActivity(activity); List <Activity> activityList = await databaseSystem.InitializationActivityData(); await databaseSystem.Delete("99", "Activity"); Assert.IsNotNull(activityList.Find(x => x.ActivityId == "99")); }
protected void Edit_Click(object sender, EventArgs e) { String message; String msgTitle; String productId = Request.QueryString["productID"]; Debug.WriteLine("Cat: " + Categories.SelectedValue + "\nTitle: " + ProductTitle.Value + "\nShort: " + ShortDesc.Value + "\nLong: " + LongDesc.Value + "Price: " + Price.Value); if (DatabaseSystem.GetInstance().UpdateProduct(new Product( productId, Categories.SelectedValue, ProductTitle.Value, ShortDesc.Value, LongDesc.Value, Price.Value))) { message = "Successfully updated product: " + ProductTitle.Value; msgTitle = "Update Successful"; } else { message = "Unable to update the product " + ProductTitle.Value; msgTitle = "Unable to Update Product"; } String jquery = @"<script> $(function() { bootbox.dialog({ message: '" + message + @"', title: '" + msgTitle + @"', buttons: { main: { label: 'OK', callback: function(){ window.location.href = 'DataManagement.aspx'; } } } }); }); </script>"; Viewport_Edit.Controls.Add(new LiteralControl(jquery)); }
protected void Add_Click(object sender, EventArgs e) { String message; String msgTitle; String categoryId = Categories.SelectedValue; String title = ProductTitle.Value; String shortDescription = ShortDesc.Value; String longDescription = LongDesc.Value; String price = Price.Value; if (DatabaseSystem.GetInstance().AddProduct(new Product(categoryId, title, shortDescription, longDescription, price))) { message = "Successfully added new product: " + title; msgTitle = "Product Added"; } else { message = "Unable to add new product: " + title; msgTitle = "Unable To Add Product"; } String jquery = @"<script> $(function() { bootbox.dialog({ message: '" + message + @"', title: '" + msgTitle + @"', buttons: { main: { label: 'OK', callback: function(){ window.location.href = 'DataManagement.aspx'; } } } }); }); </script>"; Viewport_Add.Controls.Add(new LiteralControl(jquery)); }
public async Task InitializationMemberDataTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Member member = new Member(); member.MemberId = "unitTest4"; member.MemberName = "zxczxc"; member.Password = "******"; member.Phone = "0326598741"; member.Birthday = "10/10/1659"; member.Sexuality = "女"; await databaseSystem.UpdateMemberInfo(member); List <Member> memberList = await databaseSystem.InitializationMemberData(); await databaseSystem.Delete("unitTest4", "Member"); Assert.IsNotNull(memberList.Find(x => x.MemberId == "unitTest4")); }
public ActionResult Index(int id = -1) { List <Product> products = DatabaseSystem.GetInstance().GetProductsForCategory(id); List <SelectListItem> catDropDown = new List <SelectListItem>(); catDropDown.Add(new SelectListItem { Value = "-1", Text = "All" }); foreach (Category c in DatabaseSystem.GetInstance().GetCategories()) { catDropDown.Add(new SelectListItem { Value = String.Format("{0}", c.CategoryID), Text = c.Title }); } ViewBag.categories = catDropDown; ViewBag.products = products; return(View()); }
protected void Delete_Category_Click(object sender, EventArgs e) { String jquery; Viewport_Data.Controls.Clear(); if (Categories.SelectedIndex > -1) { String selectedCatID = Categories.SelectedItem.Value; if (DatabaseSystem.GetInstance().DeleteCategory(selectedCatID)) { jquery = @"<script> $(function() { bootbox.alert('Successfully removed category " + Categories.SelectedItem.Text + " !', function() {});});</script>"; Categories.Items.Clear(); FillDropDown(); } else { jquery = @"<script> $(function() { bootbox.alert('Unable to remove category " + Categories.SelectedItem.Text + " !', function() {});});</script>"; } } else { jquery = @"<script> $(function() { bootbox.alert('Error, selected index is < 0 !', function() {});});</script>"; } Viewport_Data.Controls.Add(new LiteralControl(jquery)); }
public async Task UpdateInvitedListTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); Member member = new Member(); member.MemberId = "unitTest4"; member.MemberName = "zxczxc"; member.Password = "******"; member.Phone = "0326598741"; member.Birthday = "10/10/1659"; member.Sexuality = "女"; Dictionary <string, string> newInvitedList = new Dictionary <string, string>(); newInvitedList.Add("1", "asd123"); await databaseSystem.UpdateMemberInfo(member); var result = await databaseSystem.UpdateInvitedList("unitTest4", newInvitedList); await databaseSystem.Delete("unitTest4", "Member"); Assert.IsTrue(result); }
public async Task GetChatDataTest() { DatabaseSystem databaseSystem = new DatabaseSystem(); List <Message> messages = new List <Message>(); Message message = new Message("unitTest1", "unitTest1", "unitTestMessage"); Activity activity = new Activity(); activity.ActivityId = "99"; activity.ActivityName = "unitTest2"; activity.HomeOwnerId = "unitTest1"; activity.ActivityDate = "2020/02/02"; activity.ActivityNote = "unitTest"; activity.NumberOfPeople = "3"; await databaseSystem.InsertActivity(activity); await databaseSystem.SendMessage("99", message); messages = await databaseSystem.GetChatData("99"); await databaseSystem.Delete("99", "Activity"); Assert.AreEqual("unitTest1", messages[0].MemberId); }
public RecentConnectionString(DatabaseSystem system, Database database) { DatabaseSystem = system; ConnectionString = database.ConnectionString; Name = database.Name; }