private void cmdGetFiles_Click(object sender, EventArgs e)
{
string filesDir = Path.Combine(folder, _config.BareName);
DirectoryInfo d = new DirectoryInfo(filesDir);
if (!d.Exists)
{
d.Create();
}
var dt = _config.GetDataTable(
"select * from tb_submissions");
var iCnt = 0;
foreach (DataRow item in dt.Rows)
{
var minSub = new TurnitInSubmission(
item["SUB_UserId"].ToString(),
item["SUB_PaperId"].ToString(),
item["SUB_Title"].ToString()
);
if (minSub.DownloadDocument(filesDir, elpSessionId.Text))
iCnt++;
}
MessageBox.Show(iCnt + " documents downloaded");
}
private void cmdFetch_Click(object sender, EventArgs e)
{
students.Clear();
if (!File.Exists(fullname))
{
MessageBox.Show("Excel File not found");
return;
}
var con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fullname + ";Extended Properties=Excel 8.0;"); // Extended Properties=Excel 8.0;
con.Open();
var da = new OleDbDataAdapter("select * from [Sheet1$]", con);
var dt = new DataTable();
da.Fill(dt);
con.Close();
foreach (DataRow row in dt.Rows)
{
var stud = new TurnitInSubmission();
foreach (DataColumn col in dt.Columns)
{
var val = row[col.ColumnName].ToString();
if (val != string.Empty)
{
stud.SetProp(val, col.ColumnName);
}
}
students.Add(stud);
}
MessageBox.Show(
string.Format("{0} submissions found", students.Count)
);
if (students.Count > 0)
cmdMakeDatabase.Enabled = true;
}
