public void ProduceByIdTest()
{
//Arrange
string produceId = string.Empty;
using (IDataContextAsync context = new PrimeActs.Data.Contexts.PAndIContext() as IDataContextAsync)
using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context))
{
IRepositoryAsync <Produce> produceRepository = new Repository <Produce>(context, unitOfWork);
ICache cache = Cache.Get(CacheType.Memory);
IProduceService produceService = new ProduceService(produceRepository, cache);
var produce = CreateProduce();
produceId = produce.ProduceID.ToString();
produceService.Insert(produce);
unitOfWork.SaveChanges();
produceService.RefreshCache();
}
//Act
using (IDataContextAsync context = new PAndIContext())
using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context))
{
IRepositoryAsync <Produce> produceRepository = new Repository <Produce>(context, unitOfWork);
ICache cache = Cache.Get(CacheType.Memory);
IProduceService produceService = new ProduceService(produceRepository, cache);
var produce = produceService.ProduceById(Guid.Parse(produceId));
//Assert
Assert.AreEqual(produce.ProduceID.ToString(), produceId);
}
}
public void DepartmentByIdTest()
{
//Arrange
string departmentId = string.Empty;
using (IDataContextAsync context = new PrimeActs.Data.Contexts.PAndIContext() as IDataContextAsync)
using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context))
{
IRepositoryAsync <Department> departmentRepository = new Repository <Department>(context, unitOfWork);
ICache cache = Cache.Get(CacheType.Memory);
IDepartmentService departmentService = new DepartmentService(departmentRepository, cache);
var department = CreateDepartment();
departmentId = department.DepartmentID.ToString();
departmentService.Insert(department);
unitOfWork.SaveChanges();
departmentService.RefreshCache();
}
//Act
using (IDataContextAsync context = new PAndIContext())
using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context))
{
IRepositoryAsync <Department> departmentRepository = new Repository <Department>(context, unitOfWork);
ICache cache = Cache.Get(CacheType.Memory);
IDepartmentService departmentService = new DepartmentService(departmentRepository, cache);
var department = departmentService.DepartmentById(Guid.Parse(departmentId));
//Assert
Assert.AreEqual(department.DepartmentID.ToString(), departmentId);
}
}
public List <vwConsignmentReturns> GetConsignmentReturns(Guid id)
{
using (var context = new PrimeActs.Data.Contexts.PAndIContext())
{
var sqlqry = "select ConsignmentItemID, ReturnUnitPrice, TotalQuantity from vwConsignmentReturns where ConsignmentItemID = @pID";
//var sqlqry = @"ConsignmentItemID ,ReturnUnitPrice, TotalQuantity FROM vwConsignmentReturns where ConsignmentItemID = @pID";
//var test = context.Database.SqlQuery<vwConsignmentReturns>(sqlqrytest).ToList();
var @pID = new System.Data.SqlClient.SqlParameter("@pID", id);
var recordsReturned = context.Database.SqlQuery <vwConsignmentReturns>(sqlqry, @pID).ToList();
//var recordsReturned = context.Database.SqlQuery<vwConsignmentReturns>(sqlqry, @pID).ToList();
return(recordsReturned);
}
}
public List <vwConsignmentTicketsSingleByDate> GetConsignmentTicketsSingleByDate(Guid id, DateTime ticketDate)
{
var ticketDateString = String.Format("{0:yyyy/MM/dd}", ticketDate);
using (var context = new PrimeActs.Data.Contexts.PAndIContext())
{
var sqlqry = "select ConsignmentItemID, TicketDate, ShowTicketReference, CustomerCode, TicketItemQuantity, TicketItemTotalPrice, UnitPrice from vwConsignmentTicketsSingleByDate where ConsignmentItemID = @pID and TicketDate >= @p1";
//var sqlqry = @"ConsignmentItemID ,ReturnUnitPrice, TotalQuantity FROM vwConsignmentReturns where ConsignmentItemID = @pID";
//var test = context.Database.SqlQuery<vwConsignmentReturns>(sqlqrytest).ToList();
var @pID = new System.Data.SqlClient.SqlParameter("@pID", id);
var @p1 = new System.Data.SqlClient.SqlParameter("@p1", ticketDateString);
var recordsReturned = context.Database.SqlQuery <vwConsignmentTicketsSingleByDate>(sqlqry, @pID, @p1).ToList();
//var recordsReturned = context.Database.SqlQuery<vwConsignmentReturns>(sqlqry, @pID).ToList();
return(recordsReturned);
}
}
public List <vwConsignmentTicketsByDate> GetConsignmentsSoldPriorToday(Guid id, DateTime ticketDate)
{
var ticketDateString = String.Format("{0:yyyy/MM/dd}", ticketDate);
using (var context = new PrimeActs.Data.Contexts.PAndIContext())
{
var sqlqry = @"SELECT [TicketDate]
,[ConsignmentItemID]
,[UnitPrice]
,[TotalPrice]
,[TotalQuantity]
FROM [vwConsignmentTicketsByDate] where ConsignmentItemID = @pID and TicketDate < @p1";
var @pID = new System.Data.SqlClient.SqlParameter("@pID", id);
var @p1 = new System.Data.SqlClient.SqlParameter("@p1", ticketDateString);
var recordsReturned = context.Database.SqlQuery <vwConsignmentTicketsByDate>(sqlqry, @pID, @p1).ToList();
return(recordsReturned);
}
}
public int ConsignmentItemsReceivedQuantity(Guid ConsignmentItemID)
{
//string qry = "select ConsignmentItemID, TotalReceived from vwConsignmentReceived where ConsignmentItemID = @p0";
//var @p0 = ConsignmentItemID;
//var totalReceived =
// _repository.SelectQuery(qry, p0).ToList();
int rtnVal = 0;
using (var context = new PrimeActs.Data.Contexts.PAndIContext())
{
string qry = "select TotalReceived from vwConsignmentReceived where ConsignmentItemID = @p0";
var @p0 = ConsignmentItemID;
var recordsReturned = context.Database.SqlQuery <int>(qry, @p0).FirstOrDefault();
rtnVal = recordsReturned;
}
return(rtnVal);
}
