public string[] Validate(BE_Propiedades.BE_Users user)
{
var bdc = new BDConnection();
string query = "SELECT * From Users WHERE UserName = '******'";
return(bdc.Select(query));
}
public bool Insert(BE_Propiedades.BE_Users user)
{
var bdc = new BDConnection();
string query = "EXEC [InsertUser] @UserN = N'" + user.UserName + "', @Pass = N'" + user.PassWord + "'";
return(bdc.Insert(query));
}
public bool Delete(BE_Propiedades.BE_Users user)
{
var bdc = new BDConnection();
string query = "EXEC [DeleteUser] @User = N'" + user.UserName + "'";
return(bdc.Insert(query));
}
private void button2_Click(object sender, EventArgs e)
{
var BUser = new BE_Propiedades.BE_Users();
var NUser = new BLL_Negocio.N_Users();
BUser.UserName = textBox1.Text;
BUser.PassWord = textBox2.Text;
NUser.Update(BUser);
label3.Text = "User Updated in the database";
}
private void button3_Click(object sender, EventArgs e)
{
var BUser = new BE_Propiedades.BE_Users();
var NUser = new BLL_Negocio.N_Users();
BUser.UserName = textBox1.Text;
NUser.Delete(BUser);
label3.Text = "User Deleted from the database";
}
