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