public static DataTable IsPaperChangeAllowed(Hashtable ht) { DataTable dt = new DataTable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); //SqlCommand cmd = new SqlCommand(); dt = oDB.getparamdataset("ELGV2_PaperChange_ListSingleStudent", ht).Tables[0]; //StatusFlag = int.Parse(cmd.Parameters["@Result"].Value.ToString()); // cmd.Dispose(); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); //StatusFlag = 0; } finally { Pool.ReleaseDBObject(oDB); } return(dt); }
internal string[] IsPreviousConfigurationExists(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; string[] sRes = new string[7]; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("ELGV2_IsPreviousConfigurationExists", oHs); iRows = oCmd.ExecuteNonQuery(); sRes[0] = oCmd.Parameters["@isPreviousCoursePartConfigured"].Value.ToString(); sRes[1] = oCmd.Parameters["@isNextCoursePartConfigured"].Value.ToString(); sRes[2] = oCmd.Parameters["@PriviousCourse"].Value.ToString(); sRes[3] = oCmd.Parameters["@NextCourse"].Value.ToString(); sRes[4] = oCmd.Parameters["@PriviousCourseForDisplay"].Value.ToString(); sRes[5] = oCmd.Parameters["@OtherPartOrTermExists"].Value.ToString(); sRes[6] = oCmd.Parameters["@OtherPartOrTermExistsName"].Value.ToString(); } finally { oPool.ReleaseDBObject(oDB); } return(sRes); }
internal string[] SaveAdmissionElgConfigurationsForCourse(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; string[] sRes = new string[3]; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("ELGV2_SaveAdmissionElgConfigurationsForCourse", oHs); iRows = oCmd.ExecuteNonQuery(); sRes[0] = oCmd.Parameters["@Status"].Value.ToString(); sRes[1] = oCmd.Parameters["@PartorTermStatus"].Value.ToString(); sRes[2] = oCmd.Parameters["@ConfiguredPartOrTerm"].Value.ToString(); } finally { oPool.ReleaseDBObject(oDB); } return(sRes); }
/// <summary> /// This function Fetches the Student Signature of Regular Students /// </summary> /// <param name="Uni_ID" >University ID</param> /// <param name="Institute_ID">Institute ID</param> /// <param name="Student_ID">Student ID</param> public static DataSet IA_Fetch_Student_Signature(string Year, string Uni_ID, string Institute_ID, string Student_ID) { DataSet ds; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); // pr[0] = new SqlParameter("@pk_Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@pk_Institute_ID",Institute_ID); // pr[2] = new SqlParameter("@pk_Student_ID",Student_ID); ht.Add("pk_Year", Year); ht.Add("pk_Uni_ID", Uni_ID); ht.Add("pk_Institute_ID", Institute_ID); ht.Add("pk_Student_ID", Student_ID); ds = oDB.getparamdataset("elg_Fetch_IA_Student_Sign", ht); return(ds); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// This function Generates PRN(Permanent Registration Number) for an Eligibile Regular Student /// </summary> /// <param name="Uni_ID">University ID</param> /// <param name="Institute_ID">Institute ID</param> /// <param name="Student_ID">Student ID</param> /// <param name="DocXML">A String Builder in XML Format used to store the Document details /// as recieved by the University. DocXML contains NewDataSet/StudentDocs as root node. </param> // public static string[] GeneratePRN_Register_IA_Student(string Uni_ID, string Institute_ID, string Student_ID, System.Text.StringBuilder DocXML) // { // string[] arr = new string[2]; // SqlParameter[] pr = new SqlParameter[6]; // try // { // // pr[0] = new SqlParameter("@pk_Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@pk_Institute_ID",Institute_ID); // pr[2] = new SqlParameter("@pk_Student_ID",Student_ID); // pr[3] = new SqlParameter("@DocXML",SqlDbType.Text); // pr[3].Value = Convert.ToString(DocXML); // //pr[3] = new SqlParameter("@DocXML",DocXML); // pr[4] = new SqlParameter("@PRN",SqlDbType.Char,11); // pr[4].Direction = ParameterDirection.Output; // pr[5] = new SqlParameter("@ElgFormNo",SqlDbType.VarChar,50); // pr[5].Direction = ParameterDirection.Output; // SqlHelper.ExecuteScalar(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"elg_generatePRN_Register_IA_Student",pr); // arr[0] = pr[4].Value.ToString(); // arr[1] = pr[5].Value.ToString(); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return arr; // // } /// <summary> /// This function Generates PRN(Permanent Registration Number) for an Eligibile External Student /// </summary> /// <param name="Uni_ID">Univeristy ID</param> /// <param name="Institute_ID">Institute ID</param> /// <param name="Student_ID">Student ID</param> /// <param name="DocXML">A String Builder in XML Format used to store the Document details /// as recieved by the University. DocXML contains NewDataSet/StudentDocs as root node.</param> /// <returns></returns> // public static string[] GeneratePRN_Register_EA_Student(string Uni_ID, string Institute_ID, string Student_ID, System.Text.StringBuilder DocXML) // { // // string[] arr = new string[2]; // SqlParameter[] pr = new SqlParameter[6]; // try // { // // pr[0] = new SqlParameter("@pk_Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@pk_Institute_ID",Institute_ID); // pr[2] = new SqlParameter("@pk_Student_ID",Student_ID); // pr[3] = new SqlParameter("@DocXML",SqlDbType.Text); // pr[3].Value = Convert.ToString(DocXML); // pr[4] = new SqlParameter("@PRN",SqlDbType.Char,11); // pr[4].Direction = ParameterDirection.Output; // pr[5] = new SqlParameter("@ElgFormNo",SqlDbType.VarChar,50); // pr[5].Direction = ParameterDirection.Output; // SqlHelper.ExecuteScalar(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"elg_generatePRN_Register_EA_Student",pr); // arr[0] = pr[4].Value.ToString(); // arr[1] = pr[5].Value.ToString(); // // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return arr; // // } #endregion #region Mark Student Non-Eligible or Keep his/her Eligibility Pending /// <summary> /// This function is used to mark a student as Non-Eligible and to keep his details as Pending /// with the Reason.An Entry is made in to Elg_NonElgAndPendingElgStudents table /// with status and Reason. /// </summary> /// <param name="Uni_ID">University ID</param> /// <param name="Institute_ID">Institute ID</param> /// <param name="Student_ID">Student ID</param> /// <param name="Status">Status 0- Not Eligible ,Status 1-Pending </param> /// <param name="Reason">Reason for why the Student is made Non-Eligible or Pending</param> // public static void Enter_NonElg_PendingStudents(string Uni_ID, string Institute_ID, string Student_ID, int Status, string Reason) // { // // SqlParameter[] pr = new SqlParameter[5]; // try // { // // pr[0] = new SqlParameter("@pk_Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@pk_Institute_ID",Institute_ID); // pr[2] = new SqlParameter("@pk_Student_ID",Student_ID); // pr[3] = new SqlParameter("@Status",Status); // pr[4] = new SqlParameter("@Reason", Reason); // SqlHelper.ExecuteNonQuery(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"ELG_NonElgPendingStudents",pr); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // } #endregion #region Reports /// <summary> /// For Reports /// To get the College wise Course Statistics of the Eligibility Determination /// of Students by the University. /// </summary> /// <param name="Uni_ID">University ID</param> /// <param name="Institute_ID">Institute ID</param> /// <returns></returns> // public static DataSet GetCollegewiseCoursesStats(string Uni_ID, string Institute_ID) // { // DataSet ds = new DataSet(); // SqlParameter[] pr = new SqlParameter[2]; // try // { // // pr[0] = new SqlParameter("@UniID",Uni_ID); // pr[1] = new SqlParameter("@Institute_ID",Institute_ID); // //ds = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"],CommandType.StoredProcedure,"ELG_IA_CollegeWiseCoursesStatistics",pr); // ds = SqlHelper.ExecuteDataset(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"ELG_College_CourseWiseStatistics",pr); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return ds; // } #endregion #endregion #region by Liwia #region fetch Collegewise -Eligibility pending Students /// <summary> /// This method is used to attach array of SqlParameters to a SqlCommand. /// This function is used to get the Students(DataSet) Whose eligibility is Pending /// under a Particular Institute for a Particular Course in the University. /// </summary> /// <param name="Uni_ID">Univeristy ID</param> /// <param name="Inst_ID">Institute ID </param> /// <param name="CrPr_ID">CoursePart ID</param> /// <param name="CrMoLrnPtrnID">Course Mode Of Learning Pattern ID</param> // public static DataSet GetElgPendingStudents(int UniID,int InstID,int CrPrID,int CrMoLrnPtrnID) // { // DataSet ds = new DataSet(); // SqlParameter[] pr = new SqlParameter[4]; // try // { // // pr[0] = new SqlParameter("@UniID",UniID); // pr[1] = new SqlParameter("@InstID",InstID); // pr[2] = new SqlParameter("@CrPrID",CrPrID); // pr[3] = new SqlParameter("@CrMoLrnPtrnID",CrMoLrnPtrnID); // // ds = SqlHelper.ExecuteDataset(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"elg_GetElgPendingStudents",pr); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return ds; // } #endregion #region GetAllFaculties /// <summary> /// This method is used to attach array of SqlParameters to a SqlCommand. /// This function returns the Faculty list of the University in a DataSet. /// </summary> /// <param name="UniID">Univeristy ID</param> public static DataSet GetAllFaculties(int UniID) { DataSet ds = new DataSet(); //SqlParameter[] pr = new SqlParameter[1]; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("UniID", UniID); ds = oDB.getparamdataset("ELG_SelectAllFaculty", ht); return(ds); //ds = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"],CommandType.StoredProcedure,"ELG_SelectAllFaculty",pr); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
public static string Elg_Get_Courses_Rights(string pk_CrMoLrnPtrn_ID) { DBObjectPool Pool = null; DBObject oDB = null; string sRightsFlag = ""; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable ohs = new Hashtable(); ohs.Add("pk_CrMoLrnPtrn_ID", pk_CrMoLrnPtrn_ID); DataTable DT = oDB.getparamdataset("Elg_Get_Course_Rights", ohs).Tables[0]; if (DT.Rows.Count > 0) { sRightsFlag = DT.Rows[0]["Elg_Rights_Flag"].ToString(); } return(sRightsFlag); } finally { Pool.ReleaseDBObject(oDB); } }
public static DataTable Elg_Display_PRN(string pk_CrMoLrnPtrn_ID, string pk_CrPr_ID, string pk_Uni_ID, string pk_Institute_ID, string fk_Year_ID) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable ohs = new Hashtable(); ohs.Add("pk_CrMoLrnPtrn_ID", pk_CrMoLrnPtrn_ID); ohs.Add("pk_CrPr_ID", pk_CrPr_ID); ohs.Add("pk_Uni_ID", pk_Uni_ID); ohs.Add("pk_Institute_ID", pk_Institute_ID); ohs.Add("fk_Year_ID", fk_Year_ID); DataTable DT = oDB.getparamdataset("ELG_Dispaly_PRN", ohs).Tables[0]; return(DT); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// This will List All the Previous Course Part of Selected Course Part /// i.e If TYBA is selected then it will list FYBA and SYBA public DataTable Get_Previous_CoursePartDetailsforAddPaperChange(string pk_Uni_ID, string pk_Inst_ID, string pk_Year, string pk_Student_ID, string pk_Fac_ID, string pk_Cr_ID, string pk_MoLrn_ID, string pk_Ptrn_ID, string pk_Brn_ID, string pk_CrPr_Details_ID, string pk_CrPrCh_ID, string PRN_Number) { DataTable oDt = new DataTable(); Hashtable oHt = new Hashtable(); oHt.Add("pk_Uni_ID", pk_Uni_ID); oHt.Add("pk_Institute_ID", pk_Inst_ID); oHt.Add("pk_Year", pk_Year); oHt.Add("pk_Student_ID", pk_Student_ID); oHt.Add("pk_Fac_ID", pk_Fac_ID); oHt.Add("pk_Cr_ID", pk_Cr_ID); oHt.Add("pk_MoLrn_ID", pk_MoLrn_ID); oHt.Add("pk_Ptrn_ID", pk_Ptrn_ID); oHt.Add("pk_Brn_ID", pk_Brn_ID); oHt.Add("pk_CrPr_Details_ID", pk_CrPr_Details_ID); oHt.Add("pk_CrPrCh_ID", pk_CrPrCh_ID); oHt.Add("PRN_Number", PRN_Number); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); //oDB.ThisConnectionFor = DBConnection.DCWrite; oDt = oDB.getparamdataset("ELGV2_PreCoursePart_ForAddPaperChange", oHt).Tables[0]; } finally { Pool.ReleaseDBObject(oDB); } return(oDt); }
public static DataTable PaperChange_TotalPapers(string UniID, string CrPrDetailsID, string CrPrChID) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable oHs = new Hashtable(); oHs.Add("UniID", UniID); oHs.Add("CrPrDetailsID", CrPrDetailsID); oHs.Add("CrPrChID", CrPrChID); DataTable DT = oDB.getparamdataset("ELGV2_PaperChange_TotalPapers", oHs).Tables[0]; return(DT); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// Insert Students Course Part wise Selected Papers /// </summary> /// <param name="oHt">Hashtable</param> /// <returns>Datatable</returns> public static string AddStudentAdditionalPapers(Hashtable oHt) { string flag; SqlCommand cmd; DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); oHt.Add("Status_Out", ParameterDirection.Output); cmd = oDB.GenerateCommand("ELGV2_Add_StudentAdditionalPapers", oHt); cmd.ExecuteNonQuery(); flag = cmd.Parameters["@Result_Out"].Value.ToString(); } catch (Exception ppEx) { flag = ppEx.Message; } finally { Pool.ReleaseDBObject(oDB); } return(flag); }
/// <summary> /// Get Paper Name /// </summary> /// <param name="oHt">Hashtable</param> /// <returns>String</returns> public string GetPaperName(string sPpID) { string sPaperName = string.Empty; DataTable dt = new DataTable(); Hashtable oHt = new Hashtable(); oHt.Add("PpIDList", sPpID); System.Xml.XmlReader oR = null; System.Text.StringBuilder oS = new System.Text.StringBuilder(); DBObjectPool Pool = null; Pool = DBObjectPool.Instance; DBObject oDB = Pool.AcquireDBObject(); try { System.Data.SqlClient.SqlCommand cmd = oDB.GenerateCommand("ELGV2_Get_PpName", oHt); oR = cmd.ExecuteXmlReader(); while (!oR.EOF) { if (oR.IsStartElement()) { oS.Append(oR.ReadOuterXml()); oS.Append(Environment.NewLine); } } } finally { Pool.ReleaseDBObject(oDB); } return(oS.ToString()); }
public static DataSet PaperChange_ListPapers(string UniID, string InstID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrDetailsID, string CrPrChID, string crPrSeq, string crPrChSeq, string StudentID, string StudentYear) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable oHs = new Hashtable(); oHs.Add("UniID", UniID); oHs.Add("InstID", InstID); oHs.Add("FacID", FacID); oHs.Add("CrID", CrID); oHs.Add("MoLrnID", MoLrnID); oHs.Add("PtrnID", PtrnID); oHs.Add("BrnID", BrnID); oHs.Add("CrPrDetailsID", CrPrDetailsID); oHs.Add("CrPrChID", CrPrChID); oHs.Add("CrPrSeq", crPrSeq); oHs.Add("CrPrChSeq", crPrChSeq); oHs.Add("StudentID", StudentID); oHs.Add("StudentYear", StudentYear); DataSet ds = oDB.getparamdataset("ELGV2_PaperChange_ListCoursePartTermStudentWiseAllPapers", oHs); return(ds); } finally { Pool.ReleaseDBObject(oDB); } }
//--------------------------------------------------------------------------------------------------- // Method to Add Exam Form Modify Request for multiple students public static string SendExamFormModifyRequest_PaperExemptionApproval_MultipleStuds(string oExamFormModifyRequest) { Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; string TFlag; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = new SqlCommand(); // MySQL related change - SP name should be having less than 64 characters //cmd = oDB.GenerateCommand("ELGV2_PaperExemptionApproval_AddExamFormModifyRequest_MultipleStudents", ht); cmd = oDB.GenerateCommand("ELGV2_PpExmpApproval_AddExamFormModifyRequest_MultipleStudents", ht); cmd.Parameters.RemoveAt("@FormModifyRequestsXML"); cmd.Parameters.Add("@FormModifyRequestsXML", SqlDbType.Xml); cmd.Parameters["@FormModifyRequestsXML"].Value = oExamFormModifyRequest; cmd.ExecuteNonQuery(); TFlag = cmd.Parameters["@StatusFlag"].Value.ToString(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { Pool.ReleaseDBObject(oDB); } return(TFlag); }
public static string SendExamFormModifyRequest_PaperExemptionApproval(Hashtable ht) { DataTable dt = new DataTable(); DBObjectPool Pool = null; DBObject oDB = null; string StatusFlag = "S"; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = new SqlCommand(); cmd = oDB.GenerateCommand("ELGV2_PaperExemptionApproval_AddExamFormModifyRequest", ht); cmd.ExecuteNonQuery(); StatusFlag = cmd.Parameters["@StatusFlag"].Value.ToString(); cmd.Dispose(); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); StatusFlag = "U"; } finally { Pool.ReleaseDBObject(oDB); } return(StatusFlag); }
/// <summary> /// Seacrh student. /// </summary> /// <param name="oHs"></param> /// <returns></returns> public DataTable SearchStudentbyPRN(string PRN) { Hashtable oHs = new Hashtable(); DataTable dt = new DataTable(); DBObjectPool Pool = null; DBObject oDB = null; string uniID = clsGetSettings.UniversityID.Trim(); try { oHs.Add("UniID", uniID); oHs.Add("PRN_Number", PRN); Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); dt = oDB.getparamdataset("ELGV2_TransferPreviousAdmissions_SearchStudent", oHs).Tables[0]; } catch (SqlException ex) { throw (ex); } finally { Pool.ReleaseDBObject(oDB); } return(dt); }
public DataTable LoadStudent() { DBObjectPool Pool = null; DBObject oDB = null; DataTable DT = new DataTable(); Hashtable oHS = new Hashtable(); oHS.Add("pk_Uni_ID", spk_Uni_ID); oHS.Add("pk_Year", spk_Year); oHS.Add("pk_Student_ID", spk_Student_ID); try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); DT = oDB.getparamdataset("REGV2_Get_PersonalDetails", oHS).Tables[0]; return(DT); } catch (SqlException ex) { Exception e; e = new Exception(ex.Message, ex); throw (e); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// Seacrh student. /// </summary> /// <param name="oHs"></param> /// <returns></returns> public DataTable SearchStudentForAddPaper(string PRN, string ElgFormNo, string AcadYear) { Hashtable oHs = new Hashtable(); DataTable dt = new DataTable(); DBObjectPool Pool = null; DBObject oDB = null; string uniID = clsGetSettings.UniversityID.Trim(); try { oHs.Add("UniID", uniID); oHs.Add("PRN_Number", PRN); oHs.Add("ElgFormNo", ElgFormNo); oHs.Add("AcadYearID", AcadYear); Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); dt = oDB.getparamdataset("ELGV2_SearchStudentAdditionalPaperChange", oHs).Tables[0]; } catch (SqlException ex) { throw (ex); } finally { Pool.ReleaseDBObject(oDB); } return(dt); }
//got to work on it !!! #endregion #region Fetch Student PRN, Course and College public static DataSet Fetch_StudentReRegistraionCourseDetails(string Uni_ID, string Year, string Student_ID) { DataSet ds = new DataSet(); //SqlParameter[] pr = new SqlParameter[3]; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("UniID", Uni_ID); ht.Add("Year", Year); ht.Add("StudID", Student_ID); ds = oDB.getparamdataset("REGV2_GetStudentReRegistrationCourseDetails", ht); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw (e); } finally { Pool.ReleaseDBObject(oDB); } return(ds); }
public static DataSet Elg_Get_Eligibility_Statistics(string pk_CrMoLrnPtrn_ID, string fk_CrPr_ID, string pk_Uni_ID, string pk_Institute_ID, string College_Eligibility_Flag) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable ohs = new Hashtable(); ohs.Add("pk_CrMoLrnPtrn_ID", pk_CrMoLrnPtrn_ID); ohs.Add("fk_CrPr_ID", fk_CrPr_ID); ohs.Add("pk_Uni_ID", pk_Uni_ID); ohs.Add("pk_Institute_ID", pk_Institute_ID); ohs.Add("College_Eligibility_Flag", College_Eligibility_Flag); DataSet DS = oDB.getparamdataset("Elg_Statistics_Coll_Uni", ohs); return(DS); } finally { Pool.ReleaseDBObject(oDB); } }
public static DataSet REG_ProfileSearch_GetStudentIDs(string PRN) { DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("PRN", PRN); ds = oDB.getparamdataset("REGV2_ProfileSearch_GetStudentIDs", ht); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw (e); } finally { Pool.ReleaseDBObject(oDB); } return(ds); }
/// <summary> /// This function Fetches the Districts in the University. /// </summary> /// <param name="Uni_ID" >University ID</param> // public static DataSet Fetch_UniversityWise_Districts(int Uni_ID) // { // // DataSet ds = new DataSet(); // SqlParameter[] pr = new SqlParameter[1]; // try // { // // pr[0] = new SqlParameter("@Uni_ID",Uni_ID); // ds = SqlHelper.ExecuteDataset(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"elg_FetchUniversityWiseDistricts",pr); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return ds; // } /// <summary> /// This function Fetches the Tehsils in the University. /// </summary> /// <param name="District_ID">District ID</param> /// <param name="Lang_Flag">Language Flag</param> // public static DataSet Fetch_Tehsils(int District_ID,string Lang_Flag) // { // DataSet ds = new DataSet(); // SqlParameter[] pr = new SqlParameter[2]; // try // { // // pr[0] = new SqlParameter("@District_ID",District_ID); // pr[1] = new SqlParameter("@Lang_Flag",Lang_Flag); // ds = SqlHelper.ExecuteDataset(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"GEN_districtWiseTaluka",pr); // } // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return ds; // } #region Fetch institutes who have uploaded student data for Eligibility check /// <summary> /// This function Fetches the College List in the University. /// </summary> /// <param name="Uni_ID" >University ID</param> /// <param name="InstTy_ID">Institute Type</param> /// <param name="Inst_Name">Institute Name</param> /// <param name="Country_ID">Country ID</param> /// <param name="State_ID">State ID</param> /// <param name="District_ID">District ID</param> /// <param name="Tehsil_ID">Tehsil ID</param> // public static DataSet Fetch_College_List(string Uni_ID,string InstTy_ID,string Inst_Name,string Country_ID,string State_ID,string District_ID,string Tehsil_ID) // { // DataSet ds = new DataSet(); // SqlParameter[] pr = new SqlParameter[7]; // try // { // // pr[0] = new SqlParameter("@Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@InstTy_ID",InstTy_ID); // pr[2] = new SqlParameter("@Inst_Name",Inst_Name); // pr[3] = new SqlParameter("@Country_ID",Country_ID); // pr[4] = new SqlParameter("@State_ID",State_ID); // pr[5] = new SqlParameter("@District_ID",District_ID); // pr[6] = new SqlParameter("@Tehsil_ID",Tehsil_ID); // ds = SqlHelper.ExecuteDataset(UniversityPortal.clsGetSettings.ConnectionString,CommandType.StoredProcedure,"elg_fetchcollegelist",pr); // } // // catch(Exception Ex) // { // Exception e = new Exception(Ex.Message,Ex); // throw(e); // // } // return ds; // } #endregion #region Fetch Students Details(same function is used in clsEligibilityDBAccess class) /// <summary> /// This function Fetches the Details of a Particular Regular Student /// </summary> /// <param name="Uni_ID" >University ID</param> /// <param name="Institute_ID">Institute ID</param> /// <param name="Student_ID">Student ID</param> public static DataSet IA_Fetch_Student_Details(string Year, string Uni_ID, string Institute_ID, string Student_ID) { DataSet ds = new DataSet(); //SqlParameter[] pr = new SqlParameter[4]; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); // pr[0] = new SqlParameter("@pk_Uni_ID",Uni_ID); // pr[1] = new SqlParameter("@pk_Institute_ID",Institute_ID); // pr[2] = new SqlParameter("@pk_Student_ID",Student_ID); // pr[3] = new SqlParameter("@pk_Year", Year); ht.Add("pk_Uni_ID", Uni_ID); ht.Add("pk_Institute_ID", Institute_ID); ht.Add("pk_Student_ID", Student_ID); ht.Add("pk_Year", Year); ds = oDB.getparamdataset("elg_Fetch_IA_Student_Details", ht); return(ds); //ds = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"],CommandType.StoredProcedure,"elg_Fetch_IA_Student_Details",pr); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
public static string add(Hashtable HtAllValues) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); string returnValue; SqlCommand cmd = oDB.GenerateCommand("ID_Add_Institutetype", HtAllValues); cmd.ExecuteNonQuery(); returnValue = cmd.Parameters["@pk_InstTy_ID"].Value.ToString(); cmd.Dispose(); cmd.Connection.Close(); cmd = null; return(returnValue); } catch (SqlException ex) { Exception e; e = new Exception(ex.Message, ex); return("Y"); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// This function Fetch the Details of a Registered Sudent Signature using PRN /// </summary> /// <param name="PRN">Permanent Registration Number</param> public static DataSet Reg_Fetch_Student_Signature(int Ref_pk_Uni_ID, int Ref_pk_Year, int Ref_pk_Institute_ID, int Ref_pk_Student_ID) { DataSet ds; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("Ref_pk_Uni_ID", Ref_pk_Uni_ID); ht.Add("Ref_pk_Year", Ref_pk_Year); ht.Add("Ref_pk_Institute_ID", Ref_pk_Institute_ID); ht.Add("Ref_pk_Student_ID", Ref_pk_Student_ID); ds = oDB.getparamdataset("elg_Fetch_Reg_Student_Sign", ht); return(ds); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
public string modify(Hashtable HtAllValues) { DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = oDB.GenerateCommand("ID_Modify_InstituteType", HtAllValues); //Change Procedure name cmd.ExecuteNonQuery(); cmd.Dispose(); cmd.Connection.Close(); cmd = null; Load(); return("Y"); } catch (Exception ex) { Exception e; e = new Exception(ex.Message, ex); return(""); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// This method is used to attach array of SqlParameters to a SqlCommand. /// This function returns the CoursePart for Regular Students under a Faculty in the University /// using DataSet. /// </summary> /// <param name="UniID">Univeristy ID</param> /// <param name="FacID">Faculty ID</param> /// <param name="CrID">CourseID</param> public static DataSet selAllCoursePart(int UniID, int FacID, int CrID) { DataSet ds; //SqlParameter[] pr = new SqlParameter[3]; Hashtable ht = new Hashtable(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); // pr[0] = new SqlParameter("@UniID",UniID); // pr[1] = new SqlParameter("@FacID",FacID); // pr[2] = new SqlParameter("@CrID",CrID); ht.Add("UniID", UniID); ht.Add("FacID", FacID); ht.Add("CrID", CrID); ds = oDB.getparamdataset("ELG_RegularCoursePart", ht); return(ds); //ds = SqlHelper.ExecuteDataset(ConfigurationSettings.AppSettings["ConnectionString"],CommandType.StoredProcedure,"ELG_RegularCoursePart",pr); // ArrayList Arrds=new ArrayList(1); // Arrds.Add(ds); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
public int delete() { int recAffected = 0; SqlCommand cmd; DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); Hashtable objHS = new Hashtable(); objHS["pk_InstTy_ID"] = PK_InstTy_ID; cmd = oDB.GenerateCommand("ID_Delete_InstituteType", objHS); //Change Procedure Name recAffected = cmd.ExecuteNonQuery(); Reset(); cmd.Connection.Close(); cmd.Dispose(); cmd = null; return(recAffected); } catch (SqlException ex) { Exception e; e = new Exception(ex.Message, ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
internal string[] GetAdmissionElgibilityConfigStatusofCourse(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; string[] sRes = new string[2]; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("Elgv2_GetAdmissionElgibilityConfigStatusofCourse", oHs); iRows = oCmd.ExecuteNonQuery(); sRes[0] = oCmd.Parameters["@StatusElgConfig"].Value.ToString(); sRes[1] = oCmd.Parameters["@StatusElgConfigIndepedent"].Value.ToString(); } finally { oPool.ReleaseDBObject(oDB); } return(sRes); }
public static DataTable InstituteTypeWiseStatus(string pk_InstTy_ID) { Hashtable oHs = new Hashtable(); oHs.Add("pk_InstTy_ID", pk_InstTy_ID); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); DataTable DT = oDB.getparamdataset("ID_InstituteTypeWiseStatus", oHs).Tables[0]; return(DT); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// List StudentPhotoSignList /// </summary> /// <returns>DataTable</returns> public DataTable FetchAcademicYrCrPrTermWiseStudentList(string AcademicYearID, string UniID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrID, string CrPrChID) { dt = new DataTable(); ht = new Hashtable(); ht.Add("AcademicYearID", AcademicYearID); ht.Add("UniID", UniID); ht.Add("FacID", FacID); ht.Add("CrID", CrID); ht.Add("MoLrnID", MoLrnID); ht.Add("PtrnID", PtrnID); ht.Add("BrnID", BrnID); ht.Add("CrPrID", CrPrID); ht.Add("CrPrChID", CrPrChID); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); dt = oDB.getparamdataset("ElgV2_FetchAcademicYrCrPrTermWiseStudentList", ht).Tables[0]; } finally { Pool.ReleaseDBObject(oDB); } return(dt); }
public static string SaveChangedPapers(Hashtable ht) { string StatusFlag = "S"; DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = new SqlCommand(); cmd = oDB.GenerateCommand("ELGV2_PaperChange_SaveChangedPapers", ht); cmd.ExecuteNonQuery(); StatusFlag = cmd.Parameters["@StatusFlag"].Value.ToString(); cmd.Dispose(); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); StatusFlag = "U"; } finally { Pool.ReleaseDBObject(oDB); } return(StatusFlag); }