protected void Quizzbtn_Click(object sender, EventArgs e)
{
if (QuizzUpload.FileName == null)
{
}
else
{
string filename = Path.GetFileName(QuizzUpload.PostedFile.FileName);
string Extension = Path.GetExtension(QuizzUpload.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/LMS/QuizzResult/" + filename);
QuizzUpload.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int crsid = int.Parse(Request.QueryString["course"]);
Quizz_tbl qtbl = new Quizz_tbl {
CourseID = crsid, QuizzTitle = quizzTitle.Text, Total_Marks = int.Parse(quizzmarks.Text), Quizz_date = QuizzCalendar.SelectedDate.Date
};
int qid = db.addquizzresult(qtbl);
foreach (System.Data.DataRow row in dt.Rows)
{
string stdids = row[0].ToString();
string marks = row[1].ToString();
Student_Quizz_Mapping_tbl sqm = new Student_Quizz_Mapping_tbl {
QuizzID = qid, StudentID = int.Parse(stdids), Mark_Obtained = int.Parse(marks)
};
//Results_tbl result = new Results_tbl { CourseID = int.Parse(DropDownCourse.SelectedValue), MetricNo = row[0].ToString(), TotalMarks = int.Parse(row[1].ToString()), ObtainedMarks = int.Parse(row[2].ToString()), Year = row[3].ToString(), ExamType = row[4].ToString() };
db.quizzmarksinsertion(sqm);
}
Response.Redirect("UploadAssignments.aspx?course=" + crsid + "&tab=quizz");
}
}
protected void Quizzbtn_Click(object sender, EventArgs e)
{
if (QuizzUpload.FileName == null)
{
}
else
{
string filename = Path.GetFileName(QuizzUpload.PostedFile.FileName);
string Extension = Path.GetExtension(QuizzUpload.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/LMS/QuizzResult/" + filename);
QuizzUpload.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int crsid = int.Parse(Request.QueryString["course"]);
Quizz_tbl qtbl = new Quizz_tbl { CourseID = crsid, QuizzTitle = quizzTitle.Text, Total_Marks = int.Parse(quizzmarks.Text), Quizz_date = QuizzCalendar.SelectedDate.Date };
int qid=db.addquizzresult(qtbl);
foreach (System.Data.DataRow row in dt.Rows)
{
string stdids = row[0].ToString();
string marks = row[1].ToString();
Student_Quizz_Mapping_tbl sqm = new Student_Quizz_Mapping_tbl {QuizzID=qid,StudentID=int.Parse(stdids),Mark_Obtained=int.Parse(marks) };
//Results_tbl result = new Results_tbl { CourseID = int.Parse(DropDownCourse.SelectedValue), MetricNo = row[0].ToString(), TotalMarks = int.Parse(row[1].ToString()), ObtainedMarks = int.Parse(row[2].ToString()), Year = row[3].ToString(), ExamType = row[4].ToString() };
db.quizzmarksinsertion(sqm);
}
Response.Redirect("UploadAssignments.aspx?course=" + crsid + "&tab=quizz");
}
}
public int addquizzresult(Quizz_tbl qtbl)
{
db = new CollegeERPDBEntities();
db.Quizz_tbl.Add(qtbl);
db.SaveChanges();
return qtbl.ID;
}
