/// <summary>
/// Returns
/// </summary>
/// <returns></returns>
public int assignedHours()
{
DataTable dt = DatabaseQuery.DBQuery(String.Format("select * from demos where DemoID = {0}", ID));
hours = dt.Rows.Count;
return(hours);
}
/// <summary>
/// removes demo from database
/// </summary>
public void removeFromDB()
{
// Remove demo from all tables
DatabaseQuery.DBInsert(String.Format(@"delete from enrolled where demoID = {0}; delete from previouslyDemoed where demoID = {0};
delete from preferredPaper where demoID = {0}
delete from demoTimeTable where demoID = {0}", ID));
DatabaseQuery.DBInsert(String.Format("delete from Demos where DemoID = {0}; delete from demonstrator where studentID='{0}'", ID));
}
/// <summary>
/// Updates demos attributes to database
/// </summary>
public void updateDB()
{
DatabaseQuery.DBInsert(String.Format(@"
update DEMONSTRATOR SET name='{0}', lastName='{1}', phoneNo='{2}', gender='{3}', username='******', summerAddr='{5}', major='{6}', degree='{7}', studyYear={8}, email='{9}', lastYear={10}, age={11} where studentID = '{12}'",
firstName, familyName, phone, gender, username, summer, major, degree, year, email, last.Equals("1") ? 1 : 0, age, ID));
// add enrolled, prefered and experience papers by removing old and inserting new
DatabaseQuery.DBInsert(String.Format("delete from enrolled where demoID={0}", ID));
foreach (String s in enrolled)
{
// prevents empty lines
if (s != "")
{
DatabaseQuery.DBInsert(String.Format("insert into enrolled(paperCode, demoID) Values('{0}', {1})", s, ID));
}
}
DatabaseQuery.DBInsert(String.Format("delete from preferredPaper where demoID={0}", ID));
foreach (String s in prefer)
{
// prevents empty lines
if (s != "")
{
DatabaseQuery.DBInsert(String.Format("insert into preferredPaper Values('{0}', {1})", s, ID));
}
}
DatabaseQuery.DBInsert(String.Format("delete from previouslyDemoed where demoID={0}", ID));
foreach (String s in experience)
{
// prevents empty lines
if (s != "")
{
DatabaseQuery.DBInsert(String.Format("insert into previouslyDemoed Values('{0}', {1})", s, ID));
}
}
DatabaseQuery.DBInsert(String.Format("delete from demoTimeTable where demoID = {0}", ID));
foreach (Tuple <String, String> t in mapBoolToTime(freeTime))
{
DatabaseQuery.DBInsert(String.Format("insert into demoTimeTable Values('{0}','{1}', {2})", t.Item1, t.Item2, ID));
}
// set non free demo time slots
//for (int i = 0; i < freeTime.GetLength(0); i++)
//{
// for (int j = 0; j < freeTime.GetLength(1); j++)
// {
// if (freeTime[i, j])
// DatabaseQuery.DBInsert(String.Format("insert into demoTimeTable Values({0},{1})", ID, intToDay(i), j)); //////////////////////////////////////////////////////////////////////////////// CHANGE i TO MON, TUE etc. j to 1000, 1100, 1200 etc
// }
//}
}
protected void updatePaperToDB(String code, String title, bool[,] times)
{
//Console.WriteLine(String.Format("delete from lab where code='{0}'; delete from paper where code='{0}'", code));
//DatabaseQuery.DBInsert(String.Format("delete from lab where paper='{0}'; delete from paper where code='{0}'", paper.Code));
// will remove assigned demos that are associated to a paper
DatabaseQuery.DBInsert(String.Format(@"delete from Demos where LabID in (
select LabID
from demos d, lab l
where l.paper = '{0}'
and d.labID = l.id);delete from lab where paper='{0}';delete from paper where code='{0}';", paper.Code));
addPaperToDB(code, title, times);
this.mainForm.ListBoxPapers_Refresh();
}
/// <summary>
/// add paper to database.
/// </summary>
/// <param name="title">paper title e.g. infomation discovery</param>
/// <param name="code">paper code e.g. COMP103</param>
/// <param name="times">2D bool array where true indicates time</param>
protected void addPaperToDB(String code, String title, bool[,] times)
{
if (code != "")
{
// add paper
DatabaseQuery.DBInsert("insert into paper Values('" + code + "', '" + title + "')");
// add time for paper
foreach (Tuple <String, String> t in this.mainForm.mapBoolToTime(times))
{
DatabaseQuery.DBInsert(String.Format("insert into lab Values('{0}','{1}', {2}, 'R.G.07')", code, t.Item1, t.Item2));
}
}
else
{
MessageBox.Show("Paper must have a paper code");
}
}
/// <summary>
/// Add demo to database
/// </summary>
public void addToDB()
{
DatabaseQuery.DBInsert(String.Format("INSERT INTO DEMONSTRATOR(studentID, name) VALUES('{0}', '{1}')", ID, firstName));
updateDB();
}
