protected void Page_Load(object sender, EventArgs e)
{
SQLTrans.LoginData ldata = ((SQLTrans.LoginData)Session["userdata"]);
bool admin = false;
if (ldata != null)
{
admin = ldata.isAdmin;
}
if (!admin && (Request["action"] == "edit" || Request["action"] == "delete"))
{
output.Text = MSGNOGRANT;
}
else if (Request["id"] != null)
{
int id = Convert.ToInt32(Request["id"]);
if (Request["action"] == "delete")
{
try
{
client.sp_Delete(ldata, SQLTrans.DeleteType.Restaurante, id);
output.Text = MSGDEL;
}
catch { output.Text = MSGNODEL; }
return;
}
if (Request["action"] == "edit")
{
Button btnEdit = new Button();
Button btnDel = new Button();
btnEdit.Text = "Editar";
btnDel.Text = "Eliminar";
btnDel.OnClientClick = "if ( ! UserDeleteConfirmation()) return false;";
btnDel.Click += BtnDel_Click;
btnEdit.Click += BtnEdit_Click;
editcontrols.Controls.Add(btnEdit);
editcontrols.Controls.Add(btnDel);
txtNombre.ReadOnly = false;
txtReferencia.ReadOnly = false;
upload.Enabled = true;
upload.CssClass = "";
}
portrait.Attributes.Remove("class");
SQLTrans.Restaurantes restaurants;
try
{
restaurants = client.GetRestaurante(id)[0];
}
catch
{
output.Text = MSGNODISH;
return;
}
if (!IsPostBack)
{
if (restaurants.URL == null || restaurants.URL == "")
{
img.ImageUrl = "/images/sin-imagen.gif";
}
else
{
img.ImageUrl = restaurants.URL;
}
txtNombre.Text = restaurants.NOMBRE;
txtReferencia.Text = restaurants.REFERENCIA;
}
}
else
{
userlist.Attributes.Remove("class");
string locales = "";
foreach (SQLTrans.Restaurantes r in client.GetRestaurantes())
{
locales += string.Concat("<tr><td><img src='", (r.URL == null || r.URL == string.Empty) ? "/images/sin-imagen.gif" : r.URL, "' height='200px' width='200px' /></td><td>", r.NOMBRE, "</td><td>", r.REFERENCIA, "</td><td>", r.RATE == "" ?"Sin Datos" : Math.Round(double.Parse(r.RATE), 2).ToString(), "</td><td><a href=Locales.aspx?id=", r.ID, ">Ver</a> ");
if (ldata != null)
{
if (ldata.isAdmin)
{
locales += string.Concat("<a href=Locales.aspx?id=", r.ID, "&action=edit>Editar</a> <a href=Locales.aspx?id=", r.ID, "&action=delete onclick=\"if ( ! UserDeleteConfirmation()) return false;\">Eliminar</a></td></tr>\n");
}
}
}
tbody.InnerHtml = locales;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLTrans.Restaurantes[] restaurantes = client.GetRestaurantes();
SQLTrans.LoginData ldata = ((SQLTrans.LoginData)Session["userdata"]);
bool admin = false;
string[] tipos = client.GetTiposPlatillo();
if (ldata != null)
{
admin = ldata.isAdmin;
}
if (!admin && (Request["action"] == "edit" || Request["action"] == "delete"))
{
output.Text = MSGNOGRANT;
}
else if (Request["id"] != null)
{
int id = Convert.ToInt32(Request["id"]);
if (Request["action"] == "delete")
{
try
{
client.sp_Delete(ldata, SQLTrans.DeleteType.Platillo, id);
output.Text = MSGDEL;
}
catch { output.Text = MSGNODEL; }
return;
}
if (Request["commentdelete"] != null)
{
try
{
int i = Convert.ToInt32(Request["commentdelete"]);
client.sp_Delete(ldata, SQLTrans.DeleteType.Comentario, i);
output.Text = "Comentario eliminado!";
}
catch (Exception)
{
output.Text = "Ocurrio un error!";
}
}
if (Request["action"] == "edit")
{
Button btnEdit = new Button();
Button btnDel = new Button();
btnEdit.Text = "Editar";
btnDel.Text = "Eliminar";
btnDel.OnClientClick = "if ( ! UserDeleteConfirmation()) return false;";
btnDel.Click += BtnDel_Click;
btnEdit.Click += BtnEdit_Click;
editcontrols.Controls.Add(btnEdit);
editcontrols.Controls.Add(btnDel);
ddRestaurantes.Enabled = true;
ddTipos.Enabled = true;
txtNombre.ReadOnly = false;
txtDescripcion.ReadOnly = false;
txtPrecio.ReadOnly = false;
upload.Enabled = true;
upload.CssClass = "";
}
foreach (SQLTrans.Restaurantes r in restaurantes)
{
ddRestaurantes.Items.Add(new ListItem(r.NOMBRE, r.ID.ToString()));
}
foreach (string t in tipos)
{
string[] sp = t.Split(',');
ddTipos.Items.Add(new ListItem(sp[1], sp[0]));
}
portrait.Attributes.Remove("class");
SQLTrans.Platillos dish;
try
{
dish = client.GetPlatillo(id)[0];
}
catch
{
output.Text = MSGNOUSER;
return;
}
rate.Controls.Add(LoadControl("rating.ascx"));
if (!IsPostBack)
{
if (dish.URL == null || dish.URL == "")
{
img.ImageUrl = "/images/sin-imagen.gif";
}
else
{
img.ImageUrl = dish.URL;
}
cdish.Text = dish.NOMBRE;
txtNombre.Text = dish.NOMBRE;
txtDescripcion.Text = dish.DESCRIPCION;
txtPrecio.Text = Math.Round(dish.PRECIO, 2).ToString();
ddRestaurantes.SelectedValue = dish.ID_RESTAURANTES.ToString();
ddTipos.SelectedValue = dish.ID_TIPO.ToString();
dishrate.Text = dish.RATE == 0 ? "Sin datos" : Math.Round(dish.RATE, 2).ToString();
}
SQLTrans.Comentarios[] comments = client.GetComentarios(id);
string comentarios = string.Concat(comments.Length, " Comentarios\n<ol class='commentlist'>");
foreach (SQLTrans.Comentarios c in comments)
{
string url = (c.URL == null || c.URL == string.Empty) ? "/images/sin-imagen.gif" : c.URL;
comentarios = string.Concat(comentarios, $"<li class='comment byuser comment-author-demoadmin bypostauthor even thread-even depth-1' id='li-comment-{c.ID_COMENTARIOS}'>",
$"<div id='comment-{c.ID_COMENTARIOS}'><div class='comment-author vcard'>", $"<img src='{url}' clas='avatar avatar-48 photo' height='48' width='48'>", "<cite class='fn'>",
"<a href='Users.aspx?id=", c.ID_USUARIO, "'>", c.ID_USUARIO, "</a> <small><br/>", c.FECHA, "</small></div><div class='comment-body'><p>", c.COMENTARIOS, "</p></div><div class='reply'><a href='Platos.aspx?id=",
id, "&commentdelete=", c.ID_COMENTARIOS, "'", (!admin) ? " class=hidden " : "", ">Eliminar</a></div></div></li>");
}
comentarios = string.Concat(comentarios, "</ol>");
divcomments.InnerHtml = comentarios;
if (ldata != null)
{
commentform.Attributes.Remove("class");
}
}
else
{
userlist.Attributes.Remove("class");
string platillos = "";
string tipo = Request["tipo"];
foreach (SQLTrans.Platillos p in client.GetPlatillos())
{
if (tipo != null)
{
if (Convert.ToInt32(tipo) != p.ID_TIPO)
{
continue;
}
}
platillos += string.Concat("<tr><td><img src='", (p.URL == null || p.URL == "") ? "/images/sin-imagen.gif" : p.URL, "' height='200px' width='200px' /></td><td>", p.NOMBRE, "</td><td>", p.TIPO, "</td><td>", p.RESTAURANTE, "</td><td>$", Math.Round(p.PRECIO, 2), "</td><td><a href=Platos.aspx?id=", p.ID_PLATILLOS, ">Ver</a> ");
if (ldata != null)
{
if (ldata.isAdmin)
{
platillos += string.Concat("<a href=Platos.aspx?id=", p.ID_PLATILLOS, "&action=edit>Editar</a> <a href=Platos.aspx?id=", p.ID_PLATILLOS, "&action=delete OnClick=\"if ( ! UserDeleteConfirmation()) return false;\">Eliminar</a></td></tr>\n");
}
}
}
tbody.InnerHtml = platillos;
}
}