public void ExecuteShutdown() { try { string path = ""; bool exists; try { path = @"D:\المطعم"; exists = Directory.Exists(path); if (!exists) { Directory.CreateDirectory(path); } } catch { } try { path = @"E:\المطعم"; exists = Directory.Exists(path); if (!exists) { Directory.CreateDirectory(path); } } catch { path = @"D:\المطعم"; } using (GeneralDBContext db = new GeneralDBContext()) { try { string fileName = path + "\\RestaurantDB " + DateTime.Now.ToShortDateString().Replace('/', '-') + " - " + DateTime.Now.ToLongTimeString().Replace(':', '-'); string dbname = db.Database.Connection.Database; string sqlCommand = @"BACKUP DATABASE [{0}] TO DISK = N'" + fileName + ".bak' WITH NOFORMAT, NOINIT,NAME = N'MyAir-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"; db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname)); } catch { } } System.Windows.Application.Current.Shutdown(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private async void ExecuteBackupAsync() { try { if (BackupModel.Path == null) { return; } using (GeneralDBContext db = new GeneralDBContext()) { try { Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait; string fileName = BackupModel.Path + "\\RestaurantDB " + DateTime.Now.ToShortDateString().Replace('/', '-') + " - " + DateTime.Now.ToLongTimeString().Replace(':', '-'); string dbname = db.Database.Connection.Database; string sqlCommand = @"BACKUP DATABASE [{0}] TO DISK = N'" + fileName + ".bak' WITH NOFORMAT, NOINIT,NAME = N'MyAir-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"; db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, string.Format(sqlCommand, dbname)); BackupModel = new BackupDataModel(); } catch { Mouse.OverrideCursor = null; await currentWindow.HideMetroDialogAsync(backupDialog); await currentWindow.ShowMessageAsync("فشل الحفظ", "يجب إختيار مكان آخر لحفظ النسخة الإحتياطية", MessageDialogStyle.Affirmative, new MetroDialogSettings() { AffirmativeButtonText = "موافق", DialogMessageFontSize = 25, DialogTitleFontSize = 30 }); await currentWindow.ShowMetroDialogAsync(backupDialog); return; } finally { Mouse.OverrideCursor = null; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public SpendingRepository(GeneralDBContext context) : base(context) { }
public CategoryRepository(GeneralDBContext context) : base(context) { }
public BillRepository(GeneralDBContext context) : base(context) { }
public ShiftRepository(GeneralDBContext context) : base(context) { }
public RoleRepository(GeneralDBContext context) : base(context) { }
public ItemRepository(GeneralDBContext context) : base(context) { }
public UnitOfWork(GeneralDBContext context) { _context = context; }
public UserRepository(GeneralDBContext context) : base(context) { }