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