protected void btnSave_Click(object sender, EventArgs e)
{
var existmarkscard = muentities.MarksCards.Where(d => d.RegisterNumber == txtRegisterNumber.Text).ToList();
foreach (var v in existmarkscard)
{
v.RegisterNumber += v.RegisterNumber + "_OLD";
}
var oldexistmarkscard = muentities.OldResultMaps.Where(d => d.RegisterNumber == txtRegisterNumber.Text).ToList();
foreach (var v in oldexistmarkscard)
{
v.RegisterNumber += v.RegisterNumber + "_OLD";
}
muentities.SaveChanges();
foreach (OldResultMap m in resultMap)
{
muentities.OldResultMaps.Add(m);
}
var student = entities.Students.FirstOrDefault(s => s.RegisterNumber == txtRegisterNumber.Text);
string uniqueNumber = student.Cours.Code + Guid.NewGuid().ToString().ToUpper().Replace("-", "");
foreach (MarksCard m in markscard)
{
m.UniqueNumber = uniqueNumber.Replace("-", "");
m.SemesterAlphaSign = ddlSemesterAlphaSign.SelectedValue.ToString();
m.SemesterClass = ddlSelectSemesterClass.SelectedValue.ToString();
m.SemesterCredits = txtNetCredits.Text;
m.SemesterMax = int.Parse(txtNetSemesterMax.Text);
m.SemesterPercentage = txtNetSemesterPercentage.Text;
m.SemesterTotal = int.Parse(txtNetSemesterTotal.Text);
m.TotalGP = txtNetGPA.Text;
m.TotalGPW = txtNetGPW.Text;
m.SemesterGPA = txtSemGPA.Text;
m.ExaminationYear = txtExaminationYear.Text;
m.PrintDate = txtPrintDate.Text;
muentities.MarksCards.Add(m);
}
muentities.SaveChanges();
Response.Redirect("GenerateMarksCard.aspx?mid=" + uniqueNumber);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string error = string.Empty;
Revaluation rev = new Revaluation();
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox chkPS = (CheckBox)row.FindControl("chkPersonalSeeing");
CheckBox chkRev = (CheckBox)row.FindControl("chkRevaluation");
rev.CourseName = row.Cells[0].Text;
rev.Semester = row.Cells[1].Text;
rev.RegisterNumber = txtRegisterNumber.Text;
rev.StudentName = entities.Students.FirstOrDefault(d => d.RegisterNumber == txtRegisterNumber.Text).FirstName;
rev.SubjectName = row.Cells[2].Text;
rev.SubjectCode = row.Cells[3].Text;
rev.BatchNo = row.Cells[4].Text;
rev.DummyNo = row.Cells[5].Text;
rev.IsPersonalSeeing = chkPS.Checked == true ? 1 : 0;
rev.IsRevaluation = chkRev.Checked == true ? 1 : 0;
muentities.Revaluations.Add(rev);
muentities.SaveChanges();
}
pnlMessagePanel.Visible = true;
lblMessageBox.Text = error + "Data Saved Successfully";
}
public static void UpdateRepeateResults(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem && d.YearText.Length > 0)
.Select(d => d.RegisterNumber).Distinct().ToList();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
Console.WriteLine((i++) + "|" + regno);
entities = new MUPRJEntities();
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem &&
d.YearText.Length > 0
))
{
items.TheoryNetTotal = "-";
items.TheoryTotal = "-";
items.TheoryIATotal = "-";
items.PracticalNetTotal = "-";
items.PracticalTotal = "-";
items.PracticalIATotal = "-";
items.VivaVoice = "-";
items.Remarks = "-";
items.TotalMarks = "-";
items.SubjectCredits = "-";
items.SubjectGPA = "-";
items.SubjectGPW = "-";
}
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem &&
d.IsSemesterPass == "0"
))
{
items.SemesterPercentage = "-";
items.SemesterCredits = "-";
items.SemesterGPA = "-";
items.TotalGP = "-";
items.TotalGPW = "-";
items.SemesterAlphaSign = "-";
}
entities.SaveChanges();
}
}
public static void AllocateUniqueNumbers(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem)
.Select(d => d.RegisterNumber).Distinct();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
entities = new MUPRJEntities();
string markscard = Guid.NewGuid().ToString();
Console.WriteLine((i++) + "|" + regno + "|" + markscard);
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno && d.YearSem == yearsem))
{
items.UniqueNumber = items.CourseCode + "2015" + markscard.Replace("-", "").ToUpper();
}
entities.SaveChanges();
}
}
protected void btnAddUser_Click(object sender, EventArgs e)
{
if (!(string.IsNullOrEmpty(txtFirstName.Text) ||
string.IsNullOrEmpty(txtUserName.Text) ||
string.IsNullOrEmpty(txtPassword.Text)))
{
MUOffLoad.User user = new MUOffLoad.User();
user.CreatedDate = DateTime.Now;
user.FirstName = txtFirstName.Text;
user.Password = txtPassword.Text;
user.UserName = txtUserName.Text;
muentities.Users.Add(user);
muentities.SaveChanges();
pnlMessagePanel.Visible = true;
lblMessageBox.Text = "User added successfully";
}
else
{
pnlMessagePanel.Visible = true;
lblMessageBox.Text = "All fields are mandatory";
}
}
public static void UpdateFailResults(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem && d.Remarks == "FAIL")
.Select(d => d.RegisterNumber).Distinct();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
Console.WriteLine((i++) + "|" + regno);
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem &&
d.Remarks == "FAIL"
))
{
items.SubjectCredits = "-";
items.SubjectGPA = "-";
items.SubjectGPW = "-";
}
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem
))
{
items.SemesterPercentage = "-";
items.SemesterCredits = "-";
items.SemesterGPA = "-";
items.TotalGP = "-";
items.TotalGPW = "-";
items.SemesterAlphaSign = "-";
}
}
entities.SaveChanges();
}
public static void UpdateAbsentes(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem && d.Remarks == "ABSENT")
.Select(d => d.RegisterNumber).Distinct();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
Console.WriteLine((i++) + "|" + regno);
entities = new MUPRJEntities();
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem &&
d.Remarks == "ABSENT"
))
{
int subjectMarks = 0;
int currentMarks = 0;
if (int.TryParse(items.TheoryTotal, out currentMarks))
{
subjectMarks += currentMarks;
}
if (int.TryParse(items.TheoryIATotal, out currentMarks))
{
subjectMarks += currentMarks;
}
if (int.TryParse(items.PracticalTotal, out currentMarks))
{
subjectMarks += currentMarks;
}
if (int.TryParse(items.PracticalIATotal, out currentMarks))
{
subjectMarks += currentMarks;
}
items.SubjectCredits = "-";
items.SubjectGPA = "-";
items.SubjectGPW = "-";
items.TotalMarks = subjectMarks.ToString();
}
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno &&
d.YearSem == yearsem
))
{
items.SemesterPercentage = "-";
items.SemesterCredits = "-";
items.SemesterGPA = "-";
items.TotalGP = "-";
items.TotalGPW = "-";
items.SemesterAlphaSign = "-";
}
entities.SaveChanges();
}
}
public static void ImportData(string regno, int yearsem)
{
var exist = entities.MarksCards.Where(e => e.RegisterNumber == regno && e.YearSem == yearsem);
foreach (var r in exist)
{
r.RegisterNumber += "_OLD";
}
entities.SaveChanges();
var student = infinityentities.Students.FirstOrDefault(d => d.RegisterNumber == regno);
var did = infinityentities.Degrees.FirstOrDefault(i => i.DegreeId == student.DegreeId);
if (student != null)
{
var UGres = entities.UGFinalResultTables.Where(r => r.RegisterNumber == regno && r.YearSem == yearsem).ToList();
foreach (var r in UGres)
{
var subject = entities.mdbSubjectPaperDetails.FirstOrDefault(d => d.SubjectPaperCode == r.SubjectCode);
var max = entities.DegreeMaxes.FirstOrDefault(x => x.DegreeName == did.Name && x.YearSem == yearsem);
var grp = entities.GroupNames.FirstOrDefault(g => g.SubjectName == r.SubjectName);
MarksCard m = new MarksCard();
m.RegisterNumber = r.RegisterNumber;
m.StudentName = student.FirstName;
m.CollegeName = student.College.Name;
m.CollegeCode = student.College.Code;
m.DegreeName = r.DegreeName;
m.YearSem = r.YearSem;
m.GroupName = grp.GroupName1;
m.SubGroupName = r.SubGroupName;
m.SubjectName = r.SubjectName;
m.SubjectCode = r.SubjectCode;
m.TheoryGrace = r.TheoryGrace;
m.TheoryMarks = r.TheoryMarks;
m.TheoryMin = r.TheoryMin;
m.TheoryMax = r.TheoryMax;
m.TheoryTotal = r.TheoryTotal;
m.TheoryIAMarks = r.TheoryIAMarks;
m.TheoryIAGrace = r.TheoryIAGrace;
m.TheoryIAMin = r.TheoryIAMin;
m.TheoryIAMax = r.TheoryIAMax;
m.TheoryIATotal = r.TheoryIATotal;
m.TheoryNetTotal = r.TheoryNetTotal;
m.PracticalMarks = r.PracticalMarks;
m.PracticalGrace = r.PracticalGrace;
m.PracticalMin = r.PracticalMin;
m.PracticalMax = r.PracticalMax;
m.PracticalTotal = r.PracticalTotal;
m.PracticalIAMarks = r.PracticalIAMarks;
m.PracticalIAGrace = r.PracticalIAGrace;
m.PracticalIAMin = r.PracticalIAMin;
m.PracticalIAMax = r.PracticalIAMax;
m.PracticalIATotal = r.PracticalIATotal;
m.PracticalNetTotal = r.PracticalNetTotal;
m.VivaVoice = r.VivaVoice;
m.VivaVoiceMin = r.VivaVoiceMin;
m.VivaVoiceMax = r.VivaVoiceMax;
m.SubjectTotal = r.SubjectTotal;
m.SubGroupTotal = r.SubGroupTotal;
m.GroupTotal = r.GroupTotal;
m.TotalMarks = r.TotalMarks;
m.SubjectMin = r.SubjectMin;
m.SubjectMax = r.SubjectMax;
m.SubjectCredits = r.SubjectCredits.ToString();
m.SubjectGPA = r.SubjectGPA.ToString();
m.SubjectGPW = r.SubjectGPW.ToString();
m.CreatedDate = r.CreatedDate;
m.IsSubjectPass = r.IsSubjectPass;
m.MarksPercent = r.MarksPercent;
m.AlphaSign = r.AlphaSign;
m.SemesterCredits = r.SemesterCredits.ToString();
m.SemesterMax = (int)max.SemesterMax;
m.SemesterMin = r.SemesterMin;
m.SemesterTotal = r.SemesterTotal;
m.SemesterPercentage = r.SemesterPercentage.ToString();
m.SemesterGPA = r.SemesterGPA.ToString();
m.SemesterClass = r.SemesterClass;
m.SemesterAlphaSign = r.SemesterAlphaSign;
m.IsSemesterPass = r.IsSemesterPass.ToString();
m.Remarks = r.Remarks;
m.YearText = r.YearText;
m.CourseCode = student.Cours.Code;
m.SubjectType = subject.SubjectPaperType;
m.MarksCardOrder = (int)grp.MarksCardOrder;
entities.MarksCards.Add(m);
semesterTotal = (int)max.SemesterMax;
entities.SaveChanges();
}
}
}
public static void UpdateSemesterGPW(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem)
.Select(d => d.RegisterNumber).Distinct().ToList();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
Console.WriteLine((i++) + "|" + regno);
entities = new MUPRJEntities();
float totalGPW = 0;
float totalGP = 0;
float totalSemester = 0;
float totalPercentage = 0.0F;
float totalCredits = 0.0F;
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno && d.YearSem == yearsem))
{
int subjecttotal;
float subjectCredits;
float subjectGP;
float subjectGPW;
if (int.TryParse(items.TotalMarks, out subjecttotal))
{
totalSemester += subjecttotal;
}
if (float.TryParse(items.SubjectCredits, out subjectCredits))
{
totalCredits += subjectCredits;
}
if (float.TryParse(items.SubjectGPA, out subjectGP))
{
totalGP += subjectGP;
}
if (float.TryParse(items.SubjectGPW, out subjectGPW))
{
totalGPW += subjectGPW;
}
}
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno && d.YearSem == yearsem))
{
items.TotalGPW = totalGPW.ToString();
items.TotalGP = totalGP.ToString();
items.SemesterTotal = (int)totalSemester;
items.SemesterCredits = totalCredits.ToString();
items.SemesterMax = semesterTotal;
items.SemesterGPA = (totalCredits > 0 ? (totalGPW / totalCredits) : 0.0).ToString();
items.SemesterPercentage = Math.Round(((totalSemester / (float)semesterTotal) * 100), 2).ToString();
float semesterAggragate = ((totalSemester / (float)semesterTotal) * 100);
string semesterAlphaSign = "D";
float semesterGPA = 0.0F;
if (float.TryParse(items.SemesterGPA, out semesterGPA))
{
items.SemesterGPA = Math.Round(semesterGPA, 2).ToString();
}
if (semesterAggragate < 35)
{
semesterAlphaSign = "D";
}
if (semesterAggragate >= 35 && semesterAggragate < 50)
{
semesterAlphaSign = "C";
}
if (semesterAggragate >= 50 && semesterAggragate < 55)
{
semesterAlphaSign = "B";
}
if (semesterAggragate >= 55 && semesterAggragate < 60)
{
semesterAlphaSign = "B+";
}
if (semesterAggragate >= 60 && semesterAggragate < 70)
{
semesterAlphaSign = "A";
}
if (semesterAggragate >= 70 && semesterAggragate < 80)
{
semesterAlphaSign = "A+";
}
if (semesterAggragate >= 80 && semesterAggragate < 90)
{
semesterAlphaSign = "A++";
}
if (semesterAggragate >= 90 && semesterAggragate < 100)
{
semesterAlphaSign = "O";
}
items.SemesterAlphaSign = semesterAlphaSign;
}
entities.SaveChanges();
}
}
public static void UpdateSubjectGPA(string registernumber, int yearsem)
{
var entities = new MUPRJEntities();
var distictRegisterNumbers = entities.MarksCards.Where(d => d.RegisterNumber == registernumber && d.YearSem == yearsem)
.Select(d => d.RegisterNumber).Distinct();
int i = 0;
foreach (var regno in distictRegisterNumbers)
{
Console.WriteLine((i++) + "|" + regno);
foreach (var items in entities.MarksCards.Where(d => d.RegisterNumber == regno && d.YearSem == yearsem))
{
int subjectTotal = 0;
if (int.TryParse(items.TotalMarks, out subjectTotal))
{
float ap = subjectTotal > 0 ? ((float)subjectTotal / (float)items.SubjectMax) * 100 : 0;
string grade = "D";
int GPA = 2;
if (ap < 35)
{
GPA = 2;
grade = "D";
}
if (ap >= 35 && ap < 50)
{
GPA = 3;
grade = "C";
}
if (ap >= 50 && ap < 55)
{
GPA = 4;
grade = "B";
}
if (ap >= 55 && ap < 60)
{
GPA = 5;
grade = "B+";
}
if (ap >= 60 && ap < 70)
{
GPA = 6;
grade = "A";
}
if (ap >= 70 && ap < 80)
{
GPA = 7;
grade = "A+";
}
if (ap >= 80 && ap < 90)
{
GPA = 8;
grade = "A++";
}
if (ap >= 90 && ap <= 100)
{
GPA = 9;
grade = "O";
}
items.SubjectGPA = GPA.ToString();
items.SubjectGPW = (int.Parse(items.SubjectCredits) * GPA).ToString();
//if (!subject)
//{
// GPA = 0;
// grade = "";
//}
}
}
}
entities.SaveChanges();
}
