private static DataTable GetBranchList(Int16 nCourseID)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@nCourseID", nCourseID, ParameterDirection.Input, SqlDbType.BigInt);
_DataAccess.Retrive("SP_SVIT_GetBranchDetails", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
private DataTable GetAllatestNews(int nNewsType)
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetLatestNEWS(nNewsType, true);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
private DataTable GetDepartmentFaculty()
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _studentInfo = new StudentInformation();
try
{
_dt = _studentInfo.GetDepartmentFacultyList(2);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
private DataTable GetBranchIntake()
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetBranchIntakeDetails(13);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
private DataTable GetPaperPresentedByStaff()
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetPaperPresentedByStaff(6);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
public static string GetStudentDetails(string id)
{
DataTable _dt = null;
string sStudentDetails = string.Empty;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetStudentDetailInfo(Convert.ToInt64(id));
if (_dt!=null&&_dt.Rows.Count>0)
{
foreach (DataRow dr in _dt.Rows)
{
foreach (DataColumn dc in _dt.Columns)
{
if (sStudentDetails=="")
{
sStudentDetails = dr[dc].ToString();
}
else
{
sStudentDetails = sStudentDetails + "^" + dr[dc].ToString();
}
}
}
}
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return sStudentDetails;
}
private DataTable GetCompanyList()
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
try
{
//_dt = _Student.GetStudentInfo(0);
_DataAccess.OpenConnection(false);
_DataAccess.Retrive_Query("SELECT [Company Name] FROM [dbo].[Company]", out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
private DataTable GetSeminarOrganized()
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetSeminarOrganized(2);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
public DataTable GetWorkshopDetails(Int64 nBranchID = 0)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@nBranchID", nBranchID, ParameterDirection.Input, SqlDbType.BigInt);
_DataAccess.Retrive("SP_SVIT_GetWorkshopSeminar", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
public DataTable GetStudentDetailsByUserName(string UserName)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@sUserName", UserName, ParameterDirection.Input, SqlDbType.VarChar);
_DataAccess.Retrive("SP_SVIT_GetStudentsLoginDetails", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
public DataSet GetPaperSeminarBYStaff(Int64 nStaffID = 0)
{
DataSet _ds = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@nStaffID", nStaffID, ParameterDirection.Input, SqlDbType.BigInt);
_DataAccess.Retrive("SP_SVIT_GetPaperAndSeminarByStaff", _DBParameters, out _ds);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _ds;
}
public DataTable GetLatestNEWS(int nNewsType,Boolean bIsShownOnNEWS=false)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@nNewsType", nNewsType, ParameterDirection.Input, SqlDbType.Int);
_DBParameters.Add("@bIsShowOnNEWS", bIsShownOnNEWS, ParameterDirection.Input, SqlDbType.Bit);
_DataAccess.Retrive("SP_SVIT_GetLatestNews", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
public DataTable GetIntituteDetails(bool bIsShowInAbout)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@bIsShowInAbout", bIsShowInAbout, ParameterDirection.Input, SqlDbType.Bit);
_DataAccess.Retrive("SP_SVIT_GetIntituteDetails", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
public DataTable GetImportantLinks()
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DataAccess.Retrive("SP_SVIT_GetImportantLinks", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
public DataTable GetAlumniInfo(string sSearchString, int nSearchCriteria)
{
DataTable _dt = null;
DBParameters _DBParameters = new DBParameters();
DataAccess _DataAccess = new DataAccess();
try
{
_DataAccess.OpenConnection(false);
_DBParameters.clear();
_DBParameters.Add("@sSearchString", sSearchString, ParameterDirection.Input, SqlDbType.VarChar);
_DBParameters.Add("@nSearchCriteria", nSearchCriteria, ParameterDirection.Input, SqlDbType.Int);
_DataAccess.Retrive("SP_SVIT_GetSearchAlumni", _DBParameters, out _dt);
_DataAccess.CloseConnection(false);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
if (_DBParameters != null) { _DBParameters.Dispose(); }
}
return _dt;
}
private DataTable GetAllAlumni(string sSearchString, int nSearchCriteria)
{
DataTable _dt = null;
DataAccess _DataAccess = new DataAccess();
StudentInformation _Student = new StudentInformation();
try
{
_dt = _Student.GetAlumniInfo(sSearchString,nSearchCriteria);
}
catch (Exception)
{
if (_DataAccess != null) { _DataAccess.RollBack(); _DataAccess.CloseConnection(false); }
}
finally
{
}
return _dt;
}
