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