/// <summary> /// Submitting changes to SHarePoint and SQL. /// </summary> /// <param name="spedc">The SharePoint entities.</param> /// <param name="sqledc">The SQL entities.</param> /// <param name="progress">The delegate to inform about the operation progress.</param> public static void SubmitChanges(Microsoft.SharePoint.Linq.DataContext spedc, System.Data.Linq.DataContext sqledc, ProgressChangedEventHandler progress) { progress(null, new ProgressChangedEventArgs(1, "Submitting changes to SQL")); sqledc.SubmitChanges(); progress(null, new ProgressChangedEventArgs(1, "Submitting changes to SharePoint")); spedc.SubmitChanges(); }
protected ServiceResult HandleException(Exception ex, User user) { ServerError error = new ServerError() { ErrorMessage = ex.Message, DateCreated = DateTime.Now, }; if (user != null) { error.UserId = user.UserId; error.UserName = user.UserName; } //HACK The saving of errors needs to be refactored. The reason for the below code is because we need to //create a new context, as the DB one has thrown an exception, therefore we are not able to use it any longer to save. //That's why the error is being saved in the first place i.e. because an exception has been thrown. using (System.Data.Linq.DataContext ctx = new System.Data.Linq.DataContext(LINQOptions.Instance.Settings.ConnectionString)) { ctx.GetTable <ServerError>().InsertOnSubmit(error); ctx.SubmitChanges(); } ServiceException serviceException = ex as ServiceException; if (serviceException == null) { return(new ServiceResult { Code = ServiceResultCode.FatalError, Message = ex.Message }); //Not a user thrown exception. } else { return(serviceException.Result); } }
public void Delete() { if (DataGrid.SelectedItem != null) { if (MessageBox.Show(@"Вы действительно хотите удалить эту запись", "Удаление", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { var Table = DatabaseContext.GetTable(TableType); Table.DeleteOnSubmit(DataGrid.SelectedItem); DatabaseContext.SubmitChanges(); DataGrid.DataContext = Table; } } }
private void RegistruotisMygtukas_Click(object sender, EventArgs e) { User user = new User() { Vardas = NameText.Text, Pavarde = SurnameText.Text, UserName = UserNameText.Text, Password = PassWordName.Text }; string connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\User\Documents\GitHub\C--kursas-20190923\Rezervacijo\Rezervacijo\RezervacijosDB.mdf;Integrated Security=True"; System.Data.Linq.DataContext db = new System.Data.Linq.DataContext(connection); db.GetTable <User>().InsertOnSubmit(user); db.SubmitChanges(); Close(); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { if (DataGrid != null) { if (DataGrid.SelectedItem != null) { if (MessageBox.Show(@"Вы действительно хотите удалить эту запись", "Удаление", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { var Table = DatabaseContext.GetTable(TableType); Table.DeleteOnSubmit(DataGrid.SelectedItem); DatabaseContext.SubmitChanges(); DatabaseContext = new System.Data.Linq.DataContext(ConnectionString); DataGrid.DataContext = DatabaseContext.GetTable(TableType); } } } }
private void Resultatas_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 4) { //Antra klase Vieta vieta = new Vieta(); vieta.firstclass = false; System.Data.Linq.DataContext db = new System.Data.Linq. DataContext(Properties.Resources.ConnectionString); var lektuvas = db.GetTable <Lektuva>().Where(x => x.Id == (int)Resultatas.Rows[e.RowIndex].Cells[0].Value); lektuvas.First().AntrosKlasesVietuSkaicius--; var user = db.GetTable <User>().Where(x => x.Id == UserId); user.First().Vietas.Add(vieta); lektuvas.First().Vietas.Add(vieta); db.GetTable <Vieta>().InsertOnSubmit(vieta); db.SubmitChanges(); MessageBox.Show("Jus sekmingai atlikote rezervacija"); } else if (e.ColumnIndex == 3) { Vieta vieta = new Vieta(); vieta.firstclass = true; System.Data.Linq.DataContext db = new System.Data.Linq. DataContext(Properties.Resources.ConnectionString); var lektuvas = db.GetTable <Lektuva>().Where(x => x.Id == (int)Resultatas.Rows[e.RowIndex].Cells[0].Value); lektuvas.First().PirmosKlasesVietuSkaicius--; var user = db.GetTable <User>().Where(x => x.Id == UserId); user.First().Vietas.Add(vieta); lektuvas.First().Vietas.Add(vieta); db.GetTable <Vieta>().InsertOnSubmit(vieta); db.SubmitChanges(); MessageBox.Show("Jus sekmingai atlikote rezervacija"); } }
void ButtonOk_Click(object sender, RoutedEventArgs e) { try { var Table = DatabaseContext.GetTable(TableType); if (Creating) { Result = Activator.CreateInstance(TableType); } foreach (KeyValuePair <string, PropertyInfo> Pair in Fields) { object Value = GetValue(ValueItems["item" + Pair.Value.Name], Pair.Value.PropertyType); if (Pair.Value.Name == "ID" && Value == null) { Value = ((int)DatabaseContext.ExecuteQuery <int>("select max(ID) from " + TableType.Name + "s").First() + 1).ToString(); } Pair.Value.SetValue(Result, Value, new object[0]); } if (Creating) { Table.InsertOnSubmit(Result); } DatabaseContext.SubmitChanges(); CancelClick = false; Close(); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } }
public virtual void Delete <T>(T obj, System.Data.Linq.DataContext db) where T : class { db.GetTable <T>().DeleteOnSubmit(obj); db.SubmitChanges(); }
public void SaveAll() { _dataContextFactory.SubmitChanges(); }
public void SubmitChanges() { Standard.SubmitChanges(); }