public FrmStudentRequest()
{
DB.open();
InitializeComponent();
Check_Detail_To_Aprrove_Or_Deny();
Check_To_Save();
}
public DataTable Get_Student_Info(string Id)
{
DAL.DataBase dl = new DAL.DataBase();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Id", SqlDbType.NVarChar, 50);
param[0].Value = Id;
dl.open();
DataTable dt = new DataTable();
dt = dl.SelectData("Get_Student_Info", param);
return(dt);
}
public DataTable Search_Student(string ID)
{
DAL.DataBase DAl = new DAL.DataBase();
DAl.open();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
dt = DAl.SelectData("Search_Student", param);
DAl.close();
return(dt);
}
public DataTable delete_cyber(string Id, bool cyber)
{
DAL.DataBase DAl = new DAL.DataBase();
DAl.open();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Id", SqlDbType.NVarChar, 50);
param[0].Value = Id;
param[1] = new SqlParameter("@cyber", SqlDbType.Bit);
param[0].Value = cyber;
dt = DAl.SelectData("delete_cyber", param);
DAl.close();
return(dt);
}
public DataTable Login(string Id, string Password)
{
DAL.DataBase dl = new DAL.DataBase();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@Id", SqlDbType.NChar, 10);
param[0].Value = Id;
param[1] = new SqlParameter("@Password", SqlDbType.NChar, 10);
param[1].Value = Password;
dl.open();
DataTable dt = new DataTable();
dt = dl.SelectData("SP_LOGIN", param);
return(dt);
}
public FrmViewSchedule(string user, string pass)
{
InitializeComponent();
DB = new DAL.DataBase();
DB.open();
this.Password = pass;
this.User = user;
LctID = getLectID();
if (LctID == null)
{
MessageBox.Show("ID not found in the system!");
}
else if (LctID != null)
{
loadDataToGrid();
}
}
public FrmDeleteLesson()
{
InitializeComponent();
DB.open();
Populate();
}