/// <summary>
/// William Flood
/// Created:
/// 2017/03/29
///
/// Adds a new supplier inventory to the database.
/// </summary>
///
/// <remarks>
/// Aaron Usher
/// Updated:
/// 2017/04/21
///
/// Standardized method.
/// </remarks>
///
/// <param name="supplierInventory">The supplier inventory to add</param>
/// <returns>Rows affected.</returns>
public static int CreateSupplierInventory(SupplierInventory supplierInventory)
{
var rows = 0;
var conn = DBConnection.GetConnection();
var cmdText = @"sp_create_supplier_inventory";
var cmd = new SqlCommand(cmdText, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AGREEMENT_ID", supplierInventory.AgreementID);
cmd.Parameters.AddWithValue("@DATE_ADDED", supplierInventory.DateAdded);
cmd.Parameters.AddWithValue("@QUANTITY", supplierInventory.Quantity);
try
{
conn.Open();
rows = cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
return(rows);
}
List <SupplierInventory> GetSupplierInventory()
{
List <SupplierInventory> supplierInventories = new List <SupplierInventory>();
List <Inventory> inventory = (List <Inventory>) Controller <RosePurchaseManagementEntities, Inventory> .GetEntitiesWithIncluded("BoxInventories", "Farm");
List <Box> box = (List <Box>) Controller <RosePurchaseManagementEntities, Box> .GetEntitiesWithIncluded("BoxInventories");
foreach (Inventory inventories in inventory)
{
foreach (BoxInventory boxes in inventories.BoxInventories)
{
SupplierInventory supplierInventory = new SupplierInventory()
{
InventoryID = inventories.InventoryID,
FarmID = inventories.FarmID,
FarmName = inventories.Farm.FarmName,
Price = inventories.Price_per_stem,
Quantity = boxes.Quantity,
};
using (RosePurchaseManagementEntities context = new RosePurchaseManagementEntities())
{
var roseName = context.RoseSizes.Include("Rose").Where(x => x.RoseSizeID == inventories.RoseSizeID).Select(r => r.Rose.RoseName).FirstOrDefault();
supplierInventory.RoseName = roseName;
}
supplierInventories.Add(supplierInventory);
}
}
return(supplierInventories);
}
public void NewPurchaseOrderDetail(string orderid, string supid, List <ItemWithQtyModel> ItemList)
{
try
{
for (int i = 0; i < ItemList.Count; i++)
{
OrderListDetail old = new OrderListDetail();
if (ItemList[i].Qty != 0)
{
string id = ItemList[i].Item_ID;
int qty = ItemList[i].Qty;
old.Order_ID = orderid;
old.Item_ID = id;
old.Needed_Qty = qty;
var q = from x in context.SupplierInventories where x.Item_ID == id && x.Supplier_ID == supid select x;
SupplierInventory si = q.First();
si.Inventory_Qty = si.Inventory_Qty - old.Needed_Qty;
context.OrderListDetails.Add(old);
context.SaveChanges();
}
}
}
catch (Exception e)
{
e.Source = "Create purchase order detail fail!";
}
}
public bool CancelPurchaseOrder(string orderID, string remark)
{
try
{
var q = from x in context.OrderLists where x.Order_ID == orderID select x;
OrderList ol = q.First();
var p = from x in context.OrderListDetails where x.Order_ID == orderID select x;
foreach (OrderListDetail od in p.ToList())
{
var r = from x in context.SupplierInventories where x.Item_ID == od.Item_ID && x.Supplier_ID == ol.Supplier_ID select x;
SupplierInventory si = r.First();
si.Inventory_Qty = si.Inventory_Qty + od.Needed_Qty;
}
ol.Status = "Cancelled";
ol.Finish_Date = DateTime.Now;
if (remark != "")
{
ol.Remark = remark;
}
else
{
ol.Remark = "Cancelled";
}
context.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
//CRUD supplier for specific stock item
private void AddButton_Click(object sender, EventArgs e)
{
SupplierInventory si = getSupplierInventoryItem();
int id = ctr.addSupplierInventory(si);
MessageBox.Show("Add success!\n Your user ID is " + id.ToString(),
"Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
reset();
}
/// <summary>
/// Created 2017-03-29 by William Flood
/// </summary>
/// <param name="toAdd"></param>
/// <returns></returns>
public int CreateSupplierInventory(SupplierInventory toAdd)
{
try
{
return(SupplierInventoryAccessor.CreateSupplierInventory(toAdd));
} catch
{
throw;
}
}
/// <summary>
/// William Flood
/// Created: 2017/03/30
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPost_Click(object sender, RoutedEventArgs e)
{
int?agreementId = null;
int?quantity = null;
int parsedQuantity;
if (Int32.TryParse(txtQuantity.Text, out parsedQuantity))
{
quantity = parsedQuantity;
}
else
{
MessageBox.Show("Quantity needs an integer");
return;
}
if (cboAgreement.SelectedIndex >= 0)
{
agreementId = _agreementList[cboAgreement.SelectedIndex].AgreementId;
}
else
{
MessageBox.Show("Select an agreement");
return;
}
if (null == dpDateAdded.SelectedDate)
{
MessageBox.Show("Select a date");
return;
}
try
{
var toAdd = new SupplierInventory()
{
AgreementID = agreementId,
DateAdded = dpDateAdded.SelectedDate,
Quantity = quantity
};
_supplyInventorymanager.CreateSupplierInventory(toAdd);
MessageBox.Show("Inventory saved");
this.Close();
} catch (Exception ex)
{
if (null != ex.InnerException)
{
MessageBox.Show(ex.Message + "\n\n" + ex.InnerException.Message);
}
else
{
MessageBox.Show(ex.Message);
}
}
}
public void AddSupplierInventory(SupplierInventoryDto value)
{
var supplierInventory = new SupplierInventory
{
Id = value.ID,
SupplierStandardInventoryId = value.SupplierStandardInventoryId,
Qty = value.Qty,
UnitPrice = value.UnitPrice,
AvailableQty = value.AvailableQty,
ProcessingQty = value.ProcessingQty,
InventoryDate = DateTime.Now
};
this.supplierInventoryDataService.AddSupplierInventory(supplierInventory);
}
public static void UpdateSupplierInventory(SupplierInventory inventory, string buyerLinkedSku)
{
var requestUrl = $"buyerinventoryservice/rest/linkitem/{Key}";
var request = new RestRequest(requestUrl, Method.POST);
var body = new
{
BuyerSKU = buyerLinkedSku,
SupplierId = inventory.SupplierId.Value,
SupplierSKU = inventory.SupplierSku
};
request.AddJsonBody(body);
var response = Client.Execute <ApiResult <BuyerInventoryLinkItemResult> >(request);
if (response.StatusCode != HttpStatusCode.OK)
{
throw new Exception("Error linking the buyer inventory item");
}
}
private void UpdateButton_Click(object sender, EventArgs e)
{
SupplierInventory si = getSupplierInventoryItem();
try
{
si.ID = int.Parse(textBoxID.Text);
}
catch (Exception)
{
MessageBox.Show("Input supplier ID first.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
ctr.updateSupplierInventory(si);
MessageBox.Show("Update success!\n ",
"Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
reset();
}
private SupplierInventory getSupplierInventoryItem()
{
int supID = 0;
try
{
supID = int.Parse(SupplierTextBox.Text);
}
catch (Exception)
{
MessageBox.Show("Input supplier ID first.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
SupplierInventory si = new SupplierInventory();
si.ItemID = stockID;
si.SupplierID = supID;
return(si);
}
internal void updateSupplierInventory(SupplierInventory si)
{
siDAL.updateItem(si);
}
internal int addSupplierInventory(SupplierInventory si)
{
return(siDAL.addItem(si));
}
public void UpdateSupplierInventory(SupplierInventory supplierInventory)
{
databaseContext.SupplierInventory.Update(supplierInventory);
databaseContext.SaveChanges();
}
public void AddSupplierInventory(SupplierInventory supplierInventory)
{
databaseContext.SupplierInventory.Add(supplierInventory);
databaseContext.SaveChanges();
}
