private void selected_alumni(object sender, SelectionChangedEventArgs e)
{
var SelectedAlumni = alumni_grid.SelectedIndex;
Alumni aAlumni = ((Alumni)alumni_grid.Items[SelectedAlumni]);
alumni_name_tb.Text = aAlumni.Name;
}
public void AddNullAlumniToAlumnusListShouldThrowArgumentNullException()
{
Alumni alumni = null;
AlumnusList alumnus = new AlumnusList();
alumnus.AddAlumni(alumni);
}
public void CreateAlumniNumOfYrsBetweenStartAndGradMoreThan6YrsShouldThrowArugmentOutOfRangeException()
{
DateTime startDateTime = new DateTime(2001, 12, 1);
DateTime gradDateTime = DateTime.Now;
Alumni alumni = new Alumni("UGAC1", "Nikki", "Bell", gradDateTime, startDateTime);
}
public int Insert(Alumni alumni)
{
using (IDbConnection dbConnection = Connection)
{
dbConnection.Open();
return(dbConnection.Query <InsertID>("dbo.InsertAlumni", new { FirstName = alumni.FirstName, LastName = alumni.LastName, Email = alumni.Email }, commandType: CommandType.StoredProcedure).First().ID);
}
}
public void CreateAlumniWithNullCourseCodeShouldThrowArgumentNullException()
{
DateTime startDateTime = new DateTime(2014, 12, 1);
DateTime gradDateTime = new DateTime(2015, 12, 2);
Alumni alumni = new Alumni(null, "Sarah", "Cornell", gradDateTime, startDateTime);
}
public void CreateNew(Alumni a)
{
using (var context = new SwuDBContext())
{
context.Alumni.Add(a);
context.SaveChanges();
}
}
public void CreateAlumniWithIncorrectCourseCodeFormatShouldThrowArgumentException()
{
DateTime startDateTime = new DateTime(2013, 09, 11);
DateTime gradDateTime = new DateTime(2016, 10, 22);
Alumni alumni = new Alumni("BH101", "Dave", "McHale", gradDateTime, startDateTime);
}
public void CreateAlumniWithFutureGradDateShouldThrowArgumentOutOfRangeException()
{
DateTime futureDateTime = new DateTime(2200, 12, 1);
DateTime startDateTime = new DateTime(2015, 12, 1);
Alumni alumni = new Alumni("UG123", "Joe", "Stevens", futureDateTime, startDateTime);
}
/// <summary>
/// Adds alumni details to database..
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var email = (from a in ue.Alumni
where a.aemail == txtEmail.Text
select a.aemail).FirstOrDefault();
var course = (from c in ue.Courses
where c.cname == ddlCourse.Text
select c).FirstOrDefault();
if (ddlCourse.SelectedIndex != 0)
{
if (ddlPassYear.SelectedIndex != 0)
{
//Checks if same email already exists in alumni record..
if (email == null)
{
Alumni newAlumni = new Alumni();
newAlumni.aname = txtName.Text;
newAlumni.CoursesReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Courses", "cid", course.cid);
newAlumni.aemail = txtEmail.Text;
newAlumni.acompany = txtCompany.Text;
newAlumni.apassyear = Convert.ToInt32(ddlPassYear.Text);
newAlumni.RolesReference.EntityKey = new System.Data.EntityKey("unitycollegeEntities1.Roles", "rid", 4);
newAlumni.aworkprofile = txtWorkProfile.Text;
//if (ddlValid.SelectedIndex == 0)
newAlumni.avalid = true;
//else
// a.avalid = false;
ue.AddToAlumni(newAlumni);
ue.SaveChanges();
lblMsg.Text = "Success!!!Record Saved Successfully!";
txtName.Text = txtEmail.Text = txtCompany.Text = txtWorkProfile.Text = "";
ddlCourse.SelectedIndex = ddlPassYear.SelectedIndex = 0;
}
else
{
lblMsg.Text = "Email already exists!";
}
}
else
{
lblMsg.Text = "Passout Year is required!";
}
}
else
{
lblMsg.Text = "Course is required!";
}
}
catch (Exception e1)
{
lblMsg.Text = e1.Message;
}
}
public static AlumniProxy ToViewModel(this Alumni a)
{
return(new AlumniProxy
{
StudentId = a.StudentId,
FullName_TH = a.FullName,
FullName_EN = a.FullName_EN,
GraduatedYear = a.GraduatedYear
});
}
public void RemoveFromEmptyAlumnusListShouldThrowArgumentException()
{
DateTime startDateTime = new DateTime(2015, 12, 12);
DateTime gradDateTime = new DateTime(2016, 6, 6);
Alumni alumni = new Alumni("PG192E1", "Phil", "Davids", gradDateTime, startDateTime);
AlumnusList alumnus = new AlumnusList();
alumnus.RemoveAlumni(alumni);
}
public void Delete(Alumni a)
{
using (var context = new SwuDBContext())
{
var existing = context.Alumni
.Where(i => i.Id == a.Id)
.FirstOrDefault();
context.Alumni.Remove(existing);
context.SaveChanges();
}
}
public void Update(Alumni a)
{
using (var context = new SwuDBContext())
{
var existing = context.Alumni
.Where(i => i.Id == a.Id)
.FirstOrDefault();
existing.StudentId = a.StudentId;
existing.FullName = a.FullName;
existing.GraduatedYear = a.GraduatedYear;
context.Entry(existing).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void RemoveAddedAlumniFromAlumnusListShouldRemoveAlumni()
{
DateTime startDateTime = new DateTime(2015, 12, 12);
DateTime gradDateTime = new DateTime(2016, 6, 6);
Alumni alumni = new Alumni("PG192E1", "Phil", "Davids", gradDateTime, startDateTime);
AlumnusList alumnus = new AlumnusList();
alumnus.AddAlumni(alumni);
//verify alumni was added in the first place
CollectionAssert.Contains(alumnus.Alumnus, alumni);
Assert.AreEqual(true, alumnus.RemoveAlumni(alumni));
//verify alumni removed
CollectionAssert.DoesNotContain(alumnus.Alumnus, alumni);
}
public void AddAlumniArrayWithOneNullAlumniToAlumnusShouldThrowArgumentNullException()
{
DateTime startDateTime = new DateTime(2015, 12, 12);
DateTime gradDateTime = new DateTime(2016, 6, 6);
Alumni alumni1 = new Alumni("PG192E1", "Phil", "Davids", gradDateTime, startDateTime);
Alumni alumni2 = null;
Alumni[] alumniArray = new Alumni[2];
AlumnusList alumnus = new AlumnusList();
alumniArray.SetValue(alumni1, 0);
alumniArray.SetValue(alumni2, 1);
alumnus.AddAlumnus(alumniArray);
}
public void AddAlumniArrayToAlumnusShouldContainArrayEntriesInAlumnusList()
{
DateTime startDateTime = new DateTime(2015, 12, 12);
DateTime gradDateTime = new DateTime(2016, 6, 6);
Alumni alumni1 = new Alumni("PG192E1", "Phil", "Davids", gradDateTime, startDateTime);
Alumni alumni2 = new Alumni("UG333F1", "Bazz", "Atron", gradDateTime, startDateTime);
Alumni[] alumniArray = new Alumni[2];
AlumnusList alumnus = new AlumnusList();
alumniArray.SetValue(alumni1, 0);
alumniArray.SetValue(alumni2, 1);
alumnus.AddAlumnus(alumniArray);
CollectionAssert.Contains(alumnus.Alumnus, alumni1);
CollectionAssert.Contains(alumnus.Alumnus, alumni2);
}
public void AddAlumniUpdatesEmptyAlumnusWithNewAlumni()
{
DateTime startDateTime = new DateTime(2015, 12, 12);
DateTime gradDateTime = new DateTime(2016, 6, 6);
Alumni alumni = new Alumni("PG192E1", "Phil", "Davids", gradDateTime, startDateTime);
AlumnusList alumnus = new AlumnusList();
alumnus.AddAlumni(alumni);
CollectionAssert.Contains(alumnus.Alumnus, alumni);
/*
* Above line is equivalent to the following...
* List<Alumni> alums = new List<Alumni>();
* alums.Add(alumni);
*
* CollectionAssert.AreEquivalent(alumnus.Alumnus, alums);
*/
}
public int Insert(Alumni alumni)
{
return(_repository.Insert(alumni));
}
public void Post([FromBody] Alumni alumni)
{
_service.Insert(alumni);
}
