private void removetrack_Click(object sender, RoutedEventArgs e)
{
TrackClass trackeselect = new TrackClass();
trackeselect = track.SelectedItem as TrackClass;
var query =
(from track in context3.tracks
where track.TrackName == trackeselect.TrackName
select track).FirstOrDefault();
track tracksupdated = context3.tracks.Where(em => em.TrackName == query.TrackName).FirstOrDefault();
context3.tracks.Remove(tracksupdated);
context3.SaveChanges();
}
private void Trackadd_Click(object sender, RoutedEventArgs e)
{
TrackClass newTrack = new TrackClass();
newTrack.TrackName = tracKName_textbOX.Text.ToString();
newTrack.Year = trackdate.DisplayDate;
var counter = 1;
var trackAddedToDataBase = new track
{
TrackId = (++counter),
TrackName = newTrack.TrackName,
Year = newTrack.Year,
};
context3.tracks.Add(trackAddedToDataBase);
context3.SaveChanges();
track.Items.Add(trackAddedToDataBase);
}
private void updatetrack_Click(object sender, RoutedEventArgs e)
{
TrackClass trackselect = new TrackClass();
trackselect = track.SelectedItem as TrackClass;
var query =
(from track in context3.tracks
where track.TrackName == trackselect.TrackName
select track).FirstOrDefault();
track tracksupdated = context3.tracks.Where(em => em.TrackName == query.TrackName).FirstOrDefault();
tracksupdated.TrackName = (tracKName_textbOX.Text.ToString());
tracksupdated.Year = DateTime.Now;
context3.SaveChanges();
}
private void removetrack_Click(object sender, RoutedEventArgs e)
{
try {
TrackClass trackeselect = new TrackClass();
trackeselect = track.SelectedItem as TrackClass;
var query =
(from track in context3.tracks
where track.TrackName == trackeselect.TrackName
select track).FirstOrDefault();
track tracksupdated = context3.tracks.Where(em => em.TrackName == query.TrackName).FirstOrDefault();
context3.tracks.Remove(tracksupdated);
context3.SaveChanges();
}
catch (Exception f)
{
MessageBox.Show("invalid inputs");
}
}
private void Trackadd_Click(object sender, RoutedEventArgs e)
{
try {
TrackClass newTrack = new TrackClass();
newTrack.TrackName = tracKName_textbOX.Text.ToString();
newTrack.Year = trackdate.DisplayDate;
var counter = 1;
var trackAddedToDataBase = new track
{
TrackId = (++counter),
TrackName = newTrack.TrackName,
Year = newTrack.Year,
};
context3.tracks.Add(trackAddedToDataBase);
context3.SaveChanges();
track.Items.Add(trackAddedToDataBase);
}
catch (Exception f)
{
MessageBox.Show("invalid inputs");
}
}
public ManagerDashboard()
{
InitializeComponent();
var query2 = (from track in context3.tracks
select new
{
TrackId = track.TrackId,
Year = track.Year,
TrackName = track.TrackName,
}).ToList();
var query1 = (from intake in context3.intakes
select new
{
IntakeNo = intake.IntakeNo,
IntakeNumber = intake.IntakeNumber,
Year = intake.Year
}).ToList();
var query3 = (from branches in context3.branches
select new
{
BranchId = branches.BranchId,
Name = branches.Name,
Year = branches.Year
}).ToList();
List <IntakeClass> ListOfIntakeNumber = new List <IntakeClass>();
List <TrackClass> ListOfTrackNumber = new List <TrackClass>();
List <BranchClass> ListOfBranchNumber = new List <BranchClass>();
foreach (var item in query1)
{
IntakeClass newIntake = new IntakeClass();
newIntake.IntakeNo = item.IntakeNo;
newIntake.IntakeNumber = item.IntakeNumber;
newIntake.Year = item.Year;
ListOfIntakeNumber.Add(newIntake);
}
foreach (var item in ListOfIntakeNumber)
{
intakesViewList.Items.Add(item);
}
foreach (var item in query2)
{
TrackClass newTrack = new TrackClass();
newTrack.TrackId = item.TrackId;
newTrack.TrackName = item.TrackName;
newTrack.Year = item.Year;
ListOfTrackNumber.Add(newTrack);
}
foreach (var item in ListOfTrackNumber)
{
track.Items.Add(item);
}
foreach (var item in query3)
{
BranchClass newBranch = new BranchClass();
newBranch.BranchId = item.BranchId;
newBranch.Name = item.Name;
newBranch.Year = item.Year;
ListOfBranchNumber.Add(newBranch);
}
foreach (var item in ListOfBranchNumber)
{
branch.Items.Add(item);
}
//intakes.ItemsSource = query1;
//branch.ItemsSource = getAllBranches();
//track.ItemsSource = query2;
}
