// GET: AdminQuestion/Delete/5
public ActionResult Delete(int id)
{
string role = Convert.ToString(Session["RoleName"]);
if (role.Length > 0 || role != null)
{
if (role == "Admin")
{
AdminQuestion adm = db.AdminQuestions.Find(id);
try
{
db.AdminQuestions.Remove(adm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Message = "Relationship Exists with other table!";
return(View(adm));
}
}
else
{
return(HttpNotFound());
}
}
return(HttpNotFound());
}
public JsonResult List()
{
DLL objDB = new DLL();
AdminQuestion objCustomer = new AdminQuestion();
AdminQuestion students = null;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:62904/api/");
var responseTask = client.GetAsync("Demo2");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readtask = result.Content.ReadAsAsync <AdminQuestion>();
readtask.Wait();
students = readtask.Result;
}
else
{
ModelState.AddModelError(string.Empty, "Server error. Please contact administrator.");
}
}
return(Json(objCustomer.ShowallQuestion = students.ShowallQuestion, JsonRequestBehavior.AllowGet));
}
public JsonResult Add(AdminQuestion AdqAnswer)
{
DLL objDB = new DLL();
// int result = objDB.InsertQuestion(AdqAnswer);
return(Json(objDB.InsertQuestion(AdqAnswer), JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(FormCollection collection, AdminQuestion adm)
{
try
{
if (ModelState.IsValid)
{
var file = Request.Files["file"];
string name = "";
if (file.ContentLength > 0)
{
string extension = System.IO.Path.GetExtension(file.FileName);
name = Convert.ToString(adm.QuestionID) + extension;
string pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Uploads/AdminLevel"), name);
file.SaveAs(path);
adm.Image = name;
}
else
{
adm.Image = Convert.ToString(Session["Image"]);
}
db.Entry(adm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm));
}
catch
{
return(View(adm));
}
}
public JsonResult List()
{
DLL objDB = new DLL();
AdminQuestion objCustomer = new AdminQuestion();
HttpClient cons = new HttpClient();
cons.BaseAddress = new Uri("http://localhost:62904/");
cons.DefaultRequestHeaders.Accept.Clear();
cons.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
MyAPIGet(cons).Wait();
return(Json(objCustomer.ShowallQuestion = objDB.Selectalldata(), JsonRequestBehavior.AllowGet));
}
public ActionResult ShowAllQuestions()
{
// var bytes = new UTF8Encoding().GetBytes("");
//var hashBytes = System.Security.Cryptography.MD5.Create().ComputeHash(bytes);
AdminQuestion objCustomer = new AdminQuestion();
DLL objDB = new DLL(); //calling class DBdata
objCustomer.ShowallQuestion = objDB.Selectalldata();
ViewBag.ShowDetails = false;
return(View(objCustomer));
}
public ActionResult Test(AdminQuestion AdqAnswer)
{
if (ModelState.IsValid) //checking model is valid or not
{
DLL objDB = new DLL();
int result = objDB.InsertQuestion(AdqAnswer);
ModelState.Clear(); //clearing model
ModelState.AddModelError("", "Record Added Successfully");
return(View());
}
else
{
ModelState.AddModelError("", "Error in saving data");
return(View());
}
}
public List <AdminQuestion> Selectalldata()
{
SqlConnection con = null;
DataSet ds = null;
List <AdminQuestion> custlist = null;
try
{
con = new SqlConnection(conn);
SqlCommand cmd = new SqlCommand("GetAllRecord", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds);
custlist = new List <AdminQuestion>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
AdminQuestion cobj = new AdminQuestion();
cobj.ID = Convert.ToString(ds.Tables[0].Rows[i]["id"].ToString());
cobj.Question = Convert.ToString(ds.Tables[0].Rows[i]["Question"].ToString());
cobj.Choice1 = Convert.ToString(ds.Tables[0].Rows[i]["Choice1"].ToString());
cobj.Choice2 = Convert.ToString(ds.Tables[0].Rows[i]["Choice2"].ToString());
cobj.Choice3 = Convert.ToString(ds.Tables[0].Rows[i]["Choice3"].ToString());
cobj.Choice4 = Convert.ToString(ds.Tables[0].Rows[i]["Choice4"].ToString());
cobj.CorrectAnswers = Convert.ToString(ds.Tables[0].Rows[i]["CorrectAnswer"].ToString());
custlist.Add(cobj);
}
return(custlist);
}
catch
{
return(custlist);
}
finally
{
con.Close();
}
}
public ActionResult AddQuestion(FormCollection collection, AdminQuestion adm)
{
try
{
long count = 0;
if (db.AdminQuestions.Any())
{
count = db.AdminQuestions.Max(m => m.QuestionID);
count++;
}
else
{
count = 1;
}
var file = Request.Files["file"];
string name = "";
if (file.ContentLength > 0)
{
string extension = System.IO.Path.GetExtension(file.FileName);
name = Convert.ToString(count) + extension;
string pic = System.IO.Path.GetFileName(file.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/Uploads/AdminLevel"), name);
file.SaveAs(path);
}
if (ModelState.IsValid)
{
adm.Image = name;
db.AdminQuestions.Add(adm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm));
}
catch (Exception ex)
{
return(View(adm));
}
}
// GET: AdminQuestion/Edit/5
public ActionResult Edit(int id)
{
string role = Convert.ToString(Session["RoleName"]);
if (role.Length > 0 || role != null)
{
if (role == "Admin")
{
AdminQuestion questions = db.AdminQuestions.Find(id);
Session["Image"] = questions.Image;
if (questions == null)
{
return(HttpNotFound());
}
return(View(questions));
}
else
{
return(HttpNotFound());
}
}
return(HttpNotFound());
}
public int InsertQuestion(AdminQuestion ADQAnswer)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("InsertQ", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Question", ADQAnswer.Question);
cmd.Parameters.AddWithValue("@choice1", ADQAnswer.Choice1);
cmd.Parameters.AddWithValue("@choice2", ADQAnswer.Choice2);
cmd.Parameters.AddWithValue("@choice3", ADQAnswer.Choice3);
cmd.Parameters.AddWithValue("@choice4", ADQAnswer.Choice4);
cmd.Parameters.AddWithValue("@CorrectAnswer", ADQAnswer.CorrectAnswers);
int exec = Convert.ToInt32(cmd.ExecuteScalar());
// sda.SelectCommand = cmd;
// sda.Fill(dt);
con.Close();
return(exec);
}
