public bool AddToLikeGatewayData(string user_id, string app_id)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("AddToLikeGatewayData", user_id, app_id); return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool AddAppUserDetails(SonetPie osonetpie, AppUser oDCAppUser)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
if (oDCAppUser.SBirthdate == "")
{
int i = oDBH.ExecuteNonQuery_SP("AddAppUserDetails", oDCAppUser.DID, oDCAppUser.AppConfigDID, oDCAppUser.UserName, oDCAppUser.SonetID, oDCAppUser.SonetSRC, oDCAppUser.ImageURL, oDCAppUser.City, oDCAppUser.State, oDCAppUser.Country, oDCAppUser.EmailID, oDCAppUser.UserStatus, oDCAppUser.Gender, oDCAppUser.EmailSubscription, System.DBNull.Value, oDCAppUser.SFriend_count, oDCAppUser.SMType, oDCAppUser.Token, oDCAppUser.TokenSecret);
if (i < 0) return false; else return true;
}
else
{
int i = oDBH.ExecuteNonQuery_SP("AddAppUserDetails", oDCAppUser.DID, oDCAppUser.AppConfigDID, oDCAppUser.UserName, oDCAppUser.SonetID, oDCAppUser.SonetSRC, oDCAppUser.ImageURL, oDCAppUser.City, oDCAppUser.State, oDCAppUser.Country, oDCAppUser.EmailID, oDCAppUser.UserStatus, oDCAppUser.Gender, oDCAppUser.EmailSubscription, oDCAppUser.SBirthdate, oDCAppUser.SFriend_count, oDCAppUser.SMType, oDCAppUser.Token, oDCAppUser.TokenSecret);
if (i < 0) return false; else return true;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool AddAppNotifierDetails(SonetPie osonetpie, AppNotifier oDCAppNotifier)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
int i = oDBH.ExecuteNonQuery_SP("AddAppNotifierDetails", oDCAppNotifier.DID, oDCAppNotifier.AppProductDID, oDCAppNotifier.AppUserDID, oDCAppNotifier.SoNetFriendID, oDCAppNotifier.SoNetFriendName, oDCAppNotifier.NotifierType, oDCAppNotifier.NoOfVisits.ToString(), oDCAppNotifier.SoNetEmailID, oDCAppNotifier.SoNetEmailContext, oDCAppNotifier.SoNetEmailContent);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public int ChangePasswordUser(string cid, string txtpasswordnew)
{
try
{
EncryptionUtilities encryptObj = new EncryptionUtilities();
txtpasswordnew = encryptObj.getEncryptedCode(txtpasswordnew);
DatabaseHandler oDBH = new DatabaseHandler();
if (oDBH.ExecuteNonQuery_SP("ChangePasswordUser", txtpasswordnew, cid) > 0) return 1; else return 0;
}
catch (Exception ex)
{
throw ex;
}
}
public bool IsAppUserActive(string ADID, AppUser oDCAppUser)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
//Check if user is already present if present then update his information & status
object objRowCount = oDBH.ExecuteNonQuery_SP("IsAppUserActive", ADID, oDCAppUser.SonetID);
if ((int)objRowCount > 0)
{
return true;
}
return false;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool UpdateProductDetails(AppProduct oAppProduct)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("UpdateProductDetails", oAppProduct.DID,
oAppProduct.ProductCategory,
oAppProduct.ProductName,
oAppProduct.ProductLogo,
oAppProduct.ProductShortDesc,
oAppProduct.ProductDesc,
oAppProduct.ProductHTML,
"A",
oAppProduct.SProductContentImage,
oAppProduct.SProductHeaderImage,
oAppProduct.SProductFooterImage,
oAppProduct.SProductFooterURL, oAppProduct.ShareWidgetAdded, oAppProduct.LikeWidgetAdded, oAppProduct.ReccWidgetAdded, oAppProduct.CommentsWidgetAdded, oAppProduct.InquiryWidgetAdded, oAppProduct.LikeGatewayAdded, oAppProduct.CanvasHeight, oAppProduct.CanvasWidth, oAppProduct.AppCaption, oAppProduct.TwitterWidgetAdded, oAppProduct.SHeaderBannerImg, oAppProduct.SHeaderBannerURL);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool UpdateVideoShareData(string appConfigDID, string vidURL, string vidURLConverted, string vidDesc)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("UpdateVideoShareData", appConfigDID, vidURL, vidURLConverted, vidDesc);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateConfigExpiryForWH(string DID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("UpdateConfigExpiryForWH", DID);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCustomTabNAme(string ADID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("UpdateCustomTabNAme", ADID); return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool UpdateSweepStakesData(SweepStakesData oSweep)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("UpdateSweepStakesData", oSweep.SSweepConfigDID, oSweep.SPRizeDetails, oSweep.SSweepStartDate, oSweep.SSweepEndDate, oSweep.SSweepAboutUs, oSweep.SSweepTerms, oSweep.SSweepPrivacy, oSweep.SSweeprules, oSweep.SCouponReedem, oSweep.SCouponCode, oSweep.SCouponDesc, oSweep.SSweepExpiryDate, oSweep.SEligibility, oSweep.SSweepWinners);
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateConfigDetails(AppConfiguration oAppConfig, string ModelType, string CustTabName)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
if (ModelType.Equals("SWEEPSTAKES"))
{
int i = oDBH.ExecuteNonQuery_SP("UpdateConfigDetails", oAppConfig.DID, oAppConfig.AppCustomerDID, "Facebook", oAppConfig.AppID, oAppConfig.AppKey, oAppConfig.AppSecretKey, oAppConfig.AppPath, oAppConfig.AppName, oAppConfig.AppLogo, "", "", oAppConfig.AppExpiryPath, oAppConfig.AppExpiryDT, "SWEEPSTAKES", CustTabName, oAppConfig.SAppStartDT, oAppConfig.SInquiryEmail, oAppConfig.STemplatePage);
if (i < 0) return false; else return true;
}
else
{
int i = oDBH.ExecuteNonQuery_SP("UpdateConfigDetails", oAppConfig.DID, oAppConfig.AppCustomerDID, "Facebook", oAppConfig.AppID, oAppConfig.AppKey, oAppConfig.AppSecretKey, oAppConfig.AppPath, oAppConfig.AppName, oAppConfig.AppLogo, "", "", oAppConfig.AppExpiryPath, oAppConfig.AppExpiryDT, "PROMOTIONS", CustTabName, oAppConfig.SAppStartDT, oAppConfig.SInquiryEmail, oAppConfig.STemplatePage);
if (i < 0) return false; else return true;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool InsertFinalHTML(AppProduct oAppProduct)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
if (oDBH.ExecuteNonQuery_SP("InsertFinalHTML", oAppProduct.AppConfigDID, oAppProduct.ProductHTML, oAppProduct.DID) > 0)
{
DatabaseHandler oDBHProd = new DatabaseHandler();
StringBuilder oSBQueryPRod = new StringBuilder();
oSBQueryPRod.Append("Update [AppProduct] set PRoductHTML='" + oAppProduct.ProductHTML + "'");
oSBQueryPRod.Append("where DID='" + oAppProduct.DID + "'");
if (oDBHProd.ExecuteNonQuery(oSBQueryPRod.ToString()) > 0) return true; else return false;
}
//Now insert this FetchFinalHTML to AppProduct too!
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertNewCustomer(AppCustomer oAppCustomer)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder oSBQuery = new StringBuilder();
oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("InsertNewCustomer", oAppCustomer.GetNewDIDWithPrefix(), oAppCustomer.SCustomerUserName, oAppCustomer.SCustomerEmail, oAppCustomer.SCustomerPWD, oAppCustomer.SCompanyName, oAppCustomer.SCustomerCountry, 1, 1, oAppCustomer.SAddress,"");
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool SetNewConfigDetails(AppConfiguration oAppConfig, string CustTabName, string AppModel)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("SetNewConfigDetails", oAppConfig.DID, oAppConfig.AppCustomerDID, "Facebook", oAppConfig.AppID, oAppConfig.AppKey, oAppConfig.AppSecretKey, oAppConfig.AppPath, oAppConfig.AppName, oAppConfig.AppLogo, "", "", oAppConfig.AppExpiryPath, oAppConfig.AppExpiryDT, System.DBNull.Value, CustTabName, oAppConfig.SAppStartDT, oAppConfig.SInquiryEmail, oAppConfig.STemplatePage, oAppConfig.SCampaignType, 'N', oAppConfig.SSiteID, oAppConfig.STemplateID);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool SetNewProductDetails(AppProduct oAppProduct)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("SetNewProductDetails", oAppProduct.DID,
oAppProduct.AppConfigDID,
oAppProduct.ProductCategory,
oAppProduct.ProductName,
oAppProduct.ProductLogo,
oAppProduct.ProductShortDesc,
oAppProduct.ProductDesc,
oAppProduct.ProductHTML,
"A",
oAppProduct.SProductContentImage,
oAppProduct.SProductHeaderImage,
oAppProduct.SProductFooterImage,
oAppProduct.SProductFooterURL, oAppProduct.ShareWidgetAdded, oAppProduct.LikeWidgetAdded, oAppProduct.ReccWidgetAdded, oAppProduct.CommentsWidgetAdded, oAppProduct.InquiryWidgetAdded, oAppProduct.LikeGatewayAdded, oAppProduct.CanvasHeight, oAppProduct.CanvasWidth, oAppProduct.AppCaption, oAppProduct.TwitterWidgetAdded, oAppProduct.SHeaderBannerImg, oAppProduct.SHeaderBannerURL);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
objCommon.SendErrorMail(ex.Message, ex.StackTrace, System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), SessionData.Product.DID);
throw ex;
}
}
public bool InsertMicrositesData(string CustID, string MicroSiteName)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("InsertMicrositesData", CustID, MicroSiteName);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertErrData(string errData)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("InsertErrData", errData);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateTempPwd(string MailID, string temppass)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
if (oDBH.ExecuteNonQuery_SP("UpdateTempPwd", temppass, MailID) > 0) return true; else return false;
}
catch (Exception ex)
{
throw ex;
}
}
public bool SaveSweepStakesEntryInfo(SweepStakesEntryInfo sweepEntry)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("SaveSweepStakesEntryInfo", sweepEntry.AppConfigDID1, sweepEntry.SoNetID1, sweepEntry.FirstName1, sweepEntry.LastName1, sweepEntry.Address1, sweepEntry.Country1, sweepEntry.City1, sweepEntry.ZipCode1, sweepEntry.Email1, sweepEntry.Gender1, sweepEntry.DOB1, sweepEntry.Telephone1, sweepEntry.Mobile1, sweepEntry.UserType, sweepEntry.Remarks);
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateAppConfigForFacebook(AppConfiguration oAppConfig)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder oSBQuery = new StringBuilder();
//Already user is present update the record with status
int i = oDBH.ExecuteNonQuery_SP("UpdateAppConfigForFacebook", oAppConfig.AppID, oAppConfig.AppKey, oAppConfig.AppSecretKey, oAppConfig.AppName, oAppConfig.AppPath);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool SaveSweepStakesData(SweepStakesData oSweep)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("SaveSweepStakesData", oSweep.SSweepConfigDID, oSweep.SSweepStartDate, oSweep.SSweepEndDate, oSweep.SSweepAboutUs, oSweep.SSweepTerms, oSweep.SSweepPrivacy, oSweep.SSweeprules);
return true;
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateAppPagePath(string path, string appID, string pageID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery_SP("UpdateAppPagePath", path, pageID, appID);
return true;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public bool SetUserAction(UserAction oUserAction)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder _sbQuery = new StringBuilder();
int i = oDBH.ExecuteNonQuery_SP("SetUserAction", oUserAction.CustomerId, oUserAction.PreferenceID1, 'N', oUserAction.SubDomainName1, oUserAction.YoutubeURL1, oUserAction.CustomTabName1, oUserAction.TemplateId, oUserAction.SiteID1);
if (i < 0) return false; else return true;
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdatefpStatus(string cid, int status)
{
try
{
DatabaseHandler oDBHProd = new DatabaseHandler();
StringBuilder oSBQueryPRod = new StringBuilder();
if (oDBHProd.ExecuteNonQuery_SP("UpdatefpStatus", status, cid) > 0) return 1; else return 0;
}
catch (Exception ex)
{
throw ex;
}
}
