public DataTable Get_Fees_Stauts()
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_Fees_Stauts", null);
DAL.Clsoe();
return(Dt);
}
public DataTable Get_All_Supervisor()
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Supervisor", null);
DAL.Clsoe();
return(Dt);
}
public void DeleteStudent(int ID)
{
Data_Access_Layer.DataAccessLayer Data_Access_Layer = new Data_Access_Layer.DataAccessLayer();
Data_Access_Layer.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
Data_Access_Layer.ExecuteCommand("DeleteStudent", param);
Data_Access_Layer.Clsoe();
}
public DataTable VerfiyStudentID(int ID)
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
Dt = DAL.SelectData("VerfiyStudentID", param);
DAL.Clsoe();
return(Dt);
}
public void addNewUser(string USERNAME, string PASSWORD)
{
Data_Access_Layer.DataAccessLayer Data_Access_Layer = new Data_Access_Layer.DataAccessLayer();
Data_Access_Layer.Open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar, 25);
param[0].Value = USERNAME;
param[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 25);
param[1].Value = PASSWORD;
Data_Access_Layer.ExecuteCommand("addNewUser", param);
Data_Access_Layer.Clsoe();
}
public DataTable LOGIN(string ID, String PASSWORD)
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar, 25);
param[0].Value = ID;
param[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 25);
param[1].Value = PASSWORD;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
DAL.Clsoe();
return(Dt);
}
private void Delete_Click(object sender, EventArgs e)
{
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
if (MessageBox.Show("Do you Want To Delete This Record", "Delete Operation", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
stud.DeleteStudent(Convert.ToInt32(this.metroGrid1.CurrentRow.Cells[0].Value.ToString()));
MessageBox.Show("Record Deleted Successfully", "Delete Operation", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.metroGrid1.DataSource = stud.Get_All_Students();
}
else
{
MessageBox.Show("Record Deleted Cancelled", "Delete Operation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public void Student_ADD(int ID, string FIRST_NAME, string LAST_NAME, string BIRTH_DATE, string CLASS, string ACADEMIC_YEAR, string PHONE_NUMBER, string CITY, string STUDENT_SUPERVISOR, string STUDY_FEES)
{
Data_Access_Layer.DataAccessLayer Data_Access_Layer = new Data_Access_Layer.DataAccessLayer();
Data_Access_Layer.Open();
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
param[1] = new SqlParameter("@FIRST_NAME", SqlDbType.VarChar, 25);
param[1].Value = FIRST_NAME;
param[2] = new SqlParameter("@LAST_NAME", SqlDbType.VarChar, 25);
param[2].Value = LAST_NAME;
param[3] = new SqlParameter("@BIRTH_DATE", SqlDbType.Date);
param[3].Value = BIRTH_DATE;
param[4] = new SqlParameter("@CLASS", SqlDbType.VarChar, 25);
param[4].Value = CLASS;
param[5] = new SqlParameter("@ACADEMIC_YEAR", SqlDbType.VarChar, 25);
param[5].Value = ACADEMIC_YEAR;
param[6] = new SqlParameter("@PHONE_NUMBER", SqlDbType.VarChar, 11);
param[6].Value = PHONE_NUMBER;
param[7] = new SqlParameter("@CITY", SqlDbType.VarChar, 25);
param[7].Value = CITY;
param[8] = new SqlParameter("@STUDENT_SUPERVISOR", SqlDbType.VarChar, 25);
param[8].Value = STUDENT_SUPERVISOR;
param[9] = new SqlParameter("@STUDY_FEES", SqlDbType.VarChar, 25);
param[9].Value = STUDY_FEES;
Data_Access_Layer.ExecuteCommand("ADD_STUDENT", param);
Data_Access_Layer.Clsoe();
}