protected void UplaodAsgmtresult_Click(object sender, EventArgs e)
{
if (AssignmentResultUplaod.FileName == null)
{
}
else
{
string filename = Path.GetFileName(AssignmentResultUplaod.PostedFile.FileName);
string Extension = Path.GetExtension(AssignmentResultUplaod.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/LMS/AssignmentResults/" + filename);
AssignmentResultUplaod.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int assinmentId = int.Parse(Session["asgmtid"].ToString());
int crsid = int.Parse(Request.QueryString["course"]);
foreach (System.Data.DataRow row in dt.Rows)
{
string stdids = row[0].ToString();
string marks = row[1].ToString();
Assignment_Result_tbl assresult = new Assignment_Result_tbl {
AssignmentID = assinmentId, StudentiID = int.Parse(stdids), Assignment_Marks = 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.addassignmentresult(assresult);
}
Response.Redirect("UploadAssignments.aspx?course=" + crsid + "&tab=assignments");
}
}
protected void UplaodAsgmtresult_Click(object sender, EventArgs e)
{
if (AssignmentResultUplaod.FileName == null)
{
}
else
{
string filename = Path.GetFileName(AssignmentResultUplaod.PostedFile.FileName);
string Extension = Path.GetExtension(AssignmentResultUplaod.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/LMS/AssignmentResults/" + filename);
AssignmentResultUplaod.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int assinmentId = int.Parse(Session["asgmtid"].ToString());
int crsid = int.Parse(Request.QueryString["course"]);
foreach (System.Data.DataRow row in dt.Rows)
{
string stdids = row[0].ToString();
string marks = row[1].ToString();
Assignment_Result_tbl assresult = new Assignment_Result_tbl { AssignmentID = assinmentId, StudentiID = int.Parse(stdids), Assignment_Marks = 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.addassignmentresult(assresult);
}
Response.Redirect("UploadAssignments.aspx?course=" + crsid + "&tab=assignments");
}
}
public void addassignmentresult(Assignment_Result_tbl assresult)
{
db = new CollegeERPDBEntities();
db.Assignment_Result_tbl.Add(assresult);
db.SaveChanges();
}
