public List <Usercourseassign> DASHBOARD_COURSE_REQUESTS() { List <Usercourseassign> Uca = new List <Usercourseassign>(); try { SqlCommand cmd = new SqlCommand("DASHBOARD_COURSE_REQUESTS", conn); cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); Connection(); SqlDataReader dr = cmd.ExecuteReader(); Usercourseassign Uca1; while (dr.Read()) { Uca1 = new Usercourseassign(); Uca1.DATEOFAPPROVE = dr["USERID"] != null ? dr["USERID"].ToString() : ""; //To Store userid Uca1.EXAMSTATUSASSIGN = dr["COURSEID"] != null ? dr["COURSEID"].ToString() : ""; //To Store courseid Uca1.TRANSACTIONID = dr["TRANSACTIONID"] != null ? dr["TRANSACTIONID"].ToString() : ""; //To Store Transactionid Uca1.COURSRNAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : ""; //To Store coursename Uca.Add(Uca1); } return(Uca); } catch (Exception ex) { return(null); } finally { conn.Close(); } }
public List <Usercourseassign> Get_user_Requests() { List <Usercourseassign> Uca = new List <Usercourseassign>(); try { SqlCommand cmd = new SqlCommand("GET_REQUESTS", conn); cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); Connection(); SqlDataReader dr = cmd.ExecuteReader(); Usercourseassign Uca1; while (dr.Read()) { Uca1 = new Usercourseassign(); Uca1.DATEOFAPPROVE = dr["count"] != null ? dr["count"].ToString() : "";//To Get Request counts Uca.Add(Uca1); } return(Uca); } catch (Exception ex) { return(null); } finally { conn.Close(); } }
public Outputclass Insert_transid(Usercourseassign usercouass) { Outputclass outputclass = new Outputclass(); try { SqlCommand cmd = new SqlCommand("INSERT_TRANSACTIONID", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@COURSEID", usercouass.COURSEID); cmd.Parameters.AddWithValue("@USERID", usercouass.USERID); cmd.Parameters.AddWithValue("@DATEOFAPPROVE", usercouass.DATEOFAPPROVE); cmd.Parameters.AddWithValue("@EXAMSTATUS", usercouass.EXAMSTATUSASSIGN); cmd.Parameters.AddWithValue("@TRANSACTIONID", usercouass.TRANSACTIONID); Connection(); int i = cmd.ExecuteNonQuery(); if (i > 0) { outputclass.Count = i; } return(outputclass); } catch (Exception ex) { outputclass.Msg = ex.ToString(); return(outputclass); } finally { conn.Close(); } }
public List <Usercourseassign> Get_cources_request(string userid) { List <Usercourseassign> Uca = new List <Usercourseassign>(); try { SqlCommand cmd = new SqlCommand("GET_REQUEST_DETAILS", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UID", userid); DataTable dt = new DataTable(); Connection(); SqlDataReader dr = cmd.ExecuteReader(); Usercourseassign Uca1; while (dr.Read()) { Uca1 = new Usercourseassign(); Uca1.COURSEID = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0; Uca1.COURSRNAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : ""; Uca.Add(Uca1); } return(Uca); } catch (Exception ex) { return(null); } finally { conn.Close(); } }
public List <Usercourseassign> Get_userassigndata() { List <Usercourseassign> Uca = new List <Usercourseassign>(); try { SqlCommand cmd = new SqlCommand("GET_USERCOURSEASSIGN", conn); cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); Connection(); SqlDataReader dr = cmd.ExecuteReader(); Usercourseassign Uca1; while (dr.Read()) { Uca1 = new Usercourseassign(); Uca1.USERID = dr["USERID"] != null?Convert.ToInt32(dr["USERID"]) : 0; Uca1.COURSEID = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0; Uca1.DATEOFAPPROVE = dr["DATEOFAPPROVE"] != null ? dr["DATEOFAPPROVE"].ToString() : ""; Uca1.COURSEENDDATE = dr["COURSEENDDATE"] != null ? dr["COURSEENDDATE"].ToString() : ""; Uca1.COURSEDURATION = dr["COURSEDURATION"] != null ? dr["COURSEDURATION"].ToString() : ""; Uca1.EXAMSTATUSASSIGN = dr["EXAMSTATUSASSIGN"] != null ? dr["EXAMSTATUSASSIGN"].ToString() : ""; Uca1.STATUS = dr["STATUS"] != null ? dr["STATUS"].ToString() : ""; Uca1.TRANSACTIONID = dr["TRANSACTIONID"] != null ? dr["TRANSACTIONID"].ToString() : ""; Uca.Add(Uca1); } return(Uca); } catch (Exception ex) { return(null); } finally { conn.Close(); } }
public List <Usercourseassign> Usercourseassign_data() { List <Usercourseassign> ucalist = new List <Usercourseassign>(); try { SqlCommand cmd = new SqlCommand("GET_QUESTIONERIES", conn); cmd.CommandType = CommandType.StoredProcedure; Connection(); SqlDataReader dr = cmd.ExecuteReader(); Usercourseassign ucalist1; while (dr.Read()) { ucalist1 = new Usercourseassign(); ucalist1.COURSEID = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0; ucalist1.USERID = dr["USERID"] != null?Convert.ToInt32(dr["USERID"]) : 0; ucalist1.DATEOFAPPROVE = dr["DATEOFAPPROVE"] != null ? dr["DATEOFAPPROVE"].ToString() : ""; ucalist1.COURSEENDDATE = dr["COURSEENDDATE"] != null ? dr["COURSEENDDATE"].ToString() : ""; ucalist1.COURSEDURATION = dr["COURSEDURATION"] != null ? dr["COURSEDURATION"].ToString() : ""; ucalist1.EXAMSTATUSASSIGN = dr["EXAMSTATUSASSIGN"] != null ? dr["EXAMSTATUSASSIGN"].ToString() : ""; ucalist1.STATUS = dr["STATUS"] != null ? dr["STATUS"].ToString() : ""; ucalist.Add(ucalist1); } return(ucalist); } catch (Exception ch) { return(ucalist); } finally { conn.Close(); } }