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