private void btnAdd_Click(object sender, RoutedEventArgs e)
{
string ProdID;
string sql;
string UserID = Login.UserID;
SqlLite sq = new SqlLite();
if (DG.SelectedItems.Count == 0)
{
return;
}
ProdID = ((DataRowView)DG.SelectedItems[0]).Row["ProdID"].ToString();
//clientID = (int)((DataRowView)DG.SelectedItems[0]).Row["ID"];
sql = "select OrderState from Orders where UserID = '" + UserID + "' and OrderState = 1";
if (Convert.ToInt16(sq.GetSingleSet(sql)) == 1)
{
check = true;
}
else
{
check = false;
}
if (check == false)
{
sql = " Insert Into Orders(OrderID, OrderDate, UserID, OrderState) Select (Select IFNull(Max(OrderID)+1,1) From Orders) OrderID, DATETIME() OrderDate, '" + UserID + "' UserID, 1 OrderState";
sq.GetSingleSet(sql);
check = true;
}
sql = "Insert Into OrdersD(OrderID, SrcPosID, ProdID, qty) SELECT (SELECT MAX(OrderID) FROM Orders WHERE UserID = '" + UserID + "' AND OrderState = 1) OrderID, (SELECT IFNull(MAX(SrcPosID)+1,1) FROM OrdersD WHERE OrderID = (SELECT MAX(OrderID) FROM Orders WHERE UserID = '" + UserID + "' AND OrderState = 1)) SrcPosID, " + ProdID + " ProdID, 1 qty";
sq.GetSingleSet(sql);
}
private void btnCompleteOrder_Click(object sender, RoutedEventArgs e)
{
string sql;
string orderid;
SqlLite sq = new SqlLite();
if (Dg1.SelectedItems.Count == 0)
{
return;
}
orderid = ((DataRowView)Dg1.SelectedItems[0]).Row["OrderId"].ToString();
sql = "update orders set orderstate = 2 where orderid = " + orderid + "";
sq.GetSingleSet(sql);
}
// public static string Email;
static public bool CheckUser(string email, string PW)
{
string sql;
SqlLite sq = new SqlLite();
sql = " select ifnull(UserID,0) as UserID from UsersLogin where email = '" + email + "' and PW = '" + PW + "' ";
UserID = Convert.ToString(sq.GetSingleSet(sql));
if (UserID == "")
{
return(false);
}
else
{
return(true);
}
}
private void btnChangeQty_Click(object sender, RoutedEventArgs e)
{
string sql;
string prodid;
string orderid;
string qty;
SqlLite sq = new SqlLite();
if (Dg1.SelectedItems.Count == 0)
{
return;
}
prodid = ((DataRowView)Dg1.SelectedItems[0]).Row["ProdID"].ToString();
orderid = ((DataRowView)Dg1.SelectedItems[0]).Row["OrderId"].ToString();
qty = ((DataRowView)Dg1.SelectedItems[0]).Row["qty"].ToString();
//clientID = (int)((DataRowView)DG.SelectedItems[0]).Row["ID"];
sql = "update ordersd set qty = " + qty + " where prodid = " + prodid + " and orderid = " + orderid + " ";
sq.GetSingleSet(sql);
}
private void btnRegister_Click(object sender, RoutedEventArgs e)
{
int NewUserID;
if (checkFields() == false)
{
MessageBox.Show("Поля со * обязательны для заполнения.");
return;
}
if (CheckPassword(txtPW.Password) == "Пароль должен содержать не менее 6 символов!")
{
return;
}
SqlLite sq = new SqlLite();
NewUserID = Convert.ToInt16(sq.GetSingleSet("Select ifnull(max(UserID),0)+1 from UsersLogin"));
sq.Create("UsersLogin", Convert.ToString(NewUserID) + ",'" + txtEmail.Text + "','" + txtPW.Password + "'", "UserID,Email,PW");
if (txtFio.Text != "" || txtPhone.Text != "")
{
sq.Create("Users", Convert.ToString(NewUserID) + ",'" + txtFio.Text + "','" + txtPhone.Text + "'", "UserID,Fio,Phone");
}
// MessageBox.Show("Регистрация прошла успешно, авторизируйтесь в программе.");
login NW = new login();
NW.Show();
NW.txtRegConfirm.Content = "Регистрация прошла успешно, авторизируйтесь в программе.";
NW.txtRegConfirm.Visibility = Visibility.Visible;
this.Close();
}