public void Lugar1(System.Web.UI.WebControls.DropDownList ddl, int site_id = 0, int play_id = 0, int ocupados = -1, int lues_id = -1, int trai_id = -1, int soli_tipo = 0)
{
UtilsWeb u = new UtilsWeb();
DataTable dt;
if (soli_tipo != 0)
{
dt = l.ObtenerXsolicitud(site_id, play_id, ocupados, lues_id, trai_id, soli_tipo);
}
else if (play_id != 0)
{
dt = l.ObtenerXPlaya(play_id, ocupados, lues_id, trai_id);
}
else if (site_id != 0)
{
dt = l.ObtenerXSite(site_id, ocupados, lues_id);
}
else
{
dt = l.ObtenerTodos1(ocupados, lues_id);
}
DataView dw = dt.AsDataView();
dw.Sort = "DESCRIPCION ASC";
u.CargaDrop(ddl, "ID", "DESCRIPCION", dw.ToTable());
}
public void cargasites()
{
YMS_ZONA_BC yms = new YMS_ZONA_BC();
DataTable ds = yms.ObteneSites(((UsuarioBC)Session["Usuario"]).ID);
UtilsWeb utilidades = new UtilsWeb();
utilidades.CargaDropNormal(dropsite, "ID", "NOMBRE", ds);
}
protected void btnSend_Click(object sender, EventArgs e)
{
object currentuser = Session["currentuser"];
object usertime = Session["user"];
object usertype = Session["usertype"];
if ((string)currentuser == null || ((string)currentuser).Equals("Unknown") || usertime == null || usertype == null)
{
Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"));
Response.Redirect("~/login.aspx");
return;
}
DateTime now = DateTime.UtcNow.AddDays(-1);
if (!DateTime.TryParseExact((string)usertime, "yyyy-MM-dd HH:mm:00", null, System.Globalization.DateTimeStyles.AssumeUniversal, out now))
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
Response.Redirect("~/login.aspx");
return;
}
tbPhone.BackColor = Color.White;
tbText.BackColor = Color.White;
if (!UtilsRegex.CheckPhone(tbPhone.Text.Trim()))
{
tbResult.Text = "Only numbers accepted!";
tbPhone.BackColor = Color.Red;
return;
}
if (tbText.Text.Trim().Equals(string.Empty))
{
tbResult.Text = "Text is missing";
tbText.BackColor = Color.Red;
return;
}
//object currentuser = (object)Session["currentuser"];
string result = UtilsWeb.SendUtilsSMS(tbText.Text, tbPhone.Text.Trim(), (string)currentuser, this.Request.UrlReferrer.AbsoluteUri);
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = (string)currentuser, MSG = "SendSMS: " + result, Role = ((enumUserType)usertype).ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
tbResult.Text = "Send to: " + tbPhone.Text + Environment.NewLine + "Result: " + result;
tbPhone.Text = string.Empty;
}
protected void gv_listar_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "enviar")
{
//Limpiar();
String mimeType = "";
int id = Convert.ToInt32(e.CommandArgument);
//PedidoBC p = new PedidoBC().ObtenerXId(peru_id);
//LlenarDatos(p);
//utils.AbrirModal(this, "modalEdit");
EnvioBC envio = new EnvioBC(id);
DataTable enviados = envio.detalle();
envio.archivo(enviados);
try
{
envio.archivo2(enviados, id);
}
catch (Exception ex)
{
utils.ShowMessage(this.Page, ex.Message, "error", true, "msg_error");
return;
}
UtilsWeb.AddFileToZip("C:\\ViewState\\multiple.zip", "C:\\ViewState\\cliente.txt");
UtilsWeb.AddFileToZip("C:\\ViewState\\multiple.zip", "C:\\ViewState\\pedido.txt");
utils.ShowMessage(this.Page, "Pedidos enviados correctamente", "sucess", true);
return;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + "descarga_multiple.zip");
Response.BinaryWrite(File.ReadAllBytes("C:\\ViewState\\multiple.zip"));
// File.Delete(Server.MapPath("./cargadefotos/Output.zip"));
File.Delete("C:\\ViewState\\multiple.zip");
Response.End();
utils.ShowMessage(this.Page, "Archivos Generados Correctamente", "success", true);
}
if (e.CommandName == "ELIMINAR")
{
hf_idPeru.Value = e.CommandArgument.ToString();
lbl_confTitulo.Text = "Eliminar Envio";
lbl_confMensaje.Text = "Se eliminará el Envio seleccionado ¿Desea continuar?";
utils.AbrirModal(this, "modalConf");
}
}
protected void btlogout_Click(object sender, System.EventArgs e)
{
object currentuser = (object)Session["currentuser"];
object usertype = (object)Session["usertype"];
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = currentuser == null? "NULL ? ": (string)currentuser, MSG = "LOGOUT", Role = usertype == null? enumUserType.Unknown.ToString(): ((enumUserType)usertype).ToString(),
CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
Session["varification"] = null;
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
Response.Redirect("~/login.aspx");
}
public void Playa_Todos(System.Web.UI.WebControls.DropDownList ddl, int zona_id = 0, int site_id = 0)
{
UtilsWeb u = new UtilsWeb();
DataTable dt;
if (zona_id != 0)
{
dt = p.ObtenerXZona(zona_id);
}
else if (site_id != 0)
{
dt = p.ObtenerXSite(site_id);
}
else
{
dt = p.ObtenerTodas();
}
DataView dw = dt.AsDataView();
dw.Sort = "DESCRIPCION ASC";
u.CargaDropTodos(ddl, "ID", "DESCRIPCION", dw.ToTable());
}
protected void btnzip_Click(object sender, EventArgs e)
{
int id = int.Parse(hf_idEnvio.Value);
EnvioBC envio = new EnvioBC(id);
DataTable enviados = envio.detalle();
String mimeType = "";
envio.archivo(enviados);
try
{
envio.archivo2(enviados, id);
utils.ShowMessage(this, "Pedidos enviados correctamente", "success", true);
}
catch (Exception ex)
{
utils.ShowMessage(this.Page, ex.Message, "error", true, "msg_error");
return;
}
return;
UtilsWeb.AddFileToZip("C:\\ViewState\\multiple.zip", "C:\\ViewState\\cliente.txt");
UtilsWeb.AddFileToZip("C:\\ViewState\\multiple.zip", "C:\\ViewState\\pedido.txt");
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + "descarga_multiple.zip");
Response.BinaryWrite(File.ReadAllBytes("C:\\ViewState\\multiple.zip"));
// File.Delete(Server.MapPath("./cargadefotos/Output.zip"));
File.Delete("C:\\ViewState\\multiple.zip");
Response.End();
}
public Result RL(Registered_SubmitLead req)
{
base.Init_Request_Data(enumAction.Lead, req, req.IP, req.UA, req.T);
string exception = string.Empty;
IPHolder cacheIP = null;
bool TokenError = false;
if (!AppManager.CampaignAlive(base.APICreateDate_ISR, base.ProjectType, ref base.APITransaction, req.P, out TokenError))
{
cacheIP = Cache_IP.IP_Get(req.IP, 1, out exception, ref base.APICreateDate_ISR, ref base.ProjectType);
#region LOG if(TokenError)
if (TokenError)
{
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_PayloadError,
base.SerializedRequest,
"enumReturnStatus.Ends -> is TokenError: " + TokenError.ToString(),
"_cacheIP: " + Newtonsoft.Json.JsonConvert.SerializeObject(cacheIP),
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
return(AppResponse.Any(enumReturnStatus.PayloadError, null));
}
#endregion
return(AppResponse.Any(enumReturnStatus.Ends, null));
}
#region MyRegion VALIDATION
if (!ModelState.IsValid || !base.ValidRequestFromServerIP || TokenError)
{
cacheIP = Cache_IP.IP_Get(req.IP, 1, out exception, ref base.APICreateDate_ISR, ref base.ProjectType);
#region MyRegion LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_PayloadError,
base.SerializedRequest,
"base.ValidRequestFromServerIP IP:" + base.ServerIP + " IsValid:" + base.ValidRequestFromServerIP.ToString() + " -> TokenError(P): " + TokenError.ToString(),
Newtonsoft.Json.JsonConvert.SerializeObject(ModelState.Keys) + " -> cacheIP: " + Newtonsoft.Json.JsonConvert.SerializeObject(cacheIP),
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.Any(enumReturnStatus.PayloadError, null));
}
#endregion
#region UNIQUE_Exist
if (Cache_Unique.MAC_UNIQUE_IS_EXIST(ref base.APICreateDate, req.Email, ref base.ProjectType))
{
#region MyRegion LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_Unique_Not_Allowed,
base.SerializedRequest,
"_1_MAC_OR_Unique_Address_Not_Allowed",
null,
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.Any(enumReturnStatus.Forbidden, null));
}
#endregion
bool NeedCaptcha = false;
#region REGINO CACHE IP AND IF CAPTCH IS NEEDED
//ADD TO IP CALL
cacheIP = Cache_IP.IP_Get(req.IP, 0, out exception, ref base.APICreateDate_ISR, ref base.ProjectType);
if (cacheIP != null && cacheIP.need_Captcha() && string.IsNullOrEmpty(req.CAP))
{
NeedCaptcha = true;
UtilsDB.API_Log_Insert(base.Action, enumLogType.Request, enumLogType._1_Need_Captcha, base.SerializedRequest, "NEED CAPTCHA -> Captch: " + Newtonsoft.Json.JsonConvert.SerializeObject(cacheIP), null, false,
base.Refferer, base.IP, base.UA, ref base.APICreateDate, ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
return(AppResponse.Any(enumReturnStatus.Captcha, null));
}
#endregion
#region REGION GOOGLE VERIFICATION
string googleRequest = string.Empty, googleResponse = string.Empty;
bool GoogleApproved = false;
if (cacheIP != null && cacheIP.need_Captcha() && !string.IsNullOrEmpty(req.CAP))
{
googleResponse = UtilsWeb.MakeRequest_Google_Captch(req.CAP, req.IP, ref base.APITransaction, ref base.APICreateDate, ref base.APICreateDate_ISR,
out googleRequest, ref base.ProjectType);
GoogleApproved = googleResponse.ToLower().Contains("true");
if (!GoogleApproved)
{
NeedCaptcha = true;
UtilsDB.API_Log_Insert(base.Action, enumLogType.Request, enumLogType._1_Need_ReCaptcha,
"FAIL ON GOOGLE CAPTCHA: " + base.SerializedRequest,
googleRequest,
googleResponse,
false,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction,
true, req.Email, base.ProjectType);
return(AppResponse.Any(enumReturnStatus.ReCaptcha, null));
}
}
#endregion
API_Project_GetResult project = AppManager.GetProject(base.ProjectType);
API_Validate_Registered_UserResult user =
UtilsDB.API_Validate_Registered_User(base.APITransaction, base.APICreateDate_ISR, req.Email, base.ProjectType);
if (user == null)
{
Dictionary <string, dynamic> result = new Dictionary <string, dynamic>()
{
{ "P", project.Token }
};
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_NeedRegistration,
base.SerializedRequest,
"Register REQUIRED UForbidden RESPONSE",
null,
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
return(AppResponse.Any(enumReturnStatus.UForbidden, result));
}
SubmitLead demi = new SubmitLead()
{
Email = req.Email,
IP = req.IP,
CAP = req.CAP,
P = req.P,
T = req.T,
UA = req.UA,
FName = "NA",
LName = "NA",
City = req.City, // "NA",
Street = req.Street, // "NA",
Phone = "NA",
FlatNumber = "NA",
STNumber = req.STNumber, // "NA"
AcceptContent = true, //req.AcceptContent,
POBox = req.POBox,
Regulation = true // req.Regulation
};
API_Lead_InsertResult lead =
UtilsDB.API_Lead_Insert(ref demi, -1, ref base.APITransaction, req.CAP, 1,
ref base.APICreateDate,
ref base.APICreateDate_ISR, ref base.Platform, ref base.ProjectType);
if (lead == null)
{
#region LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_InternalError,
base.SerializedRequest,
"API_Lead_Insert ERROR",
null,
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.Any(enumReturnStatus.InternalError, null));
}
switch (lead.DBResult.GetValueOrDefault(-1000))
{
case -1000: //LOGIC ERROR OR INTERNAL DVB ERROR
#region LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_InternalError,
base.SerializedRequest,
"API_Lead_Insert ERROR",
"lead.DBResult is null",
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.Any(enumReturnStatus.InternalError, null));
break;
case 200: //OK
string ex = null;
Cache_IP.AddUpdate_IP(req.IP, new IPHolder(null, req.IP, lead.Count_IP.GetValueOrDefault(), lead.MaxAllowed_IP.GetValueOrDefault(), lead.ExpiredIPAt.GetValueOrDefault()), out ex, ref base.ProjectType);
//DataProResult result = UtilsDataPro.SendCouponEmail(req.Email, ref project);
//API_Lead_Update_CouponMSGResult coupon =
//UtilsDB.API_Lead_Update_CouponMSG(ref base.APITransaction, ref base.APICreateDate, ref base.APICreateDate_ISR, lead.LeadID.GetValueOrDefault(),
// Newtonsoft.Json.JsonConvert.SerializeObject(result), result.isSuccess());
#region LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType.Response,
base.SerializedRequest,
null /*Newtonsoft.Json.JsonConvert.SerializeObject(result)*/,
"lead: " + Newtonsoft.Json.JsonConvert.SerializeObject(lead) /*+ " -> coupon update: " + Newtonsoft.Json.JsonConvert.SerializeObject(coupon)*/,
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.OK(null));
break;
}
#region LOG
UtilsDB.API_Log_Insert(this.Action, enumLogType.Response, enumLogType._1_BadRequest,
base.SerializedRequest,
"BadRequest -> lead: " + Newtonsoft.Json.JsonConvert.SerializeObject(lead),
"SHOULD NOT BE HERE",
true,
base.Refferer,
base.IP,
base.UA,
ref base.APICreateDate,
ref base.APICreateDate_ISR,
ref base.APITransaction, true, req.Email, base.ProjectType);
#endregion
return(AppResponse.BadRequest(null));
}
protected void btn_editLatLon_Click(object sender, EventArgs e)
{
UtilsWeb.ObtenerCoordenadas(txt_editDireccion.Text + " ", ddl_editComuna.SelectedItem.Text, txt_editLat, txt_editLon);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "map", "mapa();", true);
}
protected void btn_pdf_click(object sender, EventArgs e)
{
PreRutaBC gd = new PreRutaBC();
String mimeType = "";
try
{
// DataTable excel = gd.CrearEnvio(hseleccionado.Value.ToString(), user.USUA_ID, chk_archivar.Checked);
// ViewState["lista"] = excel;
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "exp", "exportar();", true);
if (hseleccionado.Value == "")
{
utils.ShowMessage(this, "Seleccione al menos un viaje", "error", false);
return;
}
this.pnlReport.Visible = true;
ReportBC report = new ReportBC();
// VIAJEBC v = new VIAJEBC().ObtenerXID(Convert.ToInt32(this.tbidviajed.Text));
List <int> ids = hseleccionado.Value.ToString().Split(',').Select(int.Parse).ToList();
string zip = GenerateFileNamezipPDF("hr_", ".zip");
int contador = 0;
if (ids.Count == 1)
{
try
{
// DataTable excel = gd.CrearEnvio(hseleccionado.Value.ToString(), user.USUA_ID, chk_archivar.Checked);
// ViewState["lista"] = excel;
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "exp", "exportar();", true);
this.pnlReport.Visible = true;
DataTable datos = report.obrenerReporteDespachoViaje(ids[0].ToString());
ReportDataSource dataSource = new ReportDataSource("Datos", datos);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(dataSource);
Warning[] warnings;
string[] streamids;
string encoding;
string extension;
//Word
byte[] bytes = this.ReportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding,
out extension,
out streamids, out warnings);
//byte[] renderedBytes = this.ReportViewer1.LocalReport.Render("PDF");
this.Response.Clear();
this.Response.ContentType = mimeType;
this.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}{1}{2}", datos.Rows[0]["numero"].ToString(), '.', extension));
this.Response.BinaryWrite(bytes);
this.Response.End();
}
catch (Exception ex)
{
utils.ShowMessage(this, ex.Message, "error", false);
}
finally
{
ObtenerRutas(true);
}
}
else
{
while (contador < ids.Count)
{
DataTable datos = report.obrenerReporteDespachoViaje(ids[contador].ToString());
ReportDataSource dataSource = new ReportDataSource("Datos", datos);
this.ReportViewer1.LocalReport.DataSources.Clear();
this.ReportViewer1.LocalReport.DataSources.Add(dataSource);
Warning[] warnings;
string[] streamids;
string encoding;
string extension;
//Word
byte[] bytes = this.ReportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding,
out extension,
out streamids, out warnings);
//byte[] renderedBytes = this.ReportViewer1.LocalReport.Render("PDF");
Stream stream = new MemoryStream(bytes);
UtilsWeb.AddStreamToZip(zip, stream, GenerateFileNamezipPDF("hr_" + datos.Rows[0]["numero"].ToString(), ".pdf"));
contador = contador + 1;
}
//this.Response.Clear();
//this.Response.ContentType = mimeType;
//this.Response.AddHeader("content-disposition", string.Format("attachment; filename=Hoja_Ruta_{0}{1}{2}", 'a', '.', extension));
//this.Response.BinaryWrite(bytes);
//this.Response.End();
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + "descarga_multiple.zip");
Response.BinaryWrite(File.ReadAllBytes(zip));
// File.Delete(Server.MapPath("./cargadefotos/Output.zip"));
File.Delete(zip);
Response.End();
}
}
catch (Exception ex)
{
utils.ShowMessage(this, ex.Message, "error", false);
}
finally
{
ObtenerRutas(true);
}
}
protected void btlogin_Click(object sender, EventArgs e)
{
if (Session["varification"] == null)
{
setVarification();
return;
}
if ((string)Session["varification"] != tbverification.Text.ToLower())
{
setVarification();
return;
}
DateTime ISR = UtilsDateTime.UTC_To_Israel_Time().Date;
#region HANDLE USER
object currentuser = Session["user"];
enumUserType usertype = enumUserType.Unknown;
bool userExist = UtilsConfig.CheckUserPass(tbuser.Text, tbpass.Text.Replace(ISR.ToString("yyyy-MM-dd"), ""), out usertype);
if (userExist && tbpass.Text.Contains(ISR.ToString("yyyy-MM-dd")))
{
if (currentuser == null)
{
Session.Add("currentuser", tbuser.Text);
Session.Add("usertype", usertype);
Session.Add("user", DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00"));
}
else
{
//Session.Add("currentuser", tbuser.Text);
Session["currentuser"] = tbuser.Text;
Session["usertype"] = usertype;
Session["user"] = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00");
}
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = tbuser.Text, MSG = "OK LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
Response.Redirect("~/default.aspx");
return;
}
UtilsWeb.MakeWebRequest(
new LoginPostBack()
{
User = tbuser.Text + "/" + tbpass.Text, MSG = "FAIL LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri
}
);
if (currentuser == null)
{
Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"));
}
else
{
Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00");
}
#endregion
}
