public JsonResult GetTopicByAssignment(TopicFind b) { using (SqlConnection DefaultConnection = new SqlConnection(DBHelper.ConnectionString)) using (SqlCommand cmd = new SqlCommand("GetTopicByAssignment", DefaultConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AssignmentTypeID", b.AssignmentTypeID); cmd.Parameters.AddWithValue("@SubscriptionID", b.SubscriptionId); DefaultConnection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { List<SelectListItem> paresult = new List<SelectListItem>(); while (reader.Read()) { paresult.Add(new SelectListItem { Value = reader.GetString("TopicID"), Text = reader.GetString("TopicDescription") }); } return Json(paresult, JsonRequestBehavior.AllowGet); } } }
public JsonResult SaveSubscriptionDetail(TopicFind b) { int subscriptionId = b.SubscriptionId; int assignmenttypeId = b.AssignmentTypeID; int topicId = b.TopicID; string createdBy = b.CreatedBy; using (var DefaultConnection = DBHelper.DefaultConnection) using (var cmd = DefaultConnection.CreateCommand().ForProcedure("SaveDetail")) { cmd.Parameters.Add("@SubscriptionID", SqlDbType.SmallInt).Value = subscriptionId; cmd.Parameters.Add("@TopicID", SqlDbType.SmallInt).Value = topicId; cmd.Parameters.Add("@AssignmentTypeId", SqlDbType.SmallInt).Value = assignmenttypeId; cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = createdBy; try { DefaultConnection.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { } finally { DefaultConnection.Close(); } } List<SubscriptionDetails> paresult = new List<SubscriptionDetails>(); using (var DefaultConnection = DBHelper.DefaultConnection) using (var cmd = DefaultConnection.CreateCommand().ForProcedure("GetAssignmentTypeAndName")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SubscriptionID", subscriptionId); DefaultConnection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { paresult.Add(new SubscriptionDetails { TopicDescription = reader.GetString("TopicDescription"), AssignmentDescription = reader.GetString("AssignmentDescription"), CreatedBy = reader.GetString("CreatedBy"), CourseTopicID = reader.GetInt32("CourseTopicID") ?? 0, SubscriptionID = reader.GetInt32("SubscriptionID") ?? 0 }); } } } return Json(paresult, JsonRequestBehavior.AllowGet); }
public JsonResult getAssignmentTypeAndName(TopicFind b) { using (SqlConnection DefaultConnection = new SqlConnection(DBHelper.ConnectionString)) using (SqlCommand cmd = new SqlCommand("GetAssignmentTypeAndName", DefaultConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SubscriptionID", b.SubscriptionId); DefaultConnection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { List<SubscriptionDetails> paresult = new List<SubscriptionDetails>(); while (reader.Read()) { paresult.Add(new SubscriptionDetails { TopicDescription = reader.GetString("TopicDescription"), AssignmentDescription = reader.GetString("AssignmentDescription"), CreatedBy = reader.GetString("CreatedBy"), CourseTopicID = reader.GetInt32("CourseTopicID") ?? 0, SubscriptionID = reader.GetInt32("SubscriptionID") ?? 0, QuizDefinitionID = reader.GetInt32("QuizDefinitionID"), CustomQuizAllowed = reader.GetBoolean("CustomQuizAllowed")??true }); } return Json(paresult, JsonRequestBehavior.AllowGet); } } }