public override List <StateProperty> GetStateByZone(int zoneId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var objStateList = new List <StateProperty>();
_dataSet = new DataSet();
try
{
_objDataWrapper.AddParameter("@ZoneId", zoneId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetStateListByZone");
objStateList = BindStateObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error while executing GetStateByStateId in State.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objStateList);
}
public override List <PackageFactor> GetFactorById(int factorId)
{
_dataSet = new DataSet();
var objPackageFactorList = new List <PackageFactor>();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@AjFactorId", factorId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_GetFactorList");
objPackageFactorList = BindPackageFactor(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetFactorById in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}
public override List <CityProperty> GetCityDetailsByName(string cityName)
{
_dataSet = new DataSet();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var objCityList = new List <CityProperty>();
try
{
_objDataWrapper.AddParameter("@CityName", cityName);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_GetCityList");
objCityList = BindCityObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetCityDetailsByName in City.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCityList);
}
public override List <QueryProperty> GetCollegeQuery(int collegebranchId, int queryId, int course)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var listQueryProperty = new List <QueryProperty>();
_dataset = new DataSet();
try
{
_objDataWrapper.AddParameter("@CollegeId", collegebranchId);
_objDataWrapper.AddParameter("@QueryId", queryId);
_objDataWrapper.AddParameter("@CourseId", course);
_dataset = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetCollegeQuery");
listQueryProperty = BindQueryObjectList(_dataset.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetCollegeQuery in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(listQueryProperty);
}
public override List <QueryProperty> GetAllQueryListByLoan()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
List <QueryProperty> listQueryProperty = new List <QueryProperty>();
_dataset = new DataSet();
try
{
_objDataWrapper.AddParameter("@case", QueryType.Loan);
_dataset = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetStudentQueryList");
listQueryProperty = BindQueryObjectList(_dataset.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetAllQueryListByLoan in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(listQueryProperty);
}
public override List <BO.UniversityProperty> GetUniversityListByCategory(int universityCategoryId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objUniversityList = new List <BO.UniversityProperty>();
try
{
_objDataWrapper.AddParameter("@UniversityCategoryId", universityCategoryId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetUniversityList");
objUniversityList = BindUniversityObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetUniversityListByCategory in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objUniversityList);
}
public override List <CourseStreamProperty> GetStreamListByStreamName(string streamName)
{
var courseStreamObjectList = new List <CourseStreamProperty>();
_dataSet = new DataSet();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@StreamName", streamName);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetStreamList");
courseStreamObjectList = BindStreamObjectList(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetStreamListByStreamName in Stream.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseStreamObjectList);
}
public override List <FAQCategoryProperty> GetAllFAQCategoryList()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var objFAQCategoryList = new List <FAQCategoryProperty>();
_dataSet = new DataSet();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetFAQCategoryList");
objFAQCategoryList = BindFAQCategoryObjectList(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetAllFAQCategoryList in FAQ.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objFAQCategoryList);
}
public override List <UserRegistrationProperty> GetUserListByCourseId(int courseId)
{
var userListObject = new List <UserRegistrationProperty>();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
try
{
_objDataWrapper.AddParameter("@UserCourseId", courseId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetUserList");
userListObject = BindUserListObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetUserListByCourseId in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(userListObject);
}
public override List <ExamFormProperty> GetExamFormDetailsByExamSubjectCourseId(int courseId, string subjectName)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var examFormPropertyList = new List <ExamFormProperty>();
try
{
_objDataWrapper.AddParameter("@CourseId", courseId);
_objDataWrapper.AddParameter("@SubjectName", subjectName);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetExamFormList");
examFormPropertyList = BindExamFormListObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetExamFormDetailsByExamSubjectCourseId in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examFormPropertyList);
}
public override List <CollegeSpeechProperty> GetCollegeSpeechByCourseId(int courseId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objCollegeGroupList = new List <CollegeSpeechProperty>();
try
{
_objDataWrapper.AddParameter("@CourseId", courseId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_GetCollegeSpeechList");
objCollegeGroupList = BindCollegeSpeechObjectList(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetCollegeSpeechByCourseId in CollegeSpeech.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCollegeGroupList);
}
public override List <LoanDetailsProperty> GetLoanListByLoan(int LoanId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objLoanList = new List <LoanDetailsProperty>();
try
{
_objDataWrapper.AddParameter("@LoanId", LoanId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetLoanList");
objLoanList = BindLoanList(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetLoanListByLoan in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objLoanList);
}
public List <ClsDBTablesAttributes> GetAllTablesNPrimaryColumns(string tblName)
{
DbWrapper objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
DataSet ds = new DataSet();
List <ClsDBTablesAttributes> _objListClsDBTablesAttributes = new List <ClsDBTablesAttributes>();
objDataWrapper.AddParameter("@tblName", tblName);
ds = objDataWrapper.ExecuteDataSet("Aj_Proc_GetAllTables");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ClsDBTablesAttributes _objClsDBTablesAttributes = new ClsDBTablesAttributes();
_objClsDBTablesAttributes.PropTABLENAME = ds.Tables[0].Rows[i]["TABLE_NAME"].ToString();
_objClsDBTablesAttributes.PropPK_COLUMNNAME = ds.Tables[0].Rows[i]["COLUMN_NAME"].ToString();
_objListClsDBTablesAttributes.Add(_objClsDBTablesAttributes);
}
return(_objListClsDBTablesAttributes);
}
public DataTable GetStudentAccademicInfoStatus(int UserId)
{
_dataSet = new DataSet();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@UserId", UserId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetStudentAccademicInfo");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetStudentAccademicInfoStatus in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_dataSet.Tables[0]);
}
public DataTable GetadmissionJankriTestimonial(int testimonialId = 0)
{
_dataSet = new DataSet();
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@TestimonialId", testimonialId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetAdmissionJankariTestimonial");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetadmissionJankriTestimonial in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_dataSet.Tables[0]);
}
private static void LoadData()
{
try
{
var objWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var dsTemp = objWrapper.ExecuteDataSet("Aj_Proc_GetMasterValues");
dtMasterValues = dsTemp.Tables[0];
htGender = new Hashtable {
{ "1", "Male" }, { "2", "Female" }, { "0", "Select" }
};
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing LoadData in ClsSingelton .cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
public override List <CourseMasterProperty> GetCourseSourceHome()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var courseMasterObjectList = new List <CourseMasterProperty>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetCourseSourceHome");
courseMasterObjectList = BindCourseHome(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetCourseSourceHome in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseMasterObjectList);
}
public override List <ExamProperty> GetUpComingExamList(int courseId, DateTime upComingDate)
{
_dataSet = new DataSet();
var examObjectList = new List <ExamProperty>();
try
{
_objDataWrapper.AddParameter("@CourseId", courseId);
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetMostViewdExam");
examObjectList = BindExamListObject(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetMostViewdExamByCourse in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examObjectList);
}
public override List <StudyPlace> GetStudyPlace()
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
_dataSet = new DataSet();
var objBankList = new List <StudyPlace>();
try
{
_dataSet = _objDataWrapper.ExecuteDataSet("Aj_Proc_GetStudyPlace");
objBankList = BindStudyPlaceList(_dataSet.Tables[0]);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetStudyPlace in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objBankList);
}
public List <ClsDBTablesAttributes> GetAllColumnsOfTable(string _strTableName, string AutoIncrementedColumnName)
{
DbWrapper objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
DataSet ds = new DataSet();
List <ClsDBTablesAttributes> _objListClsDBTables = new List <ClsDBTablesAttributes>();
objDataWrapper.AddParameter("@TableName", _strTableName);
objDataWrapper.AddParameter("@AutoIncrementedColumnName", AutoIncrementedColumnName);
ds = objDataWrapper.ExecuteDataSet("Aj_Proc_GetColumnsOfTable");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ClsDBTablesAttributes _objClsDBTablesAttributes = new ClsDBTablesAttributes();
_objClsDBTablesAttributes.PropColumnName = ds.Tables[0].Rows[i]["column_name"].ToString();
_objClsDBTablesAttributes.PropDataType = ds.Tables[0].Rows[i]["data_type"].ToString();
_objClsDBTablesAttributes.PropColumnDTCharLength = ds.Tables[0].Rows[i]["charLength"].ToString();
_objListClsDBTables.Add(_objClsDBTablesAttributes);
}
return(_objListClsDBTables);
}