//REGISTER NEW CLIENT private void RegisterUser_Click(object sender, RoutedEventArgs e) { string firstName = userName.Text + " " + userLastname.Text; CLIENT client = new CLIENT(firstName, newUserMail.Text, newUserPassword.Password); XmlSerializer formatter = new XmlSerializer(typeof(CLIENT)); string xml = null; try { using (FileStream fs = new FileStream("../../../../xml/CLIENT/newClient.xml", FileMode.Truncate)) { formatter.Serialize(fs, client); } using (FileStream fs = new FileStream("../../../../xml/CLIENT/newClient.xml", FileMode.OpenOrCreate)) { StreamReader reader = new StreamReader(fs); xml = reader.ReadToEnd(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } using (ClientContext db = new ClientContext()) { try { var param = new SqlParameter { ParameterName = "@request", SqlDbType = System.Data.SqlDbType.Xml, Direction = System.Data.ParameterDirection.Input, Value = xml }; var result = db.Database.ExecuteSqlCommand("RegisterUser @request", param); if (result == 1) { ReservationWindow window = new ReservationWindow(client); window.Show(); this.Close(); } } catch { MessageBox.Show("Procedure RegisterUser @request connot be executed"); } } }
private void Confirm_Click(object sender, RoutedEventArgs e) { int ClientId = 0; try { using (HotelContext db = new HotelContext()) { string sqlQuery = "SELECT dbo.GetUserId ( {0} )"; Object[] param = { mail }; try { ClientId = db.Database.SqlQuery <int>(sqlQuery, param).FirstOrDefault(); } catch { MessageBox.Show("Function dbo.GetUserId cannot be executed"); } } using (ClientContext db = new ClientContext()) { var param1 = new SqlParameter { ParameterName = "@room_number", SqlDbType = System.Data.SqlDbType.SmallInt, Direction = System.Data.ParameterDirection.Input, Value = number }; var param2 = new SqlParameter { ParameterName = "@client_id", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = ClientId }; var param3 = new SqlParameter { ParameterName = "@come", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = CommingDate.SelectedDate }; var param4 = new SqlParameter { ParameterName = "@leave", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = LeavingDate.SelectedDate }; try { var result = db.Database.ExecuteSqlCommand("BookRoom_sp @room_number, @client_id, @come, @leave", param1, param2, param3, param4); } catch { MessageBox.Show("Procedure BookRoom_sp @room_number, @client_id, @come, @leave connot be executed"); } ReservationWindow window = new ReservationWindow(client); window.Show(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Login_Click(object sender, RoutedEventArgs e) { string firstName = "UserX"; string mail = userMail.Text; string password = userPassword.Password; CLIENT client = new CLIENT(firstName, mail, password); XmlSerializer formatter = new XmlSerializer(typeof(CLIENT)); string xml; try { using (FileStream fs = new FileStream("../../../../xml/CLIENT/Client.xml", FileMode.Truncate)) { formatter.Serialize(fs, client); } using (FileStream fs = new FileStream("../../../../xml/CLIENT/Client.xml", FileMode.Open)) { StreamReader reader = new StreamReader(fs); xml = reader.ReadToEnd(); } using (ClientContext db = new ClientContext()) { var param = new SqlParameter { ParameterName = "@request", SqlDbType = System.Data.SqlDbType.Xml, Direction = System.Data.ParameterDirection.Input, Value = xml }; var result = new SqlParameter { ParameterName = "@r", SqlDbType = System.Data.SqlDbType.Bit, Direction = System.Data.ParameterDirection.Output, }; try { db.Database.ExecuteSqlCommand("Login_sp @request, @r out", param, result); if ((bool)result.Value == true) { ReservationWindow window = new ReservationWindow(client); window.Show(); this.Close(); } } catch { MessageBox.Show("Procedure Login_sp @request, @r out connot be executed"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }