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 bool CheckIfSweepstakeAlreadyEntered(string ADID, string sonetID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
StringBuilder oSBQuery = new StringBuilder();
DataSet ds = oDBH.FillData_SP("CheckIfSweepstakeAlreadyEntered", ADID, sonetID);
if (ds.Tables[0].Rows[0][0].ToString().Equals("1"))
{
return true; //App EXPIRED.
}
else
{
return false; //App is still GOOD.
}
}
catch (Exception ex)
{
//Log4NetUtility.ErrorDebug(this.GetType().FullName, "Error in GetConfigData(string _AppId)", ex);
throw ex;
}
}
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 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 UserAction GetUserDetails(string UserName)
{
try
{
oDatabaseHandler = new DatabaseHandler();
DataSet oDataSet = new DataSet();
oDataSet = oDatabaseHandler.FillData("select U.UserId,U.RoleId,R.[Role] RoleName,R.[Create],R.Edit,R.[View],R.Assign,R.Finish from Users as U "
+ " inner join Roles R on R.RoleId=U.RoleId"
+ " where U.UserName='******'");
if (oDataSet != null && oDataSet.Tables != null && oDataSet.Tables.Count > 0 && oDataSet.Tables[0].Rows != null && oDataSet.Tables[0].Rows.Count > 0)
{
UserAction oUserDetails = new UserAction();
//oUserDetails.Cus = int.Parse(oDataSet.Tables[0].Rows[0]["UserId"].ToString());
oUserDetails.UserName = UserName;// oDataSet.Tables[0].Rows[0]["UserId"].ToString();
oUserDetails.RoleID = int.Parse(oDataSet.Tables[0].Rows[0]["RoleId"].ToString());
oUserDetails.RoleName = oDataSet.Tables[0].Rows[0]["RoleName"].ToString();
oUserDetails.Create = bool.Parse(oDataSet.Tables[0].Rows[0]["Create"].ToString());
oUserDetails.Edit = bool.Parse(oDataSet.Tables[0].Rows[0]["Edit"].ToString());
oUserDetails.View = bool.Parse(oDataSet.Tables[0].Rows[0]["View"].ToString());
oUserDetails.Assign = bool.Parse(oDataSet.Tables[0].Rows[0]["Assign"].ToString());
oUserDetails.Finish = bool.Parse(oDataSet.Tables[0].Rows[0]["Finish"].ToString());
return oUserDetails;
}
return null;
}
catch (Exception ex)
{
}
return null;
}
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 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 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 string GetPassword(string UserName)
{
try
{
oDatabaseHandler = new DatabaseHandler();
DataSet oDataSet = new DataSet();
oDataSet = oDatabaseHandler.FillData("select [Password] from Users where UserName='******'");
if (oDataSet != null && oDataSet.Tables != null && oDataSet.Tables.Count > 0 && oDataSet.Tables[0].Rows != null && oDataSet.Tables[0].Rows.Count > 0)
{
return oDataSet.Tables[0].Rows[0][0].ToString();
}
else
return "";
}
catch (Exception ex)
{
}
return "";
}
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 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 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 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 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 DataSet GetPlatformWiseActions1(string Customer, string Appname)
{
DataSet GenderWiseActions = new DataSet();
oDBH = new DatabaseHandler();
GenderWiseActions = oDBH.FillData_SP("GetPlatformWiseActions", Appname, Customer);
return GenderWiseActions;
}
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 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 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 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 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 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 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 DataSet Getlevelwisequery1(string Customer, string Appname)
{
DataSet levelwise = new DataSet();
oDBH = new DatabaseHandler();
levelwise = oDBH.FillData_SP("levelwisequery1", Customer, Appname);
return levelwise;
}
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 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 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 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;
}
