protected void Page_Load(object sender, EventArgs e)
{
string action = string.Empty;
string answer = "ocurrio un error";
action = Request["action"];
if (action == "period")
{
BrBonus brBonus = new BrBonus();
MyFunctions mf = new MyFunctions();
MyConstants mc = new MyConstants();
var data = brBonus.GetPeriod(User.Identity.Name.Split('¬')[1]);
var pag = int.Parse(Request["pag"]);
//var init = pag - 10;
if (!string.IsNullOrEmpty(data))
{
var stringHtml = "";
var arrayData = data.Split('¬');
pag = arrayData.Length > pag ? pag : arrayData.Length;
for (int i = 0; i < pag; i++)
{
var row = arrayData[i].Split('|');
if (row.Length > 1)
{
var dateUpdate = DateTime.Now;
dateUpdate = dateUpdate < DateTime.Parse(row[3]) ? dateUpdate : DateTime.Parse(row[3]);
var acordion = "";
acordion += $"<div class='accordion' id='accordionExample{i}'>";
acordion += "<div class='card'> <div class='card-header' id='headingOne'><h2 style='' class='mb-0'>";
acordion += "<div style='font-family: open sans, Helvetica Neue, Helvetica, Arial, sans-serif; color:black'>";
acordion += "<div class='card-body table-responsive'>";
acordion += "<table class='table thead-dark table-bordered'>";
acordion += "<thead style='font-size: 15px'>";
acordion += "<tr>";
acordion += "<th>Periodo</th>";
acordion += "<th>actualizado a </th>";
acordion += "<th>Comisión</th>";
acordion += "<th></th>";
acordion += "</tr>";
acordion += "</thead>";
acordion += "<tbody>";
acordion += "<tr>";
acordion += $"<td>{mf.DateFormatClient(row[1])} - {mf.DateFormatClient(row[2])}</td>";
acordion += $"<td>{mf.DateFormatClient(dateUpdate.ToString(mc.DateFormatBd))}</td>";
acordion += $"<td> {row[5]} {row[4]}</td>";
acordion += "<td> <button type='button' id='myBtn' data-toggle='modal' data-target='#myModal' style='color:white;' class='btn btn-xl m-t-n-xs ' >Resumen </button>";
acordion += "<button style='background-color:white' class='btn ' type='button' data-toggle='collapse' data-target='#collapse" + i + "' aria-expanded='true' ";
acordion += $"aria-controls='collapse{i}' onclick=ShowBonus('divBonus{i}',{row[0]})>ver detalle</button></div></td>";
acordion += "</tr>";
acordion += "</tbody>";
acordion += "</table>";
acordion += "</div>";
acordion += " ";
acordion += $"</div> <div id='collapse{i}' class='collapse' aria-labelledby='headingOne'";
acordion += $"data-parent='#accordionExample{i}'>";
acordion += "<div class='card-body table-responsive'>";
acordion += $"<div id='divBonus{i}'>";
acordion += "";
acordion += "</div>";
acordion += "</div></div></div>";
acordion += "</div></div>";
stringHtml += acordion;
}
}
answer = stringHtml;
}
brBonus = null;
}
if (action == "bonus")
{
var id = int.Parse(Request["period"]);
BrBonus brBonus = new BrBonus();
MyFunctions mf = new MyFunctions();
var tableHtml = "";
var data = brBonus.GetListBonus(User.Identity.Name.Split('¬')[1], id);
tableHtml += "<table class='table table-hover'>";
//tableHtml += "<thead>";
tableHtml += "<tr>";
tableHtml += "<th>#</th>";
tableHtml += "<th>Nombres</th>";
tableHtml += "<th>Tipo de Comision</th>";
tableHtml += "<th>Nivel</th>";
tableHtml += "<th>Fecha</th>";
tableHtml += "<th>Puntos</th>";
tableHtml += "<th>Porcentaje</th>";
tableHtml += "<th>Monto</th>";
tableHtml += "<th>Por Estado</th>";
tableHtml += "<th>Por Nivel</th>";
tableHtml += "</tr>";
//tableHtml += "</thead>";
//tableHtml += "<tbody>";
if (!string.IsNullOrEmpty(data))
{
var arrayData = data.Split('¬');
var amountTotal = 0m;
var symbol = "";
for (int i = 0; i < arrayData.Length; i++)
{
var row = arrayData[i].Split('|');
var interrutor = 0;
if (row.Length > 5)
{
if (i > 0)
{
if (arrayData[i - 1].Split('|')[0] != row[0])
{
tableHtml += "<tr>";
tableHtml += "<td colspan='10'>.</td>";
tableHtml += "</tr>";
}
}
var clasCss = "label-danger";
var clasCssn = "label-danger";
var status = "NO";
var nivel = "NO";
if (row[7] == "1" || row[7] == "6" || row[7] == "7")
{
clasCss = "label-success";
status = "SI";
interrutor++;
}
if (int.Parse(row[8]) == 1)
{
clasCssn = "label-success";
nivel = "SI";
interrutor++;
}
if (interrutor == 2)
{
amountTotal += decimal.Parse(row[6]);
}
symbol = row[9];
tableHtml += "<tr>";
tableHtml += $"<td>{(i + 1).ToString()}</td>";
tableHtml += $"<td>{row[0]}</td>";
tableHtml += $"<td>{row[1]}</td>";
tableHtml += $"<td>{row[2]}</td>";
tableHtml += $"<td>{mf.DateFormatClient(row[3])}</td>";
tableHtml += $"<td>{row[4]}</td>";
tableHtml += $"<td>{row[5]}</td>";
tableHtml += $"<td>{row[9]} {row[6]}</td>";
tableHtml += $"<td><span class='{clasCss}'>{status}</span></td>";
tableHtml += $"<td><span class='{clasCssn}'>{nivel}</span></td>";
tableHtml += "</tr>";
}
row = null;
}
tableHtml += $"<tr><td colspan='7'></td><td class='label-success'>{symbol} {amountTotal.ToString()}</td><td colspan='2'></td><tr>";
}
else
{
tableHtml += "<tr><td>No hay Datos</td></tr>";
}
//tableHtml += "</tbody>";
tableHtml += "</table>";
answer = tableHtml;
}
Response.Write(answer);
}
protected void Page_Load(object sender, EventArgs e)
{
string action = string.Empty;
string answer = "ocurrio un error";
action = Request["action"];
if (action == "list")
{
BrBonus brBonus = new BrBonus();
MyFunctions mf = new MyFunctions();
MyConstants mc = new MyConstants();
var data = brBonus.GetFullPeriod();
if (data != "")
{
var arrayData = data.Split('¬');
var tableHtml = "";
tableHtml = "<table class='table table-hovered'>";
tableHtml += "<tr>";
tableHtml += "<th>#</th>";
tableHtml += "<th>Fecha de Inicio</th>";
tableHtml += "<th>Fecha de Fin</th>";
tableHtml += "<th>Fecha de Pago</th>";
tableHtml += "<th>Estado</th>";
tableHtml += "<th></th>";
tableHtml += "<th></th>";
tableHtml += "</tr>";
for (int i = 0; i < arrayData.Length; i++)
{
var row = arrayData[i].Split('|');
if (row.Length > 1)
{
var button = $"Activate({row[0]})";
var display = "Activar";
var classbutton = "primary";
if (int.Parse(row[3]) == 1)
{
button = $"Defuce({row[0]})";
display = "Desactivar";
classbutton = "danger";
}
tableHtml += "<tr>";
tableHtml += $"<td>{(i + 1).ToString()}</td>";
tableHtml += $"<td>{mf.DateFormatClient(row[1])}</td>";
tableHtml += $"<td>{mf.DateFormatClient(row[2])}</td>";
tableHtml += $"<td>{mf.DateFormatClient(row[4])}</td>";
tableHtml += $"<td>{mf.GeneralStatus(row[3])}</td>";
tableHtml += $"<td><input type='button' class='btn-{classbutton}' onclick={button} value='{display}' /></td>";
if (DateTime.Parse(row[4]) >= DateTime.Now && row[3] == "1")
{
tableHtml += $"<td><input type='button' class='btn-info' onclick=PayBonus({row[0]}) value='Pagar Bonus' /> | ";
tableHtml += $"<input type='button' class='btn-success' onclick=HistoryRange({row[0]}) value='Calcular Rangos Compuestos' /> | ";
tableHtml += $"<input type='button' class='btn-warning' onclick=HistoryRangeResidual({row[0]}) value='Calcular Rangos Residual' /></td>";
}
else
{
tableHtml += "<td></td>";
}
tableHtml += "</tr>";
}
}
tableHtml += "</table>";
answer = tableHtml;
}
}
if (action == "status")
{
BrBonus brBonus = new BrBonus();
var option = int.Parse(Request["option"]);
var id = int.Parse(Request["id"]);
var anwdata = false;
if (option == 0)
{
anwdata = brBonus.ChangeStatus(id, 0);
}
if (option == 1)
{
anwdata = brBonus.ChangeStatus(id, 1);
}
if (anwdata)
{
answer = "La operacion se realizo con exito.";
}
brBonus = null;
}
if (action == "new")
{
MyFunctions mf = new MyFunctions();
var _from = Request["from"];
var _until = Request["until"];
var _payDate = Request["paydate"];
_from = mf.DateFormatBd(_from);
_until = mf.DateFormatBd(_until);
_payDate = mf.DateFormatBd(_payDate);
BrBonus brBonus = new BrBonus();
var dataresp = brBonus.PutPeriod(_from, _until, _payDate);
if (dataresp)
{
answer = "La operacion se realizo con exito.";
}
brBonus = null;
}
if (action == "paybonus")
{
var id = int.Parse(Request["id"]);
BrBonus brBonus = new BrBonus();
var dataresp = brBonus.PayBonus(id);
if (dataresp)
{
var listEmail = brBonus.GetEmailPayWallet(id).Split('¬');
for (int i = 0; i < listEmail.Length; i++)
{
var row = listEmail[i].Split('|');
var amount = decimal.Parse(row[2]);
var transfid = new Random().Next(100000).ToString();
var walletId = int.Parse(row[4]).ToString("00000000");
var arrdescrip = row[3].Split(':');
var descripti = arrdescrip[0] + " : <span>" + arrdescrip[1] + "</span>";
MyConstants mc = new MyConstants();
var sendee = SendPayWallet(row[0], row[1], amount, descripti, transfid, walletId);
sendee = SendPayWallet(mc.EmailEmpresaBonus, row[1], amount, descripti, transfid, walletId);
}
answer = "La operacion se realizo con exito.";
}
}
if (action == "historyrange")
{
var id = int.Parse(Request["id"]);
BrHistoryRange brHistoryRange = new BrHistoryRange();
var dataresp = brHistoryRange.PutHistoryRangePeriod(id);
answer = "";
if (dataresp)
{
answer = "La operacion se realizo con exito.";
}
}
if (action == "historyrangeresidual")
{
var id = int.Parse(Request["id"]);
BrHistoryRange brHistoryRange = new BrHistoryRange();
var dataresp = brHistoryRange.PutHistoryRangeResidualPeriod(id);
answer = "";
if (dataresp)
{
answer = "La operacion se realizo con exito.";
}
}
Response.Write(answer);
}
