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