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; }