public void IndexDatabase(bool filePrepared) { AccountingDataSync globalDataSync = ProcessAccountingData(filePrepared, false); using (StoreKeeperDataContext context = new StoreKeeperDataContext()) { SqlParameter userIdParam = new SqlParameter("@UserId", new Guid("F2024637-2251-479A-8ED9-940E4354F37B")); SqlParameter unlockParam = new SqlParameter("@Unlock", SqlDbType.Bit) { Value = 0 }; context.Database.ExecuteSqlCommand("exec LockDatabase @UserId, @Unlock", userIdParam, unlockParam); context.SaveLoadedData(globalDataSync); context.LastUpdate = DateTime.Now; context.ResponsibleUser = "******"; context.SaveChanges(); } }
private bool GetAccountingData(SessionId callerSessionId, bool reloadAll) { try { ISessionManager sessionManager = StoreKeeperServer.Service <ISessionManager>(); // parse data AccountingDataSync globalDataSync = ProcessAccountingData(false, reloadAll); using (StoreKeeperDataContext context = new StoreKeeperDataContext()) { // save to database context.SaveLoadedData(globalDataSync); } return(true); } catch (Exception ex) { Logger.Error(ex); throw new DataSynchronizationError(GetType(), DataSyncErrorType.Runtime, ex.Message); } }