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();
}
}
}
