private void Send_Click(object sender, RoutedEventArgs e)
{
try
{
if (MyMessege.Text != null || MyMessege.Text.Length < 300 || MyMessege.Text.Length > 1)
{
using (KPContext kp = new KPContext())
{
Review review = new Review()
{
UserId = Convert.ToInt32(UserId.Text),
ParkingId = 1,
Review1 = MyMessege.Text,
TimeRev = GetNetworkDateTime()
};
MyMessege.Clear();
kp.Review.Add(review);
kp.SaveChanges();
MessageBox.Show("Спасибо! Ваш отзыв очень ценен для нас.");
}
}
else
{
throw new Exception();
}
}
catch (Exception)
{
MessageBox.Show("Попробуйте позже");
}
}
public void Regist()
{
if (ValidReg() == true)
{
using (KPContext kp = new KPContext())
{
Users user = new Users()
{
Secondname = secondname,
Firstname = firstname,
email = _email,
Mobile = mobile,
password = GetHashPassword(_password),
Admin = false
};
kp.Users.Add(user);
kp.SaveChanges();
}
MessageBox.Show("Пользователь успешно создан");
foreach (System.Windows.Window window in System.Windows.Application.Current.Windows)
{
if (window.DataContext == this)
{
window.Close();
}
}
}
}
public void Regist()
{
if (ValidReg() == true)
{
using (KPContext kp = new KPContext())
{
Users user = new Users()
{
Secondname = secondname,
Firstname = firstname,
email = _email,
Mobile = mobile,
password = GetHashPassword(_password),
Admin = false
};
kp.Users.Add(user);
kp.SaveChanges();
}
MessageBox.Show("Регистрация прошла успешно");
Clear();
}
}
private void EnterExitPark_Click(object sender, RoutedEventArgs e)
{
string sector = " ";
if (CheckA.IsChecked == true)
{
sector = CheckA.Content.ToString();
}
if (CheckB.IsChecked == true)
{
sector = CheckB.Content.ToString();
}
if (CheckC.IsChecked == true)
{
sector = CheckC.Content.ToString();
}
using (KPContext kP = new KPContext())
{
try
{
PlaceClear();
var ForEnterOrExit = kP.Database.SqlQuery <Booking>($"select * from Booking where Booking.UserID = '{UserId.Text}'");
if (ForEnterOrExit != null)
{
var info = ForEnterOrExit.LastOrDefault();
var PlaceInfo = kP.Place.ToList();
if (info != null)
{
if (info.TimeEnd != null) //Парковка
{
foreach (var i in PlaceInfo)
{
if (i.Status == true)
{
if (i.Sector == sector)
{
//int intodata = kP.Database.ExecuteSqlCommand($"insert into Booking (UserID,PlaceID,TimeStart) values ({Convert.ToInt32(UserId.Text)},{Convert.ToInt32(i.PlaceId)},'GETDATE()'");
Booking booking = new Booking();
booking.UserID = Convert.ToInt32(UserId.Text);
booking.PlaceID = Convert.ToInt32(i.PlaceId);
booking.TimeStart = GetNetworkDateTime();
kP.Booking.Add(booking);
kP.SaveChanges();
int upd = kP.Database.ExecuteSqlCommand($"Update Place set Status = 'false' where PlaceId = {i.PlaceId}");
MessageBox.Show("Проезжайте к месту и сектору указаному ниже");
PlaceSector.Text = "Сектор: " + i.Sector;
PlaceNumber.Text = "Номер: " + i.Number;
break;
}
}
}
}
if (info.TimeEnd == null) // выезд из парковки
{
double endcost;
DateTime dateTime = new DateTime();
dateTime = GetNetworkDateTime();
int chnge = kP.Database.ExecuteSqlCommand($"Update Booking set TimeEnd = '{dateTime}' where BookingId = {Convert.ToInt32(info.BookingId)}");
int upd2 = kP.Database.ExecuteSqlCommand($"Update Place set Status = 'true' where PlaceId = {Convert.ToInt32(info.PlaceID)}");
var aboutcost = PlaceInfo.Last();
endcost = CheckTime(info.TimeStart, dateTime);
PlaceSector.Text = "Время стоянки: " + Convert.ToString(endcost);
endcost = endcost * aboutcost.cost;
PlaceNumber.Text = "Стоимость: " + Convert.ToString(endcost);
}
}
if (info == null)
{
foreach (var i in PlaceInfo)
{
if (i.Status == true)
{
if (i.Sector == sector)
{
//int intodata = kP.Database.ExecuteSqlCommand($"insert into Booking (UserID,PlaceID,TimeStart) values ({Convert.ToInt32(UserId.Text)},{Convert.ToInt32(i.PlaceId)},'GETDATE()'");
Booking booking = new Booking();
booking.UserID = Convert.ToInt32(UserId.Text);
booking.PlaceID = Convert.ToInt32(i.PlaceId);
booking.TimeStart = GetNetworkDateTime();
kP.Booking.Add(booking);
kP.SaveChanges();
int upd = kP.Database.ExecuteSqlCommand($"Update Place set Status = 'false' where PlaceId = {i.PlaceId}");
MessageBox.Show("Проезжайте к месту и сектору указаному ниже");
PlaceSector.Text = "Сектор: " + i.Sector;
PlaceNumber.Text = "Номер: " + i.Number;
break;
}
}
}
}
}
}
catch (Exception)
{
MessageBox.Show("Попробуйте в другое время");
}
}
}
