public DataTable GetStudentInfo(GraduateFormsDTO gfd)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "[Graduate].[SP_GetStudentInfo]";
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stCode", gfd.stCode);
cmd.Parameters.AddWithValue("@family", gfd.family);
cmd.Parameters.AddWithValue("@iddMeli", gfd.iddMeli);
try
{
conn.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
dt.Load(rdr);
conn.Close();
}
catch
{
throw;
}
return(dt);
}
public DataTable getMarkListReportInfo(GraduateFormsDTO gfd)
{
if (gfd.family == null)
{
gfd.family = "";
}
return(gfo.GetMarkListReportInfo(gfd));
}
public DataTable getCourseReportInfo(GraduateFormsDTO gfd)
{
if (gfd.family == null)
{
gfd.family = "";
}
return(gfo.GetCoursePassesReportInfo(gfd));
}
private void searchStudent()
{
DataTable dtTemp = new DataTable();
string stcode, Family;
btnAddStudentAsGraduate.Visible = false;
if (!Business.Common.CommonBusiness.IsNumeric(txtSearchStcode.Text) && txtSearchStcode.Text != "")
{
return;
}
GraduateFormsDTO GFD = new GraduateFormsDTO();
if (txtSearchStcode.Text.Trim() != "" && txtSearchFamnily.Text.Trim() == "")
{
stcode = txtSearchStcode.Text.Trim();
Family = string.Empty;
}
else if (txtSearchStcode.Text.Trim() == "" && txtSearchFamnily.Text.Trim() != "")
{
stcode = string.Empty;
Family = txtSearchFamnily.Text.Trim();
}
else
{
stcode = txtSearchStcode.Text.Trim();
Family = txtSearchFamnily.Text.Trim();
}
DataTable dt = new DataTable();
//to bind database with data gridview
dt = GFB.searchStudentInfo_FeraghatDocument(stcode, Family);
dtTemp = dt.Copy();
dtTemp.Columns.RemoveAt(7);
grdResults.DataSource = dtTemp;
grdResults.DataBind();
lblNotFound.Visible = dtTemp.Rows.Count == 0;
grdResults.Visible = dtTemp.Rows.Count > 0;
if (lblNotFound.Visible)
{
CanAddStudentAsGraduate(stcode);
}
}
public DataTable getStudentInfo(GraduateFormsDTO gfd)
{
return(gfo.GetStudentInfo(gfd));
}