public void Delete(long id)
{
Book r = Get(id);
DbStore.Delete <Book>(r);
bookdetails.Remove(r);
}
public Role Update(Role t)
{
if (!IsDuplicate(t))
{
if (t.Id <= 0)
{
throw new ArgumentException("Invalid Role Id");
}
Role f = Get(t.Id);
if (f == null)
{
throw new ArgumentNullException($"Role with id {t.Id} does not exist or its deleted");
}
f.Name = t.Name;
f = DbStore.Save <Role>(f);
if (f != null)
{
roles.Remove(t);
roles.Add(f);
}
return(f);
}
else
{
throw new DuplicateItemException("Role already exists");
}
}
public LibraryLog Update(LibraryLog t)
{
LibraryLog f = Get(t.Id);
if (f == null)
{
throw new ArgumentNullException($"Log Details with id {t.Id} does not exist or its deleted");
}
libraryLogs.Remove(t);
if (t.Id <= 0)
{
throw new ArgumentException("Invalid Log Details Item Id");
}
f.BookNo = t.BookNo;
f.BookName = t.BookName;
f.MemberName = t.MemberName;
f.MobileNo = t.MobileNo;
f.Address = t.Address;
f.CheckedOutDate = t.CheckedOutDate;
f.ReturnedDate = t.ReturnedDate;
f = DbStore.Save <LibraryLog>(f);
return(f);
}
public Book Update(Book t)
{
string cName = t.CategoryId.CategoryName;
if (t.Id <= 0)
{
throw new ArgumentException("Invalid Book Item Id");
}
Book f = Get(t.Id);
if (f == null)
{
throw new ArgumentNullException($"Book Item with id {t.Id} does not exist or its deleted");
}
f.BookNo = t.BookNo;
f.BookName = t.BookName;
f.AuthorName = t.AuthorName;
f.CategoryId = t.CategoryId;
f = DbStore.Save <Book>(f);
return(f);
}
public void Delete(long id)
{
Member r = Get(id);
DbStore.Delete <Member>(r);
member.Remove(r);
}
public PettyCash Update(PettyCash t)
{
if (t.Id <= 0)
{
throw new ArgumentException("Invalid PettyCash Id");
}
PettyCash f = Get(t.Id);
if (f == null)
{
throw new ArgumentNullException($"PettyCash with id {t.Id} does not exist or its deleted");
}
f.PaidTo = t.PaidTo;
f.Description = t.Description;
f.Amount = t.Amount;
f.PaymentMode = t.PaymentMode;
f.TransactionId = t.TransactionId;
f.ReceivedDate = t.ReceivedDate;
f.EntryBy = t.EntryBy;
f.Status = t.Status;
f.AttachedFiles = t.AttachedFiles;
f = DbStore.Save <PettyCash>(f);
return(f);
}
public BookCategory Update(BookCategory t)
{
BookCategory f = Get(t.Id);
if (f == null)
{
throw new ArgumentNullException($"BookCategory Item with id {t.Id} does not exist or its deleted");
}
bookCategory.Remove(t);
if (!IsDuplicate(t))
{
if (t.Id <= 0)
{
throw new ArgumentException("Invalid BookCategory Item Id");
}
f.CategoryName = t.CategoryName;
f.Quantity = t.Quantity;
f = DbStore.Save <BookCategory>(f);
return(f);
}
else
{
bookCategory.Add(f);
throw new DuplicateItemException("BookCategory Item already exists");
}
}
public void Delete(long id)
{
Role r = Get(id);
DbStore.Delete <Role>(r);
roles.Remove(r);
}
public void Delete(long id)
{
PettyCash r = Get(id);
DbStore.Delete <PettyCash>(r);
pettycashes.Remove(r);
}
private static async Task Run(WaitHandle done, CancellationToken cancellationToken)
{
// Run
var tasks = new List <Task>();
using (var host = CreateWebHost())
{
Metrics.Instance = host.Services.GetRequiredService <IMetrics>();
// Dependencies
var connectionStringBuilder = new SqlConnectionStringBuilder(
"Server=(local);Initial Catalog=EventStore;Integrated Security=SSPI;Connection Timeout=60;");
var connectionProvider = new ConnectionProvider(connectionStringBuilder);
var dbStore = new DbStore(connectionProvider);
// Init
await dbStore.PrepareDatabaseAsync(cancellationToken);
await dbStore.ClearEventsAsync(cancellationToken);
foreach (var appConfig in CreateApplications())
{
var app = new Application(dbStore, appConfig);
Task.Run(() => app.Start(cancellationToken));
}
tasks.Add(host.StartAsync(cancellationToken));
done.WaitOne();
}
await Task.WhenAll(tasks);
}
public void Delete(long id)
{
MemberType r = Get(id);
DbStore.Delete <MemberType>(r);
memberType.Remove(r);
}
public void Delete(long id)
{
Branch r = Get(id);
DbStore.Delete <Branch>(r);
branches.Remove(r);
}
public ConfigDbContext(IOptions <ConfigDbSettings> options)
{
var configDbSettings = options.Value;
ArangoDatabase.ChangeSetting(s =>
{
s.Database = configDbSettings.DbName;
s.Url = configDbSettings.Url;
s.Credential = new NetworkCredential(configDbSettings.UserName, configDbSettings.Password);
s.SystemDatabaseCredential = new NetworkCredential(configDbSettings.UserName, configDbSettings.Password);
});
using (var db = ArangoDatabase.CreateWithSetting())
{
Versions = db.Document <DbVersions>(configDbSettings.BaseVersion);
AppDefaults = db.Document <DbAppDefaults>(Versions.AppDefaults);
UserDefaults = db.Document <DbUserDefaults>(Versions.UserDefaults);
Cakes = db.Document <DbCakes>(Versions.Cakes);
Avatars = db.Document <DbAvatars>(Versions.Avatars);
Buildings = db.Document <DbBuildings>(Versions.Buildings);
Store = db.Document <DbStore>(Versions.Store);
}
}
public void Delete(long id)
{
LibraryLog r = Get(id);
DbStore.Delete <LibraryLog>(r);
libraryLogs.Remove(r);
}
public void Delete(long id)
{
BookCategory r = Get(id);
DbStore.Delete <BookCategory>(r);
bookCategory.Remove(r);
}
public List <User> Get()
{
List <User> userlist = null;
var expression = PredicateBuilder.Create <User>(d => d.DeletedDate == null);
userlist = DbStore.ExecuteeExpressionList <User>(expression);
return(userlist);
}
public TokenManager(DbStore database)
{
dbTokenList = database.GetCollection <DbApiToken>(ApiTokenTable);
dbTokenList.EnsureIndex(x => x.UserUid, true);
dbTokenList.EnsureIndex(x => x.Token, true);
database.GetMetaData(ApiTokenTable);
}
public List <Member> GetMember()
{
if (member == null)
{
var expression = PredicateBuilder.Create <Member>(d => d.DeletedDate == null);
member = DbStore.ExecuteeExpressionList <Member>(expression);
}
return(member);
}
public List <PettyCash> GetPettyCash()
{
if (pettycashes == null)
{
var expression = PredicateBuilder.Create <PettyCash>(d => d.DeletedDate == null);
pettycashes = DbStore.ExecuteeExpressionList <PettyCash>(expression);
}
return(pettycashes);
}
public List <Book> GetBookDetails()
{
if (bookdetails == null)
{
var expression = PredicateBuilder.Create <Book>(d => d.DeletedDate == null);
bookdetails = DbStore.ExecuteeExpressionList <Book>(expression);
}
return(bookdetails);
}
public HistoryManager(ConfHistory config, DbStore database)
{
Formatter = new SmartHistoryFormatter();
this.config = config;
this.database = database;
Initialize();
}
public List <LibraryLog> GetLibraryLog()
{
if (libraryLogs == null)
{
var expression = PredicateBuilder.Create <LibraryLog>(d => d.DeletedDate == null);
libraryLogs = DbStore.ExecuteeExpressionList <LibraryLog>(expression);
}
libraryLogs.Distinct();
return(libraryLogs);
}
public Stats(ConfRoot conf, DbStore database, BotManager botManager)
{
this.conf = conf;
this.database = database;
this.botManager = botManager;
uploadParamEnabled = true;
runtimeLastTrack = Tools.Now;
ReadAndUpgradeStats();
}
public List <BookCategory> GetBookCategory()
{
if (bookCategory == null)
{
var expression = PredicateBuilder.Create <BookCategory>(d => d.DeletedDate == null);
bookCategory = DbStore.ExecuteeExpressionList <BookCategory>(expression);
}
bookCategory.Distinct();
return(bookCategory);
}
public List <Branch> GetBranches()
{
if (branches == null)
{
var expression = PredicateBuilder.Create <Branch>(d => d.DeletedDate == null);
branches = DbStore.ExecuteeExpressionList <Branch>(expression);
}
branches.Sort();
return(branches);
}
public List <Role> GetRoles()
{
if (roles == null)
{
var expression = PredicateBuilder.Create <Role>(d => d.DeletedDate == null);
roles = DbStore.ExecuteeExpressionList <Role>(expression);
}
roles.Sort();
return(roles);
}
public User Get(long id)
{
User user = null;
if (user == null)
{
var expression = PredicateBuilder.Create <User>(d => d.Id == id && d.DeletedDate == null);
user = DbStore.ExecuteExpressionFirst <User>(expression);
}
return(user);
}
public SessionManager(DbStore database)
{
Util.Init(ref openSessions);
Util.Init(ref liveTokenList);
dbTokenList = database.GetCollection <DbApiToken>(ApiTokenTable);
dbTokenList.EnsureIndex(x => x.UserUid, true);
dbTokenList.EnsureIndex(x => x.Token, true);
database.GetMetaData(ApiTokenTable);
}
private static void DbStoreOptions(DbStore dbStore)
{
dbStore.DbName = "theatreTicketsDb";
dbStore.Version = 1;
dbStore.Stores.Add(TheaterSchema);
dbStore.Stores.Add(HallSchema);
dbStore.Stores.Add(PlaySchema);
dbStore.Stores.Add(PlayDateTimeSchema);
dbStore.Stores.Add(TicketSchema);
dbStore.Stores.Add(UserSchema);
}
public void Build()
{
Store = new DbStore();
if (!ConfigCheck())
{
return;
}
//,default, ConsoleColor.Blue;
//IO?.Write("Enter Source Directory>");
//
if (!Directory.Exists(Config.DataPath))
{
IO?.Write("Directory Not Exist!", OutputType.Error);
return;
}
var numbRgx = new Regex("[0-9]");
var di = new DirectoryInfo(Config.DataPath);
foreach (var actorShell in di.GetDirectories())
{
foreach (var actorDir in actorShell.GetDirectories())
{
var actorInfo = actorDir.Name.Split('-');
var actorName = actorInfo[1];
var actor = new DbStore.SrcActor
{
Index = 26 * (actorInfo[0][0] - 'A') + actorInfo[0][1] - 'A',
Name = actorName,
Stared = (actorInfo.Length == 3)
};
Store.Actors.Add(actor);
var itemIndex = 0;
foreach (var item in actorDir.GetFiles())
{
var itemInfoArr = SplitFn(item);
if (itemInfoArr.Length < 4)
{
IO?.WriteLine($"FORMAT ERROR:{itemInfoArr[0]}");
continue;
}
var itemInfo = new DbStore.SrcItem
{
Path = item.FullName,
Name = itemInfoArr.Length > 4 && numbRgx.IsMatch(itemInfoArr[4])
? $"{itemInfoArr[2].ToUpper()}-{itemInfoArr[3].ToUpper()}-{itemInfoArr[4]}"
: $"{itemInfoArr[2].ToUpper()}-{itemInfoArr[3].ToUpper()}"
};
if (itemInfoArr.Length > 4)
{
foreach (var label in itemInfoArr[4..])
