private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { using (var context = new AlojamentoDbEntities3()) { Customer queryCustomer = context.Customers .Where(s => s.nome == user) .FirstOrDefault <Customer>(); Reserva queryReser = context.Reservas .Where(s => s.id == queryCustomer.id) .FirstOrDefault <Reserva>(); Reserva reserva = new Reserva() { idAlojamento = queryReser.idAlojamento, dateReserva = queryReser.dateReserva, dateCheckIn = queryReser.dateCheckIn, dateCheckOut = queryReser.dateCheckOut, custo = queryReser.custo, idCustomer = queryCustomer.id }; dataGridView1.DataSource = reserva; context.Reservas.Attach(reserva); //context.SaveChanges(); Close(); } }
private void butonConfirmarReserva_Click(object sender, EventArgs e) { string bnum = textBoxNumBungalow.Text; if (bnum != "") { using (var context = new AlojamentoDbEntities3()) { Alojamento queryAloj = context.Alojamentoes .Where(s => s.num == textBoxNumBungalow.Text) .FirstOrDefault <Alojamento>(); Customer queryCustomer = context.Customers .Where(s => s.id == queryAloj.id) // valor estático tem de se alterar!!!! .FirstOrDefault <Customer>(); Reserva reserva = new Reserva() { idAlojamento = queryAloj.id, dateReserva = DateTime.Now, dateCheckIn = dateTimePicker1.Value, dateCheckOut = dateTimePicker2.Value, custo = queryAloj.custoNoite, idCustomer = queryCustomer.id }; context.Reservas.Add(reserva); context.SaveChanges(); Close(); } } else { MessageBox.Show("dados Invalidos"); } }
/// <summary> /// Botão de login /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void loginBtn_Click(object sender, EventArgs e) { string userName = textBoxUserNameLogin.Text; //byte passWord = Convert.ToByte( texboxPassWordLogin.Text); byte[] password = Encoding.ASCII.GetBytes(texboxPassWordLogin.Text); if (userName != "") { using (var context = new AlojamentoDbEntities3()) { User queryUser = context.Users .Where(s => s.userName == textBoxUserNameLogin.Text) .FirstOrDefault <User>(); User queryPassWord = context.Users .Where(s => s.passWord == password) //texboxPassWordLogin.Text convertida para byte) .FirstOrDefault <User>(); Close(); //string userName = "******"; //string passWord = "******"; Form1 menu1 = new Form1(); //if ((userName == queryUser.userName) && (password == queryPassWord.passWord)) //{ this.Close(); //Uso de Thread para fechar o form anterior e abrir um novo th = new Thread(OpenForm2); th.SetApartmentState(ApartmentState.STA); th.Start(); //} //else // { // MessageBox.Show("Login Invalido"); // } } } else { MessageBox.Show("preencha login"); } MinhasReservas user = new MinhasReservas(userName); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { using (var context = new AlojamentoDbEntities3()) { Customer queryCustomer = context.Customers .Where(s => s.id == 1) // valor estático tem de se alterar!!!! .FirstOrDefault <Customer>(); Customer customer = new Customer() { nome = queryCustomer.nome, sobreNome = queryCustomer.sobreNome, address = queryCustomer.address, phone = queryCustomer.phone, email = queryCustomer.email, }; //Reserva //context.Reserva.Add(Customer); //context.SaveChanges(); Close(); } }
public static string Registar(string userName, string passWord, string nome, string sobreNome, string address, string phone, string email) { //ConnectDb connect = new ConnectDb(); //SqlCommand cmd = new SqlCommand(); //SqlCommand cmd1 = new SqlCommand(); //SqlCommand cmd2 = new SqlCommand(); //string mensagem; //int customerId = 0; ////comandos sql - insert, update, delete //cmd.CommandText = "insert into customer (nome, sobreNome, address, phone, email) values(@nome, @sobreNome, @address, @phone, @email)"; //cmd2.CommandText = "select id from customer where email = @email"; //cmd1.CommandText = "insert into Users (username, passWord) values(@userName, @passWord)"; ////parametros Customer //cmd.Parameters.AddWithValue("@nome", nome); //cmd.Parameters.AddWithValue("@sobreNome", sobreNome); //cmd.Parameters.AddWithValue("@address", address); //cmd.Parameters.AddWithValue("@phone", phone); //cmd.Parameters.AddWithValue("@email", email); //cmd2.Parameters.AddWithValue("@email", email);//add do select id from customer usando o email ////parametros Users //cmd1.Parameters.AddWithValue("@userName", userName); //cmd1.Parameters.AddWithValue("@passWord", passWord); ////connectar com a db - classe connect //cmd.Connection = connect.Connect(); //cmd2.Connection = connect.Connect(); //cmd1.Connection = connect.Connect(); //try //{ // //cmd.Connection = connect.Connect(); // //cmd2.Connection = connect.Connect(); // //cmd1.Connection = connect.Connect(); // //executar // cmd.ExecuteNonQuery(); // using (SqlDataReader reader = cmd1.ExecuteReader()) // { // if (reader.Read()) // { // customerId = reader.GetInt32(0); // } // } // cmd1.ExecuteNonQueryAsync(); // //Desconectar db // connect.Disconnect(); // //mostrar msg de erro ou sucesso // mensagem = "Registo ok"; //} //catch (SqlException e) //{ // Console.WriteLine(e); // mensagem = e.ToString(); //} using (AlojamentoDbEntities3 db = new AlojamentoDbEntities3()) { using (var context = new AlojamentoDbEntities3()) { //Customer queryCustomer = context.Customer // .Where(s => s.nome == user) // .FirstOrDefault<Customer>(); Cliente customer = new Cliente(userName, passWord, nome, sobreNome, address, phone, email); byte[] pass = Encoding.ASCII.GetBytes(passWord); Customer newcustomer = new Customer() { nome = customer.Nome, sobreNome = customer.Sobrenome, address = customer.Address, phone = customer.Phone, email = customer.Email }; context.Customers.Add(newcustomer); context.SaveChanges(); User user = new User() { userName = customer.Username, passWord = pass, idCustomer = newcustomer.id, idStaff = null }; context.Users.Add(user); context.SaveChanges(); } } return(userName); }