public static async Task <string> GetInfoCommandAsync(Command command)
{
try
{
using (InfoCommandContext db = new InfoCommandContext())
{
var result = await db.InfoCommandTable.AsQueryable().Where(x =>
x.CommandName.ToLower() == command.CommandName.ToLower())
.FirstOrDefaultAsync();
if (result != null)
{
return(result.CommandContent);
}
else
{
return(string.Empty);
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ErrMessages.StorageException, ex);
throw;
}
}
public static async Task <bool> DeleteInfoCommandAsync(string name)
{
try
{
using (InfoCommandContext db = new InfoCommandContext())
{
var cmd = await db.InfoCommandTable.AsQueryable().Where(x => x.CommandName.ToLower() == name).FirstOrDefaultAsync();
if (cmd != null)
{
db.InfoCommandTable.Remove(cmd);
await db.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException($"{typeof(StorageManager).GetType().FullName}: {ExceptionManager.GetAsyncMethodName()}", ex);
throw;
}
}
public static List <string> GetInfoCommands()
{
List <string> result = new List <string>();
try
{
using (InfoCommandContext db = new InfoCommandContext())
{
foreach (var element in db.InfoCommandTable)
{
result.Add(element.CommandName);
}
return(result);
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ErrMessages.StorageException, ex);
throw;
}
}
public static async Task <bool> StoreInfoCommandAsync(Command command)
{
try
{
using (InfoCommandContext db = new InfoCommandContext())
{
var cmd = await db.InfoCommandTable.AsQueryable().FirstOrDefaultAsync(x => x.CommandName.ToLower() == command.CommandName.ToLower());
if (cmd == null)
{
await db.InfoCommandTable.AddAsync(new InfoCommandTable
{
CommandName = command.CommandName,
CommandContent = command.CommandContent
});
await db.SaveChangesAsync();
return(false);
}
else
{
cmd = new InfoCommandTable
{
CommandName = command.CommandName,
CommandContent = command.CommandContent
};
await db.SaveChangesAsync();
return(true);
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ErrMessages.StorageException, ex);
throw;
}
}