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