/// <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;
}
