public Modulesc SearchModules(string Modcode) { cmd.CommandText = "SELECT * FROM modules WHERE modcode=@mc"; try { cmd.Parameters.AddWithValue("mc", Modcode); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { Modulesc u = new Modulesc(); while (reader.Read()) { u.Modcode = reader["modcode"].ToString(); u.Modname = reader["modname"].ToString(); u.Lecname = reader["lecname"].ToString(); } return(u); } return(null); } catch (Exception e) { Console.WriteLine(e.Message); return(null); } finally { con.Close(); } }
public List <Modulesc> GetComModules() { List <Modulesc> studetails = new List <Modulesc>(); try { cmd.CommandText = "SELECT id AS 'Explorer',modcode AS 'Mode Code',modname AS 'Mode Name',lecname AS 'Lec Name' FROM modules WHERE fac='Business'"; cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Modulesc lecgv = new Modulesc() { Id = reader[0].ToString(), Modcode = reader[1].ToString(), Modname = reader[2].ToString(), Lecname = reader[3].ToString(), }; studetails.Add(lecgv); } return(studetails); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
public int AddModules(Modulesc md) { try { cmd.CommandText = "INSERT INTO modules(modcode,modname,lecname,fac) VALUES (@mc,@mn,@l,'Business')"; cmd.Parameters.AddWithValue("mc", md.Modcode); cmd.Parameters.AddWithValue("mn", md.Modname); cmd.Parameters.AddWithValue("l", md.Lecname); con.Open(); cmd.CommandType = CommandType.Text; return(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { con.Close(); } }
public int DeleteComModules(Modulesc cmdel) { try { cmd.CommandText = "DELETE modules WHERE modcode=@mc"; cmd.Parameters.AddWithValue("mc", cmdel.Modcode); cmd.CommandType = CommandType.Text; con.Open(); return(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
public int UpdateComModules(Modulesc cmu) { try { cmd.CommandText = "UPDATE modules set modcode=@mc, modname=@mn, lecname=@ln, fac='Business' WHERE modcode=@mc"; cmd.Parameters.AddWithValue("mc", cmu.Modcode); cmd.Parameters.AddWithValue("mn", cmu.Modname); cmd.Parameters.AddWithValue("ln", cmu.Lecname); con.Open(); return(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }