public int SaveTopic(TopicEntities topicEntities) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpInsertUpdateTopic", con); cmd.CommandType = CommandType.StoredProcedure; if (String.IsNullOrEmpty(topicEntities.ID.ToString()) || (topicEntities.ID == 0)) { cmd.Parameters.AddWithValue("@Id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Id", topicEntities.ID); } cmd.Parameters.AddWithValue("@TopicName", topicEntities.TopicName); cmd.Parameters.AddWithValue("@SubjectId", topicEntities.SubjectId); int recordsAffected = cmd.ExecuteNonQuery(); con.Close(); return(recordsAffected); }
//for Subject drp public void GetSubjectForDrp() { TopicBL topicBL = new TopicBL(); List <TopicEntities> pocoList = new List <TopicEntities>(); pocoList = topicBL.GetSubjectForDrp(); List <TopicEntities> itmasterList = new List <TopicEntities>(); foreach (TopicEntities up in pocoList) { TopicEntities unt = new TopicEntities(); unt.ID = up.ID; unt.SubjectName = up.SubjectName; itmasterList.Add(unt); } ViewBag.SubjectForDrp = itmasterList.Select(x => new SelectListItem() { Text = x.SubjectName, Value = x.ID.ToString() }); }
public TopicEntities GetTopicByID(int ID) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpGetTopicByID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", ID); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); TopicEntities topicEntities = new TopicEntities(); topicEntities.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString()); topicEntities.TopicName = Convert.ToString(ds.Tables[0].Rows[0]["TopicName"]); topicEntities.SubjectId = Convert.ToInt32(ds.Tables[0].Rows[0]["SubjectId"]); return(topicEntities); }
public JsonResult Add(TopicEntities topicEntities) { TopicBL topicBL = new TopicBL(); return(Json(topicBL.SaveTopic(topicEntities), JsonRequestBehavior.AllowGet)); }
public int SaveTopic(TopicEntities topicEntities) { TopicDAL topicDAL = new TopicDAL(); return topicDAL.SaveTopic(topicEntities); }