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