public HttpResponseMessage GenerateInvoice(object data_)
{
try
{
PurchaseRepository purchaseRepository = new PurchaseRepository();
Purchases purchase = new Purchases();
string invoice_ = string.Empty;
if (data_ != null)
{
string content = data_.ToString();
JObject json = JObject.Parse(content);
purchase.storeId = Convert.ToInt32(JsonConvert.DeserializeObject <int>(json.GetValue("storeId").ToString()));
purchase.purchaseDetails = content;
purchase.purchaseDate = DateTime.Today;
//invoice = purchaseRepository.SavePurchaseDetails(purchase, json);
invoice_ = JsonConvert.SerializeObject(purchaseRepository.SavePurchaseDetails(purchase, json));
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, invoice_);
return(response);
}
catch (Exception ex)
{
throw (ex);
}
}
public DataManager()
{
cont = new ModelContainer();
branchRepository = new BranchRepository(cont);
categoryRepository = new CategoryRepository(cont);
checkDishRepository = new CheckDishRepository(cont);
checkMerchandiseRepository = new CheckMerchandiseRepository(cont);
clientRepository = new ClientRepository(cont);
companyOwnerRepository = new CompanyOwnerRepository(cont);
companyRepository = new CompanyRepository(cont);
contactPersonRepository = new ContactPersonRepository(cont);
dishRepository = new DishRepository(cont);
documentRepository = new DocumentRepository(cont);
ejectionRepository = new EjectionRepository(cont);
employeeRepository = new EmployeeRepository(cont);
encashmentRepository = new EncashmentRepository(cont);
landlordRepository = new LandlordRepository(cont);
orderRepository = new OrderRepository(cont);
personRepository = new PersonRepository(cont);
positionRepository = new PositionRepository(cont);
prepackRepository = new PrepackRepository(cont);
productRepository = new ProductRepository(cont);
purchaseRepository = new PurchaseRepository(cont);
recipeDishIngrRepository = new RecipeDishIngrRepository(cont);
recipeDishPrepRepository = new RecipeDishPrepRepository(cont);
recipePrepIngrRepository = new RecipePrepIngrRepository(cont);
recipePrepPrepRepository = new RecipePrepPrepRepository(cont);
roomRepository = new RoomRepository(cont);
shiftRepository = new ShiftRepository(cont);
tableRepository = new TableRepository(cont);
warehouseRepository = new WarehouseRepository(cont);
}
public dynamic GetAllPurchase()
{
PurchaseRepository repo = new PurchaseRepository();
var listPurchase = repo.GetAll();
return(listPurchase);
}
public dynamic GetDataVehiclelist(int id)
{
PurchaseRepository repo = new PurchaseRepository();
dynamic listVehicle = repo.GetDataVehiclelist(id);
return(listVehicle);
}
public dynamic GetAllLots()
{
PurchaseRepository repo = new PurchaseRepository();
var listLot = repo.GetAllLots();
return(listLot);
}
public DataTable GetProduct(Purchase purchase)
{
PurchaseRepository _purchaseRepository = new PurchaseRepository();
return(_purchaseRepository.GetProduct(purchase));
}
public void TestCanUpdate()
{
//Prepare
Purchase originalPurchase = new Purchase()
{
Date = "failure"
};
Purchase testPurchase = new Purchase()
{
Date = "testPurchase"
};
IPurchaseRepository repository = new PurchaseRepository();
//Run
using (ISession session = _sessionFactory.OpenSession())
{
session.Save(originalPurchase);
testPurchase.Id = originalPurchase.Id;
repository.Update(testPurchase);
}
//Validate
using (ISession session = _sessionFactory.OpenSession())
{
//second session is used so fromDB get to take the changed table entry
var fromDb = session.Get <Purchase>(originalPurchase.Id);
Assert.IsNotNull(fromDb);
Assert.AreEqual(testPurchase.Date, fromDb.Date);
}
}
public static void WorkC()
{
ISalesRepository rp = new SalesRepository();
IPurchaseRepository rp1 = new PurchaseRepository();
Random ran = new Random();
Purchase p = new Purchase()
{
purchaseperson = "Cong lo"
};
Sales s = new Sales()
{
Salesperson = "qua duong"
};
object ob = new object();
Stopwatch st = Stopwatch.StartNew();
//Task t1 = Task.Run(() =>
// {
// rp1.Add(p);
// rp.Add(s);
// rp1.Add(p);
// rp1.Add(p);
// rp.Add(s);
// });
//Task t2 = Task.Run(() =>
// {
// int randomID = ran.Next(1, 1000000);
// rp.GetById(randomID);
// rp1.GetById(randomID+100);
// rp1.Add(p);
// rp.Add(s);
// });
//Task.WaitAll(t1,t2);
var tasks = new Task[3];
for (int i = 0; i < tasks.Length; i++)
{
tasks[0] = Task.Run(() =>
{
rp.Add(s);
rp1.Add(p);
rp1.Add(p);
});
tasks[1] = Task.Run(() =>
{
int randomID = ran.Next(1, 1000000);
rp.GetById(randomID);
rp1.GetById(randomID + 100);
});
tasks[2] = Task.Run(() =>
{
rp1.Add(p);
rp.Add(s);
});
}
Task.WaitAll(tasks);
st.Stop();
Console.WriteLine(st.Elapsed);
}
public void CanInsertPurchase()
{
var repo = new PurchaseRepository();
Purchase test = new Purchase()
{
VehicleListingId = 1,
CustomerId = 1,
UserId = "00000000-0000-0000-0000-000000000000",
PurchasePrice = 72000M,
PurchaseTypeId = 3
};
repo.Insert(test);
var purchases = repo.GetAll();
Assert.AreEqual(3, purchases.Count());
Assert.AreEqual(1, purchases[2].VehicleListingId);
Assert.AreEqual(1, purchases[2].CustomerId);
Assert.AreEqual("00000000-0000-0000-0000-000000000000", purchases[2].UserId);
Assert.AreEqual(72000M, purchases[2].PurchasePrice);
Assert.AreEqual(3, purchases[2].PurchaseTypeId);
}
public UnitOfWork(RestaurantContext context)
{
_context = context;
Adjustments = new AdjustmentRepository(_context);
AdjustmentsItems = new AdjustmentItemRepository(_context);
Branches = new BranchRepository(_context);
Categories = new CategoryRepository(_context);
Customers = new CustomerRepository(_context);
Deliveries = new DeliveryRepository(_context);
DeliveryItems = new DeliveryItemRepository(_context);
Divisions = new DivisionRepository(_context);
Expirations = new ExpirationRepository(_context);
Groups = new GroupRepository(_context);
Stocks = new InventoryItemRepository(_context);
Locations = new LocationRepository(_context);
Units = new MeasurementUnitRepository(_context);
Productions = new ProductionRepository(_context);
Ingredients = new ProductionItemRepository(_context);
Products = new ProductRepository(_context);
Purchases = new PurchaseRepository(_context);
PurchaseItems = new PurchaseItemRepository(_context);
PurchaseOrders = new PurchaseOrderRepository(_context);
PurchaseOrderItems = new PurchaseOrderItemRepository(_context);
SalesInvoices = new SalesInvoiceRepository(_context);
SalesInvoiceItems = new SalesInvoiceItemRepository(_context);
Suppliers = new SupplierRepository(_context);
Transfers = new TransferRepository(_context);
TransferItems = new TransferItemRepository(_context);
Wastages = new WastageRepository(_context);
WastageItems = new WastageItemRepository(_context);
Workers = new WorkerRepository(_context);
ItemLocation = new ItemLocationRepository(_context);
StockHistory = new StockHistoryRepository(_context);
Currencies = new CurrencyRepository(_context);
}
public UpdatePaymentStatusResponseModel SaveMidtransLog(UpdatePaymentStatusInputModel data, ModeMidTransEnum mode)
{
MidTransLog temp = new MidTransLog();
PurchaseRepository purchaseRepo = new PurchaseRepository(DbContext);
var purchaseInfo = purchaseRepo.GetPaymentByInvoiceNumber(data.InvoiceNumber).FirstOrDefault();
temp.CreateByUserID = data.UserID;
temp.CreateDate = DateTime.Now;
temp.MidTransStatus = (int)data.Status;
temp.PaymentID = purchaseInfo.ID;
temp.BankName = data.BankName;
temp.VANumber = data.VANumber;
temp.MidTransTransactionType = data.MidTransPaymentType;
MidtransLogRepository repo = new MidtransLogRepository(DbContext);
var res = repo.Insert(temp);
UpdatePaymentStatusOutputModel output = new UpdatePaymentStatusOutputModel();
output.Message = res.Message;
UpdatePaymentStatusResponseModel response = new UpdatePaymentStatusResponseModel();
response.Message = res.Message;
response.Response = true;
return(response);
}
public void TestCanAddNewOrder()
{
// prepare
var order = new Purchase()
{
Date = "testPurchase"
};
IPurchaseRepository repository = new PurchaseRepository();
// run
repository.Add(order);
// validate
// use session to try to load the product
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get <Purchase>(order.Id);
// Test that the product was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(order, fromDb);
Assert.AreEqual(order.Id, fromDb.Id);
Assert.AreEqual(order.Date, fromDb.Date);
}
}
public async Task Given_AValidPurchase_When_TryToInsert_Then_IsInsertedWithSuccess()
{
// arrange
var dbContextOptions = new DbContextOptionsBuilder <CryptoBasketContext>()
.UseInMemoryDatabase(databaseName: "InsertTestDatabase")
.Options;
var product = new Product(
123456,
"My Coin",
"MCN",
245.45D);
Purchase purchase = new Purchase(product, quantity: 2);
// act
using (var context = new CryptoBasketContext(dbContextOptions))
{
var repository = new PurchaseRepository(context);
await repository.SaveAsync(purchase);
}
// assert
using (var context = new CryptoBasketContext(dbContextOptions))
{
Assert.Equal(1, context.Purchase.Count());
Assert.NotNull(context.Purchase.Single());
var purchaseFromDatabase = context.Purchase.Single();
Assert.NotEqual(default, purchaseFromDatabase.Id);
public dynamic GetSupplierAddress(int id)
{
PurchaseRepository repo = new PurchaseRepository();
dynamic listVehicle = repo.GetSupplierAddress(id);
return(listVehicle);
}
public AssayController(AssayRepository repository, PurchaseRepository pu_repository, IHubContext <PrintHub> hub, IOptionsSnapshot <WorkOption> option, IHostingEnvironment env)
{
r = repository;
pu_r = pu_repository;
_hub = hub;
_hostingEnvironment = env;
this.option = option.Value;
}
public CheckoutController()
{
context = new ApplicationDbContext();
carts = new CartRepository(context);
customerProfiles = new CustomerProfileRepository(context);
purchases = new PurchaseRepository(context);
products = new ProductRepository(context);
}
public bool DeleteVehicle(int iVehicleID)
{
bool status = false;
PurchaseRepository repo = new PurchaseRepository();
status = repo.DeleteVehicle(iVehicleID);
return(status);
}
public static int AddExpenses(Expenses purchase)
{
if (Validator(purchase))
{
return(PurchaseRepository.AddExpenses(UppercaseFirst(purchase)));
}
return(-1);
}
public bool RcvStock(int id)
{
bool status = false;
PurchaseRepository repo = new PurchaseRepository();
status = repo.RcvStock(id);
return(status);
}
public dynamic GenerateInvoicePDF()
{
PurchaseRepository repo = new PurchaseRepository();
var vehicle = repo.GenerateInvoicePDF();
return(vehicle);
}
internal static int EditRecord(Expenses purchase)
{
if (Validator(purchase))
{
return(PurchaseRepository.EditRecord(UppercaseFirst(purchase)));
}
return(-1);
}
public ActionResult CreatePurchase(PurchaseViewModel purchase)
{
PurchaseRepository repo = new PurchaseRepository();
var result = repo.CreatePurchase(purchase);
return(result ? RedirectToAction("PurchaseSuccess") : RedirectToAction("PurchaseFailure"));
}
public bool DeletePurchaseLot(int id)
{
bool status = false;
PurchaseRepository repo = new PurchaseRepository();
status = repo.DeletePurchaseLot(id);
return(status);
}
public void ShouldGetPurchase()
{
Guid id = new Guid("ADFCF49D-CD53-E811-BFD6-001583C810FA");
PurchaseRepository purchaseRepo = new PurchaseRepository();
Purchase purchase = purchaseRepo.GetPurchase(id);
//TODO Допилить
Assert.AreEqual(id, purchase.Id);
}
public UnitOfWork(InventoryManagerEntities context)
{
_context = context;
Products = new ProductRepository(_context);
Stores = new StoreRepository(_context);
Sales = new SaleRepository(_context);
Purchases = new PurchaseRepository(_context);
Stocks = new StockRepository(_context);
}
public bool SavePurchaseLot(Lots lot)
{
bool status = true;
PurchaseRepository repo = new PurchaseRepository();
status = repo.PurchaseLotSaveEdit(ParserAddPurchaseLot(lot));
return(status);
}
public Memento(PurchaseRepository purchaseRepository)
{
this._state = (PurchaseRepository)purchaseRepository.Clone();
var listFromRepo = purchaseRepository.GetAll();
foreach (var p in listFromRepo)
{
_stateList.Add(p.DeepCopy());
}
}
public AdminController()
{
context = new ApplicationDbContext();
categories = new CategoryRepository(context);
products = new ProductRepository(context);
purchases = new PurchaseRepository(context);
profiles = new CustomerProfileRepository(context);
roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
}
public void SetMemento(Memento memento)
{
Console.WriteLine("restoring....");
State = memento.State;
foreach (var pur in memento.StateList)
{
State.Update(pur);//.переписать апдейт
}
}
static void Main(string[] args)
{
ProductRepository productRepository = new ProductRepository();
PurchaseRepository purchaseRepository = new PurchaseRepository();
AssociationRuleRepository associationRuleRepository = new AssociationRuleRepository();
List <Product> products = productRepository.GetAllProducts();
List <Purchase> purchases = purchaseRepository.GetAllPurchases();
Apriori apriori = new Apriori();
List <AssociationRule> associatiationRules = apriori.ProccessApriori(0.14, 0.1, products, purchases);
}
public PurchaseController(PurchaseRepository repository, ProductRepository p_repository, IOptionsSnapshot <WorkOption> option, IHostingEnvironment env, IHubContext <PrintHub> hub)
{
r = repository;
p_r = p_repository;
_hostingEnvironment = env;
//获取 销售单 企业微信应用的AccessToken
this.option = option.Value;
_hub = hub;
}
public void TestTotal()
{
IOfferRepository r1 = new OfferRepository();
IProductRepository r2 = new ProductRepository();
IPurchaseRepository r3 = new PurchaseRepository();
IFruitShopService f = new FruitShopService(r1, r2, r3);
IFruitShopAppService fApp = new FruitShopAppService(f);
Receipt r = fApp.RunFruitShop();
Assert.Equal(26.15M, Convert.ToDecimal(r.Total));
}
public RepositoryRegistry()
{
For<ICredentialRepository>()
.Use(factory =>
{
return new CredentialRepository(factory.GetInstance<Entities>());
});
For<IProfileRepository>()
.Use(factory =>
{
var repository = new ProfileRepository(factory.GetInstance<Entities>());
return repository;
});
For<IProfileActivityRepository>()
.Use(factory =>
{
var repository = new ProfileActivityRepository(factory.GetInstance<Entities>());
return repository;
});
For<IGrunkerRepository>()
.Use(factory =>
{
var repository = new GrunkerRepository(factory.GetInstance<Entities>());
return repository;
});
For<IActivityTypeRepository>()
.Use(factory =>
{
var repository = new ActivityTypeRepository(factory.GetInstance<Entities>());
return repository;
});
For<IPictureRepository>()
.Use(factory =>
{
var repository = new PictureRepository(factory.GetInstance<Entities>());
return repository;
});
For<IGenreRepository>()
.Use(factory =>
{
var repository = new GenreRepository(factory.GetInstance<Entities>());
return repository;
});
For<IArtistRepository>()
.Use(factory =>
{
var repository = new ArtistRepository(factory.GetInstance<Entities>());
return repository;
});
For<IAlbumRepository>()
.Use(factory =>
{
var repository = new AlbumRepository(factory.GetInstance<Entities>());
return repository;
});
For<IPurchaseRepository>()
.Use(factory =>
{
var repository = new PurchaseRepository(factory.GetInstance<Entities>());
return repository;
});
For<IReviewRepository>()
.Use(factory =>
{
var repository = new ReviewRepository(factory.GetInstance<Entities>());
return repository;
});
For<IReviewLinkRepository>()
.Use(factory =>
{
var repository = new ReviewLinkRepository(factory.GetInstance<Entities>());
return repository;
});
For<IStoreDetailsRepository>()
.Use(factory =>
{
var repository = new StoreDetailsRepository(HttpContext.Current.Server.MapPath("~/App_Data/storedetails.xml"));
return repository;
});
For<IStaticTextRepository>()
.Use(factory =>
{
var repository = new StaticTextRepository(factory.GetInstance<Entities>());
return repository;
});
}
public PurchaseRequestValidator()
{
purchaseRepository = new PurchaseRepository();
}
public void DeletePurchaseTest()
{
//IUnitOfWork unit = new UnitOfWork();
//IPurchaseRepository repo = new PurchaseRepository(unit);
IPurchaseRepository repo = new PurchaseRepository();
repo.Delete(repo.Single(x=>x.VendorID==1700));
var header = repo.Single (x => x.VendorID == 1700);
Assert.IsNull(header);
}
public void UpdatePurchaseTest()
{
IPurchaseRepository repo = new PurchaseRepository();
// IUnitOfWork unit = new UnitOfWork();
// IPurchaseRepository repo = new PurchaseRepository(unit);
var header = repo.Single(x => x.VendorID == 1699);
Assert.IsNotNull(header);
header.VendorID = 1700;
var details = header.PurchaseOrderDetails.Where(x => x.ProductID == 999).AsQueryable();
Assert.IsNotNull(details);
var detail = details.FirstOrDefault();
detail.ProductID= 997;
detail.OrderQty = 300;
var newdet = new PurchaseOrderDetail();
newdet.DueDate = DateTime.Now.Date;
newdet.ModifiedDate = DateTime.Now.Date;
newdet.LineTotal = 10;
newdet.OrderQty = 10;
newdet.ProductID = 999;
newdet.PurchaseOrderID = header.PurchaseOrderID;
newdet.ReceivedQty = 0;
newdet.RejectedQty = 0;
newdet.StockedQty = 0;
newdet.UnitPrice = 10;
header.PurchaseOrderDetails.Add(newdet);
header.PurchaseOrderDetails.Add(new PurchaseOrderDetail()
{
DueDate = DateTime.Now.Date
,
OrderQty = 25
,
ProductID = 998
,
UnitPrice = 600
,
LineTotal = 700
,
ReceivedQty = 25
,
RejectedQty = 0
,
StockedQty = 0
,
ModifiedDate = DateTime.Now.Date
});
repo.Attach(header);
header = repo.Single(x => x.VendorID == 1700);
Assert.IsNotNull(header);
details = header.PurchaseOrderDetails.Where(x => x.ProductID == 997).AsQueryable();
Assert.IsNotNull(details);
//var pocoDept = Mapper.Map<Department, dDepartment>(department);
//return pocoDept;
}
public PurchaseOffice()
{
_purchaseRepository = new PurchaseRepository(MngPaycheckContext.Instance);
}
public void AddPurchaseTest()
{
//delete Purchasing.PurchaseOrderDetail from Purchasing.PurchaseOrderDetail a left join Purchasing.PurchaseOrderHeader b on (a.PurchaseOrderID = b.PurchaseOrderID) where b.VendorID=1500
//delete Purchasing.PurchaseOrderheader from Purchasing.PurchaseOrderHeader where VendorID=1500
//delete Purchasing.PurchaseOrderDetail from Purchasing.PurchaseOrderDetail a left join Purchasing.PurchaseOrderHeader b on (a.PurchaseOrderID = b.PurchaseOrderID) where b.VendorID=1502
//delete Purchasing.PurchaseOrderheader from Purchasing.PurchaseOrderHeader where VendorID=1502
//IUnitOfWork unit = new UnitOfWork();
IPurchaseRepository repo = new PurchaseRepository();
var header = new PurchaseOrderHeader();
header.EmployeeID = 1;
header.RevisionNumber=10;
header.Status=1;
header.VendorID=1699;
header.ShipMethodID = 1;
header.OrderDate=DateTime.Now.Date;
header.ShipDate=DateTime.Now.Date;
header.SubTotal=555;
header.TaxAmt=10;
header.Freight=4;
header.ModifiedDate = DateTime.Now.Date;
header.PurchaseOrderDetails.Add(new PurchaseOrderDetail()
{
DueDate = DateTime.Now.Date
,
OrderQty = 15
,
ProductID = 998
,
UnitPrice = 100
,
LineTotal = 100
,
ReceivedQty = 15
,
RejectedQty = 0
,
StockedQty = 0
,
ModifiedDate = DateTime.Now.Date
});
header.PurchaseOrderDetails.Add(new PurchaseOrderDetail()
{
DueDate = DateTime.Now.Date
,
OrderQty = 25
,
ProductID = 999
,
UnitPrice = 600
,
LineTotal = 700
,
ReceivedQty = 25
,
RejectedQty = 0
,
StockedQty = 0
,
ModifiedDate = DateTime.Now.Date
});
repo.Add(header);
header = repo.Single(x => x.ModifiedDate.Day == DateTime.Now.Day &&
x.ModifiedDate.Month == DateTime.Now.Month &&
x.ModifiedDate.Year == DateTime.Now.Year && x.VendorID == 1699);
Assert.IsNotNull(header);
Assert.IsTrue(header.PurchaseOrderDetails.Count() >= 2);
}
