public requestor_Order Insert_requestor_Order_select(int ID)
{
requestor_Order = requestor_Order.Select(ID);
Insert_Requestor_ID_txt.Text = Convert.ToString(requestor_Order.Requestor_ID);
Insert_EncounterID_txt.Text = Convert.ToString(requestor_Order.EncounterID);
Insert_OrderPriority_txt.Text = Convert.ToString(requestor_Order.OrderPriority);
Insert_OrderNum_txt.Text = Convert.ToString(requestor_Order.OrderNum);
Insert_ShipToAddressID_txt.Text = Convert.ToString(requestor_Order.ShipToAddressID);
Insert_OrderDeliveryType_txt.Text = Convert.ToString(requestor_Order.OrderDeliveryType);
Insert_OrderPickUpDate_txt.Text = Convert.ToString(requestor_Order.OrderPickUpDate);
return requestor_Order;
}
public requestor_Order Insert_requestor_Order_select(int ID)
{
requestor_Order = requestor_Order.Select(ID);
Insert_Requestor_ID_txt.Text = Convert.ToString(requestor_Order.Requestor_ID);
Insert_EncounterID_txt.Text = Convert.ToString(requestor_Order.EncounterID);
Insert_OrderPriority_txt.Text = Convert.ToString(requestor_Order.OrderPriority);
Insert_OrderNum_txt.Text = Convert.ToString(requestor_Order.OrderNum);
Insert_ShipToAddressID_txt.Text = Convert.ToString(requestor_Order.ShipToAddressID);
Insert_OrderDeliveryType_txt.Text = Convert.ToString(requestor_Order.OrderDeliveryType);
Insert_OrderPickUpDate_txt.Text = Convert.ToString(requestor_Order.OrderPickUpDate);
return(requestor_Order);
}
public requestor_Order requestor_Order_insert()
{
Random random = new Random();
requestor_Order.Requestor_ID = requestor.RequestorID;
requestor_Order.EncounterID = encounter.encounter_id;
requestor_Order.OrderPriority = Convert.ToInt32(DDL_Priority_Lvl.SelectedValue);
requestor_Order.OrderNum = random.Next(0, 100000000);
requestor_Order.ShipToAddressID = address.address_id;
requestor_Order.OrderDeliveryType = "Shipping";
requestor_Order.OrderPickUpDate = Convert.ToDateTime(9 / 9 / 9);//null
requestor_Order = requestor_Order.Insert(requestor_Order);
return(requestor_Order);
}
public requestor_Order requestor_Order_insert()
{
requestor_Order.Requestor_ID = Convert.ToInt32(Insert_Requestor_ID_txt.Text);
requestor_Order.EncounterID = Convert.ToInt32(Insert_EncounterID_txt.Text);
requestor_Order.OrderPriority = Convert.ToInt32(Insert_OrderPriority_txt.Text);
requestor_Order.OrderNum = Convert.ToInt32(Insert_OrderNum_txt.Text);
requestor_Order.ShipToAddressID = Convert.ToInt32(Insert_ShipToAddressID_txt.Text);
requestor_Order.OrderDeliveryType = Insert_OrderDeliveryType_txt.Text;
requestor_Order.OrderPickUpDate = Convert.ToDateTime(Insert_OrderPickUpDate_txt.Text);
requestor_Order = requestor_Order.Insert(requestor_Order);
Insert_requestor_Order_GridView.DataBind();
Update_requestor_Order_GridView.DataBind();
Delete_requestor_Order_GridView.DataBind();
return(requestor_Order);
}
public requestor_Order requestor_Order_update(int ID)
{
requestor_Order = requestor_Order.Select(ID);
requestor_Order.OrderID = Convert.ToInt32(Update_OrderID_txt.Text);
requestor_Order.Requestor_ID = Convert.ToInt32(Update_Requestor_ID_txt.Text);
requestor_Order.EncounterID = Convert.ToInt32(Update_EncounterID_txt.Text);
requestor_Order.OrderPriority = Convert.ToInt32(Update_OrderPriority_txt.Text);
requestor_Order.OrderNum = Convert.ToInt32(Update_OrderNum_txt.Text);
requestor_Order.ShipToAddressID = Convert.ToInt32(Update_ShipToAddressID_txt.Text);
requestor_Order.OrderDeliveryType = Update_OrderDeliveryType_txt.Text;
requestor_Order.OrderPickUpDate = Convert.ToDateTime(Update_OrderPickUpDate_txt.Text);
requestor_Order.Update(requestor_Order);
Insert_requestor_Order_GridView.DataBind();
Update_requestor_Order_GridView.DataBind();
Delete_requestor_Order_GridView.DataBind();
return(requestor_Order);
}
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();
}
public requestor_Order requestor_Order_insert()
{
requestor_Order.Requestor_ID = Convert.ToInt32(Insert_Requestor_ID_txt.Text);
requestor_Order.EncounterID = Convert.ToInt32(Insert_EncounterID_txt.Text);
requestor_Order.OrderPriority = Convert.ToInt32(Insert_OrderPriority_txt.Text);
requestor_Order.OrderNum = Convert.ToInt32(Insert_OrderNum_txt.Text);
requestor_Order.ShipToAddressID = Convert.ToInt32(Insert_ShipToAddressID_txt.Text);
requestor_Order.OrderDeliveryType = Insert_OrderDeliveryType_txt.Text;
requestor_Order.OrderPickUpDate = Convert.ToDateTime(Insert_OrderPickUpDate_txt.Text);
requestor_Order = requestor_Order.Insert(requestor_Order);
Insert_requestor_Order_GridView.DataBind();
Update_requestor_Order_GridView.DataBind();
Delete_requestor_Order_GridView.DataBind();
return requestor_Order;
}
protected void Update_Select_Record(object sender, EventArgs e)
{
requestor_Order = Update_requestor_Order_select(Convert.ToInt32(Update_requestor_Order_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
requestor_Order = requestor_Order_update(Convert.ToInt32(Update_requestor_Order_GridView.SelectedValue));
}
protected void INSERT(object sender, EventArgs e)
{
requestor_Order = requestor_Order_insert();
}
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();
}
public requestor_Order requestor_Order_insert()
{
Random random = new Random();
requestor_Order.Requestor_ID = requestor.RequestorID;
requestor_Order.EncounterID = encounter.encounter_id;
requestor_Order.OrderPriority = Convert.ToInt32(DDL_Priority_Lvl.SelectedValue);
requestor_Order.OrderNum = random.Next(0, 100000000);
requestor_Order.ShipToAddressID = address.address_id;
requestor_Order.OrderDeliveryType = "Shipping";
requestor_Order.OrderPickUpDate = Convert.ToDateTime(9/9/9);//null
requestor_Order = requestor_Order.Insert(requestor_Order);
return requestor_Order;
}
protected void INSERT(object sender, EventArgs e)
{
requestor_Order = requestor_Order_insert();
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
requestor_Order = Insert_requestor_Order_select(Convert.ToInt32(Insert_requestor_Order_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
requestor_Order = requestor_Order_update(Convert.ToInt32(Update_requestor_Order_GridView.SelectedValue));
}
