private void buttonAddSupply_Click(object sender, EventArgs e)
{
var Supply = new Supply();
Supply.providerID = db.providers.Select(x => x).Where(x => x.name == providerIDComboBox.Text).FirstOrDefault().providerID;
Supply.date = System.DateTime.Now;
Supply.employeeID = Settings.userID;
db.supplies.Add(Supply);
db.SaveChanges();
foreach (DataGridViewRow row in SupplyProductsDataGridView.Rows)
{
if (row.Cells[0].Value != null)
{
int pr = Convert.ToInt32(row.Cells[0].Value);
var product = new SupplyProduct();
product.count = Convert.ToInt32(row.Cells[1].Value);
product.supplyID = Supply.supplyID;
product.productID = db.products.FirstOrDefault(x => x.productID == pr).productID;
db.supplyProducts.Add(product);
}
}
db.SaveChanges();
MessageBox.Show("Заказ на поставку оформлен!");
}
public SupplyProductView(SupplyProduct supply)
{
ProductID = supply.ProductID;
Product = supply.Product;
Quantity = supply.Quantity;
Price = supply.Price;
}
private void buttonOK_Click(object sender, EventArgs e)
{
ContractSupply c = new ContractSupply();
List <SupplyProduct> lsp = new List <SupplyProduct>();
SupplyProduct sp = new SupplyProduct();
c.wasReceived = (bool)comboBoxWasReceived.SelectedValue;
c.numberOfSupply = Int32.Parse(textBox2.Text);
c.ContractorId = (int)comboBoxContractors.SelectedValue;
sp.ProductId = (int)comboBoxProducts.SelectedValue;
sp.Amount = Int32.Parse(textBoxAmount.Text);
lsp.Add(sp);
c.SupplyProducts = lsp;
c.Date = dateTimePicker1.Value.Date;
if (Id == -1)
{
query.queryAddContractSupply(c);
}
else
{
c.Id = Id;
query.queryUpdateContractSupply(c);
}
instance.refreshGrid();
this.Dispose();
}
public SuppliedProduct(SupplyProduct command)
{
Id = command.Id;
ProductId = command.ProductId;
SupplierId = command.SupplierId;
ShopId = command.ShopId;
Amount = command.Amount;
ProcurementCost = command.ProcurementCost;
Type = command.Type;
}
private SupplyProduct SupplyProductWriteOff(SupplyProduct obj, int amount)
{
obj.StockAmount -= amount;
if (obj.RealizationAmount > amount)
{
obj.RealizationAmount -= amount;
}
else
{
obj.RealizationAmount = 0;
}
obj.TotalAmount -= amount;
return(obj);
}
public IEnumerable <SupplyProduct> GetSupplyProducts()
{
return(SupplyProduct.GetSupplies(GetSupplies()));
}
public void Supply(SupplyProductVM obj)
{
var product = _productService.All().FirstOrDefault(x => x.Title == obj.Name && x.ShopId == obj.ShopId);
if (product == null)
{
var productForCopy = _productService.All().FirstOrDefault(x => x.Id == obj.ProductId);
product = _productService.Create(new Product()
{
Title = productForCopy.Title,
Code = productForCopy.Code,
Reserv = productForCopy.Reserv,
BookingAmount = 0,
Cost = productForCopy.Cost,
CategoryId = productForCopy.CategoryId,
ShopId = obj.ShopId,
});
}
var supplyHistory = _supplyHistoryService.Create(new SupplyHistory());
InfoProduct info;
if (obj.SupplierId != 0)
{
info = new InfoProduct()
{
Amount = obj.Amount,
Date = DateTime.Now.AddHours(3),
ProductId = product.Id,
ShopId = product.ShopId,
SupplierId = obj.SupplierId,
Type = InfoProductType.Supply,
SupplyHistoryId = supplyHistory.Id
};
var supplyProduct = new SupplyProduct()
{
ProductId = product.Id,
SupplierId = obj.SupplierId,
TotalAmount = obj.Amount,
RealizationAmount = obj.Realization == SupplyType.ForRealization ? obj.Amount : 0,
AdditionalCost = obj.AdditionalCost / obj.Amount,
ProcurementCost = obj.ProcurementCost / obj.Amount,
FinalCost = (obj.ProcurementCost / obj.Amount) + (obj.AdditionalCost / obj.Amount),
StockAmount = obj.Amount,
SupplyHistoryId = supplyHistory.Id
};
_postgresContext.ProductOperations.Add(new ProductOperation(
product.Id,
obj.Amount,
DateTime.Now.AddHours(3),
obj.ProcurementCost / obj.Amount,
obj.Realization == SupplyType.ForRealization,
obj.SupplierId,
StorageType.Shop));
_postgresContext.SaveChanges();
_supplyProductService.Create(supplyProduct);
if (obj.Realization == SupplyType.DeferredPayment)
{
_deferredSupplyProductService.Create(new DeferredSupplyProduct()
{
Date = obj.Date,
SupplyProductId = supplyProduct.Id
});
}
}
else
{
var supply = _supplyProductService.Create(new SupplyProduct()
{
ProductId = product.Id,
TotalAmount = obj.Amount,
RealizationAmount = obj.Realization == SupplyType.ForRealization ? obj.Amount : 0,
AdditionalCost = obj.AdditionalCost / obj.Amount,
ProcurementCost = obj.ProcurementCost / obj.Amount,
FinalCost = (obj.ProcurementCost / obj.Amount) + (obj.AdditionalCost / obj.Amount),
StockAmount = obj.Amount,
SupplyHistoryId = supplyHistory.Id
});
info = new InfoProduct()
{
Amount = obj.Amount,
Date = DateTime.Now.AddHours(3),
ProductId = product.Id,
ShopId = product.ShopId,
Type = InfoProductType.Supply,
SupplyHistoryId = supplyHistory.Id,
};
}
_infoProductService.Create(info);
}
