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