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); }
//Added to check is cancel admission is allowd at DU Side or not public bool Allow_CancelAdmissionAtOASide(Hashtable oHt) { bool bAllow = false; string sReturnData = "N"; SqlCommand cmd = new SqlCommand(); oHt.Add("ReturnVal", ParameterDirection.Output); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); //oDB.ThisConnectionFor = DBConnection.DURead; cmd = oDB.GenerateCommand("DU_Configuration_Allow_OA_Cancel", oHt); cmd.ExecuteNonQuery(); sReturnData = cmd.Parameters["@ReturnVal"].Value.ToString(); if (sReturnData == "Y") { bAllow = true; } else { bAllow = false; } } finally { Pool.ReleaseDBObject(oDB); } return(bAllow); }
/// <summary> /// This function is to check whether the Eligibility Form Number given , exists in the IA table. /// </summary> /// <param name="pk_Uni_ID"></param> /// <param name="pk_Year"></param> /// <param name="pk_Institute_ID"></param> /// <param name="pk_Student_ID"></param> /// <returns>0 if No Matching Record , 1 if there exists a matching record</returns> public static int Check_IA_Student_Exists(string pk_Uni_ID, string pk_Year, string pk_Institute_ID, string pk_Student_ID) { int Flag = 0; Hashtable ht = new Hashtable(); SqlCommand cmd = new SqlCommand(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("pk_Uni_ID", pk_Uni_ID); ht.Add("pk_Year", pk_Year); ht.Add("pk_Institute_ID", pk_Institute_ID); ht.Add("pk_Student_ID", pk_Student_ID); ht.Add("ExistsFlag", Flag); cmd = oDB.GenerateCommand("elg_Check_IA_Student_Exists", ht); cmd.Parameters["@ExistsFlag"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); Flag = Convert.ToInt32(cmd.Parameters["@ExistsFlag"].Value.ToString()); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } return(Flag); }
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); }
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); }
public bool SavePRNImportSourceTableEntry(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; bool flag = false; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("ELGV2_PRN_Import_SourceTable_Entry", oHs); iRows = oCmd.ExecuteNonQuery(); if (iRows > 0) { flag = true; } } finally { oPool.ReleaseDBObject(oDB); } return(flag); }
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); } }
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); } }
public string Cancelrecords(string AcademicYearID, string tablename) { string result; DBObjectPool Pool = null; DBObject oDB = null; Hashtable objHT = new Hashtable(); try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); objHT.Add("AcademicYearID", AcademicYearID); objHT.Add("SourceTableName", tablename); SqlCommand cmd = oDB.GenerateCommand("ELGV2_ImportPRNFromExcel_DeleteTable", objHT); int res = cmd.ExecuteNonQuery(); result = "Successful"; } catch (Exception ex) { result = ex.Message; return(null); } finally { Pool.ReleaseDBObject(oDB); } return(result); }
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); } }
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); }
/// <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 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); }
//--------------------------------------------------------------------------------------------------- // 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); }
internal int ReplacePRN(string sExistingPRN, string sReplacePRN, string sUser) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; // string[] sRes = new string[3]; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); Hashtable oHs = new Hashtable(); oHs.Add("Existing_PRN", sExistingPRN); oHs.Add("Replaced_PRN", sReplacePRN); oHs.Add("User", sUser); oCmd = oDB.GenerateCommand("ELGV2_ReplacePRN", oHs); iRows = oCmd.ExecuteNonQuery(); } catch (Exception ex) { throw (ex); } finally { oPool.ReleaseDBObject(oDB); } return(iRows); }
internal string SaveCETDetails(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; // string[] sRes = new string[3]; string sRes = string.Empty; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("Elgv2_SaveCETDetails", oHs); iRows = oCmd.ExecuteNonQuery(); // if (iRows > 0) // { sRes = oCmd.Parameters["@Status"].Value.ToString(); //} } finally { oPool.ReleaseDBObject(oDB); } return(sRes); }
/// <summary> /// Cancel student admission /// </summary> /// <param name="ht"></param> /// <returns>N for Success, Y for Failure, E for Exists in Exam form</returns> public string CancelAdmission(Hashtable ht) { string sReturnData = string.Empty;; SqlCommand cmd = new SqlCommand(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("ErrorOccurred", ParameterDirection.Output); //cmd = oDB.GenerateCommand("Elgv2_CancelStudentAdmission", ht); cmd = oDB.GenerateCommand("ELGV2_CancelAdmission_CancelAdmission", ht); cmd.ExecuteNonQuery(); sReturnData = cmd.Parameters["@ErrorOccurred"].Value.ToString(); } catch { sReturnData = ""; } finally { Pool.ReleaseDBObject(oDB); } return(sReturnData); }
/// <summary> /// Seacrh student. /// </summary> /// <param name="oHs"></param> /// <returns></returns> public int UpdateStudyCenter_ForStudent(string PRN_Number, string NewRef_Pk_Institute_ID, string OldPk_Institute_ID, string facID, string courseID, string molrnID, string ptrnID, string brnID, string crPrDetailID, string crPrChildID, string fk_AcademicYear_ID, string fk_AcademicYear_Seq, string DeleteOldCancelEntry, string createdBy, string CrPr_Seq, string CrPrCh_Seq) { int flag = 0; Hashtable oHs = new Hashtable(); DataTable dt = new DataTable(); DBObjectPool Pool = null; DBObject oDB = null; string uniID = clsGetSettings.UniversityID.Trim(); try { oHs.Add("Pk_Uni_ID", uniID); oHs.Add("PRN_Number", PRN_Number); oHs.Add("NewRef_Pk_Institute_ID", NewRef_Pk_Institute_ID); oHs.Add("OldPk_Institute_ID", OldPk_Institute_ID); oHs.Add("PK_Fac_ID", facID); oHs.Add("PK_Cr_ID", courseID); oHs.Add("Pk_Molrn_ID", molrnID); oHs.Add("Pk_Ptrn_ID", ptrnID); oHs.Add("Pk_Brn_ID", brnID); oHs.Add("Pk_CrPr_Details_ID", crPrDetailID); oHs.Add("Pk_CrPrCh_ID", crPrChildID); oHs.Add("fk_AcademicYear_ID", fk_AcademicYear_ID); oHs.Add("fk_AcademicYear_Seq", fk_AcademicYear_Seq); oHs.Add("DeleteOldCancelEntry", DeleteOldCancelEntry); oHs.Add("UserID", createdBy); oHs.Add("CrPr_Seq", CrPr_Seq); oHs.Add("CrPrCh_Seq", CrPrCh_Seq); oHs.Add("ExecutionStatus", flag); Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = oDB.GenerateCommand("ELGV2_StudyCenterChange_ForStudent", oHs); cmd.ExecuteNonQuery(); flag = Convert.ToInt32(cmd.Parameters["@ExecutionStatus"].Value); } catch (SqlException ex) { return(0); throw (ex); } finally { Pool.ReleaseDBObject(oDB); } return(flag); }
public static DataTable CreateMercy(string PK_Year, string PK_Student, string targetXML) { DBObjectPool Pool = null; DBObject oDB = null; string UniID = clsGetSettings.UniversityID.Trim(); Hashtable objHT = new Hashtable(); objHT.Add("pk_Year", PK_Year); objHT.Add("Pk_Student_Id", PK_Student); objHT.Add("TargetXML", targetXML); DataSet ds = new DataSet(); try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); SqlCommand cmd = new SqlCommand(); cmd = oDB.GenerateCommand("Results_Update_ReRegistration_Flag_For_Mercy", objHT); if (targetXML != null && targetXML != string.Empty) { cmd.Parameters.RemoveAt("@TargetXML"); cmd.Parameters.Add("@TargetXML", SqlDbType.Xml); cmd.Parameters["@TargetXML"].Value = targetXML; } SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); } catch (Exception ex) { throw ex; } finally { Pool.ReleaseDBObject(oDB); } if (ds != null && ds.Tables.Count != 0) { return(ds.Tables[0]); } else { return(null); } }
/// <summary> /// This function is used to associate the record from IA table with a matching record in the REG table. /// </summary> /// <param name="pk_Uni_ID"></param> /// <param name="pk_Year"></param> /// <param name="pk_Student_ID"></param> /// <param name="Ref_pk_Uni_ID"></param> /// <param name="Ref_pk_Year"></param> /// <param name="Ref_pk_Institute_ID"></param> /// <param name="Ref_pk_Student_ID"></param> /// <param name="ElgDecision"></param> /// <param name="Reason"></param> /// <param name="pk_CrMoLrnPtrn_ID"></param> /// <param name="UserID"></param> /// <param name="DocXML"></param> /// <param name="ExistingPRN"></param> /// <returns>It returns a string array with PRN and Eligibility Flag of the Course to which the current /// record gets associated.</returns> public static string[] Associate_Student_With_Course(string pk_Uni_ID, string pk_Year, string pk_Student_ID, string Ref_pk_Uni_ID, string Ref_pk_Year, string Ref_pk_Institute_ID, string Ref_pk_Student_ID, string ElgDecision, string Reason, string pk_CrMoLrnPtrn_ID, string UserID, System.Text.StringBuilder DocXML, string ExistingPRN) { string[] arr = new string[3]; Hashtable ht = new Hashtable(); SqlCommand cmd = new SqlCommand(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("pk_Uni_ID", pk_Uni_ID); ht.Add("pk_Year", pk_Year); ht.Add("pk_Student_ID", pk_Student_ID); 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); ht.Add("ElgDecision", ElgDecision); ht.Add("Reason", Reason); ht.Add("pk_CrMoLrnPtrn_ID", pk_CrMoLrnPtrn_ID); ht.Add("UserID", UserID); ht.Add("DocXML", DocXML.ToString()); ht.Add("ExistingPRN", ExistingPRN); ht.Add("PRN", ""); ht.Add("Flag", 0); ht.Add("Error", 0); cmd = oDB.GenerateCommand("elg_Associate_Student_With_Course", ht); cmd.Parameters["@PRN"].Direction = ParameterDirection.Output; cmd.Parameters["@Flag"].Direction = ParameterDirection.Output; cmd.Parameters["@Error"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); arr[0] = cmd.Parameters["@PRN"].Value.ToString(); arr[1] = cmd.Parameters["@Flag"].Value.ToString(); arr[2] = cmd.Parameters["@Error"].Value.ToString(); return(arr); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); throw(e); } finally { Pool.ReleaseDBObject(oDB); } }
public string Modify_EligibilityRights(string pk_Uni_ID, string pk_Fac_ID, string pk_Cr_ID, string pk_MoLrn_ID, string pk_CrPtrn_ID, string Elg_Rights_Flag, string Created_By, string For_All_Coll) { DBObjectPool Pool = null; DBObject oDB = null; Hashtable oHs = new Hashtable(); string sReturnData = ""; SqlCommand cmd; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); oHs.Add("pk_Uni_ID", pk_Uni_ID); oHs.Add("pk_Fac_ID", pk_Fac_ID); oHs.Add("pk_Cr_ID", pk_Cr_ID); oHs.Add("pk_MoLrn_ID", pk_MoLrn_ID); oHs.Add("pk_CrPtrn_ID", pk_CrPtrn_ID); oHs.Add("Elg_Rights_Flag", Elg_Rights_Flag); oHs.Add("Modified_By", Created_By); oHs.Add("For_All_Coll", For_All_Coll); cmd = oDB.GenerateCommand("Elg_Update_Eligibility_Rights", oHs); int i = cmd.ExecuteNonQuery(); if (i > 0) { sReturnData = "Y"; } else { sReturnData = "N"; } } catch (SqlException ex) { sReturnData = "N"; throw (ex); } finally { Pool.ReleaseDBObject(oDB); } return(sReturnData); }
public string ListStudentPhotoSignXML(string AcademicYearID, string UniID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrID, string CrPrChID, string LowerLimit, string UpperLimit, string ExamEventID) { DBObjectPool Pool = null; Pool = DBObjectPool.Instance; DBObject oDB = Pool.AcquireDBObject(); ht = new Hashtable(); ht.Add("AcademicYearID", AcademicYearID); //shrikantb on 08102013 ht.Add("ExamEventID", ExamEventID); 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); ht.Add("LowerLimit", LowerLimit); ht.Add("UpperLimit", UpperLimit); System.Xml.XmlReader oR = null; System.Text.StringBuilder oS = new System.Text.StringBuilder(); try { SqlCommand cmd = oDB.GenerateCommand("ElgV2_ListStudentPhotoSignXML", ht); oR = cmd.ExecuteXmlReader(); while (!oR.EOF) { if (oR.IsStartElement()) { oS.Append(oR.ReadOuterXml()); oS.Append(Environment.NewLine); } } } finally { Pool.ReleaseDBObject(oDB); } return(oS.ToString()); }
//Added to Log the error while hiting to OA API public void WriteOAErrorLog(Hashtable oHt) { SqlCommand cmd = new SqlCommand(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); oDB.ThisConnectionFor = DBConnection.DCWrite; cmd = oDB.GenerateCommand("REGD_CancelAdmission_OA_ErrorLog", oHt); cmd.ExecuteNonQuery(); } finally { Pool.ReleaseDBObject(oDB); } }
/// <summary> /// Add Selected Additional Paper Fo rAdd Paper Change /// </summary> /// <param name="oHT">Hashtable</param> /// <returns>string</returns> public string AddSelectedAdditionalPaperForAddPaperChange(Hashtable oHt) { string flag; SqlCommand cmd; DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); cmd = oDB.GenerateCommand("ELGV2_Add_StudentAdditionalPapersForAddPaperChange", oHt); cmd.ExecuteNonQuery(); flag = cmd.Parameters["@Result_Out"].Value.ToString(); } finally { Pool.ReleaseDBObject(oDB); } return(flag); }
/// <summary> /// This will Remove the Addiotnal Papers that are Opted by student for Add Paper Change /// </summary> /// <param name="oHt"></param> /// <returns></returns> public string Remove_AdditionalPapersForAddPaperChange(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_Remove_AdditionalPapers_ForAddPaperChange", oHt); cmd.ExecuteNonQuery(); flag = cmd.Parameters["@Result_Out"].Value.ToString(); } finally { Pool.ReleaseDBObject(oDB); } return(flag); }
public static string Bulk_Process_Eligibility_Data(string Uni_ID, string Year, string Institute_ID, string pk_CrMoLrnPtrn_ID, string pk_CrPr_ID, string Student_ID, string College_Eligibility_Flag, string ElgDecision, string Reason, string UserID) { string sReturn = ""; Hashtable ht = new Hashtable(); SqlCommand cmd = new SqlCommand(); DBObjectPool Pool = null; DBObject oDB = null; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); ht.Add("Uni_ID", Uni_ID); ht.Add("Year", Year); ht.Add("Institute_ID", Institute_ID); ht.Add("Student_ID", Student_ID); ht.Add("ElgDecision", ElgDecision); ht.Add("Reason", Reason); ht.Add("pk_CrMoLrnPtrn_ID", pk_CrMoLrnPtrn_ID); ht.Add("pk_CrPr_ID", pk_CrPr_ID); ht.Add("College_Eligibility_Flag", College_Eligibility_Flag); ht.Add("UserID", UserID); ht.Add("PRN", ""); cmd = oDB.GenerateCommand("ELG_Add_BULK_DATA_PRN", ht); cmd.ExecuteNonQuery(); sReturn = "Y"; return(sReturn); } catch (Exception Ex) { Exception e = new Exception(Ex.Message, Ex); sReturn = "N"; throw (e); } finally { Pool.ReleaseDBObject(oDB); } }
public string Add_EligibilityRights(string pk_Uni_ID, string pk_Fac_ID, string pk_Cr_ID, string pk_MoLrn_ID, string pk_CrPtrn_ID, string Elg_Rights_Flag, string Created_By, string For_All_Coll) { DBObjectPool Pool = null; DBObject oDB = null; Hashtable oHS = new Hashtable(); string sReturnData = ""; SqlCommand cmd; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); oHS.Add("pk_Uni_ID", pk_Uni_ID); oHS.Add("pk_Fac_ID", pk_Fac_ID); oHS.Add("pk_Cr_ID", pk_Cr_ID); oHS.Add("pk_MoLrn_ID", pk_MoLrn_ID); oHS.Add("pk_CrPtrn_ID", pk_CrPtrn_ID); oHS.Add("Elg_Rights_Flag", Elg_Rights_Flag); oHS.Add("Created_By", Created_By); oHS.Add("For_All_Coll", For_All_Coll); cmd = oDB.GenerateCommand("ELG_Add_Eligibility_Rights", oHS); cmd.ExecuteScalar(); sReturnData = "Y"; } catch (SqlException ex) { sReturnData = "N"; throw (ex); } finally { Pool.ReleaseDBObject(oDB); } return(sReturnData); }
public int ImportPRNFromExcel(string SourceTableName, string userID) { string result; DBObjectPool Pool = null; DBObject oDB = null; Hashtable objHT = new Hashtable(); string UniID = clsGetSettings.UniversityID.ToString(); int Status = 0; try { Pool = DBObjectPool.Instance; oDB = Pool.AcquireDBObject(); string DCDatabase = ConfigurationManager.AppSettings["DCDataBase"]; //y string dbname = (DCDatabase != "") ? DCDatabase.Split('_')[1] : ""; //y objHT.Add("TableName", SourceTableName); objHT.Add("User", userID); objHT.Add("ExecutionStatus", Status); objHT.Add("DBName", dbname);//y SqlCommand cmd = oDB.GenerateCommand("ELGV2_ImportPRN", objHT); cmd.ExecuteNonQuery(); Status = Convert.ToInt32(cmd.Parameters["@ExecutionStatus"].Value); } catch (Exception ex) { result = ex.Message; return(0); } finally { Pool.ReleaseDBObject(oDB); } return(Status); }
internal string DeleteConfigurations(Hashtable oHs) { DBObjectPool oPool = null; DBObject oDB = null; SqlCommand oCmd; string sRes = string.Empty; int iRows = 0; try { oPool = DBObjectPool.Instance; oDB = oPool.AcquireDBObject(); oCmd = oDB.GenerateCommand("ELGV2_DeleteConfigurations", oHs); iRows = oCmd.ExecuteNonQuery(); sRes = oCmd.Parameters["@Status"].Value.ToString(); } finally { oPool.ReleaseDBObject(oDB); } return(sRes); }