partial void Deletetimezones_t(timezones_t instance);
partial void Inserttimezones_t(timezones_t instance);
partial void Updatetimezones_t(timezones_t instance);
public void InsertNewTimeZone(string timeZoneName, TimeSpan startTime, TimeSpan endTime) { var db = new dbDataContext(); lock (db) { Table<timezones_t> timeZonesT = db.GetTable<timezones_t>(); var timezones = new timezones_t { timezone_name = timeZoneName, timezone_start = startTime, timezone_end = endTime }; try { timeZonesT.InsertOnSubmit(timezones); db.SubmitChanges(); // RefreshTable(); } catch (Exception) { MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(5)); } try { var playstations = GetAllTables(); foreach (tables_t t in playstations) { Table<playstation_timezone> timeZoneTable = db.GetTable<playstation_timezone>(); var playstationTimezone = new playstation_timezone { playstation_id = t.playstation_id, timezone_name = timeZoneName, timezone_cost_per_hour = 0 }; timeZoneTable.InsertOnSubmit(playstationTimezone); db.SubmitChanges(); } } catch (Exception) { MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance().GetError(7)); } } }