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));
}
