public DataSet GenderDrillDownSM(string Customer, string Appname, string Gender, string SMType)
{
DataSet GenderDrillDown = new DataSet();
oDBH = new DatabaseHandler();
GenderDrillDown = oDBH.FillData_SP("Sp_GenderDrillDownSM", Customer, Appname, Gender, SMType);
return GenderDrillDown;
}
public int CheckUserEmail(string txtEmailID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet validatemail = oDBH.FillData_SP("CheckUserEmail", txtEmailID);
if (validatemail.Tables.Count > 0)
{
if (validatemail.Tables[0].Rows.Count > 0)
{
//get the value
//string username = validatemail.Tables[0].Rows[0]["username"].ToString();
//return true;
return 1;
}
else
{
//User not found
//return false;
return 0;
}
}
else
{
//user not found, cancel operation
//return false;
return 0;
}
}
catch
{
throw;
}
}
public DataSet GenderWiseActionsSM(string Customer, string Appname, string SMType)
{
DataSet GenderWiseActions = new DataSet();
oDBH = new DatabaseHandler();
GenderWiseActions = oDBH.FillData_SP("GenderWiseActionsSM", Appname, Customer, SMType);
return GenderWiseActions;
}
public DataSet Geteyeballcount1SM(string Customer, string Appname, string SMType)
{
DataSet eyeballcount = new DataSet();
oDBH = new DatabaseHandler();
eyeballcount = oDBH.FillData_SP("eyeballcount1SM", Appname, Customer, SMType);
return eyeballcount;
}
public bool EditAppUserDetails(SonetPie osonetpie, AppUser oDCAppUser)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
if (oDCAppUser.SBirthdate == "")
{
oDBH.FillData_SP("EditAppUserDetails", Convert.ToString(osonetpie.QSvars["ADID"]), oDCAppUser.SonetID, oDCAppUser.City, oDCAppUser.State, oDCAppUser.Country, oDCAppUser.EmailID, oDCAppUser.UserStatus, oDCAppUser.Gender, System.DBNull.Value, oDCAppUser.SFriend_count);
return true;
}
else
{
oDBH.FillData_SP("EditAppUserDetails", Convert.ToString(osonetpie.QSvars["ADID"]), oDCAppUser.SonetID, oDCAppUser.City, oDCAppUser.State, oDCAppUser.Country, oDCAppUser.EmailID, oDCAppUser.UserStatus, oDCAppUser.Gender, oDCAppUser.SBirthdate, oDCAppUser.SFriend_count);
return true;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public int ConfirmResetPassword(string cid)
{
try
{
DatabaseHandler oDBHProd = new DatabaseHandler();
StringBuilder oSBQueryPRod = new StringBuilder();
DataSet confirmreset = oDBHProd.FillData_SP("ConfirmResetPassword", cid);
if (confirmreset.Tables.Count > 0)
{
if (confirmreset.Tables[0].Rows.Count > 0)
{
//get the value
//string username = validatemail.Tables[0].Rows[0]["username"].ToString();
//return true;
string status = confirmreset.Tables[0].Rows[0]["fpStatus"].ToString();
if (status == "1")
{
return 1;
}
else
{
return 0;
}
}
else
{
//User not found
//return false;
return 0;
}
}
else
{
//user not found, cancel operation
//return false;
return 0;
}
}
catch
{
throw;
}
}
public DataSet GetAppwiseActionsChart1(string Customer, string Appname)
{
// AnalyticsDataEnums oADE = new AnalyticsDataEnums();
// BindingList<string> oList = new BindingList<string>();
//DataSet dsNew= new DataSet();
//oDBH = new DatabaseHandler();
//dsNew = oDBH.FillData_SP("AppwiseActionsChart1", Appname, Customer);
//foreach (DataRow dr in dsNew.Tables[0].Rows)
//{
// oADE.NotifierType1 = dr["NotifierType"].ToString();
// oADE.YearMonth1 = dr["YearMonth"].ToString();
// oADE.NotifierTypeCount1 = dr["NotifierTypeCount"].ToString();
// oList.Add(oADE.ToString());
//}
//return oList;
DataSet AppwiseActionsChart1 = new DataSet();
oDBH = new DatabaseHandler();
AppwiseActionsChart1 = oDBH.FillData_SP("AppwiseActionsChart1", Appname, Customer);
return AppwiseActionsChart1;
}
public DataSet GetPlatformWiseActions1(string Customer, string Appname)
{
DataSet GenderWiseActions = new DataSet();
oDBH = new DatabaseHandler();
GenderWiseActions = oDBH.FillData_SP("GetPlatformWiseActions", Appname, Customer);
return GenderWiseActions;
}
public string GetProductHTML(string DID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet dsFinalHTML = new DataSet();
dsFinalHTML = oDBH.FillData_SP("GetProductHTML", DID);
if (dsFinalHTML.Tables.Count > 0)
{
if (dsFinalHTML.Tables[0].Rows.Count > 0)
{
return dsFinalHTML.Tables[0].Rows[0]["ProductHTML"].ToString();
}
}
else
{
return null;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
return string.Empty;
}
public DataSet GetPeriodDrillDown(string Appname, string YearMonth)
{
//AnalyticsDataEnumsLocationPeriod oADE = new AnalyticsDataEnumsLocationPeriod();
//List<string> oList = new List<string>();
//DataSet dsNew = new DataSet();
//oDBH = new DatabaseHandler();
//dsNew = oDBH.FillData_SP("Sp_PeriodDrillDown", Appname, YearMonth);
//foreach (DataRow dr in dsNew.Tables[0].Rows)
//{
// oADE.YearMonth1 = dr["YearMonth"].ToString();
// oADE.NotifierType1 = dr["NotifierType"].ToString();
// oADE.NotifierTypeCount1 = dr["NotifierTypeCount"].ToString();
// oList.Add(oADE.ToString());
//}
//return oList;
DataSet PeriodDrillDown = new DataSet();
oDBH = new DatabaseHandler();
PeriodDrillDown = oDBH.FillData_SP("Sp_PeriodDrillDown", Appname, YearMonth);
return PeriodDrillDown;
}
public DataSet GetLocationWise1SM(string Customer, string Appname, string SMType)
{
DataSet LocationWise = new DataSet();
oDBH = new DatabaseHandler();
LocationWise = oDBH.FillData_SP("LocationWise1SM", Appname, Customer, SMType);
return LocationWise;
}
public SweepStakesData GetSweepDataForEditing(string ADID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet dsFinalHTML = new DataSet();
dsFinalHTML = oDBH.FillData_SP("GetSweepDataForEditing", ADID);
if (dsFinalHTML.Tables.Count > 0)
{
SweepStakesData oSweepData = new SweepStakesData();
oSweepData.SSweepAboutUs = dsFinalHTML.Tables[0].Rows[0]["AboutUs"].ToString();
oSweepData.SSweepEndDate = dsFinalHTML.Tables[0].Rows[0]["EndDate"].ToString();
oSweepData.SSweepPrivacy = dsFinalHTML.Tables[0].Rows[0]["Privacy"].ToString();
oSweepData.SSweeprules = dsFinalHTML.Tables[0].Rows[0]["Rules"].ToString();
oSweepData.SSweepStartDate = dsFinalHTML.Tables[0].Rows[0]["StartDate"].ToString();
oSweepData.SSweepTerms = dsFinalHTML.Tables[0].Rows[0]["Terms"].ToString();
oSweepData.SSweepExpiryDate = dsFinalHTML.Tables[0].Rows[0]["ExpiryDate"].ToString();
oSweepData.SCouponCode = dsFinalHTML.Tables[0].Rows[0]["CouponCode"].ToString();
oSweepData.SCouponDesc = dsFinalHTML.Tables[0].Rows[0]["CouponDesc"].ToString();
oSweepData.SCouponReedem = dsFinalHTML.Tables[0].Rows[0]["CouponReedem"].ToString();
oSweepData.SEligibility = dsFinalHTML.Tables[0].Rows[0]["EligibilityDetails"].ToString();
oSweepData.SPRizeDetails = dsFinalHTML.Tables[0].Rows[0]["PrizeDetails"].ToString();
oSweepData.SSweepWinners = Convert.ToInt32(dsFinalHTML.Tables[0].Rows[0]["SweepWinners"].ToString());
return oSweepData;
}
else
{
return null;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public DataTable GetPreviewProduct(string PDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
return oDBH.FillData_SP("GetPreviewProduct", PDID).Tables[0];
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public DataSet TotalActions3SM(string Appname, string Customer, string SMType)
{
DataSet gtactions = new DataSet();
oDBH = new DatabaseHandler();
gtactions = oDBH.FillData_SP("TotalActions3SM", Appname, Customer, SMType);
return gtactions;
}
public DataSet GetLocationDrillDownSM(string Customer, string Appname, string Country, string SMType)
{
DataSet LocationDrillDown_stte = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown_stte = oDBH.FillData_SP("Sp_LocationDrillDown_StateSM", Customer, Appname, Country, SMType);
return LocationDrillDown_stte;
}
public DataSet GetLocationDrillDown2_Gender(string Customer, string Appname, string City)
{
DataSet LocationDrillDown2_Gender = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown2_Gender = oDBH.FillData_SP("Sp_LocationDrillDown2_Gender", Customer, Appname, City);
return LocationDrillDown2_Gender;
}
public DataSet GetLocationDrillDown1_City(string Customer, string Appname, string State)
{
DataSet LocationDrillDown1_City = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown1_City = oDBH.FillData_SP("Sp_LocationDrillDown1_City", Customer, Appname, State);
return LocationDrillDown1_City;
}
public DataSet GetLocationDrillDown1_Actions(string Customer, string Appname, string State)
{
//AnalyticsDataEnumsLocationActions oADE = new AnalyticsDataEnumsLocationActions();
//List<string> oList = new List<string>();
//DataSet dsNew = new DataSet();
//oDBH = new DatabaseHandler();
//dsNew = oDBH.FillData_SP("Sp_LocationDrillDown1_Actions", Customer, Appname, State);
//dsNew.Tables[0].TableName = "myTable";
//foreach (DataRow dr in dsNew.Tables[0].Rows)
//{
// oADE.Gender1 = dr["Gender"].ToString();
// oADE.NotifierType1 = dr["NotifierType"].ToString();
// oADE.NotifierTypeCount1 = dr["NotifierTypeCount"].ToString();
// oList.Add(oADE.ToString());
//}
//return oList;
DataSet LocationDrillDown1_Actions = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown1_Actions = oDBH.FillData_SP("Sp_LocationDrillDown1_Actions", Customer, Appname, State);
return LocationDrillDown1_Actions;
}
public DataSet Getlevelwisequery1(string Customer, string Appname)
{
DataSet levelwise = new DataSet();
oDBH = new DatabaseHandler();
levelwise = oDBH.FillData_SP("levelwisequery1", Customer, Appname);
return levelwise;
}
public DataSet GetLevelsDrillDown_Location(string Appname, int Level)
{
DataSet LevelsDrillDown_Location = new DataSet();
oDBH = new DatabaseHandler();
LevelsDrillDown_Location = oDBH.FillData_SP("Sp_LevelsDrillDown_Location", Appname, Level);
return LevelsDrillDown_Location;
}
public DataSet GetLevelsDrillDown_Gender(string Appname, int Level)
{
DataSet LevelsDrillDown_Gender = new DataSet();
oDBH = new DatabaseHandler();
LevelsDrillDown_Gender = oDBH.FillData_SP("Sp_LevelsDrillDown_Gender", Appname, Level);
return LevelsDrillDown_Gender;
}
public DataSet GetTotalActionsSM(string Customer, string Appname, string NotifierType)
{
DataSet TotalActions = new DataSet();
oDBH = new DatabaseHandler();
TotalActions = oDBH.FillData_SP("TotalActions1", Appname, Customer, NotifierType);
return TotalActions;
}
public DataSet GetUniquevisitors1SM(string Customer, string Appname, string SMType)
{
DataSet uniquevistors = new DataSet();
oDBH = new DatabaseHandler();
uniquevistors = oDBH.FillData_SP("Uniquevisitors1SM", Appname, Customer, SMType);
return uniquevistors;
}
public bool IsUserCreatedForTwitter(string user_id, string appConfigDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder oSBQuery = new StringBuilder();
DataSet ds = oDBH.FillData_SP("IsUserCreatedForTwitter", user_id, appConfigDID);
if (Convert.ToInt32(ds.Tables[0].Rows[0][0]) >= 1)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public string GetNotifierDID(string PDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet ds = oDBH.FillData_SP("GetNotifierDID", PDID);
//return
if (ds.Tables[0].Rows.Count > 0)
{
return ds.Tables[0].Rows[0]["DID"].ToString();
}
else
{
return "";
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public DataSet GetLocationDrillDown_Gender1(string Customer, string Appname, string Country, string Gender)
{
DataSet LocationDrillDown_Gender1 = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown_Gender1 = oDBH.FillData_SP("Sp_LocationDrillDownGender", Customer, Appname, Country, Gender);
return LocationDrillDown_Gender1;
}
public DataSet GetLevelsDrillDown_Actions(string Appname, int Level)
{
DataSet LevelsDrillDown_Actions = new DataSet();
oDBH = new DatabaseHandler();
LevelsDrillDown_Actions = oDBH.FillData_SP("Sp_LevelsDrillDown_Actions", Appname, Level);
return LevelsDrillDown_Actions;
}
public string GetSiteIDForConfig(string ADID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet ds = oDBH.FillData_SP("GetSiteIDForConfig", ADID);
return ds.Tables[0].Rows[0]["SiteID"].ToString();
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
public DataSet GetLocationDrillDown_Age(string Customer, string Appname, string Country)
{
//AnalyticsDataEnumsLocationAge oADE = new AnalyticsDataEnumsLocationAge();
//List<string> oList = new List<string>();
//DataSet dsNew = new DataSet();
//oDBH = new DatabaseHandler();
//dsNew = oDBH.FillData_SP("Sp_LocationDrillDown_Age", Customer, Appname,Country);
//foreach (DataRow dr in dsNew.Tables[0].Rows)
//{
// oADE.Gender1 = dr["Gender"].ToString();
// oADE.Age1 = dr["Age"].ToString();
// oADE.NotifierTypeCount1 = dr["NotifierTypeCount"].ToString();
// oList.Add(oADE.ToString());
//}
//return oList;
DataSet LocationDrillDown_Age = new DataSet();
oDBH = new DatabaseHandler();
LocationDrillDown_Age = oDBH.FillData_SP("Sp_LocationDrillDown_Age", Customer, Appname, Country);
return LocationDrillDown_Age;
}
public int GetLikeCount(string AppproductDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder oSBQuery = new StringBuilder();
int intVisits = 0;
DataSet ds = oDBH.FillData_SP("GetLikeCount", AppproductDID);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
intVisits = Convert.ToInt32(ds.Tables[0].Rows[0]["NoOfVisits"]);
}
return intVisits;
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
