/// <summary>
/// Function to make the student Login
/// </summary>
/// <param name="studentInfo"></param>
/// <returns></returns>
public bool StudentLogin(StudentInfo studentInfo)
{
return(true);
bool IsStudentRegistered = false;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
// Administrator admin = new Administrator();
var filteredResult = from s in db.StudentInformations
select s;
foreach (var item in filteredResult)
{
if (item.Name == studentInfo.Name && item.StudentCnic == studentInfo.StudentCnic)
{
IsStudentRegistered = true;
break;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(IsStudentRegistered);
}
/// <summary>
/// Function To get All the Data From the Database And Put It In the List
/// </summary>
/// <returns></returns>
public List <StudentInfo> GetStudentDataList()
{
List <StudentInfo> studentList = new List <StudentInfo>();
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var students = from std in db.StudentInformations select std;
foreach (StudentInformation info in students)
{
StudentInfo studentInformation = new StudentInfo();
studentInformation.Name = info.Name;
studentInformation.FatherName = info.FatherName;
studentInformation.StudentCnic = info.StudentCnic;
studentInformation.Gender = info.Gender;
studentInformation.Email = info.Email;
studentInformation.Batch = info.Batch;
studentInformation.PhoneNo = info.PhoneNo;
studentInformation.DateOfBirth = info.DateOfBirth;
studentInformation.Address = info.Address;
studentInformation.StudentImage = info.StudentImage;
studentList.Add(studentInformation);
}
}
return(studentList);
}
/// <summary>
/// function to return the student data based on the given cnic no
/// </summary>
/// <param name="cnic"></param>
/// <returns></returns>
public StudentInfo getStudentInfo(int cnic)
{
StudentInfo studentInfo = new StudentInfo();
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var studentInformation = (from s in db.StudentInformations
where s.StudentCnic == cnic
select s).FirstOrDefault();
studentInfo.StudentCnic = studentInformation.StudentCnic;
studentInfo.Name = studentInformation.Name;
studentInfo.StudentImage = studentInformation.StudentImage;
studentInfo.ExamPaperId = studentInformation.ExamPaperId;
Console.WriteLine(studentInformation.StudentImage);
Console.WriteLine(studentInformation.Name);
Console.WriteLine(studentInformation.StudentCnic);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(studentInfo);
}
/// <summary>
/// Function for the admin
/// </summary>
/// <param name="adminInfo"></param>
/// <returns></returns>
public bool AdminLogin(AdministratorInfo adminInfo)
{
Console.WriteLine("Into the admin login section");
bool IsAdminRegistered = false;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
// Administrator admin = new Administrator();
var filteredResult = from s in db.Administrators
select s;
foreach (var item in filteredResult)
{
if (item.UserName == adminInfo.UserName && item.Password == adminInfo.Password)
{
IsAdminRegistered = true;
break;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(IsAdminRegistered);
}
/// <summary>
/// Service Function For Updating the Student Information
/// </summary>
/// <param name="std"></param>
public bool UpdateUsingObject(StudentInfo std)
{
bool IsStudentUpdated;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var c = (from student in db.StudentInformations
where student.StudentCnic == std.StudentCnic
select student).First();
c.Name = std.Name;
c.FatherName = std.FatherName;
c.Email = std.Email;
c.PhoneNo = std.PhoneNo;
c.Gender = std.Gender;
c.Batch = std.Batch;
c.DateOfBirth = std.DateOfBirth;
c.Address = std.Address;
db.SaveChanges();
Console.WriteLine("Data Saved Successfully");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
IsStudentUpdated = true;
}
return(IsStudentUpdated);
}
/// <summary>
/// Function To Delete The Student From The Database
/// </summary>
/// <param name="Cnic">This is the cnic no upon which whole of the record will be deleted</param>
/// <returns></returns>
public bool DeleteStudentInfo(int Cnic)
{
bool IsStudentDeleted;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
// This will bring the record only belong to that cnic number
var StudentRecord = (from Student in db.StudentInformations
where Student.StudentCnic == Cnic
select Student).First();
// This will remove the object record
db.StudentInformations.Remove(StudentRecord);
db.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
IsStudentDeleted = true;
}
return(IsStudentDeleted);
}
/// <summary>
/// Function to get Question that will be used in the quiz module
/// </summary>
/// <param name="Cnic">User cnic number</param>
/// <returns></returns>
public List <ServerInterfaces.Question> getAllQuestionsForQuiz(long Cnic)
{
List <ServerInterfaces.Question> questionList = new List <ServerInterfaces.Question>();
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var result = from question in db.Questions
join student in db.StudentInformations on question.PaperId equals student.ExamPaperId
join paper in db.ExamPapers on question.PaperId equals paper.Id
where student.StudentCnic == Cnic
select question;
foreach (Question q in result)
{
ServerInterfaces.Question questions = new ServerInterfaces.Question();
questions.Id = q.Id;
questions.OptionA = q.OptionA;
questions.OptionB = q.OptionB;
questions.OptionC = q.OptionC;
questions.OptionD = q.OptionD;
questions.PaperId = q.PaperId;
questions.Question1 = q.Question1;
questions.CorrectAns = q.CorrectAns;
questionList.Add(questions);
}
}
return(questionList);
}
/// <summary>
/// Function to get the List of All the questions used in paper pool module
/// </summary>
/// <returns></returns>
public List <ServerInterfaces.Question> getAllQuestions(string paperId)
{
List <ServerInterfaces.Question> questionList = new List <ServerInterfaces.Question>();
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var ques = (from questions in db.Questions where questions.PaperId == paperId select questions);
foreach (Question q in ques)
{
ServerInterfaces.Question questions = new ServerInterfaces.Question();
questions.Id = q.Id;
questions.OptionA = q.OptionA;
questions.OptionB = q.OptionB;
questions.OptionC = q.OptionC;
questions.OptionD = q.OptionD;
questions.PaperId = q.PaperId;
questions.Question1 = q.Question1;
questions.CorrectAns = q.CorrectAns;
questionList.Add(questions);
}
}
return(questionList);
}
public bool SendStudentInfo(string name, string fatherName, int cnic, int phone, string email, string gender, string batch, DateTime dob, string address, byte[] image, string courseId)
{
bool executeState = false;
try
{
StudentInformation model = new StudentInformation();
model.Name = name;
model.FatherName = fatherName;
model.StudentCnic = cnic;
model.PhoneNo = phone;
model.Email = email;
model.Gender = gender;
model.Batch = batch;
model.DateOfBirth = dob.Date;
model.Address = address;
model.StudentImage = image;
model.ExamPaperId = courseId;
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
db.StudentInformations.Add(model);
db.SaveChanges();
executeState = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(executeState);
}
public bool DeleteExamPaper(string ExamId)
{
bool IsExamDeleted;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
// This will bring the record only belong to that cnic number
var examRecord = (from examPaper in db.ExamPapers
where examPaper.Id == ExamId
select examPaper).FirstOrDefault();
// This will remove the object record
db.ExamPapers.Remove(examRecord);
db.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
IsExamDeleted = true;
}
return(IsExamDeleted);
}
public bool UpdateExamPaper(ServerInterfaces.ExamPaper paper)
{
bool IsExamPaperUpdated;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var exam = (from examPaper in db.ExamPapers
where examPaper.Id == paper.Id
select examPaper).FirstOrDefault();
exam.MarksPerQuestion = paper.MarksPerQuestion;
exam.Name = paper.Name;
exam.TotalQuestions = paper.TotalQuestions;
exam.TimeDuration = paper.TimeDuration;
db.SaveChanges();
Console.WriteLine("Data Saved Successfully");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
IsExamPaperUpdated = true;
}
return(IsExamPaperUpdated);
}
/// <summary>
/// Function to get TotalTime based on the course Id used in the Quiz moudule
/// </summary>
/// <param name="courseId">course id of the student</param>
/// <returns></returns>
public int getTotalTime(string courseId)
{
var totalTime = 0;
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
totalTime = Convert.ToInt32((from paper in db.ExamPapers where paper.Id == courseId select paper.TimeDuration).FirstOrDefault());
// int questions = totalQuestions;
}
Console.WriteLine("Total Questions is equal to:" + totalTime);
return(totalTime);
}
/// <summary>
/// ADD THE EXAMQUESTIONPAPER FROM COURSE MODULE
/// </summary>
/// <param name="examQuestions"></param>
/// <returns></returns>
public bool AddExamQuestionPaper(List <ExamQuestion> examQuestions)
{
bool IsExamQuestionAdded = false;
try
{
Console.WriteLine("In to the Add Question Paper Section");
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
foreach (var eQ in examQuestions)
{
Question examQuestion = new Question();
List <Question> questionList = new List <Question>();
examQuestion.Question1 = eQ.Question1;
examQuestion.PaperId = eQ.PaperId;
examQuestion.CorrectAns = eQ.CorrectAns;
examQuestion.OptionA = eQ.OptionA;
examQuestion.OptionB = eQ.OptionB;
examQuestion.OptionC = eQ.OptionC;
examQuestion.OptionD = eQ.OptionD;
db.Questions.Add(examQuestion);
}
db.SaveChanges();
IsExamQuestionAdded = true;
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
// Console.WriteLine(ex.Message);
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
Console.WriteLine(raise.Message);
throw raise;
}
Console.WriteLine("End Section");
return(IsExamQuestionAdded);
}
/// <summary>
/// Function to get all the courses id from the data base used in paper pool module
/// </summary>
/// <returns></returns>
public List <ServerInterfaces.ExamPaper> getAllCourses()
{
List <ServerInterfaces.ExamPaper> paperList = new List <ServerInterfaces.ExamPaper>();
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var examPaper = from paper in db.ExamPapers select paper;
foreach (ExamPaper info in examPaper)
{
ServerInterfaces.ExamPaper epaper = new ServerInterfaces.ExamPaper();
epaper.Id = info.Id;
paperList.Add(epaper);
}
}
return(paperList);
}
public bool AddExamPaper(ServerInterfaces.ExamPaper paper)
{
bool IsExamPaperAdded = false;
try
{
Console.WriteLine("In to the Add Exam Paper Section");
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
ExamPaper papers = new ExamPaper();
papers.Id = paper.Id;
papers.Name = paper.Name;
papers.TimeDuration = paper.TimeDuration;
papers.TotalQuestions = paper.TotalQuestions;
papers.MarksPerQuestion = paper.MarksPerQuestion;
db.ExamPapers.Add(papers);
db.SaveChanges();
IsExamPaperAdded = true;
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
// Console.WriteLine(ex.Message);
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
Console.WriteLine(raise.Message);
throw raise;
}
Console.WriteLine("End Section");
return(IsExamPaperAdded);
}
/// <summary>
/// Function to check wether the course is having questions or not
/// </summary>
/// <param name="courseId"></param>
/// <returns></returns>
public bool IsPaperEligible(string courseId)
{
bool IsEligible = false;
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var rowCount = (from questions in db.Questions where questions.PaperId == courseId select questions).Count();
var totalQuestions = (from examPaper in db.ExamPapers where examPaper.Id == courseId select examPaper.TotalQuestions).FirstOrDefault();
Console.WriteLine("Row=" + rowCount + " " + "TotalQuest=" + totalQuestions);
var ques = (from questions in db.Questions where questions.PaperId == courseId select questions);
foreach (var item in ques)
{
if (item.PaperId == courseId && ((int)rowCount != (int)totalQuestions))
{
IsEligible = true;
}
}
}
return(IsEligible);
}
public bool insertResultData(long cnic, int correctAnswer, int incorrectAnswer, double percentage)
{
bool IsResultDataInserted = false;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
Result result = new Result();
result.CnicNo = cnic;
result.CorrectAnswers = correctAnswer;
result.IncorrectAnswers = incorrectAnswer;
result.Percentage = percentage;
result.StudentInformation = null;
db.Results.Add(result);
db.SaveChanges();
IsResultDataInserted = true;
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
// Console.WriteLine(ex.Message);
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
Console.WriteLine(raise.Message);
throw raise;
}
return(IsResultDataInserted);
}
public List <ServerInterfaces.ExamPaper> getExamPaperCourse()
{
List <ServerInterfaces.ExamPaper> examPaperList = new List <ServerInterfaces.ExamPaper>();
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
var examPaper = from papers in db.ExamPapers select papers;
foreach (ExamPaper paper in examPaper)
{
ServerInterfaces.ExamPaper examPaperObj = new ServerInterfaces.ExamPaper();
examPaperObj.Id = paper.Id;
examPaperObj.Name = paper.Name;
examPaperObj.TotalQuestions = paper.TotalQuestions;
examPaperObj.TimeDuration = paper.TimeDuration;
examPaperObj.MarksPerQuestion = paper.MarksPerQuestion;
examPaperList.Add(examPaperObj);
}
}
return(examPaperList);
}
/// <summary>
/// Function To Register The New Admin
/// </summary>
/// <param name="adminInfo">Admin Object Contain Information</param>
/// <returns></returns>
public bool AdminRegistration(AdministratorInfo adminInfo)
{
bool IsAdminRegistered = false;
try
{
using (AdmissionTestingSystemEntities db = new AdmissionTestingSystemEntities())
{
Administrator admin = new Administrator();
admin.UserName = adminInfo.UserName;
admin.Password = adminInfo.Password;
admin.Cnic = adminInfo.Cnic;
admin.Image = adminInfo.Image;
db.Administrators.Add(admin);
db.SaveChanges();
IsAdminRegistered = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(IsAdminRegistered);
}