public void Add_UnorderedPart(UnorderedPurchaseItemCart item)
{
using (var context = new eBikesContext())
{
context.UnorderedPurchaseItemCarts.Add(item);
context.SaveChanges();
}
} //eom
public void Add_UnorderedItemToCart(UnorderedPurchaseItemCart item)
{
using (var context = new eToolsContext())
{
context.UnorderedPurchaseItemCart.Add(item);
context.SaveChanges();
}
}
public int Remove_UnorderedVendorPart(UnorderedPurchaseItemCart itemDelete)
{
using (var context = new eBikeContext())
{
var item = context.UnorderedPurchaseItemCarts.Find(itemDelete.CartID);
context.UnorderedPurchaseItemCarts.Remove(item);
return(context.SaveChanges());
}
}
public void UnOrderReturns_Delete(UnorderedPurchaseItemCart item)
{
using (var context = new eToolsContext())
{
var existing = context.UnorderedPurchaseItemCarts.Find(item.CartID);
context.UnorderedPurchaseItemCarts.Remove(existing);
context.SaveChanges();
}
}// part-three, Delete button
public int Add_UnorderedVendorPart(UnorderedPurchaseItemCart itemAdd)
{
using (var context = new eBikeContext())
{
//itemAdd.PurchaseOrderNumber = poNumber;
itemAdd = context.UnorderedPurchaseItemCarts.Add(itemAdd);
context.SaveChanges();
return(itemAdd.CartID);
}
}
public void UnOrderedReturns_Add(UnorderedPurchaseItemCart item)
{
using (var context = new eToolsContext())
{
// var purchaseorderid = context.PurchaseOrders.Find(item.PurchaseOrderID);
context.UnorderedPurchaseItemCarts.Add(item);
//context.UnorderedPurchaseItemCarts.Add();
context.SaveChanges();
}
}// part-three, Insert button.
/// <summary>
/// Inserts an unordered purchase item to the database
/// </summary>
/// <param name="_upic"></param>
public int UPIC_Add(UnorderedPurchaseItemCart _upic)
{
using (var context = new eToolsContext())
{
// Stage instance for physical insertion
context.UnorderedPurchaseItemCart.Add(_upic);
// Commit the changes to the database
context.SaveChanges();
// Output of the generated identity ID
return(_upic.CartID);
}
}
public void AddUnorderedItem(UnorderedPart item)
{
using (var context = new eBikesContext())
{
var unorderedPart = new UnorderedPurchaseItemCart()
{
PurchaseOrderNumber = item.PONumber,
Description = item.Description,
Quantity = item.Quantity,
VendorPartNumber = item.VendorPartNumber
};
context.UnorderedPurchaseItemCarts.Add(unorderedPart);
context.SaveChanges();
}
}
public void Delete_UnOrderedParts(UnorderedPurchaseItemCart item)
{
Delete_UnorderedPart(item.CartID);
}
protected void InsertButton_Click(object sender, EventArgs e)
{
bool qtyIsValid = true;
MessageUserControl.TryRun(() =>
{
UnorderedPurchaseItemCartController sysmgr = new UnorderedPurchaseItemCartController();
UnorderedPurchaseItemCart upic = new UnorderedPurchaseItemCart();
// Load data from insert row into a new UPIC instance
upic.PurchaseOrderID = int.Parse(PurchaseOrderID.Text);
upic.Description = (ReturnList.InsertItem.FindControl("DescriptionTextBox") as TextBox).Text;
upic.VendorStockNumber = (ReturnList.InsertItem.FindControl("VendorStockNumberTextBox") as TextBox).Text;
TextBox qtyTextBox = (ReturnList.InsertItem.FindControl("QuantityTextBox") as TextBox);
int qty;
// Validate user entry
if (int.TryParse(qtyTextBox.Text, out qty))
{
if (qty > 0)
{
upic.Quantity = qty;
}
else // Invalid entry
{
qtyIsValid = false;
}
}
else // Invalid entry
{
qtyIsValid = false;
}
SetTextBoxValidity(qtyTextBox, qtyIsValid);
// Only continue with insert if a valid qty is entered
if (qtyIsValid)
{
// Send UPIC to the BLL for insertion - Receive identity ID for record
int cartID = sysmgr.UPIC_Add(upic);
// Restore data from previous postbacks
CartIDs = Session["Session_CartList"] as List <int>;
// Add identity ID to the temporary list
CartIDs.Add(cartID);
// Save data to session for future postbacks
Session["Session_CartList"] = CartIDs;
// Refresh list
ReloadReturnList(sysmgr);
}
},
"Return Added",
"Unordered return successfully recorded");
// Specific validity message
if (!qtyIsValid)
{
MessageUserControl.ShowInfo(
"Invalid Quantity",
"Quantity is required to be greater than zero and a valid number");
}
}
