public List <ExamenStack> GetScores(string Username) { conn.Open(); List <ExamenStack> examens = new List <ExamenStack>(); cmdGetScores = new SqlCommand("proc_GetAllScores", conn); cmdGetScores.Parameters.Add("@Username", SqlDbType.VarChar, 50); cmdGetScores.Parameters.Add("@CandidateId", SqlDbType.VarChar, 20); cmdGetScores.Parameters.Add("@TestModel", SqlDbType.VarChar, 50); cmdGetScores.Parameters.Add("@Mark", SqlDbType.Int); cmdGetScores.CommandType = CommandType.StoredProcedure; cmdGetScores.Parameters[0].Value = Username; cmdGetScores.Parameters[1].Direction = ParameterDirection.Output; cmdGetScores.Parameters[2].Direction = ParameterDirection.Output; cmdGetScores.Parameters[3].Direction = ParameterDirection.Output; ExamenStack examen = new ExamenStack(); cmdGetScores.ExecuteNonQuery(); examen.Candidate_ID = cmdGetScores.Parameters[1].Value.ToString(); examen.Testmodel = cmdGetScores.Parameters[2].Value.ToString(); examen.Mark = Convert.ToInt32(cmdGetScores.Parameters[3].Value); examens.Add(examen); conn.Close(); return(examens); }
public List <ExamenStack> GetAllQuestions(string testmodel) { conn.Open(); List <ExamenStack> examens = new List <ExamenStack>(); cmdGetQuestions = new SqlCommand("proc_GetAllQuestions", conn); cmdGetQuestions.Parameters.Add("@TestModel", SqlDbType.VarChar, 50); cmdGetQuestions.CommandType = CommandType.StoredProcedure; cmdGetQuestions.Parameters[0].Value = testmodel; ExamenStack examen; SqlDataReader dataReader = cmdGetQuestions.ExecuteReader(); while (dataReader.Read()) { examen = new ExamenStack(); examen.Sno = Convert.ToInt32(dataReader[0]); examen.Testmodel = dataReader[1].ToString(); examen.Questions = dataReader[2].ToString(); examen.Answers = dataReader[3].ToString(); examen.Option1 = (dataReader[4].ToString()); examen.Option3 = (dataReader[5].ToString()); examen.Option2 = (dataReader[6].ToString()); examen.Option4 = (dataReader[7].ToString()); examen.Mark = Convert.ToInt32(dataReader[8]); examens.Add(examen); } conn.Close(); return(examens); }
public ExamenStack AddQuestions(ExamenStack examen) { try { conn.Open(); cmdAddQuestion = new SqlCommand("proc_AddQuestion", conn); cmdAddQuestion.CommandType = CommandType.StoredProcedure; cmdAddQuestion.Parameters.AddWithValue("@SNo", examen.SNo); cmdAddQuestion.Parameters.AddWithValue("@TestModel", examen.Testmodel); cmdAddQuestion.Parameters.AddWithValue("@Questions", examen.Questions); cmdAddQuestion.Parameters.AddWithValue("@Answers", examen.Answers); cmdAddQuestion.Parameters.AddWithValue("@option1", examen.Option1); cmdAddQuestion.Parameters.AddWithValue("@option2", examen.Option2); cmdAddQuestion.Parameters.AddWithValue("@option3", examen.Option3); cmdAddQuestion.Parameters.AddWithValue("@option4", examen.Option4); cmdAddQuestion.Parameters.AddWithValue("@Mark", examen.Mark); if (cmdAddQuestion.ExecuteNonQuery() > 0) { examen = null; } } catch (SqlException se) { Console.WriteLine(se.Message); } conn.Close(); return(examen); }
public List <ExamenStack> GetTestType(string testType) { List <ExamenStack> list = new List <ExamenStack>(); conn.Open(); cmdGetTestQuestion = new SqlCommand("proc_GetTestTypeQuestions", conn); cmdGetTestQuestion.Parameters.AddWithValue("@TestModel", testType); cmdGetTestQuestion.CommandType = CommandType.StoredProcedure; cmdGetTestQuestion.Parameters[0].Value = testType; SqlDataReader drQuestionType = cmdGetTestQuestion.ExecuteReader(); ExamenStack examen = null; while (drQuestionType.Read()) { examen = new ExamenStack(); examen.SNo = Convert.ToInt32(drQuestionType[0]); examen.Questions = drQuestionType[2].ToString(); examen.Answers = drQuestionType[3].ToString(); examen.Option1 = drQuestionType[4].ToString(); examen.Option2 = drQuestionType[5].ToString(); examen.Option3 = drQuestionType[6].ToString(); examen.Option4 = drQuestionType[7].ToString(); examen.Mark = Convert.ToInt32(drQuestionType[8]); list.Add(examen); } conn.Close(); return(list); }
// POST api/values public ExamenStack Post([FromBody] ExamenStack examen) { if (User != null) { return(bl.AddQuestions(examen)); } else { return(new ExamenStack()); } }
// PUT api/values/5 public ExamenStack Put([FromBody] ExamenStack examen) { //var user = (from u in examen // where u.SNo == id // select u).First(); if (User != null) { return(bl.UpdateQuestion(examen)); } else { return(examen); } }
public List <string> GetAllTestModels() { conn.Open(); List <string> examens = new List <string>(); cmdGetAllTestModels = new SqlCommand("proc_GetAllTestModels", conn); cmdGetAllTestModels.CommandType = CommandType.StoredProcedure; cmdGetAllTestModels.ExecuteNonQuery(); ExamenStack examen; SqlDataReader dataReader = cmdGetAllTestModels.ExecuteReader(); while (dataReader.Read()) { examen = new ExamenStack(); string Testmodel = dataReader[0].ToString(); examens.Add(Testmodel); } conn.Close(); return(examens); }
public ExamenStack UpdateQuestion(ExamenStack examen) { conn.Open(); cmdUpdateQuestion = new SqlCommand("proc_UpdateQuestion", conn); cmdUpdateQuestion.CommandType = CommandType.StoredProcedure; cmdUpdateQuestion.Parameters.AddWithValue("@SNo", examen.SNo); cmdUpdateQuestion.Parameters.AddWithValue("@TestModel", examen.Testmodel); cmdUpdateQuestion.Parameters.AddWithValue("@Question", examen.Questions); cmdUpdateQuestion.Parameters.AddWithValue("@Answer", examen.Answers); cmdUpdateQuestion.Parameters.AddWithValue("@option1", examen.Option1); cmdUpdateQuestion.Parameters.AddWithValue("@option2", examen.Option2); cmdUpdateQuestion.Parameters.AddWithValue("@option3", examen.Option3); cmdUpdateQuestion.Parameters.AddWithValue("@option4", examen.Option4); cmdUpdateQuestion.Parameters.AddWithValue("@Mark", examen.Mark); if (cmdUpdateQuestion.ExecuteNonQuery() > 0) { examen = null; } conn.Close(); return(examen); }
public List <ExamenStack> GetAdminDetails() { conn.Open(); List <ExamenStack> examens = new List <ExamenStack>(); cmdGetAdminDetails = new SqlCommand("proc_AdminDetails", conn); cmdGetAdminDetails.CommandType = CommandType.StoredProcedure; ExamenStack examen; SqlDataReader dataReader = cmdGetAdminDetails.ExecuteReader(); while (dataReader.Read()) { examen = new ExamenStack(); examen.Admin_name = dataReader[0].ToString(); examen.Admin_email = dataReader[1].ToString(); examen.Admin_phone = dataReader[2].ToString(); examen.Admin_username = dataReader[3].ToString(); examens.Add(examen); } conn.Close(); return(examens); }
public ActionResult Register(ExamenDataModel dataModel, string submitButton) { try { ExamenBL bl = new ExamenBL(); ExamenStack examenStack = new ExamenStack(); examenStack.Phone = dataModel.Phone; examenStack.Email = dataModel.Email; examenStack.Username = dataModel.Username; examenStack.Password = dataModel.Password; examenStack.Name = dataModel.Name; if (submitButton == "Submit") { if (bl.InsertIntoCandidates(examenStack)) { ViewBag.Message = "Registered Successfully"; return(RedirectToAction("RegisterSuccessView", "WelcomePage")); } else { return(ViewBag.Message = "Registration Failed.."); } } else if (submitButton == "Cancel") { return(RedirectToAction("Index", "WelcomePage")); } } catch (SqlException se) { ViewBag.ErrorMessage = "Invalid Username or Password.."; } return(View()); }
public bool InsertCandidate(ExamenStack examen) { conn.Open(); bool insertresult = false; cmdRegister = new SqlCommand("proc_RegisterCandidates", conn); cmdRegister.Parameters.AddWithValue("@p_phone", examen.Phone); cmdRegister.Parameters.AddWithValue("@p_email", examen.Email); cmdRegister.Parameters.AddWithValue("@p_username", examen.Username); cmdRegister.Parameters.AddWithValue("@p_password", examen.Password); cmdRegister.Parameters.AddWithValue("@p_name", examen.Name); cmdRegister.CommandType = CommandType.StoredProcedure; if (cmdRegister.ExecuteNonQuery() > 0) { insertresult = true; } conn.Close(); return(insertresult); }
public List <ExamenStack> GetScoreDetails() { conn.Open(); List <ExamenStack> examens = new List <ExamenStack>(); cmdGetScoreDetails = new SqlCommand("proc_GetScoreDetails", conn); cmdGetScoreDetails.CommandType = CommandType.StoredProcedure; ExamenStack examen; SqlDataReader dataReader = cmdGetScoreDetails.ExecuteReader(); while (dataReader.Read()) { examen = new ExamenStack(); examen.Name = dataReader[0].ToString(); examen.Email = dataReader[1].ToString(); examen.Phone = dataReader[2].ToString(); examen.Testmodel = dataReader[3].ToString(); examen.Score = Convert.ToInt32(dataReader[4]); examens.Add(examen); } conn.Close(); return(examens); }
public ExamenStack UpdateQuestion(ExamenStack examen) { return(dal.UpdateQuestion(examen)); }
public ExamenStack AddQuestions(ExamenStack examen) { return(dal.AddQuestions(examen)); }
public bool InsertIntoCandidates(ExamenStack examen) { return(dal.InsertCandidate(examen)); }