public static DataTable SearchStudents(Student student)
{
if (conndb.State == ConnectionState.Closed)
{
conndb = UtilityDB.connectDB();
cmd = new SqlCommand();
}
cmd.Connection = conndb;
cmd.CommandText = string.Format("Select * from Students where FirstName='{0}' or PhoneNumber='{1}'", student.FirstName, student.PhoneNumber);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
reader.Close();
cmd.Dispose();
conndb.Close();
return(dt);
}
public static bool UpdateStudents(Student student)
{
try
{
if (conndb.State == ConnectionState.Closed)
{
conndb = UtilityDB.connectDB();
cmd = new SqlCommand();
}
cmd.Connection = conndb;
cmd.CommandText = string.Format("update Students set FirstName='{0}' , LastName ='{1}', PhoneNumber = '{2}' where StudentNumber ={3}", student.FirstName, student.LastName, student.PhoneNumber, student.StudentNumber);
cmd.ExecuteNonQuery();
conndb.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static bool AddStudents(Student student)
{
try
{
if (conndb.State == ConnectionState.Closed)
{
conndb = UtilityDB.connectDB();
cmd = new SqlCommand();
}
cmd.Connection = conndb;
cmd.CommandText = string.Format("insert into Students (FirstName,LastName,PhoneNumber) values('{0}','{1}','{2}')", student.FirstName, student.LastName, student.PhoneNumber);
cmd.ExecuteNonQuery();
conndb.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static DataTable DisplayStudents()
{
DataTable datatable = new DataTable();
try
{
if (conndb.State == ConnectionState.Closed)
{
conndb = UtilityDB.connectDB();
cmd = new SqlCommand();
}
cmd.Connection = conndb;
cmd.CommandText = "select * from Students";
SqlDataReader reader = cmd.ExecuteReader();
datatable.Load(reader);
reader.Close();
cmd.Dispose();
conndb.Close();
}
catch (Exception)
{
}
return(datatable);
}