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