internal System.Data.DataTable GetNewsFeedList(Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { dt = db.ExecuteDataTable("SELECT [Serial],[NewsBody],[NewsTitale],[ValidDate],[CreatedBy],[CreatedDate]FROM [dbo].[tblNewsFeed]"); } catch (Exception) { throw; } return(dt); }
internal DataTable getAccountSummaryById(string UserId, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@UserId", UserId); dt = db.ExecuteDataTable("SELECT [Serial],[UserId],isnull( [Income],0) as Income,isnull( [Deposit],0) as Deposit,isnull( [Commission],0) as Commission,isnull( [FxFund],0) as FxFund,isnull( [TotalIncome],0) as TotalIncome FROM [dbo].[tblUserAccounts] where [UserId]=@UserId "); } catch (Exception) { throw; } return(dt); }
internal System.Data.DataTable GetUserPlacementInfoById(string UserId, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@UserId", UserId); dt = db.ExecuteDataTable("SELECT [Serial],[UserId],[RefferId],[PleacementId],[PlacePosition],[StakeId],[StakeKey],[JoinDate],[isChecked],[CheckedDate],[ActiveDate],[JoinFrom],[ActiveFrom] FROM [dbo].[tblStakeJoining] where [UserId] =@UserId "); } catch (Exception) { throw; } return(dt); }
internal System.Data.DataTable SaveNewsInfo(BLL.NewsFeedBLL newsFeedBLL, Lumex.Tech.LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@NewsBody", newsFeedBLL.BodyText); db.AddParameters("@NewsTitale", newsFeedBLL.Title); db.AddParameters("@ValidDate", newsFeedBLL.Value); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId")); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); dt = db.ExecuteDataTable("INSERT INTO [dbo].[tblNewsFeed]([NewsBody],[NewsTitale],[ValidDate],[CreatedBy],[CreatedDate])VALUES(@NewsBody,@NewsTitale,@ValidDate,@CreatedBy,GETDATE())"); } catch (Exception) { //throw; } return(dt); }
internal bool checkDuplicateLookupGroup(BLL.initialDataBLL lookUpDataBLL, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@ElementName", lookUpDataBLL.ElementGroupName.Trim()); dt = db.ExecuteDataTable("[CHECK_DUPLICATE_ELEMENT_GROUP]", true); if (dt.Rows.Count > 0) { status = false; } } catch (Exception) { throw; } return(status); }
internal System.Data.DataTable GetNewsFeedDataById(BLL.NewsFeedBLL newsFeedBLL, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@Serial", newsFeedBLL.NewsFeedId); dt = db.ExecuteDataTable("SELECT [Serial],[NewsBody],[NewsTitale],[ValidDate],[CreatedBy],[CreatedDate]FROM [dbo].[tblNewsFeed] where Serial=@Serial"); } catch (Exception) { throw; } return(dt); }
internal DataTable UpdateUserAccount(string UserId, string StakeId, string StakeKey, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@UserId", UserId); db.AddParameters("@StakeId", StakeId); db.AddParameters("@StakeKey", StakeKey); db.AddParameters("@ActiveFrom", LumexLibraryManager.GetTerminal()); dt = db.ExecuteDataTable("[Update_USER_ACCOUNT_ACTIVATION_BY_STAKE_KEY]", true); } catch (Exception) { throw; } return(dt); }
internal DataTable getUserIncomeStatementById(string UserId, string FromDate, string ToDate, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { db.AddParameters("@UserId", UserId); db.AddParameters("@FromDate", FromDate); db.AddParameters("@ToDate", ToDate); dt = db.ExecuteDataTable("GET_USER_RECEIVE_PAYMENT_BY_DATE_RANGE", true); } catch (Exception) { throw; } return(dt); }
internal System.Data.DataTable GetTransiction(BLL.UserAccountBLL userAccountBLL, Lumex.Tech.LumexDBPlayer db) { bool status = true; DataTable dt = new DataTable(); try { } catch (Exception) { throw; } return(dt); }