public int addresults(Results_tbl result)
{
db = new CollegeERPDBEntities();
db.Results_tbl.Add(result);
db.SaveChanges();
return result.ID;
}
protected void uplaodfile_Click(object sender, EventArgs e)
{
if(Resultfile.FileName==null)
{
}
else
{
string filename = Path.GetFileName(Resultfile.PostedFile.FileName);
string Extension = Path.GetExtension(Resultfile.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/Admin/Temp_UploadedFiles/" + filename);
Resultfile.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int grade = 1008; //None Grade For Mid Result
foreach (System.Data.DataRow row in dt.Rows)
{
if (row[4].ToString().ToLower() != "mid")
{
if (int.Parse(row[2].ToString()) >= 90)
grade = 1;//A Grade
else if (int.Parse(row[2].ToString()) >= 85 && int.Parse(row[2].ToString()) < 90)
grade = 2;//A- Grade
else if (int.Parse(row[2].ToString()) >= 80 && int.Parse(row[2].ToString()) < 85)
grade = 3;//B+ Grade
else if (int.Parse(row[2].ToString()) >= 70 && int.Parse(row[2].ToString()) < 80)
grade = 4;//B Grade
else if (int.Parse(row[2].ToString()) >= 60 && int.Parse(row[2].ToString()) < 70)
grade = 5;//B- Grade
else if (int.Parse(row[2].ToString()) >= 55 && int.Parse(row[2].ToString()) < 60)
grade = 6;//C+ Grade
else if (int.Parse(row[2].ToString()) >= 50 && int.Parse(row[2].ToString()) < 55)
grade = 7;//C Grade
else if (int.Parse(row[2].ToString()) >= 45 && int.Parse(row[2].ToString()) < 50)
grade = 8;
else if (int.Parse(row[2].ToString()) < 45)
grade = 9; //F Grade
}
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(), Semester = int.Parse(row[5].ToString()),GradeID=grade};
//string marks = row[0].ToString();
db.addresults(result);
LabelUpload.Text = "Result Uploaded.";
LabelUpload.Visible = true;
AddmissionList_tbl student= db.getstudentinfoFromMetrcino(result.MetricNo);
if(grade!=9)
{
db.updateenrollment(student.UserID.Value, result.CourseID.Value,2); //Pass
}
else
{
db.updateenrollment(student.UserID.Value, result.CourseID.Value, 3); //Fail
}
}
}
}
protected void uplaodfile_Click(object sender, EventArgs e)
{
if (Resultfile.FileName == null)
{
}
else
{
string filename = Path.GetFileName(Resultfile.PostedFile.FileName);
string Extension = Path.GetExtension(Resultfile.PostedFile.FileName);
long milliseconds = (DateTime.Now.Ticks / TimeSpan.TicksPerMillisecond) / 1000;
string orgPath = string.Empty;
orgPath = Server.MapPath("~/Admin/Temp_UploadedFiles/" + filename);
Resultfile.SaveAs(orgPath);
System.Data.DataTable dt = Import_To_Grid(orgPath, Extension, "Yes");
DBFunctions db = new DBFunctions();
int grade = 1008; //None Grade For Mid Result
foreach (System.Data.DataRow row in dt.Rows)
{
if (row[4].ToString().ToLower() != "mid")
{
if (int.Parse(row[2].ToString()) >= 90)
{
grade = 1;//A Grade
}
else if (int.Parse(row[2].ToString()) >= 85 && int.Parse(row[2].ToString()) < 90)
{
grade = 2;//A- Grade
}
else if (int.Parse(row[2].ToString()) >= 80 && int.Parse(row[2].ToString()) < 85)
{
grade = 3;//B+ Grade
}
else if (int.Parse(row[2].ToString()) >= 70 && int.Parse(row[2].ToString()) < 80)
{
grade = 4;//B Grade
}
else if (int.Parse(row[2].ToString()) >= 60 && int.Parse(row[2].ToString()) < 70)
{
grade = 5;//B- Grade
}
else if (int.Parse(row[2].ToString()) >= 55 && int.Parse(row[2].ToString()) < 60)
{
grade = 6;//C+ Grade
}
else if (int.Parse(row[2].ToString()) >= 50 && int.Parse(row[2].ToString()) < 55)
{
grade = 7;//C Grade
}
else if (int.Parse(row[2].ToString()) >= 45 && int.Parse(row[2].ToString()) < 50)
{
grade = 8;
}
else if (int.Parse(row[2].ToString()) < 45)
{
grade = 9; //F Grade
}
}
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(), Semester = int.Parse(row[5].ToString()), GradeID = grade
};
//string marks = row[0].ToString();
db.addresults(result);
LabelUpload.Text = "Result Uploaded.";
LabelUpload.Visible = true;
AddmissionList_tbl student = db.getstudentinfoFromMetrcino(result.MetricNo);
if (grade != 9)
{
db.updateenrollment(student.UserID.Value, result.CourseID.Value, 2); //Pass
}
else
{
db.updateenrollment(student.UserID.Value, result.CourseID.Value, 3); //Fail
}
}
}
}