public void fac_acc(Account obj) { try { conobj.openconnect(); strQuery = "insert into " + this.strTable + " (user_pass,admin_id,fac_id,stu_id,pro_id,status) values (@pass,@admin,@fac,@stu,@pro,@status);"; cmd = conobj.execute(this.strQuery); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@pass", obj.Password); cmd.Parameters.AddWithValue("@admin", DBNull.Value); cmd.Parameters.AddWithValue("@fac", obj.Fac_id); cmd.Parameters.AddWithValue("@stu", DBNull.Value); cmd.Parameters.AddWithValue("@pro", DBNull.Value); cmd.Parameters.AddWithValue("@status", 1); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { conobj.closeconnect(); } }
public Pro get(int id) { Pro obj = null; strQuery = "select pro_id,program_name,sem_num,sem_name from program,semester where program.pro_id=" + id + "and semester.sem_id=program.sem_id;"; cmd = conobj.execute(this.strQuery); SqlDataReader dr; try { obj = new Pro(); conobj.openconnect(); dr = cmd.ExecuteReader(); while (dr.Read()) { obj.Program_id = dr.GetInt32(0); obj.Program_Name = dr.GetString(1); obj.Semester_Number = dr.GetInt32(2); obj.Semester_Name = dr.GetString(3); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { conobj.closeconnect(); } return(obj); }
public List <string> teachernames() { List <string> mylist = new List <string>(); strQuery = "select fac_name from faculty"; cmd = conobj.execute(strQuery); SqlDataReader dr; try { conobj.openconnect(); dr = cmd.ExecuteReader(); while (dr.Read()) { names = dr.GetString(0); mylist.Add(names); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { conobj.closeconnect(); } return(mylist); }
public int getfac(string name) { strQuery = "select fac_id from " + this.strTableName + " where fac_name='" + name + "'"; cmd = conobj.execute(this.strQuery); SqlDataReader dr; try { conobj.openconnect(); dr = cmd.ExecuteReader(); while (dr.Read()) { fid = (int)dr["fac_id"]; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { conobj.closeconnect(); } return(fid); }
public Student get(int id) { Student obj = null; strQuery = "select * from " + strTableName + " where stu_id = " + id; cmd = conobj.execute(this.strQuery); SqlDataReader dr; try { obj = new Student(); conobj.openconnect(); dr = cmd.ExecuteReader(); while (dr.Read()) { obj.ID = (int)dr["stu_id"]; obj.Name = (string)dr["stu_name"]; obj.Email = (string)dr["stu_email"]; obj.Semester = (int)dr["stu_sem"]; obj.Program = (int)dr["program_id"]; obj.Age = (DateTime)dr["stu_age"]; obj.Gender = (string)dr["stu_gen"]; obj.Image = (byte[])dr["stu_img"]; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { conobj.closeconnect(); } return(obj); }