public FormParking() { InitializeComponent(); parkingCollection = new ParkingCollection(pictureBoxParking.Width, pictureBoxParking.Height); }
public MainViewModel(User user) { this.SignedUser = user; VType = new ObservableCollection <vtype>() { new vtype() { Title = "Автомобиль" }, new vtype() { Title = "Мотоцикл" }, }; PType = new ObservableCollection <ptype>() { new ptype() { Title = "Крытая" }, new ptype() { Title = "Открытая" }, }; try { string sql = "SELECT EnterDate, ExitDate, CarNumber, VehicleType, ParkingType, Price, Id FROM ParkingPlace WHERE Username=@username AND DATEDIFF(dd, GETDATE(), EnterDate)>2"; SqlCommand command = new SqlCommand(sql, sqlCon); command.Parameters.AddWithValue("@username", Username); sqlCon.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ParkingPlace place = new ParkingPlace(); place.Entrydate = reader.GetDateTime(0); place.Exitdate = reader.GetDateTime(1); place.Carnumber = reader.GetString(2); place.Vehicletype = reader.GetString(3); place.Parkingtype = reader.GetString(4); place.Price = reader.GetInt32(5); place.Id = reader.GetInt32(6); ParkingCollection.Add(place); } reader.Close(); string mail = "SELECT Email, Username FROM tblUser where Username = @username"; SqlCommand newcmd = new SqlCommand(mail, sqlCon); newcmd.Parameters.AddWithValue("@username", Username); SqlDataReader newreader = newcmd.ExecuteReader(); while (newreader.Read()) { Email = newreader.GetString(0); Username = newreader.GetString(1); } newreader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (sqlCon != null) { sqlCon.Close(); } } }