private static void Transaction()
{
LinqTdsDataContext dt = new LinqTdsDataContext(ConnString);
try
{
int sender = SelectUser("Please select message sender");
int chatid = SelectChat("Please select chat to send message");
string message = Core.GetInput("Message");
db.GetTable <messages>().InsertOnSubmit(new messages()
{
sender = sender, chatId = chatid, message = message
});
db.GetTable <messages>().InsertOnSubmit(new messages()
{
sender = sender, chatId = chatid, message = message + " _additional"
});
db.SubmitChanges(ConflictMode.ContinueOnConflict);
MenuManager.Menu(new string[] { "Go back" }, "Transaction successful!");
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
Console.WriteLine("Conflict");
Console.ReadKey(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
foreach (ObjectChangeConflict item in db.ChangeConflicts)
{
item.Resolve(RefreshMode.KeepCurrentValues);
}
}
}
public static void Init()
{
//SelectUser("test");
// cmd = new SqlCommand("SELECT * FROM accounts", connection);
// adapter = new SqlDataAdapter(cmd);
// connection.Open();
// adapter.Fill(ds, "accounts");
// cmd = new SqlCommand("SELECT * FROM Keys", connection);
// adapter = new SqlDataAdapter(cmd);
// adapter.Fill(ds, "Keys");
// connection.Close();
// Console.WriteLine("DataSet initialised!\r\nPress any key to continue. . .");
// Console.ReadKey(true);
LinqTdsDataContext context = new LinqTdsDataContext();
//IEnumerable<accounts> accs = new
/*var result = from accounts in ds.Tables["accounts"].AsEnumerable()
* select accounts;*/
/*var result = from accounts in db.GetTable<accounts>()
* select accounts;*/
Menu();
}
