Example #1
0
        private bool IsvalidUser(string userName, string password)

        {
            BD.ProyectoDataClassesDataContext context = new ProyectoDataClassesDataContext();

            var q = from p in context.TBusers

                    where p.Usuario == textBox1.Text

                    && p.Pass == textBox2.Text

                    select p;



            if (q.Any())
            {
                return(true);
            }

            else

            {
                return(false);
            }
        }
Example #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            BD.ProyectoDataClassesDataContext busers = new ProyectoDataClassesDataContext();

            var count    = from rango in busers.TBusers select rango;
            var cantidad = count.Count();

            int i = cantidad;

            i = i + 1;
            try
            {
                busers.Insertar_User("TEMP" + i.ToString(), textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, Convert.ToInt32(textBox5.Text), textBox6.Text, 1, "JUBN3", 2);
                MessageBox.Show("Se ha aƱadido un invitado", "InformaciĆ³n");
                textBox1.Text = "";
                textBox2.Text = "";
                textBox3.Text = "";
                textBox4.Text = "";
                textBox5.Text = "";
                textBox6.Text = "";

                textBox1.Focus();
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
        }