/// <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();
}
