/// <summary> /// 删除 /// </summary> private void DeleteFromDatabase() { if (PolyLine.ObjectId != new ObjectId()) { DataBaseTools.TryRemove(PolyLine); } }
private void ReadAllRecords() { ObservableCollection <Models.Benefit> bens = new ObservableCollection <Models.Benefit>(); bens = DataBaseTools.ReturnAllRecords <Models.Benefit>("Benefit", "SavingObjectsToDatabase.Models.Benefit"); lv1.Items.Add(bens[0].Name.ToString()); }
protected void submitAccount(object sender, EventArgs e) { string _account = UserAccount.Value; string _name = UserName.Value; string _pass = password.Value; string _confirPass = comfirnPassword.Value; string _birthday = birthday.Value; string _sex = Request.Form["sexual"].ToString(); List <String> UserInfo = new List <string>(); UserInfo.Add(""); UserInfo.Add(_account); UserInfo.Add(_name); UserInfo.Add(_birthday); UserInfo.Add(_sex); UserInfo.Add(_pass); if (_pass != _confirPass) { Response.Write("<script>alert('请确认两次密码一致')</script>"); return; } else { int lifluCount = DataBaseTools.Insert("User", UserInfo); if (lifluCount == 1) { Session["UserAccount"] = _account; Response.Redirect("userIndex.aspx"); } if (lifluCount == -1) { Response.Write("<script>alert('用户名已存在')</script>"); } } }
/// <summary> /// Call this function to Initialize the MySql objects or apply new settings /// </summary> public static void Init() { string connString = DataBaseTools.GenerateConnectionString(DBIP, DBUser, DBPass); conn = new MySqlConnection(connString); cmd = new MySqlCommand("", conn); }
protected void Page_Load(object sender, EventArgs e) { _userAccount = Session["UserAccount"].ToString(); _UserInfoDictionary = DataBaseTools.getInfoByAccount(_userAccount); UserNameInNav = _UserInfoDictionary["UserName"]; }
/// <summary> /// 添加顶点 /// </summary> private void AddPoint() { PolyLine.AddOrSetVertexAt(PolyLine.NumberOfVertices, new Point2d(TemPoint2d.X, TemPoint2d.Y), 0, 0, 0); if (NumberOfVertices == 1 && PolyLine.ObjectId == new ObjectId()) { PolyLine.AddToModelSpace(DataBaseTools.DocumentDatabase()); } }
public IActionResult AddToCart() { var item = new ShoppingItem(DataBaseTools.GetSpecifiedProduct(2), 1); Models.ShoppingCart.addToShoppingCart(item, this.HttpContext); return(Redirect("Index")); }
protected void Page_Load(object sender, EventArgs e) { _UserAccount = Session["UserAccount"].ToString(); _UserInfoDictionary = DataBaseTools.getInfoByAccount(_UserAccount); setInfoToForm(_UserInfoDictionary); }
public EuroleagueInformationLoader( DataBaseTools dataBaseTools, TeamRepository teamRepository, DayRepository dayRepository) { _dataBaseTools = dataBaseTools; _teamRepository = teamRepository; _dayRepository = dayRepository; }
public IActionResult AddProduct(AddProductVM viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } DataBaseTools.AddProduct(viewModel); return(RedirectToAction("Index", "Home")); }
private void Writedb() { DataBaseTools.FieldListBuilder <Models.Benefit>(bnf, "Benefit"); DataBaseTools.FieldListBuilder <Models.FoodItem>(fi, "FoodItem"); DataBaseTools.FieldListBuilder <Models.Meal>(ml, "Meal"); TBResults.Text = DataBaseTools.CreateDatabase(); DataBaseTools.WriteRecord(); }
private void deleteBTN_Click(object sender, System.Windows.RoutedEventArgs e) { int bookID = (int)gridControl.GetFocusedRowCellValue("ID"); object o = System.Windows.Forms.MessageBox.Show("Delete Book " + bookID + "?", "Info", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question); if ("Yes" == o.ToString()) { DataBaseTools.DeleteBook(bookID); } }
/// <summary> /// Call this function to Initialize the MySql objects or apply new settings /// </summary> public void Init() { string connString = DataBaseTools.GenerateConnectionString(DBIP, DBUser, DBPass); conn = new MySqlConnection(connString); cmd = new MySqlCommand() { Connection = conn }; adapter = new MySqlDataAdapter(); }
public static Polyline DrawArc() { var ed = DataBaseTools.DocumentEditor(); var jig = new ArcJig(); do { ed.Drag(jig); var res = (PromptPointResult)ed.Drag(jig); if (res.Status == PromptStatus.OK) { jig.AddPoint(); } } while (jig.Points.Count < 3); return(jig.Arc); }
protected void loginManager(object sender, EventArgs e) { _userAccount = Request.Form["input_userAccount"]; _passWord = Request.Form["input_password"]; login_result = DataBaseTools.LoginForManager(_userAccount, _passWord); if (login_result == 1) { Response.Redirect("managerUser.aspx"); } else { Response.Write("<script>alert('账户密码错误')</script>"); } }
protected void submitToServer(object sender, EventArgs e) { if (Request.Form["ConfirmPassWord"].ToString() == Request.Form["PassWord"].ToString()) { _UserInfoDictionary = null; _UserInfoDictionary = new Dictionary <string, string>(); _UserInfoDictionary.Add("UserAccount", _UserAccount); _UserInfoDictionary.Add("UserName", Name.Value); _UserInfoDictionary.Add("UserPassWord", Request.Form["ConfirmPassWord"].ToString()); _UserInfoDictionary.Add("UserBirth", Request.Form["birthday"].ToString()); _UserInfoDictionary.Add("UserSex", Request.Form["sexual"].ToString()); DataBaseTools.SubmitData(_UserInfoDictionary); Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('两次输入密码不一致')</script>"); } }
protected void loginUser(object sender, EventArgs e) { _userAccount = Request.Form["input_userAccount"]; _passWord = Request.Form["input_password"]; login_result = DataBaseTools.LoginForUser(_userAccount, _passWord); if (login_result == 1) { Session["UserAccount"] = _userAccount; Response.Redirect("userIndex.aspx"); return; } else { Response.Write("<script>alert('账号或者密码出错');</script>"); return; } }
public static Polyline DrawPolyLine() { var ed = DataBaseTools.DocumentEditor(); var jig = new PolyLineJig(); do { var res = (PromptPointResult)ed.Drag(jig); if (res.Status == PromptStatus.OK) { jig.AddPoint(); } else if (res.Status == PromptStatus.Keyword) { var isBreak = false; switch (res.StringResult) { case "U": jig.U(); break; case "C": jig.C(); isBreak = true; break; default: isBreak = true; break; } if (isBreak) { break; } } else { break; } } while (true); return(jig.PolyLine); }
private void changePassBTN_Click(object sender, RoutedEventArgs e) { if (oldPassTB.Text == CurrentUser.getPassword()) { if (confirmPassTB.Text == NewpassTB.Text) { confirmLBL.Content = ""; DataBaseTools.UpdateUserPassword(CurrentUser.getID(), confirmPassTB.Text); System.Windows.MessageBox.Show("Password Changed", "Info"); Close(); } else { confirmLBL.Content = "Confirmation password dosen't match the password"; } } else { System.Windows.MessageBox.Show("Worng password", "Info"); } }
public RarityRepository() { dbTools = DataBaseTools.getInstance(); dbTools.createTableIfNotExist<Rarity>(); }
private void ReturnOneRecord() { Models.FoodItem fi = new Models.FoodItem(); fi = DataBaseTools.SearchRecords <Models.FoodItem>("FoodItem", "SavingObjectsToDatabase.Models.FoodItem", "Name", "Banana"); lv1.Items.Add(fi.Name); }
public IActionResult Index() { return(View(DataBaseTools.GetPopularProducts())); }
public IActionResult Products(int id) { return(View(DataBaseTools.GetAllProducts(id))); }
public ComponentTypeRepository() { dbTools = DataBaseTools.getInstance(); dbTools.createTableIfNotExist <ComponentType>(); }
public ItemAttributeRepository() { dbTools = DataBaseTools.getInstance(); dbTools.createTableIfNotExist <ItemAttribute>(); }
// GET: /<controller>/ public IActionResult View(int id) { return(View(DataBaseTools.GetSpecifiedProduct(id))); }