//for Question drp
public void GetQuestionForDrp()
{
ChoiceBL topicBL = new ChoiceBL();
List <ChoiceEntities> pocoList = new List <ChoiceEntities>();
pocoList = topicBL.GetQuestionForDrp();
List <ChoiceEntities> itmasterList = new List <ChoiceEntities>();
foreach (ChoiceEntities up in pocoList)
{
ChoiceEntities unt = new ChoiceEntities();
unt.ID = up.ID;
unt.QuestionName = up.QuestionName;
itmasterList.Add(unt);
}
ViewBag.QuestionForDrp = itmasterList.Select(x =>
new SelectListItem()
{
Text = x.QuestionName,
Value = x.ID.ToString()
});
}
public int SaveChoice(ChoiceEntities choiceEntities)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpInsertUpdateChoice", con);
cmd.CommandType = CommandType.StoredProcedure;
if (String.IsNullOrEmpty(choiceEntities.ID.ToString()) || (choiceEntities.ID == 0))
{
cmd.Parameters.AddWithValue("@Id", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Id", choiceEntities.ID);
}
cmd.Parameters.AddWithValue("@ChoiceText", choiceEntities.ChoiceText);
cmd.Parameters.AddWithValue("@QuestionId", choiceEntities.QuestionId);
int recordsAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordsAffected);
}
public ChoiceEntities GetChoiceByID(int ID)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("stpGetChoiceByID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", ID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
ChoiceEntities topicEntities = new ChoiceEntities();
topicEntities.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
topicEntities.ChoiceText = Convert.ToString(ds.Tables[0].Rows[0]["ChoiceText"]);
topicEntities.QuestionId = Convert.ToInt32(ds.Tables[0].Rows[0]["QuestionId"]);
return(topicEntities);
}
public int SaveChoice(ChoiceEntities choiceEntities)
{
ChoiceDAL topicDAL = new ChoiceDAL();
return(topicDAL.SaveChoice(choiceEntities));
}
public JsonResult Add(ChoiceEntities choiceEntities)
{
ChoiceBL topicBL = new ChoiceBL();
return(Json(topicBL.SaveChoice(choiceEntities), JsonRequestBehavior.AllowGet));
}
