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