private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
selectedIndexComB1 = comboBox1.SelectedIndex;
Object o = list.Asl.ElementAt(selectedIndexComB1);
Assignment a = (Assignment)o;
int assignmentIndex = a.Id;
Service1Client winService = new Service1Client();
ListForObjects hl = winService.GetAllHomeworksById(assignmentIndex);
List <Homework> homeworks = new List <Homework>();
foreach (Object ob in hl.Asl)
{
Homework h = (Homework)ob;
homeworks.Add(h);
}
//makes a new List with two attributes of childs name and the path
//To avoid makeing a new wrapper and instead of child objects address it displays its name
List <Tuple <string, string> > nameList = new List <Tuple <string, string> >();
foreach (Homework hmw in homeworks)
{
nameList.Add(new Tuple <string, string>(hmw.Child.Name, hmw.DiskName));
}
//If there are columns it removes the last button column so that the other columns
//don't lose their indexes after data change
if (dataGridView1.Columns.Count > 0)
{
dataGridView1.Columns.Remove("Download");
}
//Creates new data and replaces the data in the table
DataSet ds = new DataSet();
BindingSource bs = new BindingSource();
bs.DataSource = nameList;
dataGridView1.DataSource = bs;
dataGridView1.Columns[0].HeaderText = "Name";
dataGridView1.Columns[1].HeaderText = "Path";
//Adds the button column as the last column
DataGridViewButtonColumn btnCol = new DataGridViewButtonColumn();
btnCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
btnCol.Text = "Download";
btnCol.Name = "Download";
btnCol.UseColumnTextForButtonValue = true;
btnCol.HeaderText = "Download";
dataGridView1.Columns.Add(btnCol);
}
public ListForObjects GetAllAssignmentsByTeacherId(int teacherId)
{
AssignmentDb asDB = new AssignmentDb();
PersonCtrl userCtrl = new PersonCtrl();
ListForObjects list = new ListForObjects();
ListForObjects l = asDB.GetAllAssignmentsByTeacherId(teacherId);
foreach (Object o in l.Asl)
{
Assignment a = (Assignment)o;
a.teacher = (Teacher)userCtrl.GetPerson(a.teacher.Id);
list.Asl.Add(a);
}
return(list);
}
public ListForObjects GetAllHomeworksByID(int assignmentId)
{
HomeworkDb hwDb = new HomeworkDb();
PersonCtrl userCtrl = new PersonCtrl();
AssignmentCtrl assgnmentCtrl = new AssignmentCtrl();
ListForObjects l = hwDb.GetAllHomeworksById(assignmentId);
ListForObjects list = new ListForObjects();
foreach (Homework hw in l.Asl)
{
hw.Child = (Child)userCtrl.GetPerson(hw.Child.Id);
//hw.Assignment = assgnmentCtrl.GetAssignmentById(hw.Assignment.Id);
list.Asl.Add(hw);
}
return(list);
}
public ListForObjects GetAllHomeworksById(int assignmentId)
{
ListForObjects homeworkList = new ListForObjects();
try
{
comm = new SqlCommand();
comm.CommandText = "SELECT * FROM Homework WHERE assignmentId = " + assignmentId;
dbCon = new DbConnection();
comm.Connection = dbCon.GetConnection();
comm.Connection.Open();
comm.CommandType = CommandType.Text;
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
Homework h = new Homework();
h.Id = Convert.ToInt32(dr["hid"]);
Assignment a = new Assignment();
a.Id = Convert.ToInt32(dr["assignmentId"]);
h.Assignment = a;
Child c = new Child();
c.Id = Convert.ToInt32(dr["childId"]);
h.Child = c;
h.Date = Convert.ToDateTime(dr["date"]);
h.DiskName = Convert.ToString(dr["diskName"]);
homeworkList.AddObj(h);
}
}
catch (Exception)
{
throw;
}
finally
{
comm.Connection.Close();
}
return(homeworkList);
}
public ListForObjects GetAllAssignmentsByTeacherId(int teacherId)
{
ListForObjects al = new ListForObjects();
try
{
comm = new SqlCommand();
comm.CommandText = "SELECT * FROM Assignment WHERE pid = " + teacherId;
dbCon = new DbConnection();
comm.Connection = dbCon.GetConnection();
comm.Connection.Open();
comm.CommandType = CommandType.Text;
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
Assignment a = new Assignment();
a.Id = Convert.ToInt32(dr["aid"]);
a.exercise = Convert.ToString(dr["exercise"]);
a.date = Convert.ToDateTime(dr["date"]);
a.deadline = Convert.ToDateTime(dr["deadLine"]);
a.subject = Convert.ToString(dr["subject"]);
Teacher t = new Teacher();
t.Id = Convert.ToInt32(dr["pid"]);
a.teacher = t;
a.title = Convert.ToString(dr["title"]);
al.AddObj(a);
}
}
catch (Exception)
{
throw;
}
finally
{
comm.Connection.Close();
}
return(al);
}
private List <String> populateAssignmentCB()
{
Service1Client winService = new Service1Client();
strings = new List <string>();
list = winService.GetAllAssignmentsForTeacherById(teacher.Id);
foreach (Object o in list.Asl)
{
Assignment a = (Assignment)o;
strings.Add(a.title);
}
//creates new data and replaces the data in drop down list
DataSet ds = new DataSet();
BindingSource bs = new BindingSource();
bs.DataSource = strings;
comboBox1.DataSource = bs;
return(strings);
}
//Need to clean up a code a bit for the method below
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
selectedIndexComB1 = comboBox1.SelectedIndex;
Object o = list.Asl.ElementAt(selectedIndexComB1);
Assignment a = (Assignment)o;
int assignmentIndex = a.Id;
Service1Client winService = new Service1Client();
ListForObjects hl = winService.GetAllHomeworksById(assignmentIndex);
var gridSender = (DataGridView)sender;
if (gridSender.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0)
{
int index = e.RowIndex;
Object ob = hl.Asl.ElementAt(index);
Homework homework = (Homework)ob;
//Simulating download by showing download path...
MessageBox.Show("The file is downloaded. Path of download was : " + homework.DiskName);
}
}
private List<String> populateAssignmentCB()
{
Service1Client winService = new Service1Client();
strings = new List<string>();
list = winService.GetAllAssignmentsForTeacherById(teacher.Id);
foreach (Object o in list.Asl)
{
Assignment a = (Assignment)o;
strings.Add(a.title);
}
//creates new data and replaces the data in drop down list
DataSet ds = new DataSet();
BindingSource bs = new BindingSource();
bs.DataSource = strings;
comboBox1.DataSource = bs;
return strings;
}