/// <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)));
}
