// Сделать заказ
private object NewOrder()
{
TimeSpan t = (DateTime.UtcNow - new DateTime(1970, 1, 1));
int timestamp = (int)t.TotalSeconds;
string query = "INSERT INTO orders(`id_user`,`timestamp`) VALUES (" + userid + "," + timestamp + ")";
db.Database.ExecuteSqlCommand(query);
db.SaveChanges();
query = "SELECT max(id_ord) FROM orders";
var orderid = db.Database.SqlQuery <int?>(query).First();
foreach (var item in order)
{
query = "INSERT INTO order_items(`id_order`,`id_good`,`amount`,`price`) VALUES(" + orderid + "," + item.id_good + "," + item.in_storage + "," + item.price + ")";
db.Database.ExecuteSqlCommand(query);
query = "UPDATE goods SET `in_storage`=`in_storage`-" + item.in_storage + " WHERE `id_good`=" + item.id_good;
db.Database.ExecuteSqlCommand(query);
db.SaveChanges();
}
order.Clear();
goods_base.Clear();
LoadGoodsBase();
res.prop = 0;
var msg = new GoToPageMessage()
{
PageName = "CreateOrder", Parameter = orderid.ToString()
};
Messenger.Default.Send <GoToPageMessage>(msg);
return(null);
}
private object ReceiveMessage(GoToPageMessage action)
{
// this.contentControl1.Content = this.Page2View;
//this shows what pagename property is!!
switch (action.PageName)
{
case "Page2View":
if (this.contentControl1.Content != this.Page2View)
{
this.contentControl1.Content = this.Page2View;
}
break;
case "Page3View":
if (this.contentControl1.Content != this.Page3View)
{
this.contentControl1.Content = this.Page3View;
}
break;
default:
break;
}
// string testII = action.PageName.ToString();
// System.Windows.MessageBox.Show("You were successful switching to " + testII + ".");
return(null);
}
public override void OnBindViewHolder(RecyclerView.ViewHolder holder, int position)
{
holder.ItemView.Selected = _selectedPosition == position;
if (position <= _data.Count)
{
var currentObject = _data[position];
var element = holder as PersonCardViewHolder;
element.SetData(currentObject, position);
element.EditButton.Click += (object sender, EventArgs e) =>
{
var person = currentObject;
var msg = new GoToPageMessage {
PersonId = person.Id
};
Messenger.Default.Send <GoToPageMessage>(msg);
};
element.DeleteButton.Click += (object sender, EventArgs e) =>
{
var person = currentObject;
var msg = new GoToPageMessage {
PersonId = person.Id
};
Messenger.Default.Send <GoToPageMessage>(msg);
};
}
}
private object GoToPage2()
{
var msg = new GoToPageMessage() { PageName = "Page2View" };
Messenger.Default.Send<GoToPageMessage>(msg);
//System.Windows.MessageBox.Show("Navigate to Page 2!");
return null;
}
private void ReceiveMessage(GoToPageMessage action)
{
StringBuilder sb = new StringBuilder("/Views/");
sb.Append(action.PageName);
sb.Append(".xaml");
NavigationService.Navigate(
new System.Uri(sb.ToString(),
System.UriKind.Relative));
}
private object GoToPage2()
{
var msg = new GoToPageMessage()
{
PageName = "Page2"
};
Messenger.Default.Send <GoToPageMessage>(msg);
return(null);
}
/// <summary>
/// Receives message stating which page to switch to
/// </summary>
/// <param name="action">Name of page to switch to</param>
private void ReceiveMessage(GoToPageMessage action)
{
switch (action.PageName)
{
case "Repair":
RepairViewModel._options = (Options)action.Payload;
CurrentViewModel = RepairViewModel;
RepairViewModel.LoadMaime();
break;
}
}
private object GoToPage3()
{
var msg = new GoToPageMessage()
{
PageName = "Page3View"
};
Messenger.Default.Send <GoToPageMessage>(msg);
//System.Windows.MessageBox.Show("Navigate to Page 2!");
return(null);
}
private void PreChangeUser(int param = -1)
{
if (param != -1)
{
cur_user = db.users.Where(x => x.id_user == param).First <user>();
}
var msg = new GoToPageMessage()
{
PageName = "UserEdit", Parameter = param.ToString()
};
Messenger.Default.Send <GoToPageMessage>(msg);
}
private object GoToPageShop()
{
DbClient db = new DbClient();
db.users.Load();
user us = new user();
us = db.users
.Where(u => u.login == _login)
.FirstOrDefault <user>();
if (us != null && us.password == _password)
{
var msg = new GoToPageMessage()
{
PageName = "ShopWindow", Parameter = us.id_user.ToString(), Parameter2 = us.user_cat.ToString()
};
Messenger.Default.Send <GoToPageMessage>(msg);
}
return(null);
}
private void ChangeUser()
{
string query = "";
if (cur_user.id_user == 0)
{
query = "INSERT INTO users(`login`,`password`,`user_cat`) VALUES ('" + cur_user.login + "','" + cur_user.password + "','" + cur_user.user_cat + "')";
}
else
{
query = "UPDATE users SET `login`='" + cur_user.login + "', `password`=" + cur_user.password + ", `user_cat`=" + cur_user.user_cat + " WHERE `id_user`=" + cur_user.id_user;
}
db.Database.ExecuteSqlCommand(query);
db.SaveChanges();
var msg = new GoToPageMessage()
{
PageName = "UserSave"
};
Messenger.Default.Send <GoToPageMessage>(msg);
cur_user = new user();
PreChangeUser();
LoadUsersBase();
}
private void setCurrentPage(GoToPageMessage message)
{
currentPage = message.Data as String;
}
private void GoToPageHandler(GoToPageMessage msg)
{
this.SendGoToPage(msg.Page, msg.Next, msg.Previous);
}
private void SetCurrentPage(GoToPageMessage goToPageMessage)
{
//throw new NotImplementedException();
}
private void GoToPerson(GoToPageMessage obj)
{
var person = People.First(p => p.Id == obj.PersonId);
SelectedPerson = person;
}
