private void button1_Click(object sender, RoutedEventArgs e) { if (passwordBox2.Password == "" || passwordBox1.Password == "") { MessageBox.Show("password must not be null ! "); return; } if (this.passwordBox1.Password != this.passwordBox2.Password ) { MessageBox.Show("both passwords must be identical! "); return; } slAmidaConsole.Web.EQ_DomainContext db = new slAmidaConsole.Web.EQ_DomainContext(); EntityQuery<slAmidaConsole.Web.tblUser> qry = db.GetTblUserQuery().Where(n => n.UserID == ((slDBManager.App)App.Current).UserID); LoadOperation < slAmidaConsole.Web.tblUser > lo = db.Load <slAmidaConsole.Web.tblUser > (qry); lo.Completed += (s, a) => { if (lo.Error != null) { MessageBox.Show(lo.Error.Message); return; } slAmidaConsole.Web.tblUser userinfo = lo.Entities.FirstOrDefault(); userinfo.Password = passwordBox1.Password; db.SubmitChanges(); this.Dispatcher.BeginInvoke(()=> passwordBox1.Password = passwordBox2.Password = "" ); MessageBox.Show("change password ok!"); }; }
private void LayoutRoot_Loaded(object sender, RoutedEventArgs e) { context = new slAmidaConsole.Web.EQ_DomainContext(); EntityQuery<slAmidaConsole.Web.tblEQ> q = from n in context.GetTblEQQuery() orderby n.eqi_id select n; LoadOperation<slAmidaConsole.Web.tblEQ> lo = context.Load<slAmidaConsole.Web.tblEQ>(q); lo.Completed += (s, a) => { Items = new System.Collections.ObjectModel.ObservableCollection<slAmidaConsole.Web.tblEQ>(lo.Entities); // lstEq.ItemsSource = Items; Filter(); }; }