public override int InsertUniversityDetails(BO.UniversityProperty objUniversityProerty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UniversityName", objUniversityProerty.UniversityName);
_objDataWrapper.AddParameter("@UniversityUrl", objUniversityProerty.UniversityUrl);
_objDataWrapper.AddParameter("@UniversityTitle", objUniversityProerty.UniversityTitle);
_objDataWrapper.AddParameter("@UniversityMetaDesc", objUniversityProerty.UniversityMetaDesc);
_objDataWrapper.AddParameter("@UniversityCategoryId", objUniversityProerty.UniversityCategoryId);
_objDataWrapper.AddParameter("@UniversityMetaTag", objUniversityProerty.UniversityMetaTag);
_objDataWrapper.AddParameter("@UniversityDesc", objUniversityProerty.UniversityDesc);
_objDataWrapper.AddParameter("@UniversityLogo", objUniversityProerty.UniversityLogo);
_objDataWrapper.AddParameter("@UniversityWebsite", objUniversityProerty.UniversityWebsite);
_objDataWrapper.AddParameter("@UniversityEst", objUniversityProerty.UniversityEst);
_objDataWrapper.AddParameter("@UniversityPhone", objUniversityProerty.UniversityPhoneNo);
_objDataWrapper.AddParameter("@UniversityMobile", objUniversityProerty.UniversityMobile);
_objDataWrapper.AddParameter("@UniversityEmailId", objUniversityProerty.UniversityEmailId);
_objDataWrapper.AddParameter("@UniversityPopularName", objUniversityProerty.UniversityPopularName);
_objDataWrapper.AddParameter("@UniversityShortName", objUniversityProerty.UniversityshortName);
_objDataWrapper.AddParameter("@UniversityFax", objUniversityProerty.UniversityFax);
_objDataWrapper.AddParameter("@UniversityAddrs", objUniversityProerty.UniversityAddrs);
_objDataWrapper.AddParameter("@UniversityCountryId", objUniversityProerty.UniversityCountryId);
_objDataWrapper.AddParameter("@UniversityStateId", objUniversityProerty.UniversityStateId);
_objDataWrapper.AddParameter("@UniversityCityId", objUniversityProerty.UniversityCityId);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var objErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUniversityDetails");
if (objErrMsg != null && objErrMsg.Value != null)
{
errmsg = Convert.ToString(objErrMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertUniversityDetails in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int InsertBankInfo(BankDetailsProperty objBankProperty, int createdBy, out string errmsg,
out int bankId)
{
bankId = 0;
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@BankName", objBankProperty.BankName);
_objDataWrapper.AddParameter("@BankShortName", objBankProperty.BankShortName);
_objDataWrapper.AddParameter("@BankUrl", objBankProperty.BankUrl);
_objDataWrapper.AddParameter("@BankAddress", objBankProperty.BankAddress);
_objDataWrapper.AddParameter("@BankPhoneNo", objBankProperty.BankPhoneNo);
_objDataWrapper.AddParameter("@BankLogo", objBankProperty.BankLogo);
_objDataWrapper.AddParameter("@BankShortDescription", objBankProperty.BankShortDescription);
_objDataWrapper.AddParameter("@BankContactPerson", objBankProperty.BankContactPerson);
_objDataWrapper.AddParameter("@BankContactPersonDesignation", objBankProperty.BankContactPersonDesignation);
_objDataWrapper.AddParameter("@BankContactPersonEmailId", objBankProperty.BankContactPersonEmailId);
_objDataWrapper.AddParameter("@BankContactPersonMobile", objBankProperty.BankContactPersonMobile);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var objBankId =
(SqlParameter)(_objDataWrapper.AddParameter("@BankId", objBankProperty.BankId, SqlDbType.Int, ParameterDirection.InputOutput));
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateBankDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errmsg = Convert.ToString(objErrmsg.Value);
}
if (objBankId != null && objBankId.Value != null)
{
bankId = Convert.ToInt32(objBankId.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertBankInfo in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public string[] CountTotalSheets(string file)
{
int i = 0;
OleDbConnection consrc;
String[] excelSheets = new String[0];
string consrcstr = file.EndsWith(".xls") ? Common.OleCnnString : Common.OleCnnString2007;
consrcstr = consrcstr + file;
consrc = new OleDbConnection(consrcstr);
DataSet ds = new DataSet();
try
{
if (consrc.State == ConnectionState.Closed)
{
consrc.Open();
}
DataTable dt = consrc.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
excelSheets = new String[dt.Rows.Count];
// Add the sheet name to the string array.
foreach (DataRow row in dt.Rows)
{
excelSheets[i] = row["TABLE_NAME"].ToString();
i++;
}
consrc.Close();
}
catch (Exception ex)
{
consrc.Close();
string err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error while CountTotalSheets in ClsOleDBDataWrapper :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
finally
{
consrc.Close();
}
return(excelSheets);
}
/* End: Constructor.....*/
public DataTable GetRecordsForMappedColumnFromCSVToDataTable(string _strTableName, string _strPrimaryKey, string filePath, string[] SeprateColumns)
{
dtb = new DataTable();
var objClsOledbdatalayer = new ClsOleDBDataWrapper();
string FileColumnName = "", DBColumnName = "", DBDataType = "", DBSize = "", StrColumn = "";
foreach (string strColumns in SeprateColumns)
{
var arrColumns = strColumns.Split('|');
FileColumnName = Convert.ToString(arrColumns[0]).Trim();
DBColumnName = Convert.ToString(arrColumns[1]).Trim();
DBDataType = Convert.ToString(arrColumns[2]).Trim();
DBSize = Convert.ToString(arrColumns[3]).Trim();
StrColumn += FileColumnName + ",";
}
StrColumn = StrColumn.TrimEnd(',');
string location = HttpContext.Current.Server.MapPath("~/Resource/ExcelUpload/" + filePath);
try
{
var excelSheets = objClsOledbdatalayer.CountTotalSheets(location);
if (excelSheets.Length > 0)
{
foreach (DataTable dt in excelSheets.Select(t => objClsOledbdatalayer.GetExcelSheetValueBasedOnColumn(location, StrColumn, t)).Where(dt => dt.Rows.Count > 0))
{
dtb = dt.Rows.Cast <DataRow>().Where(row => !row.ItemArray.All(field => field is System.DBNull || string.Compare((field as string).Trim(), string.Empty) == 0)).CopyToDataTable();
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetRecordsForMappedColumnFromCSVToDataTable in ExcelToDataTable.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(dtb);
}
private List <PackageFactorMaster> BindFactorByPackage(DataTable datatable)
{
var objPackageFactorList = new List <PackageFactorMaster>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
var objPackageFactor = new PackageFactorMaster();
var objPackage = new PackageMaster();
var objFactorMasterList = new List <PackageFactor>();
var objPackageFactorID = new List <int>();
objPackage.PackageId = (datatable.Rows[0]["AjPackageId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["AjPackageId"]);
objPackage.PackageName = (datatable.Rows[0]["PackageName"] is DBNull) ? "" : Convert.ToString(datatable.Rows[0]["PackageName"]);
objPackage.PackageAmount = (datatable.Rows[0]["PackageAmount"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["PackageAmount"]);
objPackage.IsChargeable = (datatable.Rows[0]["IsPackageChargeable"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[0]["IsPackageChargeable"]);
objPackage.IsVisible = (datatable.Rows[0]["IsVisible"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[0]["IsVisible"]);
objPackage.courseId = (datatable.Rows[0]["AjCourseId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[0]["AjCourseId"]);
objPackage.CourseName = (datatable.Rows[0]["AjCourseName"] is DBNull) ? null : Convert.ToString(datatable.Rows[0]["AjCourseName"]);
objPackageFactor.objPackage = objPackage;
for (var j = 0; j < datatable.Rows.Count; j++)
{
var packageFactorId = (datatable.Rows[j]["AjPackageFactorId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjPackageFactorId"]);
var objPackageMaster = new PackageFactor();
objPackageMaster.FactorID = (datatable.Rows[j]["FactorId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["FactorId"]);
objPackageMaster.FactorName = (datatable.Rows[j]["AjFactorName"] is DBNull) ? "" : Convert.ToString(datatable.Rows[j]["AjFactorName"]);
objPackageFactorID.Add(packageFactorId);
objFactorMasterList.Add(objPackageMaster);
}
objPackageFactor.ObjPackageFactor = objFactorMasterList;
objPackageFactor.PackageFactorId = objPackageFactorID;
objPackageFactorList.Add(objPackageFactor);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindFactorByPackage in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}
// Method to bind the QueryList
private List <QueryProperty> BindQueryObjectList(DataTable datatable)
{
List <QueryProperty> listQueryProperty = new List <QueryProperty>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (int i = 0; i < datatable.Rows.Count; i++)
{
var objQueryProperty = new QueryProperty
{
UserId = Convert.ToInt32(datatable.Rows[i]["AjUserId"]),
UserMobileNo = Convert.ToString(datatable.Rows[i]["AjUserMobile"]),
UserEmailId = Convert.ToString(datatable.Rows[i]["AjUserEmail"]),
StudentSourceId = Convert.ToInt32(datatable.Rows[i]["SourceId"]),
StudentCourseId = Convert.ToInt32(datatable.Rows[i]["AjCourseId"]),
StudentCourseName = Convert.ToString(datatable.Rows[i]["CourseName"]),
StudentName = Convert.ToString(datatable.Rows[i]["AjUserFullName"]),
StudentQuery = Convert.ToString(datatable.Rows[i]["AjStudentQueryText"]),
SourceTypeName = Convert.ToString(datatable.Rows[i]["Source"]),
StudentQueryId = Convert.ToString(datatable.Rows[i]["AjStudentQueryId"]),
StudentCityName = Convert.ToString(datatable.Rows[i]["AjCityName"]),
SourceName = Convert.ToString(datatable.Rows[i]["SourceName"]),
ReplyStatus = Convert.ToBoolean(datatable.Rows[i]["AjStudentQueryReplyStatus"]),
QueryReply = datatable.Columns.Contains("AjQueryReply") == true ? ((datatable.Rows[i]["AjQueryReply"] is DBNull) ? null : Convert.ToString(datatable.Rows[i]["AjQueryReply"])) : null,
CreatedOn = Convert.ToDateTime(datatable.Rows[i]["CreatedOn"]),
QueryStatus = datatable.Columns.Contains("AjQueryStatus") == true ? ((datatable.Rows[i]["AjQueryStatus"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[i]["AjQueryStatus"])) : false,
};
listQueryProperty.Add(objQueryProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindQueryObjectList in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(listQueryProperty);
}
// This is private member that will bind the Coutse stream Object List
private List <CourseStreamProperty> BindStreamObjectList(DataTable datatable)
{
var courseStreamObjectList = new List <CourseStreamProperty>();
try
{
if (datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objCourseStream = new CourseStreamProperty
{
CourseId = Convert.ToInt32(datatable.Rows[j]["AjCourseId"]),
CourseName = Convert.ToString(datatable.Rows[j]["AjCourseName"]),
CourseSteamFuture = Convert.ToString(datatable.Rows[j]["AjCourseStreamFuture"]),
CourseStreamCoreCompanies = Convert.ToString(datatable.Rows[j]["AjCourseStreamCoreCompanies"]),
CourseStreamDesc = Convert.ToString(datatable.Rows[j]["AjCourseStreamDesc"]),
CourseStreamHistory = Convert.ToString(datatable.Rows[j]["AjCourseStreamHistory"]),
CourseStreamMetaDesc = Convert.ToString(datatable.Rows[j]["AjCourseStreamMetaDesc"]),
CourseStreamMetaTag = Convert.ToString(datatable.Rows[j]["AjCourseStreamMetaTag"]),
CourseStreamName = Convert.ToString(datatable.Rows[j]["AjCourseStreamName"]),
CourseStreamRelatedIndustry = Convert.ToString(datatable.Rows[j]["AjCourseStreamRelatedIndustry"]),
CourseStreamStatus = Convert.ToBoolean(datatable.Rows[j]["AjCourseStreamStatus"]),
CourseStreamTitle = Convert.ToString(datatable.Rows[j]["AjCourseStreamTitle"]),
CourseStreamUrl = Convert.ToString(datatable.Rows[j]["AjCourseStreamUrl"]),
StreamId = Convert.ToInt32(datatable.Rows[j]["AjCourseStreamId"])
};
courseStreamObjectList.Add(objCourseStream);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindStreamObjectList in Stream.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseStreamObjectList);
}
private List <ExamProperty> BindExamListObject(DataTable dataTable)
{
var examObjectList = new List <ExamProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objExamProperty = new ExamProperty
{
ExamId = Convert.ToInt32(dataTable.Rows[j]["AjExamId"]),
CourseName = Convert.ToString(dataTable.Rows[j]["AjCourseName"]),
ExamDesc = Convert.ToString(dataTable.Rows[j]["AjExamDesc"]),
ExamEligiblityCriteria =
Convert.ToString(dataTable.Rows[j]["AjExamEligiblityCriteria"]),
ExamFullName = Convert.ToString(dataTable.Rows[j]["AjExamFullName"]),
ExamLogo = Convert.ToString(dataTable.Rows[j]["AjExamLogo"]),
ExamName = Convert.ToString(dataTable.Rows[j]["AjExamName"]),
ExamPopularName =
Convert.ToString(dataTable.Rows[j]["AjExamPopularName"]),
ExamWebSite = Convert.ToString(dataTable.Rows[j]["AjExamWebsite"]),
CourseId = Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
ExamStatus = Convert.ToBoolean(dataTable.Rows[j]["AjExamStatus"]),
HelpLineNumber = Convert.ToString(dataTable.Columns.Contains("AjHelpLineNo") ? (dataTable.Rows[j]["AjHelpLineNo"].ToString() != "" ? dataTable.Rows[j]["AjHelpLineNo"] : null) : null),
};
examObjectList.Add(objExamProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindExamListObject in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(examObjectList);
}
private List <LoanDetailsProperty> BindLoanList(DataTable datatable)
{
var objLoanList = new List <LoanDetailsProperty>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objLoanListProperty = new LoanDetailsProperty
{
BankId = (datatable.Rows[j]["AjBankId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjBankId"]),
LoanId = (datatable.Rows[j]["AjLoanId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjLoanId"]),
LoanRangeId = (datatable.Rows[j]["AjLoanRangeId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjLoanRangeId"]),
StudyPlaceId = (datatable.Rows[j]["AjStudyPlaceId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjStudyPlaceId"]),
Eligibilty = (datatable.Rows[j]["AjEligibilty"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjEligibilty"]),
Security = (datatable.Rows[j]["AjSecurity"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjSecurity"]),
RepaymentDuration = (datatable.Rows[j]["AjRepaymentDuration"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRepaymentDuration"]),
Remark = (datatable.Rows[j]["AjRemark"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRemark"]),
RateOfInterest = (datatable.Rows[j]["AjRateOfInterest"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjRateOfInterest"]),
ProcessingFees = (datatable.Rows[j]["AjProcessingFees"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjProcessingFees"]),
ProcessingTime = (datatable.Rows[j]["AjProcessingTime"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjProcessingTime"]),
Margin = (datatable.Rows[j]["AjMargin"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjMargin"]),
Amount = (datatable.Rows[j]["AjAmount"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjAmount"]),
StudyPlaceName = (datatable.Rows[j]["AjStudyPlaceName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjStudyPlaceName"])
};
objLoanList.Add(objLoanListProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindBankList in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objLoanList);
}
public override int UpdateCourseMasterDetails(int courseId, string courseName, string courseUrl, string courseTitle, string courseMetaTag, string courseMetaDesc, string courseDesc, string courseshortName, string coursePopularName, int courseCategoryId, int courseEligibiltyId, int createdBy, out string errMsg, string CourseImage, string HelpLineNo, bool courseStatus = false, bool IsBookSeatVisible = true)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@CourseId", courseId);
_objDataWrapper.AddParameter("@CourseName", courseName);
_objDataWrapper.AddParameter("@CourseUrl", courseUrl);
_objDataWrapper.AddParameter("@CourseTitle", courseTitle);
_objDataWrapper.AddParameter("@CourseMetaTag", courseMetaTag);
_objDataWrapper.AddParameter("@CourseMetaDesc", courseMetaDesc);
_objDataWrapper.AddParameter("@CourseDesc", courseDesc);
_objDataWrapper.AddParameter("@CourseShortName", courseshortName);
_objDataWrapper.AddParameter("@CoursePopularName", coursePopularName);
_objDataWrapper.AddParameter("@CoursecategoryId", courseCategoryId);
_objDataWrapper.AddParameter("@CourseEligibiltyId", courseEligibiltyId);
_objDataWrapper.AddParameter("@CourseStatus", courseStatus);
_objDataWrapper.AddParameter("@CourseImage", CourseImage);
_objDataWrapper.AddParameter("createdBy", createdBy);
_objDataWrapper.AddParameter("@AjHelpLineNo", HelpLineNo);
_objDataWrapper.AddParameter("@AjIsBookSeatVisible", IsBookSeatVisible);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCourseMasterDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errMsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateCourseMasterDetails in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
// Method To get The Column Data from Excel
public DataTable GetExcelSheetValueBasedOnColumn(string fileName, string columnName, string sheetname)
{
OleDbConnection consrc;
string consrcstr = fileName.EndsWith(".xls") ? Common.OleCnnString : Common.OleCnnString2007;
consrcstr = consrcstr + fileName;
consrc = new OleDbConnection(consrcstr);
DataSet ds = new DataSet();
try
{
if (consrc.State == ConnectionState.Closed)
{
consrc.Open();
}
string cmd = "select " + columnName + " from [" + sheetname + "]";
OleDbDataAdapter cmdsrc = new OleDbDataAdapter(cmd, consrc);
cmdsrc.TableMappings.Clear();
cmdsrc.TableMappings.Add("Table", "Data");
cmdsrc.Fill(ds);
consrc.Close();
}
catch (Exception ex)
{
consrc.Close();
string err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
string addInfo = "Error while executing GetExcelSheetValueBasedOnColumn in OleDbConnection.cs :: -> ";
ClsExceptionPublisher objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
finally
{
consrc.Close();
}
return(ds.Tables[0]);
}
public override int InsertCommonQuickQuery(QueryProperty objQuickQuery, out string errMsg, out int UserId)
{
errMsg = "";
UserId = 0;
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@UserEmailId", objQuickQuery.UserEmailId);
_objDataWrapper.AddParameter("@UserName", objQuickQuery.StudentName);
_objDataWrapper.AddParameter("@UserMobile", objQuickQuery.UserMobileNo);
_objDataWrapper.AddParameter("@UserPasseord", _objCrypto.Encrypt(objQuickQuery.UserMobileNo));
_objDataWrapper.AddParameter("@UserCity", objQuickQuery.StudentCityName);
_objDataWrapper.AddParameter("@UserQuerySourceTypeId", QueryType.Com);
_objDataWrapper.AddParameter("@UserCourseId", objQuickQuery.StudentCourseId);
_objDataWrapper.AddParameter("@UserQuery", objQuickQuery.StudentQuery);
var ObjerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
var ObjUserId =
(SqlParameter)(_objDataWrapper.AddParameter("@UserId", SqlDbType.Int, ParameterDirection.Output));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUserQuery");
if (ObjerrMsg != null && ObjerrMsg.Value != null)
{
errMsg = Convert.ToString(ObjerrMsg.Value);
}
if (ObjUserId != null && ObjUserId.Value != null)
{
UserId = Convert.ToInt32(ObjUserId.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertCommonQuickQuery in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateLoanInfo(LoanDetailsProperty objLoanDetailsProperty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@LoanId", objLoanDetailsProperty.LoanId);
_objDataWrapper.AddParameter("@BankId", objLoanDetailsProperty.BankId);
_objDataWrapper.AddParameter("@LoanRangeId", objLoanDetailsProperty.LoanRangeId);
_objDataWrapper.AddParameter("@StudyPlaceId", objLoanDetailsProperty.StudyPlaceId);
_objDataWrapper.AddParameter("@Eligibilty", objLoanDetailsProperty.Eligibilty);
_objDataWrapper.AddParameter("@Security", objLoanDetailsProperty.Security);
_objDataWrapper.AddParameter("@Margin", objLoanDetailsProperty.Margin);
_objDataWrapper.AddParameter("@ProcessingFees", objLoanDetailsProperty.ProcessingFees);
_objDataWrapper.AddParameter("@ProcessingTime", objLoanDetailsProperty.ProcessingTime);
_objDataWrapper.AddParameter("@RateOfInterest", objLoanDetailsProperty.RateOfInterest);
_objDataWrapper.AddParameter("@Remark", objLoanDetailsProperty.Remark);
_objDataWrapper.AddParameter("@RepaymentDuration", objLoanDetailsProperty.RepaymentDuration);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateLoanInfoDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errmsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateLoanInfo in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public List <CoursePaymentMasterProperty> BindCoursePaymentMasterObject(DataTable dataTable)
{
var coursePaymentMasterList = new List <CoursePaymentMasterProperty>();
try
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objcoursecategory = new CoursePaymentMasterProperty
{
PaymentCourseId = (dataTable.Rows[j]["AjPaymentCourseId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjPaymentCourseId"]),
CourseId = (dataTable.Rows[j]["AjCourseId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]),
OnlinePaymentAmount =
(dataTable.Rows[j]["AjPaymentAmount"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjPaymentAmount"]),
OfflinePaymentAmount =
(dataTable.Rows[j]["AjOfflinePaymentAmount"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjOfflinePaymentAmount"]),
CourseName = (dataTable.Rows[j]["AjCourseName"] is DBNull) ? null :
Convert.ToString(dataTable.Rows[j]["AjCourseName"]),
courseCategoryId = (dataTable.Rows[j]["AjCourseCategoryId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCourseCategoryId"]),
};
coursePaymentMasterList.Add(objcoursecategory);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCoursePaymentMasterObject in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(coursePaymentMasterList);
}
private List <BankDetailsProperty> BindBankList(DataTable datatable)
{
var objBankList = new List <BankDetailsProperty>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objBankListProperty = new BankDetailsProperty
{
BankId = Convert.ToInt32(datatable.Rows[j]["AjBankId"]),
BankName = Convert.ToString(datatable.Rows[j]["AJBankName"]),
BankShortName = Convert.ToString(datatable.Rows[j]["AjBankShortName"]),
BankShortDescription = Convert.ToString(datatable.Rows[j]["AjBankShortDescription"]),
BankPhoneNo = Convert.ToString(datatable.Rows[j]["AjBankPhoneNo"]),
BankUrl = Convert.ToString(datatable.Rows[j]["AjBankUrl"]),
BankContactPersonMobile = Convert.ToString(datatable.Rows[j]["AjBankContactPersonMobile"]),
BankContactPerson = Convert.ToString(datatable.Rows[j]["AjBankContactPerson"]),
BankContactPersonDesignation = Convert.ToString(datatable.Rows[j]["AjBankContactPersonDesignation"]),
BankContactPersonEmailId = Convert.ToString(datatable.Rows[j]["AjBankContactPersonEmailId"]),
BankAddress = Convert.ToString(datatable.Rows[j]["AjBankAddress"]),
BankLogo = Convert.ToString(datatable.Rows[j]["AjBankLogo"])
};
objBankList.Add(objBankListProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindBankList in Bank.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objBankList);
}
private List <CourseEligibiltyProperty> BindCourseEligibiltyObject(DataTable dataTable)
{
var courseEligibiltyList = new List <CourseEligibiltyProperty>();
try
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCourseEligibilty = new CourseEligibiltyProperty
{
CourseEligibilityId =
(dataTable.Rows[j]["AjCollegeCourseEligibiltyId"] is DBNull) ? 0 : Convert.ToInt32(
dataTable.Rows[j]["AjCollegeCourseEligibiltyId"]),
CourseEligibiltyName =
(dataTable.Rows[j]["AjCollegeCourseEligibiltyName"] is DBNull) ? null : Convert.ToString(
dataTable.Rows[j]["AjCollegeCourseEligibiltyName"]),
CourseEligibilityStatus =
(dataTable.Rows[j]["AjCollegeCourseEligibiltyStatus"] is DBNull) ? false : Convert.ToBoolean(
dataTable.Rows[j]["AjCollegeCourseEligibiltyStatus"])
};
courseEligibiltyList.Add(objCourseEligibilty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCourseEligibiltyObject in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(courseEligibiltyList);
}
public override int UpdateCourseStreamDetails(CourseStreamProperty objCourseStreamProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@StreamId", objCourseStreamProperty.StreamId);
_objDataWrapper.AddParameter("@StreamName", objCourseStreamProperty.CourseStreamName);
_objDataWrapper.AddParameter("@CourseId", objCourseStreamProperty.CourseId);
_objDataWrapper.AddParameter("@CourseStreamUrl", objCourseStreamProperty.CourseStreamUrl);
_objDataWrapper.AddParameter("@CourseStreamTitle", objCourseStreamProperty.CourseStreamName);
_objDataWrapper.AddParameter("@CourseStreamMetaTag", objCourseStreamProperty.CourseStreamMetaTag);
_objDataWrapper.AddParameter("@CourseStreamMetaDesc", objCourseStreamProperty.CourseStreamMetaDesc);
_objDataWrapper.AddParameter("@CourseStreamDesc", objCourseStreamProperty.CourseStreamDesc);
_objDataWrapper.AddParameter("@CourseStreamHistory", objCourseStreamProperty.CourseStreamHistory);
_objDataWrapper.AddParameter("@CourseStreamFurture", objCourseStreamProperty.CourseSteamFuture);
_objDataWrapper.AddParameter("@CourseStreamCoreCompanies", objCourseStreamProperty.CourseStreamCoreCompanies);
_objDataWrapper.AddParameter("@CourseStreamRelatedIndustry", objCourseStreamProperty.CourseStreamRelatedIndustry);
_objDataWrapper.AddParameter("@CourseStreamStatus", objCourseStreamProperty.CourseStreamStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrmsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCourseStreamDetails");
if (objErrmsg != null && objErrmsg.Value != null)
{
errmsg = Convert.ToString(objErrmsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateCourseStreamDetails in Stream.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public DataSet getdata(string file, string sheetname)
{
OleDbConnection consrc;
string consrcstr = file.EndsWith(".xls")? Common.OleCnnString:Common.OleCnnString2007;
consrcstr = consrcstr + file;
consrc = new OleDbConnection(consrcstr);
DataSet ds = new DataSet();
try
{
consrc.Open();
string cmd = "Select * from [" + sheetname + "]"; //[Sheet1$]";
OleDbDataAdapter cmdsrc = new OleDbDataAdapter(cmd, consrcstr);
cmdsrc.TableMappings.Clear();
cmdsrc.TableMappings.Add("Table", "Data");
cmdsrc.Fill(ds);
consrc.Close();
}
catch (Exception ex)
{
consrc.Close();
string err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
string addInfo = "Error :: -> ";
ClsExceptionPublisher objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
finally
{
consrc.Close();
}
return(ds);
}
// Private Method to Bind the College Group Object Details
private List <CollegeSpeechProperty> BindCollegeSpeechObjectList(DataTable datatable)
{
var objCollegeSpeechList = new List <CollegeSpeechProperty>();
try
{
if (datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objCollegeSpeechProperty = new CollegeSpeechProperty
{
CollegeSpeechId = (datatable.Rows[j]["AjCollegeKeySpeechId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjCollegeKeySpeechId"]),
CollegeName = (datatable.Rows[j]["AjCollegeBranchName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCollegeBranchName"]),
CollegeBranhID = (datatable.Rows[j]["AjCollegeBranchId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjCollegeBranchId"]),
CollegeSpeechPersonName = (datatable.Rows[j]["AjCollegeKeySpeechPersonName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCollegeKeySpeechPersonName"]),
CollegeSpeechPersonDesignation = (datatable.Rows[j]["AjCollegeKeySpeechPersonDesignation"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCollegeKeySpeechPersonDesignation"]),
CollegeSpeechPersonImage = (datatable.Rows[j]["AjCollegeKeySpeechPersonImage"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCollegeKeySpeechPersonImage"]),
CollegeSpeechDesc = (datatable.Rows[j]["AjCollegeKeySpeechDesc"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCollegeKeySpeechDesc"]),
AboutKeyPerson = (datatable.Rows[j]["AjAboutKeyPerson"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjAboutKeyPerson"]),
SpeechStatus = (datatable.Rows[j]["AjAboutKeySpeechStatus"] is DBNull) ? true : Convert.ToBoolean(datatable.Rows[j]["AjAboutKeySpeechStatus"]),
};
objCollegeSpeechList.Add(objCollegeSpeechProperty);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCollegeGroupObjectList in College.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCollegeSpeechList);
}
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 override int UpdateExamDetails(ExamProperty objExamProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@ExamId", objExamProperty.ExamId);
_objDataWrapper.AddParameter("@ExamName", objExamProperty.ExamName);
_objDataWrapper.AddParameter("@CourseId", objExamProperty.CourseId);
_objDataWrapper.AddParameter("@ExamFullName", objExamProperty.ExamFullName);
_objDataWrapper.AddParameter("@ExamPopularName", objExamProperty.ExamPopularName);
_objDataWrapper.AddParameter("@ExamLogo", objExamProperty.ExamLogo);
_objDataWrapper.AddParameter("@ExamDesc", objExamProperty.ExamDesc);
_objDataWrapper.AddParameter("@ExamWebsite", objExamProperty.ExamWebSite);
_objDataWrapper.AddParameter("@ExamEligiblityCriteria", objExamProperty.ExamEligiblityCriteria);
_objDataWrapper.AddParameter("@ExamStatus", objExamProperty.ExamStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrMsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateExam");
if (objErrMsg != null && objErrMsg.Value != null)
{
errmsg = Convert.ToString(objErrMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateExamDetails in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
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]);
}
public override int UpdateUserProfile(string value, string field, int userId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
if (field != "AjUserDOB")
{
_objDataWrapper.AddParameter("@Value", value);
}
else
{
_objDataWrapper.AddParameter("@Value", Common.GetDateFromString(value));
}
_objDataWrapper.AddParameter("@Field", field);
_objDataWrapper.AddParameter("@CreatedBy", userId);
var errmsg = "";
var errMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_UpdateUserProfile");
if (errMsg != null && errMsg.Value != null)
{
errmsg = Convert.ToString(errMsg.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateUserCategory in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int InsertUniversityDetailsUpload(BO.UniversityProperty objUniversityProerty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UniversityName", objUniversityProerty.UniversityName);
_objDataWrapper.AddParameter("@UniversityCategoryName", objUniversityProerty.UniversityCategoryName);
_objDataWrapper.AddParameter("@UniversityDesc", objUniversityProerty.UniversityDesc);
_objDataWrapper.AddParameter("@UniversityWebsite", objUniversityProerty.UniversityWebsite);
_objDataWrapper.AddParameter("@UniversityEst", objUniversityProerty.UniversityEst);
_objDataWrapper.AddParameter("@UniversityPhone", objUniversityProerty.UniversityPhoneNo);
_objDataWrapper.AddParameter("@UniversityMobile", objUniversityProerty.UniversityMobile);
_objDataWrapper.AddParameter("@UniversityEmailId", objUniversityProerty.UniversityEmailId);
_objDataWrapper.AddParameter("@UniversityPopularName", objUniversityProerty.UniversityPopularName);
_objDataWrapper.AddParameter("@UniversityShortName", objUniversityProerty.UniversityshortName);
_objDataWrapper.AddParameter("@UniversityFax", objUniversityProerty.UniversityFax);
_objDataWrapper.AddParameter("@UniversityAddrs", objUniversityProerty.UniversityAddrs);
_objDataWrapper.AddParameter("@UniversityCountryName", objUniversityProerty.UniversityCountryName);
_objDataWrapper.AddParameter("@UniversityStateName", objUniversityProerty.UniversityStateName);
_objDataWrapper.AddParameter("@UniversityCityName", objUniversityProerty.UniversityCityName);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUniversityDataUpload");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing Upload universityData in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
private List <CityProperty> BindCityObject(DataTable dataTable)
{
var objCityList = new List <CityProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCity = new CityProperty
{
CityId = (dataTable.Rows[j]["AjCityId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCityId"]),
CityName = (dataTable.Rows[j]["AjCityName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjCityName"]),
CountryId = (dataTable.Rows[j]["AjCountryId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjCountryId"]),
CountryName = (dataTable.Rows[j]["AjCountryName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjCountryName"]),
StateId = (dataTable.Rows[j]["AjStateId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjStateId"]),
StateName = (dataTable.Rows[j]["AjStateName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjStateName"]),
ZoneId = (dataTable.Rows[j]["AjZoneId"] is DBNull) ? 0 : Convert.ToInt32(dataTable.Rows[j]["AjZoneId"]),
ZoneName = (dataTable.Rows[j]["AjZoneName"] is DBNull) ? null : Convert.ToString(dataTable.Rows[j]["AjZoneName"])
};
objCityList.Add(objCity);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCityObject in City.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCityList);
}
private List <CountryProperty> BindCountryObject(DataTable dataTable)
{
if (dataTable == null)
{
throw new ArgumentNullException("dataTable");
}
var objCountryList = new List <CountryProperty>();
try
{
if (dataTable.Rows.Count > 0)
{
for (var j = 0; j < dataTable.Rows.Count; j++)
{
var objCountry = new CountryProperty
{
CountryId = Convert.ToInt32(dataTable.Rows[j]["AjCountryId"]),
CountryCode = Convert.ToString(dataTable.Rows[j]["AjCountryCode"]),
CountryName = Convert.ToString(dataTable.Rows[j]["AjCountryName"])
};
objCountryList.Add(objCountry);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindCountryObject in Country.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCountryList);
}
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 string GetUserPassword(string emailId, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
string Password = "";
var objCrypto = new ClsCrypto(ClsSecurity.GetPasswordPhrase(Common.PassPhraseOne, Common.PassPhraseTwo));
try
{
_objDataWrapper.AddParameter("@UserEmailId", emailId);
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
var objPassword =
(SqlParameter)(_objDataWrapper.AddParameter("@Password", "", SqlDbType.VarChar, ParameterDirection.Output, 64));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_GetUserPassword");
if (ObjErrMsg != null && ObjErrMsg.Value != null)
{
errmsg = Convert.ToString(ObjErrMsg.Value);
}
if (objPassword != null && objPassword.Value != null)
{
Password = Convert.ToString(objPassword.Value);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing GetUserPassword in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(!string.IsNullOrEmpty(Password)? objCrypto.Decrypt(Password):"");
}
// Method to send the SMS
public bool SendSMS(string MobileNo, string Message)
{
string responsedata = "";
string url = string.Empty;
bool Sucess = false;
try
{
url = "http://www.myvaluefirst.com/smpp/sendsms?username=quorconsultancy&password=quorom2consultancy1&to=" + MobileNo + " + &from=ajankari&text=" + Message + "";
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url);
request.Method = "GET";
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
if (response.StatusCode == HttpStatusCode.OK)
{
StreamReader responseReader = new StreamReader(response.GetResponseStream());
responsedata = responseReader.ReadToEnd();
responseReader.Close();
Sucess = true;
}
else
{
Sucess = false;
}
}
catch (Exception Ex)
{
string err = Ex.Message;
if (Ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + Ex.InnerException.Message;
}
string addInfo = "Error While sending the SMS in the CLSSMS:: -> ";
ClsExceptionPublisher objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(Sucess);
}
private List <PackageMaster> BindPackageDetails(DataTable datatable)
{
var objPackageFactorList = new List <PackageMaster>();
try
{
if (datatable != null && datatable.Rows.Count > 0)
{
for (var j = 0; j < datatable.Rows.Count; j++)
{
var objPackageFactor = new PackageMaster
{
PackageId = (datatable.Rows[j]["AjPackageId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjPackageId"]),
PackageName = (datatable.Rows[j]["PackageName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["PackageName"]),
PackageAmount = (datatable.Rows[j]["PackageAmount"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["PackageAmount"]),
IsChargeable = (datatable.Rows[j]["IsPackageChargeable"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[j]["IsPackageChargeable"]),
IsVisible = (datatable.Rows[j]["IsVisible"] is DBNull) ? false : Convert.ToBoolean(datatable.Rows[j]["IsVisible"]),
courseId = (datatable.Rows[j]["AjCourseId"] is DBNull) ? 0 : Convert.ToInt32(datatable.Rows[j]["AjCourseId"]),
CourseName = (datatable.Rows[j]["AjCourseName"] is DBNull) ? null : Convert.ToString(datatable.Rows[j]["AjCourseName"])
};
objPackageFactorList.Add(objPackageFactor);
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindPackageDetails in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objPackageFactorList);
}