//test CreatPOItem protected void ButtonAddNew_Click(object sender, EventArgs e) { using (PurchaseOrderManager pom = new PurchaseOrderManager()) { PurchaseOrderItem item = pom.FindPurchaseOrderItemByID(509); PurchaseOrderItem newItem = new PurchaseOrderItem(); newItem.QuantityToOrder = item.QuantityToOrder; newItem.StationeryID = item.StationeryID; newItem.PurchaseOrderID = item.PurchaseOrderID; newItem.Price = item.Price; newItem.DeliveryRemarks = item.DeliveryRemarks; PurchaseOrderItem newItem1 = pom.CreatePurchaseOrderItem(newItem); } }
// create Purchase Order and together with Purchase Order Items protected void btnSubmit_Click(object sender, EventArgs e) { //justify how many suppliers involed List<Supplier> suppliers = SupplierInvolved(); using (PurchaseOrderManager pom = new PurchaseOrderManager()) { foreach (Supplier s in suppliers) { PurchaseOrder purchaseOrder = new PurchaseOrder(); purchaseOrder.PONumber = pom.CreatePONumber(); purchaseOrder.DateOfOrder = DateTime.Now; purchaseOrder.AttentionTo = Convert.ToInt32(ddlAttentionTo.SelectedValue); purchaseOrder.CreatedBy = Membership.GetCurrentLoggedInUser().UserID; purchaseOrder.IsDelivered = false; DateTimeFormatInfo dtfi = new DateTimeFormatInfo(); dtfi.ShortDatePattern = "MM/dd/yyyy"; dtfi.DateSeparator = "/"; purchaseOrder.DateToSupply = Convert.ToDateTime(txtDateToSupply.Text, dtfi); purchaseOrder.SupplierID = s.SupplierID; foreach (GridViewRow r in gvPOItems.Rows) { if (Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString()) == s.SupplierID) { PurchaseOrderItem item = new PurchaseOrderItem(); item.PurchaseOrder = purchaseOrder; item.StationeryID = (int)gvPOItems.DataKeys[r.RowIndex].Value; //item.QuantityToOrder = 5; item.QuantityToOrder = Convert.ToInt32(((TextBox)r.FindControl("txtRecommend")).Text.ToString()); using (CatalogManager cm = new CatalogManager()) { StationeryPriceSearchDTO criteria = new StationeryPriceSearchDTO(); criteria.SupplierID = Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString()); criteria.StationeryID = (int)item.StationeryID; item.Price = cm.FindStationeryPricesByCriteria(criteria)[0].Price; // record supplier ID for the PO purchaseOrder.SupplierID = criteria.SupplierID; } purchaseOrder.PurchaseOrderItems.Add(item); // only this way works } } pom.CreatePurchaseOrder(purchaseOrder); } } }
public void DeletePurchaseOrderItem(PurchaseOrderItem purchaseOrderItem) { try { using (TransactionScope ts = new TransactionScope()) { this.context.PurchaseOrderItems.Attach(purchaseOrderItem); this.context.PurchaseOrderItems.DeleteObject(purchaseOrderItem); this.context.SaveChanges(); ts.Complete(); } } catch (Exception) { throw; } }
public PurchaseOrderItem CreatePurchaseOrderItem(PurchaseOrderItem purchaseOrderItem) { try { using (TransactionScope ts = new TransactionScope()) { this.context.PurchaseOrderItems.AddObject(purchaseOrderItem); this.context.SaveChanges(); ts.Complete(); return purchaseOrderItem; } } catch (Exception) { throw; } }
protected void btnSubmit_Click(object sender, EventArgs e) { List<Supplier> suppliers = SupplierInvolved(); using (PurchaseOrderManager pom = new PurchaseOrderManager()) { foreach (Supplier s in suppliers) { PurchaseOrder purchaseOrder = new PurchaseOrder(); purchaseOrder.PONumber = pom.CreatePONumber(); purchaseOrder.DateOfOrder = DateTime.Now; purchaseOrder.AttentionTo = Convert.ToInt32(ddlAttentionTo.SelectedValue); purchaseOrder.CreatedBy = Membership.GetCurrentLoggedInUser().UserID; purchaseOrder.IsDelivered = false; DateTimeFormatInfo dtfi = new DateTimeFormatInfo(); dtfi.ShortDatePattern = "MM/dd/yyyy"; dtfi.DateSeparator = "/"; purchaseOrder.DateToSupply = Convert.ToDateTime(txtDateToSupply.Text, dtfi); purchaseOrder.SupplierID = s.SupplierID; foreach (GridViewRow r in gvPOItems.Rows) { if (Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue.ToString()) == s.SupplierID) { PurchaseOrderItem item = new PurchaseOrderItem(); item.PurchaseOrder = purchaseOrder; item.SpecialStationeryID = (int)gvPOItems.DataKeys[r.RowIndex].Value; item.QuantityToOrder = Convert.ToInt32(((TextBox)r.FindControl("txtOrderQuantity")).Text.ToString()); item.Price = 5.0m; purchaseOrder.SupplierID = Convert.ToInt32(((DropDownList)r.FindControl("ddlSupplier")).SelectedValue); purchaseOrder.PurchaseOrderItems.Add(item); // only this way works } } pom.CreatePurchaseOrder(purchaseOrder); } } }
protected void ButtonAdd_Click(object sender, EventArgs e) { PurchaseOrderDAO poDAO = new PurchaseOrderDAO(); PurchaseOrder po = new PurchaseOrder(); DateTime t1 = new DateTime(2010, 12, 12); DateTime t2 = new DateTime(2010, 12, 20); po.SupplierID = 2; po.PONumber = "90000"; po.DateOfOrder = t1; po.DateToSupply = t2; po.AttentionTo = 2; po.CreatedBy = 2; po.DateReceived = t2; po.IsDelivered = false; PurchaseOrderItem poitem1 = new PurchaseOrderItem(); po.PurchaseOrderItems.Add(poitem1); PurchaseOrder savedPO = poDAO.CreatePurchaseOrder(po); //savedPO.PurchaseOrderID List<PurchaseOrderItem> poitems = savedPO.PurchaseOrderItems.ToList<PurchaseOrderItem>(); //poitems[0].PurchaseOrderItemID }
public PurchaseOrderItem UpdatePurchaseOrderItem(PurchaseOrderItem purchaseOrderItem) { try { PurchaseOrderItem purchaseOrderItemTemp = (from p in context.PurchaseOrderItems where p.PurchaseOrderItemID == purchaseOrderItem.PurchaseOrderItemID select p).FirstOrDefault(); if (purchaseOrderItemTemp != null) { purchaseOrderItemTemp.PurchaseOrderItemID = purchaseOrderItem.PurchaseOrderItemID; purchaseOrderItemTemp.StationeryID = purchaseOrderItem.StationeryID; purchaseOrderItemTemp.QuantityToOrder = purchaseOrderItem.QuantityToOrder; purchaseOrderItemTemp.PurchaseOrderID = purchaseOrderItem.PurchaseOrderID; purchaseOrderItemTemp.Price = purchaseOrderItem.Price; purchaseOrderItemTemp.DeliveryRemarks = purchaseOrderItem.DeliveryRemarks; // add more properties here } using (TransactionScope ts = new TransactionScope()) { this.context.SaveChanges(); ts.Complete(); return purchaseOrderItem; } } catch (Exception) { throw; } }
// CRUD for PurchaseOrderItem public PurchaseOrderItem CreatePurchaseOrderItem(PurchaseOrderItem item) { PurchaseOrderItem poItem = new PurchaseOrderItem(); try { if (ValidatePurchaseOrderItem(item, PurchaseOrderMethod.Create)) { poItem = purchaseOrderDAO.CreatePurchaseOrderItem(item); } } catch (Exception) { throw; } return poItem; }
// validate purchase order item private bool ValidatePurchaseOrderItem(PurchaseOrderItem item, PurchaseOrderMethod purchaseOrderItemMethod) { string errMsg = ""; try { if (item != null) { if (purchaseOrderItemMethod == PurchaseOrderMethod.Create) { errMsg = "Create Purchase Order item failed. Please try again later"; if (//(item.PurchaseOrderID != 0 || item.PurchaseOrder != null) && ((item.StationeryID != 0 && item.SpecialStationeryID == null) || ((item.StationeryID == null && item.SpecialStationeryID != 0))) && (item.QuantityToOrder != 0)) { return true; } } if (purchaseOrderItemMethod == PurchaseOrderMethod.Update) { errMsg = "Update Purchase Order item failed. Please try again later"; if ((item.PurchaseOrderID != 0 || item.PurchaseOrder != null) && // comment off because of current test database error // ((item.StationeryID != 0 && item.SpecialStationeryID == 0) || ((item.StationeryID == 0 && item.SpecialStationeryID != 0))) && (item.QuantityToOrder != 0)) { return true; } } } return false; } catch (Exception) { throw new PurchaseOrderException(errMsg); } }
public void DeletePurchaseOrderItem(PurchaseOrderItem item) { purchaseOrderDAO.DeletePurchaseOrderItem(item); }
/// <summary> /// Deprecated Method for adding a new object to the PurchaseOrderItems EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPurchaseOrderItems(PurchaseOrderItem purchaseOrderItem) { base.AddObject("PurchaseOrderItems", purchaseOrderItem); }
/// <summary> /// Create a new PurchaseOrderItem object. /// </summary> /// <param name="purchaseOrderItemID">Initial value of the PurchaseOrderItemID property.</param> /// <param name="purchaseOrderID">Initial value of the PurchaseOrderID property.</param> /// <param name="quantityToOrder">Initial value of the QuantityToOrder property.</param> /// <param name="price">Initial value of the Price property.</param> public static PurchaseOrderItem CreatePurchaseOrderItem(global::System.Int32 purchaseOrderItemID, global::System.Int32 purchaseOrderID, global::System.Int32 quantityToOrder, global::System.Decimal price) { PurchaseOrderItem purchaseOrderItem = new PurchaseOrderItem(); purchaseOrderItem.PurchaseOrderItemID = purchaseOrderItemID; purchaseOrderItem.PurchaseOrderID = purchaseOrderID; purchaseOrderItem.QuantityToOrder = quantityToOrder; purchaseOrderItem.Price = price; return purchaseOrderItem; }