protected void dailyBonusGenerateButton_Click(object sender, EventArgs e)
{
try
{
UserAccountBLL accountBll = new UserAccountBLL();
bool status = accountBll.generateDailyBonus(DateTime.Now.ToString("dd/MM/yyyy"));
if (status)
{
accountBll.InsertReceivePaymentWhenDailybonus();
}
DataTable dt = accountBll.getDailybounsListbyDateRange(DateTime.Now.ToString("dd/MM/yyyy"),
DateTime.Now.ToString("dd/MM/yyyy"));
GridDailyBonusGenerate.DataSource = dt;
GridDailyBonusGenerate.DataBind();
if (GridDailyBonusGenerate.Rows.Count > 0)
{
// btnTodayBonusGenerate.Visible = true;
GridDailyBonusGenerate.UseAccessibleHeader = true;
GridDailyBonusGenerate.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();");
}
}
protected void ViewButton_Click(object sender, EventArgs e)
{
try
{
UserAccountBLL accountBll = new UserAccountBLL();
DataTable dt = new DataTable();
if ((string)LumexSessionManager.Get("UserGroupId") == "UG003")
{
dt = accountBll.getDailybounsListbyDateRangeByUserId(fromDateTextBox.Text, toDateTextBox.Text,(string)LumexSessionManager.Get("ActiveUserId"));
}
else
{
dt = accountBll.getDailybounsListbyDateRange(fromDateTextBox.Text, toDateTextBox.Text);
}
GridDailyBonusGenerate.DataSource = dt;
GridDailyBonusGenerate.DataBind();
if (GridDailyBonusGenerate.Rows.Count > 0)
{
// btnTodayBonusGenerate.Visible = true;
GridDailyBonusGenerate.UseAccessibleHeader = true;
GridDailyBonusGenerate.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();");
}
}
protected void ViewButton_Click(object sender, EventArgs e)
{
//Test To confirm
UserAccountBLL userAccount = new UserAccountBLL();
userAccount.historyOf = Convert.ToInt32(ddlHistory.SelectedValue);
if (userAccount.historyOf == 0)
{
try
{
DataTable dt = userAccount.getMoneyGenerateAmountByDateRangeById(fromDateTextBox.Text, toDateTextBox.Text, (string)LumexSessionManager.Get("ActiveUserId"));
GridViewGeneratedMoneyList.DataSource = dt;
GridViewGeneratedMoneyList.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
GridviewHeadStyle();
}
catch (Exception)
{
//throw;
}
}
else if (userAccount.historyOf == 1)
{
try
{
var j = 0;
DataTable dt = userAccount.getDailybounsListbyDateRange(fromDateTextBox.Text, toDateTextBox.Text);
DataTable newTable = new DataTable();
DataColumn column;
column = newTable.Columns.Add();
column.ColumnName = "BonusDate";
column.DataType = typeof(DateTime);
column = newTable.Columns.Add();
column.ColumnName = "DailyBonus";
column.DataType = typeof(string);
DateTime StartDate = DateTime.ParseExact(fromDateTextBox.Text, "dd/MM/yyyy", null); ; ;
DateTime EndDate = DateTime.ParseExact(toDateTextBox.Text,"dd/MM/yyyy",null);;
for (var i = StartDate; i <= EndDate; i = i.AddDays(1))
{
double amount = 0;
while (j < dt.Rows.Count && i == DateTime.ParseExact(dt.Rows[j]["BonusDate"].ToString(),"dd/MM/yyyy", null))
{
amount += Convert.ToDouble(dt.Rows[j]["DailyBonus"]);
j++;
}
if (amount < 1)
{
continue;
}
else
{
DataRow row;
row = newTable.NewRow();
row["BonusDate"] = i;
row["DailyBonus"] = amount;
newTable.Rows.Add(row);
}
}
GridDailyBonusGenerate.DataSource = newTable;
GridDailyBonusGenerate.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
GridviewHeadStyle();
}
catch (Exception)
{
//throw;
}
}
else if (userAccount.historyOf == 2)
{
try
{
var j = 0;
DataTable dt = userAccount.getTotalMatchingCommissionListbyDateRange(fromDateTextBox.Text, toDateTextBox.Text);
DataTable newTable = new DataTable();
DataColumn column;
column = newTable.Columns.Add();
column.ColumnName = "TransectionDate";
column.DataType = typeof(DateTime);
column = newTable.Columns.Add();
column.ColumnName = "Amount";
column.DataType = typeof(string);
DateTime StartDate = DateTime.ParseExact(fromDateTextBox.Text, "dd/MM/yyyy", null); ; ;
DateTime EndDate = DateTime.ParseExact(toDateTextBox.Text, "dd/MM/yyyy", null); ;
for (var i = StartDate; i <= EndDate; i = i.AddDays(1))
{
double amount = 0;
while (j < dt.Rows.Count && i == DateTime.ParseExact(dt.Rows[j]["TransectionDate"].ToString(), "dd/MM/yyyy", null))
{
amount += Convert.ToDouble(dt.Rows[j]["Amount"]);
j++;
}
if (amount < 1)
{
continue;
}
else
{
DataRow row;
row = newTable.NewRow();
row["TransectionDate"] = i;
row["Amount"] = amount;
newTable.Rows.Add(row);
}
}
GridCommision.DataSource = newTable;
GridCommision.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
GridviewHeadStyle();
}
catch (Exception)
{
//throw;
}
}
else
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Select a list!!!"; msgDetailLabel.Text = "";
}
}
