public async Task <PurchaseViewModel> Insert(PurchaseViewModel model)
{
var payment = new Payment();
var purchase = new Purchase();
var pLine = new PurchaseLine();
payment.PaymentType = "Purchase";
payment.PaymentMethod = model.PaymentMethod;
payment.Amount = model.Amount;
payment.BankName = model.BankName;
payment.TransactionId = model.TransactionId;
payment.PaymentNote = model.PaymentNote;
_db.Payments.Add(payment);
await _db.SaveChangesAsync();
purchase.ReferenceNo = model.ReferenceNo;
purchase.PurchaseStatus = model.PurchaseStatus;
purchase.UserId = model.UserId;
purchase.PurchaseDate = model.PurchaseDate;
purchase.TotalAmount = model.TotalAmount;
purchase.VatAmount = model.VatAmount;
purchase.DiscountAmount = model.DiscountAmount;
purchase.PublisherId = model.PublisherId; //fk m
purchase.PaymentId = payment.PaymentId; //fk a
_db.Purchases.Add(purchase);
await _db.SaveChangesAsync();
model.PurchaseLines.ForEach(ol =>
{
pLine.PurchaseId = purchase.PurchaseId; //fk a
pLine.BookId = ol.BookId;
pLine.Quantity = ol.Quantity;
pLine.Rate = ol.Rate;
_db.PurchaseLines.Add(pLine);
_db.SaveChanges();
//update stock
int stockId = _db.Stocks.Where(a => a.BookId == ol.BookId).Select(s => s.StockId).SingleOrDefault();
Stock stock = _db.Stocks.Find(stockId);
stock.Quantity += ol.Quantity;
_db.Entry(stock).State = EntityState.Modified;
_db.SaveChanges();
});
return(model);
}
//更新采购单
public void UpdatePurchase(PurchaseViewModel model)
{
var purchase = _purchaseRepository.FindBy(x => x.PurchaseId == model.PurchaseId).Include(z => z.PurchaseApplication.Item).Include(z => z.PurchaseApplication.PurchaseApplicationHeader.RequestHeader).FirstOrDefault();
if (purchase == null)
{
return;
}
purchase.CurrentPurchasePrice = model.Price;
purchase.ReadyForInStock = model.ReadyForInStock;
if (Math.Abs(purchase.CurrentPurchasePrice - purchase.PurchaseApplication.Item.Price) > 0.00001)
{
purchase.IsPriceChange = true;
}
if (purchase.ReadyForInStock == purchase.PurchaseTotal)
{
if (purchase.PurchaseApplication.PurchaseApplicationHeader.RequestHeader.RequestCategory ==
RequestCategoriesEnum.材料需求)
{
purchase.Status = ProcessStatusEnum.采购完成;
purchase.LastDeliveryDate = DateTime.Now;
}
else
{
purchase.Status = ProcessStatusEnum.退货申请完成;
}
}
if (model.IsDeleted)
{
purchase.IsDeleted = true;
purchase.PurchaseApplication.ProcessStatus = ProcessStatusEnum.申请审核中;
purchase.PurchaseApplication.AuditStatus = AuditStatusEnum.未审批;
purchase.Status = ProcessStatusEnum.申请审核中;
}
purchase.Note = model.Note;
purchase.UpdateDate = DateTime.Now;
purchase.DeliveryDate = model.DeliveryDate;
purchase.CorrectionTotal = model.CorrectionTotal;
_purchaseRepository.Edit(purchase);
_purchaseRepository.Save();
UpdatePurchaseProcessStatus(purchase.PurchaseId, purchase.Status);
}
public void Create(PurchaseViewModel purchaseViewModel)
{
var purchase = new Purchase()
{
Date = purchaseViewModel.Date,
CreatedDate = DateTime.Now,
UpdatedDate = DateTime.Now
};
purchase.PurchaseUnits = CreatePurchaseUnits(purchaseViewModel.PurchaseUnits, purchase);
var deliveryPurchases = new List <DeliveryPurchase>(purchaseViewModel.Deliveries.Count);
foreach (var delVm in purchaseViewModel.Deliveries)
{
var delivery = _deliveriesService.GetEntityById(delVm.DeliveryId);
var contacts = new List <Contact>(delVm.Contacts.Count);
foreach (var contact in delVm.Contacts)
{
contacts.Add(new Contact {
Name = contact.Name, Phone = contact.Phone
});
}
var dPurchase = new DeliveryPurchase()
{
Contacts = contacts,
Address = delVm.Address,
Date = delVm.Date.Value,
Purchase = purchase,
TimeFrom = delVm.TimeFrom,
TimeTo = delVm.TimeTo,
Notes = delVm.Notes
};
if (delivery != null)
{
dPurchase.Delivery = delivery;
}
deliveryPurchases.Add(dPurchase);
}
purchase.DeliveryPurchases = deliveryPurchases;
_service.CreateEntity(purchase);
}
private void RepositoryItemLookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
LookUpEdit edit = sender as LookUpEdit;
GridView gridView = sender as GridView;
object editValue = edit.EditValue;
int index = edit.Properties.GetDataSourceRowIndex(edit.Properties.ValueMember, editValue);
PurchaseViewModel row = (PurchaseViewModel)edit.Properties.GetDataSourceRowByKeyValue(editValue);
PurchaseApplicationViewModel rowPurchaseApplication = (PurchaseApplicationViewModel)gridView.GetFocusedRow();
rowPurchaseApplication.SelectedPurchaseNumber = row.PurchaseNumber;
rowPurchaseApplication.PoNumber = row.PoNumber;
rowPurchaseApplication.SupplierName = row.SupplierCode;
rowPurchaseApplication.CurrentPurchasePrice = row.Price;
//PurchaseApplicationViewModel rowView = (PurchaseApplicationViewModel)edit.GetSelectedDataRow();
//DataRow row1 = rowView.Row;
//_requestService.UpdateRequest(row);
}
public IActionResult GetPuchaseList([FromQuery(Name = "NE")] bool notExecuted)
{
var globalUserRole = HttpContext.Session.GetInt32("UserRole");
var model = new PurchaseViewModel();
ViewBag.UserRole = (UserRoles)globalUserRole;
ViewBag.Id = globalUserRole.ToString();
ViewData["DateTime"] = DateTime.Now;
if (notExecuted == true)
{
return(View("Views/ViewRole/Storekeeper/PurchaseList.cshtml", model));
}
return(View("Views/ViewRole/PurchasingManager/PurchaseList.cshtml", model));
}
public async Task <IHttpActionResult> GetDeletedProduct([FromUri] PaginationQuery paginationQuery)
{
try
{
IEnumerable <Purchase> purchases = await Task.FromResult(purchaseRepository.GetAllDeleted(
paginationQuery.Skip, paginationQuery.Limit));
return(new HttpJsonApiResult <IEnumerable <PurchaseViewModel> >(
PurchaseViewModel.GetAll(purchases),
Request,
HttpStatusCode.OK));
}
catch (Exception)
{
return(new HttpJsonApiResult <string>("Internal Server Error", Request, HttpStatusCode.InternalServerError));
}
}
public PurchaseViewModel Update(PurchaseViewModel purchaseViewModel)
{
var purchase = Mapper.Map <PurchaseViewModel, Purchase>(purchaseViewModel);
BeginTransaction();
if (!purchase.ValidationResult.IsValid)
{
return(purchaseViewModel);
}
_purchaseService.Update(purchase);
Commit();
return(purchaseViewModel);
}
public IHttpActionResult Insert(PurchaseViewModel model)
{
Purchase purchase = new Purchase
{
Id = model.Id,
ProductId = model.ProductId,
UserId = User.Identity.GetUserId(),
Quantity = model.Quantity,
CreatedTime = DateTime.Now,
DeliveryTime = model.DeliveryTime,
Description = model.Description
};
_purchase.Insert(purchase);
return(Ok(purchase));
}
public ActionResult Add()
{
PurchaseViewModel purchasevm = new PurchaseViewModel();
purchasevm.SupplierList = _supplierManager.GetAll().Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.Name
});
purchasevm.ProductList = _productManager.GetAll().Select(c => new SelectListItem()
{
Value = c.ID.ToString(),
Text = c.Name
});
return(View(purchasevm));
}
// GET: Tickets/Delete/5
public ActionResult Delete(int id)
{
var selectedschedule = db.schedules.Where(x => x.ID == id).ToList().First();
var model = new PurchaseViewModel()
{
shipname = selectedschedule.shipname,
startDate = selectedschedule.startDate,
endDate = selectedschedule.endDate,
startLocation = selectedschedule.startLocation,
price = selectedschedule.price,
destination = selectedschedule.destination,
seat = selectedschedule.seat,
email = User.Identity.Name
};
return(View(model));
}
public PurchaseViewModel GetPurchaseViewModal(int id)
{
PurchaseViewModel purchaseviewNodal = new PurchaseViewModel();
PurchaseInvoiceMaster invmstr = GetPurchaseInvoicemaster(id);
purchaseviewNodal.SupplierInvoice = invmstr.PurchaseInvoiceNum;
purchaseviewNodal.SupplierInvoiceDate = invmstr.InvoiceDate;
purchaseviewNodal.PurchaseDate = invmstr.PurchaseDate;
purchaseviewNodal.CustomerID = invmstr.CustomerID;
purchaseviewNodal.InvoiceValue = invmstr.TotalBill;
purchaseviewNodal.PaidValue = invmstr.TotalPaid;
//foreach (PurchaseInvoiceDetail in invmstr.PurchaseInvoiceDetails ){
//}
return(purchaseviewNodal);
}
public ActionResult Purchase(int id)
{
var model = new PurchaseViewModel();
var statesRepo = SalesFactory.GetRepo();
var purchaseTypesRepo = SalesFactory.GetRepo();
var detailsRepo = SalesFactory.GetRepo().GetDetails(id);
model.States = new SelectList(statesRepo.GetStates(), "StateId", "StateId");
model.PurchaseType = new SelectList(purchaseTypesRepo.GetPurchaseType(), "PurchaseTypeId", "PurchaseTypeName");
model.Car = new CarView();
model.Car = detailsRepo;
model.Customer = new Customer();
model.Purchase = new Purchase();
return(View(model));
}
void LoadCurrentPurchasesFromDB()
{
CurrentPurchases = new List <PurchaseViewModel>();
var purchases = Database.GetPurchaseItems();
foreach (var item in purchases)
{
PurchaseViewModel temp = new PurchaseViewModel()
{
Name = item.Name,
Count = item.Count,
Units = item.Units,
Completed = item.Completed
};
CurrentPurchases.Add(temp);
}
}
public ActionResult Purchase(SaleLogViewModel saleLogViewModel)
{
if (ModelState.IsValid)
{
var saleLogRepo = SaleLogRepositoryFactory.GetSaleLogRepository();
var vehicleRepo = VehicleRepositoryFactory.GetVehicleRepository();
var saleLog = new SaleLog()
{
BuyerName = saleLogViewModel.BuyerName,
Email = saleLogViewModel.Email,
Street1 = saleLogViewModel.Street1,
Street2 = saleLogViewModel.Street2,
City = saleLogViewModel.City,
State = saleLogViewModel.State,
ZipCode = saleLogViewModel.ZipCode,
PurchasePrice = saleLogViewModel.PurchasePrice,
PurchaseType = saleLogViewModel.PurchaseType,
VehicleId = saleLogViewModel.VehicleId,
Phone = saleLogViewModel.Phone,
SalesUserId = User.Identity.GetUserId(),
PurchaseDate = DateTime.Today
};
// Add Sale Log Record
saleLogRepo.AddSaleLog(saleLog);
// Mark Vehicle as Purchased
vehicleRepo.VehicleMarkPurchased(saleLogViewModel.VehicleId);
return(RedirectToAction("Index", "Home"));
}
else // send back the View with error list
{
var repo = VehicleRepositoryFactory.GetVehicleRepository();
var model = new PurchaseViewModel()
{
vehicle = repo.GetVehicleById(saleLogViewModel.VehicleId),
saleLogViewModel = saleLogViewModel
};
return(View(model));
}
}
public IHttpActionResult PostPurchaseViewModel(PurchaseViewModel purchaseViewModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
_purchaseAppService.Add(purchaseViewModel);
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(CreatedAtRoute("DefaultApi", new { id = purchaseViewModel.Id }, purchaseViewModel));
}
public IHttpActionResult GetPurchase([FromUri] int id)
{
Exception ex = null;
PurchaseViewModel result = null;
try {
var purchase = _dataProvider.GetEntity <Purchase>(id);
result = new PurchaseViewModel(purchase);
result.AddLink(new Link(Request.RequestUri, HttpMethod.Get, RelValues.Self, ActionValues.Refresh, "Purchases/" + id));
result.AddLink(new Link(Request.RequestUri, HttpMethod.Put, RelValues.Self, ActionValues.Save, "Purchases/" + id));
result.AddLink(new Link(Request.RequestUri, HttpMethod.Delete, RelValues.Self, ActionValues.Delete, "Purchases/" + id));
} catch (Exception e) {
ex = e;
}
return(GetHttpActionResult(result, ex));
}
public async Task <IActionResult> Purchase()
{
var user = await _userManager.GetUserAsync(HttpContext.User);
var orders = _db.OrderNumbers
.Include(item => item.Orders)
.Where(item => item.Email == user.Email)
.ToList();
var model = new PurchaseViewModel()
{
Orders = orders,
Avatar = user.Avatar,
Name = user.Name
};
return(View(model));
}
public async Task <IActionResult> PuchaseDetails([FromQuery(Name = "id")] string id)
{
try
{
PurchaseViewModel model = null;
var purchase = await _dm.PurchaseAccessor.GetPurchase(System.Convert.ToInt32(id));
var products = await _dm.ProductAccessor.GetProducts(purchase.Id);
purchase.ProductList = products;
model = purchase.ToPurchaseViewModel();
return(View("Views/ViewRole/PurchasingManager/PurchaseDetails.cshtml", model));
}
catch (Exception ex)
{
return(null);
}
}
public ActionResult Entry()
{
PurchaseViewModel purchaseViewModel = new PurchaseViewModel();
purchaseViewModel.SupplierSelectListItems = _supplierManager.GetAll().Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
});
purchaseViewModel.ProductSelectListItems = _productManager.GetAll().Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
});
return(View(purchaseViewModel));
}
public static PurchaseViewModel GetPurchaseViewModel()
{
var vm = new PurchaseViewModel();
vm.Initlize(new string[] { "Durable" }, new string[] { "9N5XR16ZVS8M", "9NMV8XM83L0W", "9NWRT6CM2ZK4" });
var mainWindow = Application.Current.MainWindow;
if (mainWindow != null)
{
IntPtr windowHandle = new WindowInteropHelper(mainWindow).Handle;
//不初始化的情况下，内部注册窗口会自己调
vm.InitHandle(windowHandle, mainWindow.Dispatcher);
}
string VIPGroup = "864039359";
vm.VIPContent = new VIPContent($"巨应工作室VIP QQ群：{VIPGroup}", VIPGroup, "https://shang.qq.com/wpa/qunwpa?idkey=24010e6212fe3c7ba6f79f5f91e6b216c6708d7a47abceb6f7e26890c3b15944");
return(vm);
}
public ActionResult Details(int?id)
{
//STARTS HERE
//ENDS HERE
String CurrentUserId = User.Identity.GetUserId();
Purchase ActiveCartPurchase = db.Purchases.Find(id);
List <Album> Albums = new List <Album>();
foreach (PurchaseItem pi in ActiveCartPurchase.PurchaseItems)
{
if (pi.isAlbum)
{
Albums.Add(pi.PurchaseItemAlbum);
}
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Purchase purchase = db.Purchases.Find(id);
if (purchase == null)
{
return(HttpNotFound());
}
if (checkDuplicates(Albums))
{
return(RedirectToAction("Index"));
}
else
{
//CalcSubtotals
PurchaseViewModel PVM = calcPVM(ActiveCartPurchase);
//End Calc Subtotals
//create list and execute query
AppUser CurrentUser = db.Users.Find(CurrentUserId);
//get Cards
getCards(CurrentUser);
PVM.purchaserName = CurrentUser.Email;
return(View("Details", PVM));
}
}
public ActionResult ShowFinalPrice(PurchaseViewModel pv, string price)
{
int weightInt;
int amountInt;
if (!int.TryParse(pv.Weight, out weightInt))
{
weightInt = 25;
}
if (!int.TryParse(pv.Amount, out amountInt))
{
amountInt = 1;
}
decimal unitPrice = decimal.Parse(price);
decimal finalPrice = 0;
if (weightInt == 25)
{
finalPrice = unitPrice * amountInt;
}
else if (weightInt == 50)
{
finalPrice = unitPrice * (decimal)(2 * 0.95 * amountInt);
}
else if (weightInt == 100)
{
finalPrice = unitPrice * (decimal)(4 * 0.9 * amountInt);
}
else if (weightInt == 250)
{
finalPrice = unitPrice * (decimal)(10 * 0.85 * amountInt);
}
else if (weightInt == 500)
{
finalPrice = unitPrice * (decimal)(20 * 0.8 * amountInt);
}
pv.FinalPrice = finalPrice;
return(Json(pv));
}
public string Buy(PurchaseViewModel purchaseViewModel)
{
if (ModelState.IsValid)
{
var purchase = new Purchase
{
Address = purchaseViewModel.Address,
Person = purchaseViewModel.Person,
Date = DateTime.Now,
ProductId = purchaseViewModel.ProductId
};
_appDbContext.Purchases.Add(purchase);
_appDbContext.SaveChanges();
return("Thank you, " + purchase.Person + ", for your purchase!");
}
return("Name or address doesn't correct.");
}
public void CheckVIP(PurchaseViewModel vm)
{
try
{
if (AppData.Purchased != vm.IsVIP)
{
AppData.Purchased = vm.IsVIP;
SaveAppData();
}
_eventAggregator.PublishOnBackgroundThread(new VipEvent()
{
IsVIP = vm.IsVIP
});
}
catch (Exception ex)
{
logger.Warn("CheckVIP EX:" + ex);
}
}
public ActionResult Purchase(PurchaseViewModel viewModel)
{
viewModel.Sale.MSRP = viewModel.VehicleDetails.MSRP;
viewModel.Sale.SalesPrice = viewModel.VehicleDetails.SalesPrice;
if (ModelState.IsValid)
{
try
{
var usrManger = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
var user = usrManger.FindByName(User.Identity.Name);
var salesRepo = SalesFactory.GetSalesRepository();
var vehicleRepo = VehicleFactory.GetVehicleRepository();
var vehicle = vehicleRepo.GetVehicle(viewModel.VehicleDetails.VehicleId);
vehicle.IsSold = true;
viewModel.Sale.VehicleId = vehicle.VehicleId;
viewModel.Sale.DatePurchased = DateTime.Now;
viewModel.Sale.UserId = user.Id;
salesRepo.InsertSale(viewModel.Sale);
vehicleRepo.UpdateVehicle(vehicle);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
var viewModelReturn = new PurchaseViewModel();
viewModelReturn.VehicleDetails = VehicleFactory.GetVehicleRepository().GetVehicleDetails(viewModel.VehicleDetails.VehicleId);
TempData["MileageDisplay"] = viewModel.VehicleDetails.Mileage.ToString("#,###");
TempData["SalesPriceDisplay"] = viewModel.VehicleDetails.SalesPrice.ToString("#,###");
TempData["MSRPDisplay"] = viewModel.VehicleDetails.MSRP.ToString("#,###");
return(View(viewModelReturn));
}
}
public ActionResult DeleteConfirmed(PurchaseViewModel model)
{
var ticket = new Ticket()
{
seatnumber = model.seatnumber,
shipType = model.shipType,
shipName = model.shipname,
startLocation = model.startLocation,
destination = model.destination,
StartDate = model.startDate,
EndDate = model.endDate,
price = model.price,
email = model.email
};
db.tickets.Add(ticket);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddPurchase(PurchaseViewModel purchase)
{
Sale carPurchase = purchase.SaleDetails;
carPurchase.DateSold = DateTime.Now;
carPurchase.User = purchase.SaleDetails.User;
carPurchase.PurchaseType = dealerDb.Purchase.SingleOrDefault(p => p.PurchaseTypeId == purchase.PurchaseTypeDetails.PurchaseTypeId);
VehicleDetails vehicleSold = dealerDb.VehicleDetails.SingleOrDefault(v => v.VehicleId == purchase.VehiclePurchaseId);
carPurchase.IsSold = true;
carPurchase.IsFeatured = false;
carPurchase.Vehicle = vehicleSold;
carPurchase.VehicleId = vehicleSold.VehicleId;
dealerDb.SaveChanges();
dealerDb.Sale.Add(carPurchase);
dealerDb.SaveChanges();
}
public ActionResult AddPurchase(PurchaseViewModel purchaseViewModel)
{
purchaseViewModel.SupplierSelectListItems = _supplierManager.GetAll().Select(c => new SelectListItem
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
purchaseViewModel.CategorySelectListItems = _categoryManager.GetAll().Select(c => new SelectListItem
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
ViewBag.Category = purchaseViewModel.CategorySelectListItems;
//purchaseViewModel.ProductSelectListItems = _productManager.GetAll().Select(c => new SelectListItem
// {
// Value = c.Id.ToString(),
// Text = c.Name
// }).ToList();
string message = "";
Purchase purchase = Mapper.Map <Purchase>(purchaseViewModel);
if (_purchaseManager.Add(purchase))
{
message = "Data Save Successfully";
}
else
{
message = "not save";
}
ViewBag.Message = message;
purchaseViewModel.Purchases = _purchaseManager.GetPurchaseReportAll();
return(View(purchaseViewModel));
}
public ActionResult Add(Purchases purchases)
{
string message = "";
if (ModelState.IsValid)
{
if (_purchaseManager.Add(purchases))
{
message = "Purchase Saved";
}
else
{
message = "Not saved";
}
}
ViewBag.Message = message;
PurchaseViewModel purchaseViewModel = new PurchaseViewModel();
purchaseViewModel.SupplierSelectListItems = _supplierManager.
GetAll().Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
//purchaseViewModel.ProductSelectListItems = _productManager.GetAll()
// .Select(c => new SelectListItem()
// {
// Value = c.Id.ToString(),
// Text = c.Name
// }).ToList();
purchaseViewModel.CategorySelectListItems = _categoryManager.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}).ToList();
ViewBag.Category = purchaseViewModel.CategorySelectListItems;
return(View(purchaseViewModel));
}
public ActionResult Purchase(int?id) // This will be called from Javascript code in Index View
{
var repo = VehicleRepositoryFactory.GetVehicleRepository();
try
{
var model = new PurchaseViewModel()
{
vehicle = repo.GetVehicleById(id),
saleLogViewModel = new SaleLogViewModel()
};
return(View(model));
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PutBuyBook(int id)
{
var context = new BookShopContext();
var book = context.Books.FirstOrDefault(b => b.Id == id);
if (book == null)
{
return this.NotFound();
}
if (book.Copies <= 0)
{
return this.BadRequest("No copies left");
}
book.Copies--;
var purchase = new Purchase()
{
Book = book,
ApplicationUser = context.Users.FirstOrDefault(u => u.UserName == this.User.Identity.Name),
Price = book.Price,
DateOfPurchase = DateTime.Now,
IsRecalled = false
};
context.Purchases.Add(purchase);
context.SaveChanges();
var purchaseView = new PurchaseViewModel()
{
BookName = book.Title,
Price = book.Price,
User = purchase.ApplicationUser.UserName
};
return this.Ok(purchaseView);
}
