/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns>A user if found; null if user not found</returns>
public User GetUserByName(String name)
{
DataSet ds = new DataSet();
DataSetTableAdapters.usersTableAdapter adapter = new DataSetTableAdapters.usersTableAdapter();
adapter.Fill(ds.users);
User u = new User();
// find the user
DataSet.usersDataTable table = adapter.GetUserByName(name);
// if a user was found, then fill in the details
if (table.Rows.Count > 0)
{
// use the 1st row's data
DataSet.usersRow row = (DataSet.usersRow)table.Rows[0];
u.Name = row.userName;
u.Password = row.userPassword;
u.Email = row.userEmail;
u.ClientId = row.clientId;
return u;
}
else
{
return null;
}
}
public int DeleteUser(String name)
{
DataSet ds = new DataSet();
DataSetTableAdapters.usersTableAdapter adapter = new DataSetTableAdapters.usersTableAdapter();
return adapter.Delete(name);
}
protected void btnEnviar_Click(object sender, EventArgs e)
{
try
{
DataSetTableAdapters.usersTableAdapter obj = new DataSetTableAdapters.usersTableAdapter();
String userPass = obj.Login(txtUser.Text, txtPass.Text);
if (userPass != null)
{
Session["usuario"] = userPass;
Response.Redirect("verificar.aspx");
}
else
{
l1.Text = "usuario o contraseña incorrecta" +
" " + "Nota: Si es nuevo usuario en el sistema comunicarse con el administrador";
}
}
catch {
l1.Text = "usuario o contraseña incorrecta" + "adios";
}
}
public List<User> GetUsers()
{
List<User> users = new List<User>();
DataSet ds = new DataSet();
DataSetTableAdapters.usersTableAdapter adapter = new DataSetTableAdapters.usersTableAdapter();
adapter.Fill(ds.users);
DataSet.usersDataTable table = adapter.GetUserData();
// load all users into the list
foreach (DataSet.usersRow row in table.Rows)
{
// create memory for new user & fill in properties
User u = new User();
u.Name = row.userName;
u.Password = row.userPassword;
u.Email = row.userEmail;
u.ClientId = row.clientId;
// add this user to the list
users.Add(u);
}
// returns the list w/ 0 or more Users
return users;
}
public int UpdateUser(String name, String password, String email, int clientId)
{
DataSet ds = new DataSet();
DataSetTableAdapters.usersTableAdapter adapter = new DataSetTableAdapters.usersTableAdapter();
return adapter.Update(name, password, email, clientId, name);
}
