private void AddIntake_Click(object sender, RoutedEventArgs e)
{
IntakeClass intakeAdd = new IntakeClass();
intakeAdd.IntakeNumber = int.Parse(Intake_NumberTextBox.Text.ToString());
intakeAdd.Year = intakdate.DisplayDate;
//var counter = 1;
var IntakeAddedToDataBase = new intake
{
IntakeNumber = intakeAdd.IntakeNumber,
Year = intakdate.DisplayDate,
};
context3.intakes.Add(IntakeAddedToDataBase);
context3.SaveChanges();
intakesViewList.Items.Add(IntakeAddedToDataBase);
}
private void RemoveIntake_Click(object sender, RoutedEventArgs e)
{
IntakeClass intakeselect = new IntakeClass();
intakeselect = intakesViewList.SelectedItem as IntakeClass;
var query =
(from intake in context3.intakes
where intake.IntakeNumber == intakeselect.IntakeNumber
select intake).FirstOrDefault();
intake intakesupdated = context3.intakes.Where(em => em.IntakeNo == query.IntakeNo).FirstOrDefault();
context3.intakes.Remove(intakesupdated);
context3.SaveChanges();
}
private void UpdateIntake_Click(object sender, RoutedEventArgs e)
{
IntakeClass intakeselect = new IntakeClass();
intakeselect = intakesViewList.SelectedItem as IntakeClass;
var query =
(from intake in context3.intakes
where intake.IntakeNumber == intakeselect.IntakeNumber
select intake).FirstOrDefault();
intake intakesupdated = context3.intakes.Where(em => em.IntakeNo == query.IntakeNo).FirstOrDefault();
intakesupdated.IntakeNumber = int.Parse(Intake_NumberTextBox.Text.ToString());
intakesupdated.Year = DateTime.Now;
context3.SaveChanges();
}
private void RemoveIntake_Click(object sender, RoutedEventArgs e)
{
try
{
IntakeClass intakeselect = new IntakeClass();
intakeselect = intakesViewList.SelectedItem as IntakeClass;
var query =
(from intake in context3.intakes
where intake.IntakeNumber == intakeselect.IntakeNumber
select intake).FirstOrDefault();
intake intakesupdated = context3.intakes.Where(em => em.IntakeNo == query.IntakeNo).FirstOrDefault();
context3.intakes.Remove(intakesupdated);
context3.SaveChanges();
}
catch (Exception f)
{
MessageBox.Show("invalid inputs");
}
}
private void addstudent_Click(object sender, RoutedEventArgs e)
{
try
{
track addtrackstudent = new track();
intake addintakstudent = new intake();
branch addbranchstudent = new branch();
user studentuser = new user();
rel_branch_track_intake ITb = new rel_branch_track_intake();
student newstudent = new student();
newstudent.StuId = int.Parse(idstudent.Text.ToString());
newstudent.FirstName = studentFirstName.Text.ToString();
newstudent.LastName = lastnamestudent.Text.ToString();
newstudent.BirthDate = datestudent.DisplayDate;
newstudent.StuEmail = emailstudent.Text.ToString();
newstudent.MatrailStatus = "single";
newstudent.JoinDate = DateTime.Now;
addbranchstudent.Year = DateTime.Now;
addbranchstudent.Name = branchstudent.SelectedItem.ToString();
addtrackstudent.Year = DateTime.Now;
addtrackstudent.TrackName = tracksstudent.SelectedItem.ToString();
addintakstudent.IntakeNumber = int.Parse(intakestudent.SelectedItem.ToString());
addintakstudent.Year = DateTime.Now;
ShowStudentData newstudentwasadded = new ShowStudentData();
newstudentwasadded.StuId = int.Parse(idstudent.Text.ToString());
newstudentwasadded.StuEmail = emailstudent.Text.ToString();
newstudentwasadded.FirstName = studentFirstName.Text.ToString();
newstudentwasadded.LastName = lastnamestudent.Text.ToString();
newstudentwasadded.Track = tracksstudent.SelectedItem.ToString();
newstudentwasadded.Intake = int.Parse(intakestudent.SelectedItem.ToString());
newstudentwasadded.Branch = branchstudent.SelectedItem.ToString();
newstudentwasadded.BirthDate = DateTime.Now;
studentuser.Email = newstudent.StuEmail;
studentuser.Password = passswordstudent.Text.ToString();
studentuser.Type = "student";
int branchFindId
= (from branches in context3.branches
where branches.Name == addbranchstudent.Name
select branches.BranchId).FirstOrDefault();
int trackFindId
=
(from trackID in context3.tracks
where trackID.TrackName == addtrackstudent.TrackName
select trackID.TrackId).FirstOrDefault();
int intakeFindId
=
(from intakeId in context3.intakes
where intakeId.IntakeNumber == addintakstudent.IntakeNumber
select intakeId.IntakeNo
).FirstOrDefault();
ITb.intack = intakeFindId;
ITb.trackID = trackFindId;
ITb.branchID = branchFindId;
int findITB =
(
from TIB in context3.rel_branch_track_intake
where TIB.branchID == branchFindId && TIB.trackID == trackFindId && TIB.intack == intakeFindId
select TIB.id
).Count();
int lastindexOfTIB;
lastindexOfTIB =
(from lastindexes in context3.rel_branch_track_intake
select lastindexes).Count();
MessageBox.Show(lastindexOfTIB.ToString());
if (findITB > 0)
{
int findITB2 =
(
from TIB in context3.rel_branch_track_intake
where TIB.branchID == branchFindId && TIB.trackID == trackFindId && TIB.intack == intakeFindId
select TIB.id
).FirstOrDefault();
newstudent.ITBid = findITB2;
context3.users.Add(studentuser);
context3.students.Add(newstudent);
context3.SaveChanges();
lvUsers.Items.Add(newstudentwasadded);
}
else
{
newstudent.ITBid = lastindexOfTIB;
ITb.id = lastindexOfTIB;
context3.rel_branch_track_intake.Add(ITb);
context3.SaveChanges();
context3.users.Add(studentuser);
context3.students.Add(newstudent);
context3.SaveChanges();
lvUsers.Items.Add(newstudentwasadded);
}
}
catch (Exception d)
{
MessageBox.Show("invalid inputs");
}
}
