protected void Button1_Click(object sender, EventArgs e)
{
SQLTrans.CrudServiceClient client = new SQLTrans.CrudServiceClient();
DataSet ds = client.sp_ValidarUsuario(txtUser.Text, txtPass.Text);
string user = "";
if (ds.Tables[0].Rows.Count > 0)
{
try
{
user = ds.Tables[0].Rows[0][0].ToString();
}
catch { }
if (user != txtUser.Text)
{
Session.Remove("userdata");
output.Text = "Usuario o Password incorrectos!";
}
else
{
SQLTrans.LoginData linfo = new SQLTrans.LoginData();
linfo.USER = txtUser.Text;
linfo.PASS = txtPass.Text;
linfo.isAdmin = client.isAdmin(linfo.USER);
Session["userdata"] = linfo;
Response.Redirect("Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SQLTrans.CrudServiceClient client = new SQLTrans.CrudServiceClient();
if (Session["userdata"] != null)
{
SQLTrans.LoginData ldata = ((SQLTrans.LoginData)Session["userdata"]);
if (!ldata.isAdmin && Request["id"] == null)
{
output.Text = MSGNOGRANT;
}
else if (Request["id"] != null)
{
portrait.Attributes.Remove("class");
string id = Request["id"];
if (Request["action"] == "edit" && ldata.isAdmin)
{
Button btnEdit = new Button();
btnEdit.Text = "Editar";
btnEdit.Click += BtnEdit_Click;
editcontrols.Controls.Add(btnEdit);
txtApellido.ReadOnly = false;
txtBirth.ReadOnly = false;
txtCorreo.ReadOnly = false;
txtNombre.ReadOnly = false;
chkAdmin.Enabled = true;
}
else if (Request["edit"] == "true" && ldata.USER == Request["id"])
{
Button btnEdit = new Button();
btnEdit.Text = "Editar";
btnEdit.Click += BtnEdit_Click;
editcontrols.Controls.Add(btnEdit);
txtApellido.ReadOnly = false;
txtBirth.ReadOnly = false;
txtCorreo.ReadOnly = false;
txtNombre.ReadOnly = false;
}
SQLTrans.Usuarios user;
try
{
user = client.GetUsuario(id)[0];
}
catch
{
output.Text = MSGNOUSER;
return;
}
username.Text = id;
if (!IsPostBack)
{
if (user.URL == null || user.URL == "")
{
img.ImageUrl = "/images/sin-imagen.gif";
}
else
{
img.ImageUrl = user.URL;
}
chkAdmin.Checked = client.isAdmin(id);
txtNombre.Text = user.NOMBRE;
txtApellido.Text = user.APELLIDO;
txtBirth.Text = Convert.ToDateTime(user.FECHA_CUMPLE).ToShortDateString();
txtCorreo.Text = user.CORREO_ELECTRONICO;
lcount.Text = user.VISITAS.ToString();
}
}
else
{
userlist.Attributes.Remove("class");
string users = "";
foreach (SQLTrans.Usuarios u in client.GetUsuarios())
{
users += string.Concat("<tr><td>", u.ID_USUARIO, "</td><td>", u.ADMIN ? "Admin" : "Usuario", "</td><td>", u.CORREO_ELECTRONICO, "</td><td><a href=Users.aspx?id=", u.ID_USUARIO, ">Ver</a> <a href=Users.aspx?id=",
u.ID_USUARIO, "&action=edit>Editar</a></td></tr>\n");
}
tbody.InnerHtml = users;
}
}
else
{
output.Text = MSGNOGRANT;
}
}