/// <summary> /// Gets a collection of PurchaseOrderItem objects by a PurchaseOrder object. /// </summary> /// <param name="purchaseorder_">purchaseorder_</param> /// <returns>A collection PurchaseOrderItem objects.</returns> public static EntityList<PurchaseOrderItem> GetPurchaseOrderItemsBypurchaseorder_(PurchaseOrder @purchaseorder_) { string commandText = "PurchaseOrderItemGetByPurchaseOrder"; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@purchaseorder_id", @purchaseorder_.purchaseorder_id)); return GetList<PurchaseOrderItem>(@purchaseorder_, commandText, parameters); }
/// <summary> /// Gets a collection of PurchaseOrderItem objects by a PurchaseOrder object. /// </summary> /// <param name="purchaseOrder">purchaseOrder</param> /// <param name="orderBy"></param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRows"></param> /// <returns>A collection PurchaseOrderItem objects.</returns> protected static EntityList<PurchaseOrderItem> GetPurchaseOrderItemsBypurchaseorder_(PurchaseOrder @purchaseorder_, string orderBy, long startRowIndex, int pageSize, out long totalRows) { string commandText = @" FROM [dbo].[PurchaseOrderItems] WHERE [PurchaseOrderItems].[purchaseorder_id] = @purchaseorder_id "; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@purchaseorder_id", @purchaseorder_.purchaseorder_id)); return GetList<PurchaseOrderItem>(SelectFieldList, commandText, parameters, orderBy, startRowIndex, pageSize, out totalRows); }
/// <summary> /// Deletes PurchaseOrderItem objects by a PurchaseOrder object. /// </summary> /// <param name="purchaseOrder">purchaseOrder</param> public static void DeletePurchaseOrderItemsBypurchaseorder_(PurchaseOrder purchaseOrder) { string commandText = "PurchaseOrderItemDeleteByPurchaseOrder"; System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>(); parameters.Add(new SqlParameter("@purchaseorder_id", purchaseOrder.purchaseorder_id)); using (SqlHelper helper = new SqlHelper()) { helper.Execute(commandText, CommandType.StoredProcedure, parameters); } }
/// <summary> /// Create a new PurchaseOrderItem object from a PurchaseOrder object. /// </summary> /// <param name="purchaseorder_">purchaseorder_</param> /// <returns>The newly created PurchaseOrderItem object.</returns> public static PurchaseOrderItem CreatePurchaseOrderItemBypurchaseorder_(PurchaseOrder @purchaseorder_) { PurchaseOrderItem purchaseOrderItem = InitializeNew<PurchaseOrderItem>(); purchaseOrderItem.purchaseorder_id = @purchaseorder_.purchaseorder_id; purchaseOrderItem.purchaseorder_ = @purchaseorder_; return purchaseOrderItem; }
protected void Page_Load(object sender, EventArgs e) { loggedInAdmin = Helpers.GetLoggedInAdmin(); homeCompany = Helpers.GetCurrentCompany(); currentOrder = Helpers.GetRequestedPurchaseOrder(); permission = AllowedStore.GetAllowedStoreByCustomerSupplier(homeCompany.company_id, currentOrder.supplier_id); if (!(Helpers.IsAuthorizedAdmin(loggedInAdmin, homeCompany))) { Response.Redirect("/status.aspx?error=notadmin"); } else if (!(currentOrder.customer_id == homeCompany.company_id || currentOrder.supplier_id == homeCompany.company_id)) { Response.Redirect("/status.aspx?error=genericerror"); } if (!IsPostBack) { PopulateDetails(); PopulateOrderItems(); PopulaterInvoices(); } if (currentOrder.is_submitted) { StatusLabel.Text = "Submitted and waiting for fulfillment"; EditableOrderItemsGridView.Visible = false; } else if (currentOrder.InvoicesBypurchaseorder_.Count > 0) { StatusLabel.Text = "Fulfilled"; EditableOrderItemsGridView.Visible = false; } else { StatusLabel.Text = "Waiting to submit"; if (currentOrder.customer_id == homeCompany.company_id) { SubmitButton.Visible = true; FindProductPanel.Visible = true; } EditableOrderItemsGridView.Visible = true; FrozenOrderItemsGridView.Visible = false; } }
/// <summary> /// Gets a collection of Invoice objects by a PurchaseOrder object. /// </summary> /// <param name="purchaseOrder">purchaseOrder</param> /// <param name="startRowIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRows"></param> /// <returns>A collection Invoice objects.</returns> public static EntityList<Invoice> GetInvoicesBypurchaseorder_(PurchaseOrder @purchaseorder_, long startRowIndex, int pageSize, out long totalRows) { string commandText = @" FROM [dbo].[Invoices] WHERE [Invoices].[purchaseorder_id] = @purchaseorder_id "; List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@purchaseorder_id", @purchaseorder_.purchaseorder_id)); return GetList<Invoice>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows); }
/// <summary> /// Create a new Invoice object from a PurchaseOrder object. /// </summary> /// <param name="purchaseorder_">purchaseorder_</param> /// <returns>The newly created Invoice object.</returns> public static Invoice CreateInvoiceBypurchaseorder_(PurchaseOrder @purchaseorder_) { Invoice invoice = InitializeNew<Invoice>(); invoice.purchaseorder_id = @purchaseorder_.purchaseorder_id; invoice.purchaseorder_ = @purchaseorder_; return invoice; }