protected void Page_Load(object sender, EventArgs e)
{
try
{
msgbox.Visible = false;
if (!IsPostBack)
{
fromDateTextBox.Text = LumexLibraryManager.GetAppDateView(DateTime.Today.ToString());
toDateTextBox.Text = LumexLibraryManager.GetAppDateView(DateTime.Today.ToString());
LumexSessionManager.Add("CenterId", "CNT001");
LumexSessionManager.Add("ActiveUserId", "Developer");
}
if (deletedListGridView.Rows.Count > 0)
{
deletedListGridView.UseAccessibleHeader = true;
deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void allDeletedListButton_Click(object sender, EventArgs e)
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim());
string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim());
DataTable dt = userGroup.GetDeletedUserGroupListByDateRangeAll(fromDate, toDate, "All");
deletedListGridView.DataSource = dt;
deletedListGridView.DataBind();
if (deletedListGridView.Rows.Count > 0)
{
deletedListGridView.UseAccessibleHeader = true;
deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
userGroup = null;
}
}
public bool UpdateUser(UserBLL user, LumexDBPlayer db)
{
bool status = false;
try
{
//db.AddParameters("@Serial", user.Serial.Trim());
db.AddParameters("@UserId", user.UserId.Trim());
db.AddParameters("@UserName", user.UserName.Trim());
//db.AddParameters("@EmployeeId", "");
db.AddParameters("@UserGroupId", user.UserGroupId.Trim());
//db.AddParameters("@Department", "");
//db.AddParameters("@Designation", "");
//db.AddParameters("@Address","");
db.AddParameters("@ContactNumber", user.Cell.Trim());
db.AddParameters("@Email", user.Email.Trim());
//db.AddParameters("@NationalId", "");
//db.AddParameters("@PassportNumber", "");
// db.AddParameters("@BaranchId", user.Branch);
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
//db.AddParameters("@Password", LumexLibraryManager.EncodeIntoMd5Hash(user.Password));
status = Convert.ToBoolean(db.ExecuteNonQuery("UPDATE_USER_BY_ID", true));
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return(status);
}
// @StakeName nvarchar(100) ,
//@DailyAwardFrom decimal(18, 2) ,
//@DailyAwardTo decimal(18, 2) ,
//@Avarage decimal(18, 2) ,
//@TotalDuration decimal(18, 2) ,
//@BinaryCap decimal(18, 2) ,
//@Parcentage decimal(18, 2) ,
//@CreatedBy varchar(50) ,
//@CreatedFrom varchar(50)
internal System.Data.DataTable SaveStaKeInfo(BLL.StakeInfoBLL stakeInfoBLL, LumexDBPlayer db)
{
bool status = true;
DataTable dt = new DataTable();
try
{
db.AddParameters("@StakeName", stakeInfoBLL.StakeName);
db.AddParameters("@Amount", stakeInfoBLL.Amount);
db.AddParameters("@DailyAwardFrom", stakeInfoBLL.DailyAwardFrom);
db.AddParameters("@DailyAwardTo", stakeInfoBLL.DailyAwardTo);
db.AddParameters("@Avarage", stakeInfoBLL.AvgAward);
db.AddParameters("@TotalDuration", stakeInfoBLL.TotalDuration);
db.AddParameters("@BinaryCap", stakeInfoBLL.BinaryCap);
db.AddParameters("@Parcentage", stakeInfoBLL.Parcentage);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("[INSERT_STAKE_INFO]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable UpdatePaymentInfoBySerial(UserAccountBLL account, LumexDBPlayer db)
{
bool status;
DataTable dt = new DataTable();
try
{
db.AddParameters("@serial", LumexSessionManager.Get("Serial").ToString());
db.AddParameters("@UserId", account.UserId);
db.AddParameters("@GatewayType", account.Type);
db.AddParameters("@BankName", account.BankName);
db.AddParameters("@BankAccount", account.BankAccountNo);
db.AddParameters("@SwiftCode", account.SwiftCode);
db.AddParameters("@CardNo", account.CardNumber);
db.AddParameters("@CardWoner", account.CardOwnerName);
db.AddParameters("@ExpireDate", LumexLibraryManager.ParseAppDate(account.CardExpireDate));
db.AddParameters("@GatewayEmail", account.OnlineEmail);
db.AddParameters("@GatewayOwner", account.GateWayOwnerName);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@IsActive", "Yes");
db.ExecuteNonQuery("INSERT INTO [dbo].[tblPaymetnMethod] ([GatewayType], [BankName], [BankAccount], [SwiftCode], [CardNo], [CardWoner], [ExpireDate], [GatewayEmail], [GatewayOwner], [UserId], [CreatedBy], [IsActive]) VALUES (@GatewayType, @BankName, @BankAccount, @SwiftCode, @CardNo, @CardWoner, @ExpireDate, @GatewayEmail, @GatewayOwner, @UserId, @CreatedBy, @IsActive)");
status = true;
}
catch (Exception)
{
throw;
}
return(dt);
}
internal void InsertReceivePaymentWhenDailybonus(LumexDBPlayer db)
{
try
{
db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RECEIVE_PAYMENT_WHEN_DAILY_BONUS]", true);
}
catch (Exception)
{
// throw;
}
}
internal void SaveGeneratedPin(DataTable dt, LumexDBPlayer db)
{
try
{
db.AddParameters("@StakeGen", dt);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteDataTable("INSERT_STAKE_PIN", true);
}
catch (Exception)
{
throw;
}
}
protected void ViewButton_Click(object sender, EventArgs e)
{
try
{
if (ddlStatus.SelectedValue == "P")
{
GridViewWithdrawRequest.Columns[6].Visible = false;
GridViewWithdrawRequest.Columns[7].Visible = false;
}
else if (ddlStatus.SelectedValue == "R")
{
// GridViewWithdrawRequest.Columns[5].Visible = false;
GridViewWithdrawRequest.Columns[7].Visible = false;
GridViewWithdrawRequest.Columns[10].Visible = false;
GridViewWithdrawRequest.Columns[11].Visible = false;
}
else if (ddlStatus.SelectedValue == "A")
{
// GridViewWithdrawRequest.Columns[5].Visible = false;
GridViewWithdrawRequest.Columns[6].Visible = false;
GridViewWithdrawRequest.Columns[10].Visible = false;
GridViewWithdrawRequest.Columns[11].Visible = false;
}
UserAccountBLL userAccount = new UserAccountBLL();
DataTable dt = userAccount.getWithdrawRequestList(LumexLibraryManager.ParseAppDate(fromDateTextBox.Text), LumexLibraryManager.ParseAppDate(toDateTextBox.Text), ddlStatus.SelectedValue);
GridViewWithdrawRequest.DataSource = dt;
GridViewWithdrawRequest.DataBind();
if (GridViewWithdrawRequest.Rows.Count > 0)
{
// generateButton.Visible = true;
GridViewWithdrawRequest.UseAccessibleHeader = true;
GridViewWithdrawRequest.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
MyAlertBox("MyOverlayStop();");
}
}
internal DataTable InsertReceivePaymentWhenPinChange(LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("Amount", "5");
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_RECEIVE_PAYMENT_WHEN_PINCHANGE", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
internal void InsertReceivePaymentWhenActive(string UserId, string RefferId, string Commission, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", UserId);
db.AddParameters("@RefferId", RefferId);
db.AddParameters("@Commission", Commission);
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RECEIVE_PAYMENT_WHEN_COMMISSION]", true);
}
catch (Exception)
{
// throw;
}
}
public void DeleteUserGroup(string userGroupId, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserGroupId", userGroupId);
db.AddParameters("@DeletedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@DeletedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
db.ExecuteNonQuery("DELETE_USER_GROUP_BY_ID", true);
}
catch (Exception)
{
throw;
}
}
internal void UpdateUserPin(string userId, string pin, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", userId);
db.AddParameters("@Pin", pin);
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[UPDATE_USER_PIN_BY_ID]", true);
}
catch (Exception)
{
throw;
}
}
internal void UpdateLookUpGroup(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@ElementGrpId", lookUpDataBLL.ElementGroupId.Trim());
db.AddParameters("@ElementGrpName", lookUpDataBLL.ElementGroupName.Trim());
db.AddParameters("@Description", lookUpDataBLL.ElementGroupDes.Trim());
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[UPDATE_ELEMENT_GROUP]", true);
}
catch (Exception)
{
throw;
}
}
public void UpdateUserGroupActivation(string userGroupId, string activationStatus, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserGroupId", userGroupId);
db.AddParameters("@IsActive", activationStatus);
db.AddParameters("@ActivatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@ActivatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_USER_GROUP_ACTIVATION", true);
}
catch (Exception)
{
throw;
}
}
internal DataTable generateDailyBonus(string Date, LumexDBPlayer db)
{
try
{
db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("[INSERT_DAILY_BONUS]", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
internal DataTable ReceivePaymentMoney(string amount, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@Amount", amount);
db.AddParameters("@GenerateBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@GenerateFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_GENERATE_MONRY]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable getDailybounsListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate));
db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate));
dt = db.ExecuteDataTable("SELECT [Serial],[UserId],[DailyBonus],CONVERT(VARCHAR, CAST([BonusDate] AS SMALLDATETIME), 103)as [BonusDate] ,[CreatedFrom],[CreatedBy],[InvestAmount] FROM [dbo].[tblDailyBous] where CAST(BonusDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE) ORDER BY [BonusDate] ASC");
}
catch (Exception)
{
throw;
}
return(dt);
}
internal void InsertIntoGenolgyTree(string placeId, string position, string referId, string UserId, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", UserId);
db.AddParameters("@RefferId", referId);
db.AddParameters("@PleacementId", placeId);
db.AddParameters("@PlacePosition", position);
db.AddParameters("@JoinFrom", LumexLibraryManager.GetTerminal());
int i = db.ExecuteNonQuery("INSERT INTO [dbo].[tblStakeJoining] (UserId,RefferId,PleacementId,PlacePosition,JoinDate,JoinFrom)VALUES(@UserId,@RefferId,@PleacementId,@PlacePosition,GETDATE(),@JoinFrom)");
}
catch (Exception)
{
throw;
}
}
internal DataTable getMatchingCommissionListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate));
db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate));
dt = db.ExecuteDataTable("Select [Serial],[UserId],[Leftcarry],[RightCarry],[CarryFlash],[CarryForward],[CarryFrwdPosition],[MatchCommission],[DailyAcBonus],[CalculateDate] FROM [dbo].[tblDailyFlashHistory] where CAST(CalculateDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)");
}
catch (Exception)
{
throw;
}
return(dt);
}
internal void UpdateLookUpElementData(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@ElementId", lookUpDataBLL.ElementDataId.Trim());
db.AddParameters("@ElementName", lookUpDataBLL.ElementDataName.Trim());
db.AddParameters("@ElementGrpId", lookUpDataBLL.ElementGroupId.Trim());
db.AddParameters("@Suffix", lookUpDataBLL.ElementDataDescp.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[UPDATE_ELEMENT_DATA]", true);
}
catch (Exception)
{
throw;
}
}
public void UpdateUserPassword(string userId, string password, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", userId);
db.AddParameters("@Password", ProtectPassword(password));
db.AddParameters("@ActualPass", password);
//db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_USER_PASSWORD_BY_ID", true);
}
catch (Exception)
{
throw;
}
}
internal DataTable updateKeyWhenPurchase(string NoofPin, string UnitPrice, string StakeId, string payby, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@NoofPin", NoofPin);
db.AddParameters("@PinAmount", UnitPrice);
db.AddParameters("@StakeId", StakeId);
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.AddParameters("@PayBy", payby);
DataTable dt = db.ExecuteDataTable("[UPDATE_STAKE_PIN_ON_PURCHEAS_AND_PAYMENT]", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
internal DataTable getTotalMatchingCommissionListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate));
db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate));
dt = db.ExecuteDataTable("Select [amount],CONVERT(VARCHAR, CAST([TransectionDate] AS SMALLDATETIME), 103) as [TransectionDate] FROM [dbo].[tblReceivePayment] where CAST(TransectionDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE) ORDER BY [TransectionDate] ASC");
}
catch (Exception)
{
throw;
}
return(dt);
}
internal void updateKeyonTransfer(BLL.StakeInfoBLL stakeInfoBLL, DataTable dt, LumexDBPlayer db)
{
try
{
db.AddParameters("@StakeKey", dt);
db.AddParameters("@SentTo", stakeInfoBLL.sendto);
db.AddParameters("@SentBy", stakeInfoBLL.transferBy);
db.AddParameters("@SendSms", stakeInfoBLL.sendSms);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteDataTable("[UPDATE_STAKE_PIN_ON_TRANSFER]", true);
}
catch (Exception)
{
throw;
}
}
internal DataTable getDailybounsListbyDateRangeByUserId(string FromDate, string ToDate, string UserId, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@UserId", UserId);
db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate));
db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate));
dt = db.ExecuteDataTable("SELECT [Serial],[UserId],[DailyBonus],[BonusDate],[CreatedFrom],[CreatedBy],[InvestAmount]FROM [dbo].[tblDailyBous] where UserId=@UserId and CAST(BonusDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)");
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable SaveLookUpGroup(initialDataBLL lookUpDataBLL, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@ElementGrpName", lookUpDataBLL.ElementGroupName.Trim());
db.AddParameters("@Description", lookUpDataBLL.ElementGroupDes.Trim());
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("[INSERT_ELEMENT_GROUP]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
internal DataTable getMoneyGenerateAmountByDateRangeById(string FromDate, string ToDate, string UserId, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate));
db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate));
dt = db.ExecuteDataTable("Select [Serial],[Amount],[GenerateBy],[GenerateFrom],[GenerateDate] FROM [dbo].[tblMoneyGenerate] where CAST(GenerateDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)");
}
catch (Exception)
{
throw;
}
return(dt);
}
public DataTable SaveUser(UserBLL user, LumexDBPlayer db)
{
try
{
db.AddParameters("@UserId", user.UserId.Trim());
db.AddParameters("@UserName", user.UserName.Trim());
db.AddParameters("@EmployeeId", "");
db.AddParameters("@UserGroupId", "UG001");
db.AddParameters("@Department", "");
db.AddParameters("@Designation", "");
db.AddParameters("@Address", "");
db.AddParameters("@ContactNumber", user.Cell.Trim());
db.AddParameters("@Email", user.Email.Trim());
db.AddParameters("@NationalId", "");
db.AddParameters("@PassportNumber", "");
db.AddParameters("@Password", ProtectPassword(user.Password.Trim()));
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
//db.AddParameters("@DOB",LumexLibraryManager.ParseAppDate(user.DOB.Trim()));
//db.AddParameters("@Gender",user.Gender.Trim());
if ((string)LumexSessionManager.Get("ActiveUserId") == "Developer")
{
db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
}
else
{
db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
}
db.AddParameters("@ValidDate", "");
DataTable dt = db.ExecuteDataTable("INSERT_USER", true);
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
}
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 DataTable CalculateMatchingCommission(string UserId, decimal leftAmount, decimal rightAmount, LumexDBPlayer db)
{
DataTable dt = new DataTable();
try
{
db.AddParameters("@UserId", UserId);
db.AddParameters("@TotalLeft", leftAmount);
db.AddParameters("@TotalRight", rightAmount);
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("[INSERT_RECEIVE_PAYMENT_WHEN_MATCHING_COMMISSION]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
