public ActionResult SaveOrUpdate(ExamEntities Examentities)
{
ExamBL Exambl = new ExamBL();
int recordAffected = Exambl.SaveOrUpdateExam(Examentities);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
//for GetExamForDrp drp
public void GetExamForDrp()
{
ExamBL examBL = new ExamBL();
List <ExamEntities> pocoList = new List <ExamEntities>();
pocoList = examBL.GetExamForDrp();
List <ExamEntities> itmasterList = new List <ExamEntities>();
foreach (ExamEntities up in pocoList)
{
ExamEntities unt = new ExamEntities();
unt.ExamID = up.ExamID;
unt.ExamName = up.ExamName;
itmasterList.Add(unt);
}
ViewBag.Exam = itmasterList.Select(x =>
new SelectListItem()
{
Text = x.ExamName,
Value = x.ExamID.ToString()
});
}
public List <ExamEntities> GetAllExam()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetExamAll", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
List <ExamEntities> ExamList = new List <ExamEntities>();
ExamEntities exam = new ExamEntities();
foreach (DataRow dr in ds.Tables[0].Rows)
{
ExamList.Add(new ExamEntities
{
ID = Convert.ToInt32(dr["ID"].ToString()),
ExamName = Convert.ToString(dr["ExamName"]),
});
}
con.Close();
return(ExamList);
}
public ActionResult LoginStudent(Student model)
{
if (ModelState.IsValid)
{
string oldpassword = model.passwod;
model.passwod = Encryptor.MD5Hash(oldpassword);
using (var context = new ExamEntities())
{
Student user = context.Students
.Where(u => u.email == model.email && u.passwod == model.passwod)
.FirstOrDefault();
if (user != null)
{
Session["rule"] = user.rule;
Session["UserName"] = user.name;
Session["UserId"] = user.ST_id;
return(RedirectToAction("StudentPage", "Students"));
}
else
{
ModelState.AddModelError("", "Invalid User Name or Password");
return(View(model));
}
}
}
else
{
return(View(model));
}
}
public ExamEntities GetExamByID(int ExamID)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetExamByExamID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ExamID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
ExamEntities Exam = new ExamEntities();
Exam.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
Exam.ExamName = Convert.ToString(ds.Tables[0].Rows[0]["ExamName"]);
return(Exam);
}
public int SaveOrUpdateExam(ExamEntities exam)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdateExam", con);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(exam.ID.ToString()) || (exam.ID == 0))
{
cmd.Parameters.AddWithValue("@ID", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ID", exam.ID);
}
cmd.Parameters.AddWithValue("@ExamName", exam.ExamName);
int recordAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordAffected);
}
public ActionResult Instructions(string check)
{
if (Session["st_id"] == null)
{
return(RedirectToAction("Index"));
}
TempData["totalQues"] = 0;
List <QuesCategory> lis = db.QuesCategories.ToList();
var prf = db.Profiles.Where(x => x.Status == 1).FirstOrDefault();
List <Exam> ls = db.Exams.Where(x => x.ProfileId == prf.Id).ToList();
if (check != null)
{
Queue <Question> queue = new Queue <Question>();
foreach (var quesCat in ls)
{
if (quesCat.CheckBox == true)
{
int k = Convert.ToInt32(quesCat.NoOfQues);
int i = 1;
// List<Question> list = db.Questions.Where(x => x.QuesCategoryId == quesCat.Id).ToList();
foreach (var cat in lis)
{
if (cat.Name == quesCat.Category)
{
using (var ctx = new ExamEntities())
{
var questionList = ctx.Questions.SqlQuery("Select * from Questions where QuesCategoryId=" + cat.Id + " ").Distinct().OrderBy(x => Guid.NewGuid()).ToList();
foreach (Question a in questionList)
{
if (i <= k)
{
queue.Enqueue(a);
i++;
TempData["totalQues"] = Convert.ToInt32(TempData["totalQues"]) + 1;
}
else
{
break;
}
}
}
}
}
}
}
TempData["questions"] = queue;
TempData["score"] = 0;
TempData["Indi"] = "";
TempData["i"] = 0;
TempData["sc1"] = null;
TempData["sc2"] = null;
TempData["sc3"] = null;
TempData["attempt"] = 0;
TempData["ExamName"] = prf.Name;
// for(int i = 1; i < queue.Count; i++)
// {
// TempData["sl"] = i;
//}
TempData.Keep();
return(RedirectToAction("Ncat"));
}
else
{
ViewBag.error = "Kindly Check the box";
}
return(View());
}
public BaseService(ExamEntities dataContext)
{
this.dataContext = dataContext;
dbSet = dataContext.Set <T>();
}
public int SaveOrUpdateExam(ExamEntities Exam)
{
ExamDAL ExamDl = new ExamDAL();
return(ExamDl.SaveOrUpdateExam(Exam));
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
var userId = Convert.ToInt32(httpContext.Session["UserId"]);
var username = Convert.ToString(httpContext.Session["UserName"]);
var user_rule = (string)httpContext.Session["rule"];
if (!string.IsNullOrEmpty(username) && userId != 0)
{
using (var context = new ExamEntities())
{
// string rule="" ;
// if (user_rule == "student")
// { var userRole = context.Students.Where(m => m.ST_id == userId).FirstOrDefault();
// rule = userRole.rule;
// }
//else if (user_rule == "professor")
// {
// var userRole = context.Professors.Where(m => m.P_id == userId).FirstOrDefault();
// rule = userRole.rule;
// }
// else if (user_rule == "admin")
// { var userRole = context.Admins.Where(m => m.A_id == userId).FirstOrDefault();
// rule = userRole.rule;
// }
// var userRole = (from u in context.ST_Rules
// join r in context.Rules on u.R_id equals r.id
// where u.ST_id == userId
// select new
// {
// r.title
// }).ToList();
foreach (var role in allowedroles)
{
if (role == user_rule)
{
if(user_rule=="student")
{
var user = context.Students.Single(d => d.ST_id == userId);
if (user.approval == true)
{ return true; }
}
else if(user_rule=="professor")
{
var user = context.Professors.Single(n => n.P_id == userId);
if (user.approval == true)
{ return true; }
}
else if (user_rule=="admin")
{
return true;
}
else { return false; }
}
}
}
}
return authorize;
}
public ExamDatabaseService(ExamEntities dataContext) : base(dataContext)
{
}
