private void BtnAdd(object sender, MouseButtonEventArgs e)
{
var db = new GameHalldbEntities();
var newPlayer = new player
{
name = name.Text,
lastname = lastname.Text
};
db.players.Add(newPlayer);
if (Convert.ToBoolean(db.SaveChanges()))
{
successAdd.Opacity = 1;
name.Text = "";
lastname.Text = "";
}
else
{
notSuccessAdd.Opacity = 1;
name.Text = "";
lastname.Text = "";
}
}
private void BtnAdd(object sender, MouseButtonEventArgs e)
{
var db = new GameHalldbEntities();
var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var secondLast = DateTime.Now.Subtract(DateTime.MinValue).TotalSeconds;
var newPlaying = new playing
{
startTime = Convert.ToDateTime(time),
description = information.Text,
status = false,
place = Convert.ToInt32(table.Text),
startTimeInSecond = secondLast
};
db.playings.Add(newPlaying);
if (Convert.ToBoolean(db.SaveChanges()))
{
success.Opacity = 1;
}
else
{
noSuccess.Opacity = 0;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var db = new GameHalldbEntities();
var result = from a in db.playings
where a.status.Equals(false)
orderby a.Id
select a;
playerList.ItemsSource = result.ToList();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
MainWindow main = new MainWindow();
var db = new GameHalldbEntities();
table.ItemsSource = db.hallTables.ToList();
table.DisplayMemberPath = "number";
TimeText.Text = Convert.ToString(DateTime.Now.Hour);
TimeMin.Text = Convert.ToString(DateTime.Now.Minute);
DateYear.Text = Convert.ToString(main.PersianCalender.SelectedDate.Year);
DateMonth.Text = Convert.ToString(main.PersianCalender.SelectedDate.Month);
DateDay.Text = Convert.ToString(main.PersianCalender.SelectedDate.Day);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var db = new GameHalldbEntities();
playerList.ItemsSource = db.players.ToList();
}
private void FinishClick(object sender, RoutedEventArgs e)
{
var db = new GameHalldbEntities();
var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var secondLast = DateTime.Now.Subtract(DateTime.MinValue).TotalSeconds;
var getSetting = (from a in db.settings
where a.Id.Equals(1)
select a).SingleOrDefault();
if (getSetting != null)
{
var oneHourPrice = getSetting.OneHourPrice;
object item = playerList.SelectedItem;
var id = ((playing)item).Id;
var qGet = (from a in db.playings
where a.Id.Equals(id)
select a).SingleOrDefault();
if (qGet != null)
{
var timeDifference = secondLast - qGet.startTimeInSecond;
var priceForOneSecond = (double)oneHourPrice / 3600;
var totalPrice = timeDifference * priceForOneSecond;
qGet.endTime = Convert.ToDateTime(time);
qGet.status = true;
qGet.price = totalPrice;
qGet.endTimeInSecond = secondLast;
db.playings.Attach(qGet);
db.Entry(qGet).State = System.Data.Entity.EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges()))
{
var qGetName = (from a in db.players
where a.Id.Equals(qGet.playerId)
select a).SingleOrDefault();
if (qGetName != null)
{
var username = qGetName.name + qGetName.lastname;
var lastPrice = Convert.ToInt64(qGet.price);
new ShowFinish(username, Convert.ToString(qGet.startTime, CultureInfo.InvariantCulture), Convert.ToString(qGet.endTime), Convert.ToString(lastPrice)).Show();
Close();
}
else
{
var lastPrice = Convert.ToInt64(qGet.price);
new ShowFinish("بدون نام", Convert.ToString(qGet.startTime, CultureInfo.InvariantCulture), Convert.ToString(qGet.endTime, CultureInfo.InvariantCulture), Convert.ToString(lastPrice)).Show();
Close();
}
}
else
{
error.Opacity = 1;
}
}
else
{
error.Opacity = 1;
}
}
}
