// GET: Orders/Create
public ActionResult Create(int?id)
{
if (id == null)
{
return(View("Error", new string[] { "You must specify an order to add!" }));
}
List <ProcurementDetail> AllProcurementDetails = new List <ProcurementDetail>();
var query2 = from e in _context.ProcurementDetails
select e;
query2 = query2.Include(o => o.Book).Include(o => o.Procurement).Where(o => o.Procurement.Completed == false && o.Procurement.ProcurementType == ProcurementType.Manual && o.Book.BookID == id);
AllProcurementDetails = query2.ToList();
if (AllProcurementDetails.Any())
{
return(View("Error", new string[] { "You already have this book in your reorder cart!" }));
}
Procurement pro = _context.Procurements.OrderByDescending(p => p.ProcurementID)
.FirstOrDefault(p => p.Completed == false);
Book bo = _context.Books.FirstOrDefault(b => b.BookID == id);
if (pro == null)
{
return(View("Error", new string[] { "Order not found!" }));
}
ProcurementDetail pd = new ProcurementDetail()
{
Procurement = pro, Book = bo, BookPrice = bo.Cost
};
return(View("Create", pd));
}
public static void Get()
{
DataTable rawData = Helper.OpenExcel("Procurements");
int N = 0;
Helper.Context.Context.Configuration.AutoDetectChangesEnabled = false;
Helper.Context.Context.Configuration.ValidateOnSaveEnabled = false;
foreach (DataRow row in rawData.Rows)
{
Procurement procurement = new Procurement()
{
Document = Helper.getString(row, 1),
Date = Helper.getDate(row, 2),
Product = Helper.Context.Products.Get(Lexicon.Products[Helper.getInteger(row, 3)]),
Supplier = Helper.Context.Suppliers.Get(Lexicon.Suppliers[Helper.getInteger(row, 4)]),
Quantity = Helper.getInteger(row, 5),
Price = Helper.getDouble(row, 6)
};
N++;
if (N % 100 == 0)
{
Console.Write($"{N} ");
}
Helper.Context.Procurements.Insert(procurement);
}
Helper.Context.Commit();
Console.WriteLine(N);
}
public async Task <IActionResult> Edit(int id, [Bind("ProcurementID,ProcurementDate,SupplierID,DeliveryNoteNumber,MerchandiseName,MeasureUnit,UnitPrice,Quantity")] Procurement procurement)
{
if (id != procurement.ProcurementID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
procurement.TotalPrice = procurement.UnitPrice * procurement.Quantity;
try
{
_context.Update(procurement);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProcurementExists(procurement.ProcurementID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["SupplierID"] = new SelectList(_context.Suppliers, "SupplierID", "SupplierName", procurement.SupplierID);
return(View(procurement));
}
public IActionResult Create(ProcurementDetail pd)
{
if (pd.Quantity == 0)
{
return(RedirectToAction("EditOrder", "Procurements", new { id = pd.Procurement.ProcurementID }));
}
else
{
Book bo = _context.Books.FirstOrDefault(b => b.BookID == pd.Book.BookID);
pd.Book = bo;
Procurement pro = _context.Procurements.Find(pd.Procurement.ProcurementID);
pd.Procurement = pro;
bo.Cost = pd.BookPrice;
_context.Books.Update(bo);
_context.SaveChanges();
pd.ExtendedPrice = pd.Quantity * pd.BookPrice;
if (ModelState.IsValid)
{
_context.ProcurementDetails.Add(pd);
_context.SaveChanges();
return(RedirectToAction("EditOrder", "Procurements", new { id = pd.Procurement.ProcurementID }));
}
return(View(pd));
}
}
public OperationResult Create(ProcurementViewModel input)
{
var result = new OperationResult();
try
{
BizModel context = new BizModel();
var repository = new BizRepository <Procurement>(context);
Procurement entity = new Procurement()
{
PartNo = input.PartNo,
PurchasingDay = input.PurchasingDay,
Quantity = input.Quantity,
InvetoryQuantity = input.InvetoryQuantity,
UintPrice = input.UnitPrice
};
repository.Create(entity);
context.SaveChanges();
result.IsSuccessful = true;
}
catch (Exception ex)
{
result.IsSuccessful = false;
result.exception = ex;
}
return(result);
}
public static void Get()
{
IBillingRepository <Procurement> procurements = new BillingRepository <Procurement>(Help.Context);
IBillingRepository <Supplier> suppliers = new BillingRepository <Supplier>(Help.Context);
IBillingRepository <Product> products = new BillingRepository <Product>(Help.Context);
DataTable rawData = Help.OpenExcel("Procurements");
int N = 0;
foreach (DataRow row in rawData.Rows)
{
Supplier supplier = suppliers.Get(Help.dicSupp[Help.getInteger(row, 2)]);
Product product = products.Get(Help.dicProd[Help.getInteger(row, 3)]);
Procurement procurement = new Procurement()
{
Document = Help.getString(row, 0),
Date = Help.getDate(row, 1),
Supplier = supplier,
Product = product,
Quantity = Help.getInteger(row, 4),
Price = Help.getDouble(row, 5)
};
N++;
procurements.Insert(procurement);
}
procurements.Commit();
Console.WriteLine(N);
}
public async Task <ActionResult> Create([Bind(Include = "id_procurement,date_procurement,cost_procurement,count_procurement,id_storage,id_product")] Procurement procurement)
{
var product = await db.Products.ToListAsync();
if (product.Count == 0)
{
ViewBag.no_product = "Требуется выбор названия товара";
}
ViewBag.id_product = new SelectList(db.Products, "id_product", "name_product");
if (ModelState.IsValid && product.Count != 0)
{
db.Procurements.Add(procurement);
if (db.Product_storage.Find(procurement.id_product) == null)
{
db.Product_storage.Add(new Product_storage(procurement.count_procurement, procurement.id_product));
}
else
{
db.Product_storage.Find(procurement.id_product).id_product = procurement.id_product;
db.Product_storage.Find(procurement.id_product).count += procurement.count_procurement;
}
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(procurement));
}
public ConcreteMediator(Admin component1, Log component2, Procurement component3,
Search component4, Storage component5, Store component6, Supplier component7, Warehouse_Core.Models.Task component8,
Transfer component9, User component10)
{
this._component1 = component1;
this._component1.SetMediator(this);
this._component2 = component2;
this._component2.SetMediator(this);
this._component3 = component3;
this._component3.SetMediator(this);
this._component4 = component4;
this._component4.SetMediator(this);
this._component5 = component5;
this._component5.SetMediator(this);
this._component6 = component6;
this._component6.SetMediator(this);
this._component7 = component7;
this._component7.SetMediator(this);
this._component8 = component8;
this._component8.SetMediator(this);
this._component9 = component9;
this._component9.SetMediator(this);
this._component10 = component10;
this._component10.SetMediator(this);
}
public List <Procurement> FindDocuments(string substring)
{
var zipNames = GetZipNames();
var procurements = new List <Procurement>();
foreach (var zipName in zipNames)
{
var documents = GetAllDocumentsFromZip(zipName);
foreach (var pair in documents)
{
var name = pair.Key;
if (pair.Value.Contains(substring))
{
var procurement = new Procurement()
{
Name = name,
ArchiveName = zipName,
Url = $"{uri}{zipName}",
Value = pair.Value
};
procurements.Add(procurement);
}
}
}
return(procurements);
}
//[ValidateAntiForgeryToken]
public ActionResult EditProcurement([Bind(Include = "ProcurementId, ProductName, PurchaseDate, Quantity, UnitPrize, ProductId")] Procurement procurement)
{
//var procurement = JsonConvert.DeserializeObject<Procurement>(procurementJson);
ProductRepository productRepo = new ProductRepository(db);
ProcurementRepository procurementRepo = new ProcurementRepository(db);
List <ProcurementViewModel> procurements = new List <ProcurementViewModel>();
//將變更儲存在資料庫
if (ModelState.IsValid)
{
db.Entry(procurement).State = EntityState.Modified;
db.SaveChanges();
}
//抓取改變後的資料
foreach (Procurement item in procurementRepo.GetAll().ToList())
{
ProcurementViewModel procurementVM = new ProcurementViewModel()
{
ProductName = productRepo.GetProductNameByID(item.ProductId),
ProcurementId = item.ProcurementId,
PurchaseDate = item.PurchaseDate.ToString("yyyy/MM/dd hh:mm:ss"),
Quantity = item.Quantity,
UnitPrize = item.UnitPrize,
};
procurements.Add(procurementVM);
}
return(Json(procurements));
}
public async Task <IActionResult> Edit(int id, [Bind("ProcurementID,ProcurementDate,Price,Quantity")] Procurement procurement)
{
if (id != procurement.ProcurementID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(procurement);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProcurementExists(procurement.ProcurementID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(procurement));
}
public bool Insert(ProcurementVM procurementVM)
{
var push = new Procurement(procurementVM);
var get = myContext.Item.Find(procurementVM.Item_Id);
if (get != null)
{
push.Item = get;
myContext.Procurement.Add(push);
var result = myContext.SaveChanges();
if (result > 0)
{
status = true;
return(status);
}
else
{
return(status);
}
}
else
{
return(status);
}
}
//change the procurement status and
public IActionResult ReorderConfirmed(int?id)
{
if (id == null)
{
return(View("Error", new string[] { "You need to specify an order id" }));
}
Procurement pro = _context.Procurements.Include(p => p.ProcurementDetails).ThenInclude(p => p.Book)
.FirstOrDefault(p => p.ProcurementID == id);
if (pro == null)
{
return(RedirectToAction("Index"));
}
AppUser user = _context.Users.FirstOrDefault(x => x.UserName == User.Identity.Name);
pro.AppUser = user;
pro.Completed = true;
_context.Procurements.Update(pro);
_context.SaveChanges();
foreach (ProcurementDetail pd in pro.ProcurementDetails)
{
Book bo = _context.Books.Include(b => b.ProcurementDetails).FirstOrDefault(b => b.BookID == pd.Book.BookID);
bo.QuantityOnOrder = bo.QuantityOnOrder + pd.Quantity;
_context.Books.Update(bo);
_context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public IActionResult AutomaticOrder(int[] IdsToAdd, string[] QuantityToAdd, Decimal Cost)
{
var query = from r in _context.Books select r;
//change to < r.ReplenishMinimum, exclude books on active procurement
List <Book> allBooks = new List <Book>();
allBooks = query.ToList();
List <Book> SelectedBooks = new List <Book>();
foreach (Book book in allBooks)
{
foreach (int id in IdsToAdd)
{
if (id == book.BookID)
{
SelectedBooks.Add(book);
}
}
}
Int16 Qt = Convert.ToInt16(QuantityToAdd);
foreach (Book b in SelectedBooks)
{
Procurement procurement = new Procurement();
procurement.Price = Cost;
//procurement.Quantity = Quantity;
}
return(View("Index"));
}
public ActionResult CreateProcurement([Bind(Include = "ProductId,PurchaseDate,Quantity,UnitPrize")] Procurement procurement)
{
ProductRepository productRepo = new ProductRepository(db);
ProcurementRepository procurementRepo = new ProcurementRepository(db);
List <ProcurementViewModel> procurements = new List <ProcurementViewModel>();
//將輸入資料儲存在資料庫
if (ModelState.IsValid)
{
db.Procurement.Add(procurement);
db.SaveChanges();
}
//抓取改變後的資料
foreach (Procurement item in procurementRepo.GetAll().ToList())
{
ProcurementViewModel procurementVM = new ProcurementViewModel()
{
ProductName = productRepo.GetProductNameByID(item.ProductId),
ProcurementId = item.ProcurementId,
PurchaseDate = item.PurchaseDate.ToString("yyyy/MM/dd hh:mm:ss"),
Quantity = item.Quantity,
UnitPrize = item.UnitPrize,
};
procurements.Add(procurementVM);
}
return(Json(procurements));
}
public void Should_ReturnExpectedResult_WithChangedColumnOrder(string header, string line)
{
var deserializeRowData = new DeserializeRowData <Procurement>();
var lineParser = new LineParser();
var expected = new Procurement
{
Project = "2",
Description = "Harmonize Lactobacillus acidophilus sourcing",
StartDate = "2014-01-01 00:00:00.000",
Category = "Dairy",
Responsible = "Daisy Milks",
SavingsAmount = "NULL",
Currency = "EUR",
Complexity = "Simple"
};
var headerColumnDictionary = lineParser.TabSeparatedParser(header);
var rowColumnDictionary = lineParser.TabSeparatedParser(line);
var actual = deserializeRowData.Deserialize(headerColumnDictionary, rowColumnDictionary, attributeMappings);
var expectedJsonString = JsonConvert.SerializeObject(expected);
var actualJsonString = JsonConvert.SerializeObject(actual);
Assert.Equal(expectedJsonString, actualJsonString);
}
private void confirmGoodButton_Click(object sender, RoutedEventArgs e)
{
IWareHouseDao whd = new WareHouseDao();
IProcurementDao ipd = new ProcementDao();
IGoodDao igd = new GoodDao();
Procurement procurment = new Procurement();
List <WareHouse> warehouseList = whd.getWareHouseList();
int warehouseid = Convert.ToInt32(warehouseBox.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < warehouseList.Count; j++)
{
if (warehouseid == warehouseList[j].WareHouseID)
{
procurment.WareHouse = warehouseList[j];
Good good = igd.getSingleGood(Convert.ToInt32(dt.Rows[i][0]));
Dictionary <Good, int> listgood_number = new Dictionary <Good, int>();
listgood_number.Add(good, Convert.ToInt32(dt.Rows[i][3]));
//procurment还需要自己添加一个自身employee信息
procurment.addGood(good, listgood_number[good]);
}
}
}
DateTime now = DateTime.Now;
procurment.WareHouse.WareHouseID = warehouseid;
procurment.Employee.EmployeeID = 0;
procurment.StorageTime = now;
ipd.addProcurement(procurment);
dt.Clear();
dataGridDetail.ItemsSource = dt.DefaultView;
}
public ActionResult DeleteConfirmed(int id)
{
Procurement procurement = db.Procurement.Find(id);
db.Procurement.Remove(procurement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void GetProcurementProducts()
{
products.Clear();
Procurement = (Procurement)listView.SelectedItems[0].Tag;
Procurement.ProductsWithPrice
.Select(keyValue => new KeyValuePair <Product, long>(keyValue.Key, keyValue.Value))
.ToList()
.ForEach(keyValue => products.Add(keyValue));
}
List <Procurement> IProcurementDao.getAllProcurementList(DateTime starttime, DateTime endtime)
{
List <Procurement> ProcurementList = new List <Procurement>();
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sql = "select *" +
" from procurement natural join wareHouse " +
" where :endtime >= storageTime and storageTime >= :starttime ";
OracleCommand cmd = new OracleCommand(sql, con);
cmd.Parameters.Add(":endtime", OracleDbType.TimeStamp);
cmd.Parameters.Add(":starttime", OracleDbType.TimeStamp);
// cmd.Parameters.Add(":id", OracleDbType.Int32);
cmd.Parameters[0].Value = endtime;
cmd.Parameters[1].Value = starttime;
// cmd.Parameters[2].Value = employeeID;
OracleDataReader DataReader = cmd.ExecuteReader();
while (DataReader.Read())
{
Procurement Procurement = new Procurement();
int id = int.Parse(DataReader["ProcurementID"].ToString());
DateTime time = (DateTime)DataReader["storageTime"];
int wareHouseId = int.Parse(DataReader["wareHouseID"].ToString());
int employeeId = int.Parse(DataReader["employeeID"].ToString());
string wareHouseName = DataReader["name"].ToString();
string wareHouseAddress = DataReader["address"].ToString();
WareHouse wareHouse = new WareHouse();
wareHouse.Name = wareHouseName;
wareHouse.Address = wareHouseAddress;
wareHouse.Address = wareHouseAddress;
Employee employee = new Employee();
employee.EmployeeID = employeeId;
Procurement.Employee = employee;
Procurement.ProcurementID = id;
Procurement.StorageTime = time;
Procurement.WareHouse = wareHouse;
ProcurementList.Add(Procurement);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
}
//MessageBox.Show(ProcurementList[0].ToString());
return(ProcurementList);
}
private void AddProcurementToListView(Procurement procurement)
{
ListViewItem item = new ListViewItem(procurement.PaymentDate.ToShortDateString());
item.SubItems.Add(procurement.IsRecieved ? procurement.RecieveDate.ToShortDateString() : "");
item.SubItems.Add(procurement.ToString());
item.SubItems.Add(procurement.TotalPrice.ToString());
item.Tag = procurement;
listView_Procurements.Items.Add(item);
}
private void CreateProcurementForm_Load(object sender, EventArgs e)
{
ProductsContainer.Instance.Load();
checkBox_recieved.Checked = false;
dateTimePicker_recieve.Enabled = false;
procurement = null;
products.Clear();
FillComboBox();
}
public async Task <IActionResult> Create([Bind("ProcurementID,ProcurementDate,Price,Quantity")] Procurement procurement)
{
if (ModelState.IsValid)
{
_context.Add(procurement);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(procurement));
}
public async Task <ActionResult> Edit([Bind(Include = "id_procurement,date_procurement,cost_procurement,count_procurement,id_storage,id_product")] Procurement procurement)
{
if (ModelState.IsValid)
{
db.Entry(procurement).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(procurement));
}
public async Task <IActionResult> DeleteConfirmed(int id)
{
var pd = await _context.ProcurementDetails.FindAsync(id);
Procurement pro = _context.Procurements.FirstOrDefault(r => r.ProcurementDetails.Any(p => p.ProcurementDetailID == id));
_context.ProcurementDetails.Remove(pd);
await _context.SaveChangesAsync();
return(RedirectToAction("EditOrder", "Procurements", new { id = pro.ProcurementID }));
}
public ActionResult Edit([Bind(Include = "ProcurementId,ProductId,PurchaseDate,Quantity,UnitPrize")] Procurement procurement)
{
if (ModelState.IsValid)
{
db.Entry(procurement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Name", procurement.ProductId);
return(View(procurement));
}
private Procurement ToEntity(ProcurementDTO DTO)
{
var DTOValue = new Procurement()
{
NameSeller = DTO.NameSeller,
ContactSeller = DTO.ContactSeller,
ProductName = DTO.ProductName,
ProductPrice = DTO.ProductPrice,
};
return(DTOValue);
}
private void Button_Delete_Click(object sender, EventArgs e)
{
Procurement selectedProcurement = listView_Procurements.SelectedItems[0].Tag as Procurement;
if (selectedProcurement is null)
{
MessageBox.Show("Выберите элемент, который вы хотите удалить!", "Удаление", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
ProcurementsContainer.Instance.Delete(selectedProcurement);
RefreshListView();
}
public async Task <IActionResult> Create([Bind("ProcurementID,ProcurementDate,SupplierID,DeliveryNoteNumber,MerchandiseName,MeasureUnit,UnitPrice,Quantity")] Procurement procurement)
{
if (ModelState.IsValid)
{
procurement.TotalPrice = procurement.UnitPrice * procurement.Quantity;
_context.Add(procurement);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["SupplierID"] = new SelectList(_context.Suppliers, "SupplierID", "SupplierName", procurement.SupplierID);
return(View(procurement));
}
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Procurement procurement = await db.Procurements.Include(x => x.product).SingleOrDefaultAsync(i => i.id_procurement == id);
if (procurement == null)
{
return(HttpNotFound());
}
return(View(procurement));
}
private static string GetDonors(Procurement procurement)
{
var donorList = procurement.ProcurementDonors.Select(GetDonorDisplayString()).Aggregate((working, next) => working + "; " + next);
return donorList;
}
private static string GetBusinessName(Procurement procurement)
{
return procurement.ProcurementDonors.FirstOrDefault().Donor.BusinessName;
}
public static SerializableProcurement ConvertProcurementToSerializableProcurement(Procurement procurement)
{
return new SerializableProcurement()
{
CatalogNumber = procurement.CatalogNumber,
Description = procurement.Description,
Procurement_ID = procurement.Procurement_ID,
Year = procurement.ContactProcurement.Auction.Year,
AuctionNumber = procurement.AuctionNumber,
ItemNumber = procurement.ItemNumber,
Quantity = procurement.Quantity,
EstimatedValue = procurement.EstimatedValue,
SoldFor = procurement.SoldFor,
Category_ID = procurement.Category_ID,
CategoryName = procurement.Category == null ? "" : procurement.Category.CategoryName,
GeoLocation_ID = procurement.ContactProcurement.Donor == null ? null : procurement.ContactProcurement.Donor.GeoLocation_ID,
GeoLocationName = (procurement.ContactProcurement.Donor == null || procurement.ContactProcurement.Donor.GeoLocation == null) ? "" : procurement.ContactProcurement.Donor.GeoLocation.GeoLocationName,
PerItemValue = procurement.PerItemValue,
BusinessName = GetBusinessName(procurement),
Donors = GetDonors(procurement),
Procurer_ID = procurement.Procurement_ID,
ProcurerName = procurement.ContactProcurement.Procurer == null ? "" : procurement.ContactProcurement.Procurer.FirstName + " " + procurement.ContactProcurement.Procurer.LastName,
Notes = procurement.Notes,
Donation = procurement.Donation,
ThankYouLetterSent = procurement.ThankYouLetterSent,
Certificate = procurement.Certificate,
Limitations = procurement.Limitations,
CreatedOn = procurement.CreatedOn,
ProcurementType_ID = procurement.ProcurementType_ID,
ProcurementType = procurement.ProcurementType == null ? "" : procurement.ProcurementType.ProcurementTypeDesc,
Title = procurement.Title
};
}
