private void Branch_Intake_Track_Add(object sender, RoutedEventArgs e)
{
try
{
List <BranchIntackTrack> branchIntackTracks =
context.BranchIntackTracks.ToList(); //.Where(s => s.BranchID == (byte)BranchName.SelectedValue
//&& s.TrackID == (byte)TrackName.SelectedValue && s.IntakeID == (byte)IntakeNumber.SelectedValue).FirstOrDefault();
foreach (var item in branchIntackTracks)
{
if (item.BranchID == (byte)BranchNameBIT.SelectedValue &&
item.TrackID == (byte)TrackNameBIT.SelectedValue &&
item.IntakeID == (byte)IntakeNumberBIT.SelectedValue)
{
MessageBox.Show("this track and intake are already assigned to this branch");
}
}
BranchIntackTrack branchIntackTrack =
new BranchIntackTrack()
{
BranchID = (byte)BranchNameBIT.SelectedValue,
TrackID = (byte)TrackNameBIT.SelectedValue,
IntakeID = (byte)IntakeNumberBIT.SelectedValue,
};
context.BranchIntackTracks.Add(branchIntackTrack);
context.SaveChanges();
MessageBox.Show("this intake and track are sucessfully assigned to this branch");
}catch
{
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (StudentUsername.Text != "" && StudentPassword.Text != "" &&
StudentName.Text != "")
{
var query =
from use in context.Users
where use.Name == StudentUsername.Text
select use.Name;
if (query.FirstOrDefault() != StudentUsername.Text)
{
User user = new User()
{
Name = StudentUsername.Text,
Password = StudentPassword.Text,
};
context.Users.Add(user);
context.SaveChanges();
byte intakeID = (byte)InakeNumber.SelectedValue;
byte trackID = (byte)TrackName.SelectedValue;
byte branchID = (byte)BranchName.SelectedValue;
BranchIntackTrack BIT = context.BranchIntackTracks
.Where(b => b.IntakeID == intakeID && b.TrackID == trackID && b.BranchID == branchID).FirstOrDefault();
int branchIntakeTrackID = BIT.ID;
Student student = new Student();
student.Name = StudentName.Text;
student.College = StudentCollege.Text;
student.Email = StudentEmail.Text;
student.UserID = user.ID;
student.BranchIntackTrackID = branchIntakeTrackID;
context.Students.Add(student);
context.SaveChanges();
MessageBox.Show("Student Added Successfully");
}
else
{
MessageBox.Show("Username is already taken");
}
}
else
{
MessageBox.Show("Some Empty fields are required");
}
}
