public List <Coursereg> SHOW_COURSE_NOTNULL()
{
List <Coursereg> coreg = new List <Coursereg>();
try
{
SqlCommand cmd = new SqlCommand("SHOW_COURSE_NOTNULL", conn);
cmd.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Coursereg coreg1;
while (dr.Read())
{
coreg1 = new Coursereg();
coreg1.Courseid = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0;;
coreg1.COURSENAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : "";
coreg.Add(coreg1);
}
dr.Close();
return(coreg);
}
catch (Exception ch)
{
return(coreg);
}
finally
{
conn.Close();
}
}
public Outputclass Update_qns(Coursereg coureg)
{
Outputclass outputclass = new Outputclass();
try
{
SqlCommand cmd = new SqlCommand("UPDATE_QNS", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CID", coureg.Courseid);
cmd.Parameters.AddWithValue("@NOOFQNS", coureg.NUMBEROSQUETIONS);
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 <Coursereg> Get_Course_QNData()
{
List <Coursereg> coursereg = new List <Coursereg>();
try
{
SqlCommand cmd = new SqlCommand("GET_COURSE_QNNUMBERS", conn);
cmd.CommandType = CommandType.StoredProcedure;
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Coursereg coursereg1;
while (dr.Read())
{
coursereg1 = new Coursereg();
coursereg1.COURSENAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : "";
coursereg1.NUMBEROSQUETIONS = dr["NUMBEROSQUETIONS"] != null ? dr["NUMBEROSQUETIONS"].ToString() : "";
if (coursereg1.NUMBEROSQUETIONS == "" || coursereg1.NUMBEROSQUETIONS == null)
{
coursereg1.NUMBEROSQUETIONS = "0";
}
coursereg.Add(coursereg1);
}
return(coursereg);
dr.Close();
}
catch (Exception ch)
{
return(coursereg);
}
finally
{
conn.Close();
}
}
public Outputclass Update_Course(Coursereg coureg)
{
Outputclass outputclass = new Outputclass();
try
{
SqlCommand cmd = new SqlCommand("UPDATECOURSE", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CName", coureg.COURSENAME);
cmd.Parameters.AddWithValue("@CNOOFD", coureg.COURSEPERID);
cmd.Parameters.AddWithValue("@CSTDT", coureg.COURSEFROMDATE);
cmd.Parameters.AddWithValue("@CEDT", coureg.COURSETODATE);
cmd.Parameters.AddWithValue("@CDES", coureg.Description);
cmd.Parameters.AddWithValue("@CAMT", coureg.COURSEAMOUNT);
cmd.Parameters.AddWithValue("@CTRAINERNAME", coureg.TRAINERNAME);
cmd.Parameters.AddWithValue("@STATUS", coureg.STATUS);
cmd.Parameters.AddWithValue("@CIMPORTANCE", coureg.COURSEIMPORTANCE);
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 <Coursereg> Get_cources_usercourseassign()
{
List <Coursereg> Uca = new List <Coursereg>();
try
{
SqlCommand cmd = new SqlCommand("GET_COURSES", conn);
cmd.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Coursereg Uca1;
while (dr.Read())
{
Uca1 = new Coursereg();
Uca1.Courseid = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0;
Uca1.COURSENAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : "";
Uca.Add(Uca1);
}
return(Uca);
}
catch (Exception ex)
{
return(null);
}
finally
{
conn.Close();
}
}
public List <Coursereg> GET_APPROVE_EXAMCOURSE(string userid)
{
List <Coursereg> qnlist = new List <Coursereg>();
try
{
SqlCommand cmd = new SqlCommand("GET_APPROVE_EXAMCOURSE", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UID", userid);
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Coursereg qnlist1;
while (dr.Read())
{
qnlist1 = new Coursereg();
qnlist1.COURSEIMPORTANCE = dr["COURSEID"] != null ? dr["COURSEID"].ToString() : "";//To store Courseid
qnlist1.COURSENAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : "";
qnlist.Add(qnlist1);
}
return(qnlist);
}
catch (Exception ch)
{
return(qnlist);
}
finally
{
conn.Close();
}
}
public List <Coursereg> CourseRegistration_data()
{
List <Coursereg> coureglist = new List <Coursereg>();
try
{
SqlCommand cmd = new SqlCommand("GET_COURSEREGISTRATION", conn);
cmd.CommandType = CommandType.StoredProcedure;
Connection();
SqlDataReader dr = cmd.ExecuteReader();
Coursereg coureglist1;
while (dr.Read())
{
coureglist1 = new Coursereg();
coureglist1.Courseid = dr["COURSEID"] != null?Convert.ToInt32(dr["COURSEID"]) : 0;
coureglist1.COURSENAME = dr["COURSENAME"] != null ? dr["COURSENAME"].ToString() : "";
coureglist1.COURSEPERID = dr["COURSEPERIOD"] != null ? dr["COURSEPERIOD"].ToString() : "";
coureglist1.COURSEFROMDATE = dr["COURSEFROMDATE"] != null ? dr["COURSEFROMDATE"].ToString() : "";
coureglist1.COURSETODATE = dr["COURSETODATE"] != null ? dr["COURSETODATE"].ToString() : "";
coureglist1.NUMBEROSQUETIONS = dr["NUMBEROSQUETIONS"] != null ? dr["NUMBEROSQUETIONS"].ToString() : "";
coureglist1.NUMBEROFDAYS = dr["NUMBEROFDAYS"] != null ? dr["NUMBEROFDAYS"].ToString() : "";
coureglist1.TOTALMARKS = dr["TOTALMARKS"] != null ? dr["TOTALMARKS"].ToString() : "";
coureglist1.STATUS = dr["STATUS"] != null ? dr["STATUS"].ToString() : "";
coureglist1.Description = dr["COURSEDESCRIPTION"] != null ? dr["COURSEDESCRIPTION"].ToString() : "";
coureglist1.TRAINERNAME = dr["COURSETRAINER"] != null ? dr["COURSETRAINER"].ToString() : "";
coureglist1.COURSEAMOUNT = dr["COURSEAMOUNT"] != null ? dr["COURSEAMOUNT"].ToString() : "";
coureglist1.COURSEIMPORTANCE = dr["courseimportance"] != null ? dr["courseimportance"].ToString() : "";
coureglist1.COURSEDURATIONINHRS = dr["Duration_hours"] != null ? dr["Duration_hours"].ToString() : "";
coureglist.Add(coureglist1);
}
return(coureglist);
}
catch (Exception ch)
{
return(coureglist);
}
finally
{
conn.Close();
}
}
public Outputclass Create_Course(Coursereg coureg)
{
Outputclass outputclass = new Outputclass();
try
{
SqlCommand cmd = new SqlCommand("Insert_COURSEREGISTRATION", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@COURSENAME", coureg.COURSENAME);
cmd.Parameters.AddWithValue("@COURSEPERIOD", coureg.COURSEPERID);
cmd.Parameters.AddWithValue("@COURSEFROMDATE", coureg.COURSEFROMDATE);
cmd.Parameters.AddWithValue("@COURSETODATE", coureg.COURSETODATE);
//cmd.Parameters.AddWithValue("@NUMBEROSQUETIONS", coureg.NUMBEROSQUETIONS);
cmd.Parameters.AddWithValue("@NUMBEROFDAYS", coureg.NUMBEROFDAYS);
cmd.Parameters.AddWithValue("@TOTALMARKS", coureg.TOTALMARKS);
cmd.Parameters.AddWithValue("@STATUS", "ACTIVE");
cmd.Parameters.AddWithValue("@DESCRIPTION", coureg.Description);
cmd.Parameters.AddWithValue("@COURSEAMOUNT", coureg.COURSEAMOUNT);
cmd.Parameters.AddWithValue("@TRAINER", coureg.TRAINERNAME);
cmd.Parameters.AddWithValue("@COURSEIMPORTANCE", coureg.COURSEIMPORTANCE);
cmd.Parameters.AddWithValue("@DURATIONINHOURS", coureg.COURSEDURATIONINHRS);
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();
}
}
