public List <Course_Assign> LoadCADB(string cnm, string yr, string tnm)
{
string query = "";
List <Course_Assign> CAlst = new List <Course_Assign>();
if (!String.IsNullOrEmpty(cnm) && !String.IsNullOrEmpty(tnm))
{
return(CAlst);
}
if (!String.IsNullOrEmpty(cnm) && !String.IsNullOrEmpty(yr))
{
return(CAlst);
}
if (!String.IsNullOrEmpty(tnm) && !String.IsNullOrEmpty(yr))
{
return(CAlst);
}
else if (!String.IsNullOrEmpty(cnm))
{
query = "SELECT * FROM course_assign WHERE cName='" + cnm + "'";
}
else if (!String.IsNullOrEmpty(yr))
{
query = "SELECT * FROM course_assign WHERE year='" + yr + "'";
}
else if (!String.IsNullOrEmpty(tnm))
{
query = "SELECT * FROM course_assign WHERE tName='" + tnm + "'";
}
else
{
return(CAlst);
}
try
{
this.OpenConnection();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Course_Assign ca = new Course_Assign();
ca.CaId = dr["caId"].ToString();
ca.CName = dr["cName"].ToString();
ca.TName = dr["tName"].ToString();
ca.Year = dr["year"].ToString();
ca.Sem = dr["sem"].ToString();
CAlst.Add(ca);
}
dr.Close();
return(CAlst);
}
catch (Exception e)
{
return(CAlst);
}
finally
{
this.CloseConnection();
}
}
public List <Course_Assign> getAllCaDB()
{
string query = "SELECT * FROM course_assign";
Course_Assign c = new Course_Assign();
List <Course_Assign> CAlst = new List <Course_Assign>();
try
{
this.OpenConnection();
//DataTable table = new DataTable();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dr = cmd.ExecuteReader();
//dr.Fill(table);
while (dr.Read())
{
Course_Assign ca = new Course_Assign();
ca.CaId = dr["caId"].ToString();
ca.CName = dr["cName"].ToString();
ca.TName = dr["tName"].ToString();
ca.Year = dr["year"].ToString();
ca.Sem = dr["sem"].ToString();
CAlst.Add(ca);
}
dr.Close();
return(CAlst);
}
catch (Exception ex)
{
c.Error = ex.Message;
CAlst.Add(c);
return(CAlst);
}
finally
{
this.CloseConnection();
}
}