public warehouse Insert_warehouse_select(int ID)
{
warehouse = warehouse.Select(ID);
Insert_warehouse_name_txt.Text = Convert.ToString(warehouse.warehouse_name);
Insert_address_id_txt.Text = Convert.ToString(warehouse.address_id);
Insert_warehouse_type_txt.Text = Convert.ToString(warehouse.warehouse_type);
Insert_Location_ID_txt.Text = Convert.ToString(warehouse.Location_ID);
return(warehouse);
}
protected void view_btn_Click(object sender, EventArgs e)
{
ChooseCPL.ClientState = "true";
ChooseCPL.Collapsed = true;
ChooseCPL.CollapsedText = "Search For a Different Warehouse";
warehouseViewInfoHead.Visible = true;
warehouseViewInfoBody.Visible = true;
warehouseInformation_L.Text = warehouseInformation_L_hf.Value;
//sdsProductType.SelectCommand += "and warehouse_id = " + Convert.ToString(passWarehouseID_hf.Value);
GlobalVariables.WarehouseID = Convert.ToInt32(passWarehouseID_hf.Value);
warehouse = warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(warehouse.address_id);
//warehouse_product_Location = warehouse_product_Location.Select()
name_txt.Text = warehouse.warehouse_name.ToString();
address_txt.Text = address.str_add.ToString() + "" + address.city.ToString() + ", " + address.state.ToString() + "" + address.zip_plus_four.ToString();
type_txt.Text = warehouse.warehouse_type.ToString();
int returnValue = getWarehouseProductQty(GlobalVariables.WarehouseID);
amountOfResources_txt.Text = Convert.ToString(returnValue);
}
protected void updateDatabase()
{
//product_id_array has all product ids
call_center = call_center.Select(Convert.ToInt32(DDL_Call_Center.SelectedValue));
selected_Warehouse = selected_Warehouse.Select(Convert.ToInt32(passWarehouseID_hf.Value));
address = address.Select(selected_Warehouse.address_id);
//case_intake
case_intake = case_intake_insert();
//encounter
encounter = encounter_insert();
//requestor
requestor = requestor_insert();
//requestor_Order
requestor_Order = requestor_Order_insert();
//Order_product
Order_Product = Order_Product_insert();
}
protected void createInvoicePreview()
{
//create invoice preview
final_invoice_div.Style.Add("display", "block");
FINAL_to_Name_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_CompanyName_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_StreetAddress_L.Text = address.str_add;
FINAL_to_CityStateZip_L.Text = address.city + " " + address.state + " " + address.zip_plus_four;
FINAL_caseNumber_L.Text = "Case #/Order #: " + case_intake.case_id + " / " + requestor_Order.OrderID;
FINAL_date_L.Text = Convert.ToString(DateTime.Now);
for (int i = 0; i < product_id_array.Length; i++)
{
products = products.Select(Convert.ToInt32(product_id_array[i]));
warehouse_product_location = warehouse_product_location.Select_By_Product_ID(products.product_id);
warehouse = warehouse.Select(warehouse_product_location.warehouse_id);
checkWarehouseIDs.Add(warehouse.warehouse_id);
for (int j = 0; j < checkWarehouseIDs.Count; j++)
{
if (warehouse.warehouse_id != checkWarehouseIDs[j] || checkWarehouseIDs.Count == 1)
{
selectedWarehouseIDs.Add(warehouse.warehouse_id);
}
}
int itemNum = i + 1;
FINAL_orderNum_div.InnerHtml += itemNum + "<br/>";
FINAL_ProductID_and_WarehouseID_div.InnerHtml += products.product_id + " / " + warehouse.warehouse_id + "<br/>";
FINAL_orderQTY_div.InnerHtml += 1 + "<br/>";
FINAL_orderDESCRIPTION_div.InnerHtml += products.product_name + "<br/>";
}
FINAL_from_Name_L.Text = "";
FINAL_from_CompanyName_L.Text = "";
FINAL_from_StreetAddress_L.Text = "";
FINAL_from_CityStateZip_L.Text = "";
for (int k = 0; k < selectedWarehouseIDs.Count; k++)
{
warehouse = warehouse.Select(selectedWarehouseIDs[k]);
address = address.Select(warehouse.address_id);
if (selectedWarehouseIDs[k] == selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add + " | ";
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four + " | ";
}
else if (selectedWarehouseIDs[k] != selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add;
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four;
}
else
{
FINAL_from_Name_L.Text += warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += address.str_add;
FINAL_from_CityStateZip_L.Text += address.city + " " + address.state + " " + address.zip_plus_four;
}
}
placeOrder_div.Style.Add("display", "none");
}
protected void createInvoicePreview()
{
//create invoice preview
final_invoice_div.Style.Add("display", "block");
FINAL_to_Name_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_CompanyName_L.Text = selected_Warehouse.warehouse_name;
FINAL_to_StreetAddress_L.Text = address.str_add;
FINAL_to_CityStateZip_L.Text = address.city + " " + address.state + " " + address.zip_plus_four;
FINAL_caseNumber_L.Text = "Case #/Order #: " + case_intake.case_id + " / " + requestor_Order.OrderID;
FINAL_date_L.Text = Convert.ToString(DateTime.Now);
for (int i = 0; i < product_id_array.Length; i++)
{
products = products.Select(Convert.ToInt32(product_id_array[i]));
warehouse_product_location = warehouse_product_location.Select_By_Product_ID(products.product_id);
warehouse = warehouse.Select(warehouse_product_location.warehouse_id);
checkWarehouseIDs.Add(warehouse.warehouse_id);
for (int j = 0; j < checkWarehouseIDs.Count; j++)
{
if (warehouse.warehouse_id != checkWarehouseIDs[j] || checkWarehouseIDs.Count == 1)
{
selectedWarehouseIDs.Add(warehouse.warehouse_id);
}
}
int itemNum = i + 1;
FINAL_orderNum_div.InnerHtml += itemNum + "<br/>";
FINAL_ProductID_and_WarehouseID_div.InnerHtml += products.product_id + " / " + warehouse.warehouse_id + "<br/>";
FINAL_orderQTY_div.InnerHtml += 1 + "<br/>";
FINAL_orderDESCRIPTION_div.InnerHtml += products.product_name + "<br/>";
}
FINAL_from_Name_L.Text = "";
FINAL_from_CompanyName_L.Text = "";
FINAL_from_StreetAddress_L.Text = "";
FINAL_from_CityStateZip_L.Text = "";
for (int k = 0; k < selectedWarehouseIDs.Count; k++)
{
warehouse = warehouse.Select(selectedWarehouseIDs[k]);
address = address.Select(warehouse.address_id);
if (selectedWarehouseIDs[k] == selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name + " | ";
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add + " | ";
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four + " | ";
}
else if (selectedWarehouseIDs[k] != selectedWarehouseIDs.Count - 1 && selectedWarehouseIDs.Count > 0)
{
FINAL_from_Name_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += selectedWarehouseIDs[k] + ": " + warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += selectedWarehouseIDs[k] + ": " + address.str_add;
FINAL_from_CityStateZip_L.Text += selectedWarehouseIDs[k] + ": " + address.city + " " + address.state + " " + address.zip_plus_four;
}
else
{
FINAL_from_Name_L.Text += warehouse.warehouse_name;
FINAL_from_CompanyName_L.Text += warehouse.warehouse_name;
FINAL_from_StreetAddress_L.Text += address.str_add;
FINAL_from_CityStateZip_L.Text += address.city + " " + address.state + " " + address.zip_plus_four;
}
}
placeOrder_div.Style.Add("display", "none");
}