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; }