public override string UpdateFactor(int factorId, string factorName, string factorRemar, bool isChargable, bool isVisible)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
string errMsg = "";
try
{
_objDataWrapper.AddParameter("@AjFactorId", factorId);
_objDataWrapper.AddParameter("@AjFactorName", factorName);
_objDataWrapper.AddParameter("@AjFactorRemark", factorRemar);
_objDataWrapper.AddParameter("@AjIsChargeable", isChargable);
_objDataWrapper.AddParameter("@AjIsVisible", isVisible);
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Insert_Update_Package_Factor");
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 UpdateFactor in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(errMsg);
}
public override int UpdateStateDetails(int stateId, string stateName, int zoneId, int countryId, int modofiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@StateId", stateId);
_objDataWrapper.AddParameter("@StateName", stateName);
_objDataWrapper.AddParameter("@ZoneId", zoneId);
_objDataWrapper.AddParameter("@CountryId", countryId);
_objDataWrapper.AddParameter("@CreatedBy", modofiedBy);
var objerrMsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@errmsg", "", SqlDbType.VarChar, ParameterDirection.Output, 64));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateState");
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.InnerException.Message;
}
const string addInfo = "Error while executing UpdateStateDetails in State.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
// method to Insert the country
public override int InsertCountry(string countryname, int createdby, out string errMsg, string countrycode = null)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@CountryName", countryname);
_objDataWrapper.AddParameter("@CountryCode", countrycode);
_objDataWrapper.AddParameter("@createdBy", createdby);
var objErrMsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@errmsg", "", SqlDbType.VarChar, ParameterDirection.Output, 64));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCountryDetails");
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.InnerException.Message;
}
const string addInfo = "Error while executing InsertCountry in Country.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int InsertLoanQuickQuery(QueryProperty objQuickQuery, out string errMsg)
{
errMsg = "";
_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.Loan);
_objDataWrapper.AddParameter("@UserCourseId", objQuickQuery.StudentCourseId);
_objDataWrapper.AddParameter("@UserQuery", objQuickQuery.StudentQuery);
var ObjerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUserQuery");
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 InsertLoanQuickQuery in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int InsertCoursePaymentMasterDetails(int CourseId, string OnlinePaymentAmount, string OfflinePaymentAmount, out string errMsg, int createdBy)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@CourseId", CourseId);
_objDataWrapper.AddParameter("@OnlinePaymentAmount", OnlinePaymentAmount);
_objDataWrapper.AddParameter("@OfflinePaymentAmount", OfflinePaymentAmount);
_objDataWrapper.AddParameter("@createdBy", createdBy);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCoursePaymentMaster");
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 InsertCoursePayment in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override string InsertPackage(string packageName, int courseId, string factorId, bool isChargable, bool isVisible, int amount)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
string errMsg = "";
try
{
_objDataWrapper.AddParameter("@PackageName", packageName);
_objDataWrapper.AddParameter("@FactorId", factorId);
_objDataWrapper.AddParameter("@IsVisible", isVisible);
_objDataWrapper.AddParameter("@IsPackageChargeable", isChargable);
_objDataWrapper.AddParameter("@PackageAmount", amount);
_objDataWrapper.AddParameter("@CourseId", courseId);
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@errMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_InsertPackageDetails");
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 InsertPackage in FormFackageFactor.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(errMsg);
}
public override int UpdateUnivesityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UniversityCategoryId", objUniversityCategory.UniversityCategoryId);
_objDataWrapper.AddParameter("@UniversityCategoryName", objUniversityCategory.UniversityCategoryName);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUniversityCategoryDetails");
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 UpdateUnivesityCategoryDetails in University.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int InsertFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@FAQCategoryName", objFAQCategoryProperty.FAQCategoryName);
_objDataWrapper.AddParameter("@FAQCategoryStatus", objFAQCategoryProperty.FAQCategoryStatus);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var errMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateFAQCategory");
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 InsertFAQCategory in FAQ.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int ChangePassword(int userId, string oldPassword, string newPassword, 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("@UserId", userId);
_objDataWrapper.AddParameter("@UserOldPassword", objCrypto.Encrypt(oldPassword));
_objDataWrapper.AddParameter("@UserNewPassword", objCrypto.Encrypt(newPassword));
var ObjErrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_UserChangePassword");
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 GetUserPassword in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int ModerateStudentQuery(int queryId, int moderateBy, bool status, out string errMsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = "";
try
{
_objDataWrapper.AddParameter("@queryStatus", status);
_objDataWrapper.AddParameter("@QueryId", queryId);
_objDataWrapper.AddParameter("@ModerateBy", moderateBy);
var objerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@errMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_ModerateQuery");
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 BindQueryObjectList in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override string CheckQueryModerate(int queryId)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
var isModerated = "";
try
{
_objDataWrapper.AddParameter("@QueryId", queryId);
var objerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@moderate", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_CheckQueryModerate");
if (objerrMsg != null && objerrMsg.Value != null)
{
isModerated = 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 BindQueryObjectList in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(isModerated);
}
public override int UpdateQueryReplyStatus(QueryProperty objQuickQuery, out string errMsg)
{
errMsg = "";
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@UserId", objQuickQuery.UserId);
_objDataWrapper.AddParameter("@QueryId", objQuickQuery.StudentQueryId);
_objDataWrapper.AddParameter("@ReplyStatus", objQuickQuery.ReplyStatus);
var ObjerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_UpdateQyeryStatus");
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 UpdateQueryReplyStatus in Query.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateUserCityDetails(int country, int state, int city, int userId)
{
var query = "";
query = " AjCountryId=" + country + ",AjStateId=" + state + ",AjCityId=" + city + " where AjUserId=" + userId;
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@Query", query);
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_UpdateCityUserProfile");
}
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 InsertCollegeSpeechDetails(CollegeSpeechProperty objCollegeSppechProperty, int createdBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@CollegeName", objCollegeSppechProperty.CollegeName);
_objDataWrapper.AddParameter("@CollegeSpeechPersonDesignation", objCollegeSppechProperty.CollegeSpeechPersonDesignation);
_objDataWrapper.AddParameter("@CollegeSpeechPersonName", objCollegeSppechProperty.CollegeSpeechPersonName);
_objDataWrapper.AddParameter("@CollegeSpeechPersonImage", objCollegeSppechProperty.CollegeSpeechPersonImage);
_objDataWrapper.AddParameter("@CollegeSpeechDesc", objCollegeSppechProperty.CollegeSpeechDesc);
_objDataWrapper.AddParameter("@AboutKeyPerson", objCollegeSppechProperty.AboutKeyPerson);
_objDataWrapper.AddParameter("@SpeechStatus", objCollegeSppechProperty.SpeechStatus);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var errMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCollegeSpeechDetails");
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 InsertCollegeSpeechDetails in CollegeSpeech.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateCourseCategory(int courseCategoryId, string courseCategoryName, out string errmsg, int modifiedBy, bool courseCategoryStatus = false)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@CourseCategoryId", courseCategoryId);
_objDataWrapper.AddParameter("@CourseCategoryName", courseCategoryName);
_objDataWrapper.AddParameter("@CourseCategoryStatus", courseCategoryStatus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.NVarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateCourseCategoryDetails");
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 UpdateCourseCategory in Course.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateUserInfo(UserRegistrationProperty objUserRegistrationProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
var objCrypto = new ClsCrypto(ClsSecurity.GetPasswordPhrase(Common.PassPhraseOne, Common.PassPhraseTwo));
try
{
_objDataWrapper.AddParameter("@UserCityId", objUserRegistrationProperty.CityId);
_objDataWrapper.AddParameter("@UserCountryId", objUserRegistrationProperty.CountryCode);
_objDataWrapper.AddParameter("@UserPhone", objUserRegistrationProperty.PhoneNo);
_objDataWrapper.AddParameter("@UserStateId", objUserRegistrationProperty.StateId);
_objDataWrapper.AddParameter("@UserCatId", objUserRegistrationProperty.UserCategoryId);
_objDataWrapper.AddParameter("@UserCorssAddrs", objUserRegistrationProperty.UserCorrespondenceAddress);
_objDataWrapper.AddParameter("@UserEmailId", objUserRegistrationProperty.UserEmailid);
_objDataWrapper.AddParameter("@UserFullName", objUserRegistrationProperty.UserFullName);
_objDataWrapper.AddParameter("@UserPassword", objCrypto.Encrypt(objUserRegistrationProperty.UserPassword));
_objDataWrapper.AddParameter("@UserMobileNo", objUserRegistrationProperty.MobileNo);
_objDataWrapper.AddParameter("@UserPerAddrs", objUserRegistrationProperty.UserPermanentAddress);
_objDataWrapper.AddParameter("@UserPincode", objUserRegistrationProperty.UserPincode);
_objDataWrapper.AddParameter("@UserStatus", objUserRegistrationProperty.UserStatus);
_objDataWrapper.AddParameter("@SubUserId", objUserRegistrationProperty.UserSubId);
_objDataWrapper.AddParameter("@UserCourseId", objUserRegistrationProperty.CourseId);
_objDataWrapper.AddParameter("@UserGender", objUserRegistrationProperty.UserGender);
_objDataWrapper.AddParameter("@UserDOB", objUserRegistrationProperty.UserDOB);
_objDataWrapper.AddParameter("@UserFatherName", objUserRegistrationProperty.UserFatherName);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
var objerrMsg
= (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
var objUserId
= (SqlParameter)(_objDataWrapper.AddParameter("@UserId", objUserRegistrationProperty.UserId, SqlDbType.Int, ParameterDirection.Input));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUserDetails");
if (objerrMsg != null && objerrMsg.Value != null)
{
errmsg = Convert.ToString(objerrMsg.Value);
}
if (objUserId != null && objUserId.Value != null)
{
objUserRegistrationProperty.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 UpdateUserInfo in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateExamFormDetails(ExamFormProperty objExamFormProperty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = string.Empty;
try
{
_objDataWrapper.AddParameter("@EaxmFormId", objExamFormProperty.ExamFormId);
_objDataWrapper.AddParameter("@ExamId", objExamFormProperty.ExamId);
_objDataWrapper.AddParameter("@ExamFormUrl", objExamFormProperty.ExamFormUrl);
_objDataWrapper.AddParameter("@ExamFormTitle", objExamFormProperty.ExamFormTitle);
_objDataWrapper.AddParameter("@ExamFormMetaDesc", objExamFormProperty.ExamFormMetaDesc);
_objDataWrapper.AddParameter("@ExamFormMetaTag", objExamFormProperty.ExamFormKeywords);
_objDataWrapper.AddParameter("@ExamFormSubject", objExamFormProperty.ExamFormSubject);
_objDataWrapper.AddParameter("@ExamFormYear", objExamFormProperty.ExamFormYear);
_objDataWrapper.AddParameter("@ExamFormWebsite", objExamFormProperty.ExamFormWebsite);
_objDataWrapper.AddParameter("@ExamFormSalesStartDate", objExamFormProperty.ExamFormSaleStartDate);
_objDataWrapper.AddParameter("@ExamFormSalesStartDateReamrk", objExamFormProperty.ExamFromSaleStartDateRemark);
_objDataWrapper.AddParameter("@ExamFormSalesEndDate", objExamFormProperty.ExamFormSaleEndDate);
_objDataWrapper.AddParameter("@ExamFormSalesEndDateReamrk", objExamFormProperty.ExamFormSaleEndDateRemark);
_objDataWrapper.AddParameter("@ExamFormSubmitDate", objExamFormProperty.ExamFormSubmitDate);
_objDataWrapper.AddParameter("@ExamFormSubmitDateReamrk", objExamFormProperty.ExamFormSubmitDateRemark);
_objDataWrapper.AddParameter("@ExamFormResultDate", objExamFormProperty.ExamFormResultDate);
_objDataWrapper.AddParameter("@ExamFormResultDateRemark", objExamFormProperty.ExamFormResultDateReamrk);
_objDataWrapper.AddParameter("@ExamFormResultWebsite", objExamFormProperty.ExamFormResultWebsite);
_objDataWrapper.AddParameter("@ExamFormPrice", objExamFormProperty.ExamFormPrice);
_objDataWrapper.AddParameter("@ExamFormStore", objExamFormProperty.ExamFormStore);
_objDataWrapper.AddParameter("@ExamFromCenter", objExamFormProperty.ExamFormCenter);
_objDataWrapper.AddParameter("@ExamFromDD", objExamFormProperty.ExamFormDd);
_objDataWrapper.AddParameter("@ExamFromSyllabus", objExamFormProperty.ExamFormSyllabus);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
_objDataWrapper.AddParameter("@AjExamFormStatus", objExamFormProperty.ExamFormStatus);
var objErrmsg =
(SqlParameter)
(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateExamFormDetails");
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 UpdateExamFormDetails in Exam.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
private void CreateLogs(string message, string EventName, string TopicName, bool IsSucess)
{
try
{
DbWrapper.ExecuteNonQuery("CreateSNSLogs",
message, TopicName, EventName,
IsSucess);
}
catch (Exception ex)
{
throw ex;
}
}
public override int UpdateUniversityDetails(BO.UniversityProperty objUniversityProerty, int modifiedBy, out string errmsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errmsg = "";
try
{
_objDataWrapper.AddParameter("@UniversityId", objUniversityProerty.UniversityId);
_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", modifiedBy);
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 UpdateUniversityDetails 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 void Publish(string exceptionInfo, string additionalInfo)
{
string connectString = System.Configuration.ConfigurationManager.AppSettings["DB_CON_STRING"].ToString();
DbWrapper objDataWrapper = new DbWrapper(System.Configuration.ConfigurationManager.AppSettings["DB_CON_STRING"].ToString(), CommandType.StoredProcedure);
try
{
objDataWrapper.AddParameter("@exceptionInfo", exceptionInfo);
objDataWrapper.AddParameter("@additionalInfo", additionalInfo);
int i = objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertException");
}
catch (Exception ex)
{
WriteLogFile(exceptionInfo + "," + additionalInfo + ex.ToString());
}
}
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);
}
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 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 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 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 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);
}
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):"");
}
public override int InsertUpdateTestimonialAdmssionjankari(AdmissionJankariTestimonial objAdmissionJankariTestimonial, int createdBy, out string errMsg)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
errMsg = "";
try
{
_objDataWrapper.AddParameter("@TestimonialId", objAdmissionJankariTestimonial.TestimonialId);
_objDataWrapper.AddParameter("@TestimonialPersonName", objAdmissionJankariTestimonial.TestimonialPersonName);
_objDataWrapper.AddParameter("@TestimonialPersonDesgination", objAdmissionJankariTestimonial.TestimonialPeronDesignation);
_objDataWrapper.AddParameter("@TestimonialPriority", objAdmissionJankariTestimonial.TestimonialPriority);
_objDataWrapper.AddParameter("@TestimonialText", objAdmissionJankariTestimonial.TestimonialText);
_objDataWrapper.AddParameter("@TestimonialStatus", objAdmissionJankariTestimonial.TestimonialStatus);
_objDataWrapper.AddParameter("@TestimonialPersonImage", objAdmissionJankariTestimonial.TestimonialImage);
_objDataWrapper.AddParameter("@CreatedBy", createdBy);
var ObjerrMsg =
(SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128));
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateAdmissionjankariTestimonial");
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 InsertUpdateTestimonialAdmssionjankari in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}
public override int UpdateCourseByUser(UserRegistrationProperty objUserCategoryProperty, int modifiedBy)
{
_objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure);
try
{
_objDataWrapper.AddParameter("@CourseId", objUserCategoryProperty.CourseId);
_objDataWrapper.AddParameter("@CreatedBy", modifiedBy);
_i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_UpdateCourseByUser");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateCourseByUser in UserManager.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(_i);
}