public void getVideos(string eid, string chap_id, string sub_id)
{
Context.Response.AppendHeader("Access-Control-Allow-Origin", "*");
Context.Response.ContentType = "application/json";
List <Note_Video_Details> lst = new List <Note_Video_Details>();
var video_dict = new Dictionary <string, List <Note_Video_Details> >();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Mansuri\Desktop\PROJECT2020\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True";
cn.Open();
SqlCommand cmdl = new SqlCommand();
cmdl.CommandText = "SELECT BATCH_ID FROM ENROLLMENT WHERE Enrollment_id=" + eid;
cmdl.Connection = cn;
int batch_id = Convert.ToInt32(cmdl.ExecuteScalar());
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "SELECT Video_Details , Path FROM Videos WHERE Video_Id IN (SELECT Video_Id FROM Videos_Batch WHERE BATCH_ID =" + batch_id + ") AND SUBJECT_ID =" + sub_id + " AND CHAPTER_ID=" + chap_id;
cmd2.Connection = cn;
SqlDataReader dr = cmd2.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
Note_Video_Details n1 = new Note_Video_Details();
n1.details = Convert.ToString(dr.GetValue(0));
n1.path = Convert.ToString(dr.GetValue(1));
lst.Add(n1);
}
video_dict.Add("Attendance", lst);
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(video_dict));
}
cn.Close();
}
public void getNotes(string id, string chap_id, string sub_id)
{
Context.Response.AppendHeader("Access-Control-Allow-Origin", "*");
Context.Response.ContentType = "application/json";
List <Note_Video_Details> lst = new List <Note_Video_Details>();
var video_dict = new Dictionary <string, List <Note_Video_Details> >();
if (Connection())
{
SqlCommand cmdl = new SqlCommand();
cmdl.CommandText = "SELECT BATCH_ID FROM ENROLLMENT WHERE Enrollment_id=" + id;
cmdl.Connection = cn;
int batch_id = Convert.ToInt32(cmdl.ExecuteScalar());
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "SELECT NOTE_DETAILS , PATH FROM NOTES WHERE NOTE_ID IN (SELECT NOTE_ID FROM NOTES_BATCH WHERE BATCH_ID =" + batch_id + ") AND SUBJECT_ID =" + sub_id + " AND CHAPTER_ID=" + chap_id;
cmd2.Connection = cn;
SqlDataReader dr = cmd2.ExecuteReader();
var sub = new Dictionary <string, string>();
if (dr != null)
{
while (dr.Read())
{
Note_Video_Details n1 = new Note_Video_Details();
n1.details = Convert.ToString(dr.GetValue(0));
n1.path = Convert.ToString(dr.GetValue(1));
lst.Add(n1);
}
video_dict.Add("Notes", lst);
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(video_dict));
}
cn.Close();
}
}
