public void GetAllActors()
{
var query = new ActorQuery(_runner);
var result = query.GetAll();
Assert.Equal(result.Count(), 203);
}
public void GetActorByIdWithDynamic()
{
var query = new ActorQuery(_runner);
var result = query.GetOneDynamic(2);
Assert.Equal(result != null, true);
Assert.Equal(result.FirstName, "Nick");
}
public void GetActorById()
{
var query = new ActorQuery(_runner);
var result = query.GetById(12);
Assert.Equal(result != null, true);
Assert.Equal(result.FirstName == "Karl" && result.LastName == "Berry", true);
}
public async Task <IActionResult> Get()
{
await Db.Connection.OpenAsync();
var query = new ActorQuery(Db);
var result = await query.getActors();
return(new OkObjectResult(result));
}
/// <summary>
/// Пушит задачу
/// </summary>
/// <param name="queryHandle">номер хэндлера</param>
/// <param name="query">задача без параметра и без возвращаемого значения</param>
/// <param name="isSync">синронно/асинронно</param>
/// <param name="executeTime">время когда нужно выполнить задачу (в тиках) DateTime.Now.AddSecond(60).Ticks</param>
public void PushQuery(int queryHandle, ActorQuery query, bool isSync = false, long executeTime = -1)
{
if (!IsWorking)
{
throw new WorkerDisposed();
}
delegateQuery(makeQuery(queryHandle, query, isSync, executeTime, null));
}
public PagedResponse <ActorDto> Execute(ActorQuery request)
{
var query = Context.Actors
.Include(ma => ma.MovieActors)
.ThenInclude(m => m.Movie)
.AsQueryable();
query = query.Where(a => a.IsDeleted == false);
if (request.FirstName != null)
{
query = query.Where(a => a.FirstName.ToLower().Contains(request.FirstName.ToLower()));
}
if (request.LastName != null)
{
query = query.Where(a => a.LastName.ToLower().Contains(request.LastName.ToLower()));
}
if (request.MovieId > 0)
{
query = query.Where(a => a.MovieActors.Any(x => x.MovieId == request.MovieId));
}
if (request.MovieName != null)
{
query = query.Where(a => a.MovieActors.Any(x => x.Movie.Title.ToLower().Contains(request.MovieName.ToLower())));
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
return(new PagedResponse <ActorDto>
{
CurrentPage = request.PageNumber,
PagesCount = pagesCount,
TotalCount = totalCount,
Data = query.Select(a => new ActorDto
{
Id = a.Id,
FirstName = a.FirstName,
LastName = a.LastName,
Link = a.Link
})
});
}
public IActionResult Get([FromQuery] ActorQuery query)
{
try
{
return(Ok(getActors.Execute(query)));
}
catch (Exception e)
{
return(StatusCode(500, new
{
Errors = new List <string> {
e.Message
}
}));
}
}
// GET: Actors
public ActionResult Index([FromQuery] ActorQuery query)
{
try
{
return(View(executor.ExecuteQuery(getActors, query)));
}
catch (EntityNotAllowedException)
{
return(RedirectToAction("PageNotFound", "Redirections"));
}
catch (Exception e)
{
TempData["error"] = e.Message;
}
return(RedirectToAction("Home", "Index"));
}
static void Main(string[] args)
{
var db = new CommandRunner("dvds");
var q = new RegisterCommand(db);
q.Email = "*****@*****.**";
q.Password = "******";
q.Confirmation = "password";
q.First = "Nick";
q.Last = "Shoup";
var result = q.Execute();
Console.WriteLine(result.Message, result.NewUserId, result.Status);
var qAuth = new AuthenticateCommand(db);
qAuth.ProviderKey = "*****@*****.**";
qAuth.ProviderValue = "password";
var authResult = qAuth.Execute();
Console.WriteLine(authResult.Message, authResult.UserID);
var query = new RawSalesByDate(db);
query.Year = 2007;
var sales = query.Execute();
foreach (var sale in sales)
{
//Console.WriteLine(sale.Title);
}
var films = db.Execute <Film>("select * from film");
foreach (var film in films)
{
// Console.WriteLine(film.Title);
}
var filmsDynamic = db.ExecuteDynamic("select * from film");
foreach (var film in filmsDynamic)
{
// Console.WriteLine(film.title);
}
//var cmd = db.BuildCommand("insert into actor(first_name, last_name, last_update) values (@0, @1, @2)", "Nick", "Shoup", DateTime.Now);
//var resulsts = db.Transact(cmd);
//foreach (var result in resulsts)
//{
// Console.WriteLine(result);
//}
var actorQuery = new ActorQuery(db);
actorQuery.ActorId = 3;
var actors = actorQuery.Execute();
Console.WriteLine(actors.Fullname);
foreach (var film in actors.Films)
{
// Console.WriteLine(film.Title) ;
}
var actor1 = new Actor()
{
First = "Woody", Last = "Harrelson"
};
var actor2 = new Actor()
{
First = "Joe", Last = "Biff"
};
var actor3 = new Actor()
{
First = "Jolene", Last = "Silidkdk"
};
var qCommand = new Commands.Actors.AddBatchOfActors(db);
qCommand.Actors = new Actor[] { actor1, actor2, actor3 };
qCommand.Execute();
Console.Read();
}
public ActorController(ActorQuery query, ActorCommand command)
{
_query = query;
_command = command;
}
public Queries()
{
_runner = new Runner("server=localhost;user id=Hussein;database=dvdrental;password=123456;");
_query = new ActorQuery(_runner);
}
