public requestor Insert_requestor_select(int ID)
{
requestor = requestor.Select(ID);
Insert_EncounterID_txt.Text = Convert.ToString(requestor.EncounterID);
Insert_Requestor_Type_txt.Text = Convert.ToString(requestor.Requestor_Type);
Insert_MobilUnitID_txt.Text = Convert.ToString(requestor.MobilUnitID);
Insert_PersonID_txt.Text = Convert.ToString(requestor.PersonID);
Insert_AgencyID_txt.Text = Convert.ToString(requestor.AgencyID);
return(requestor);
}
public requestor requestor_insert()
{
requestor.EncounterID = encounter.encounter_id;
requestor.Requestor_Type = "Warehouse";
requestor.MobilUnitID = 0; //null
requestor.PersonID = 0; //null
requestor.AgencyID = 0; //null
requestor = requestor.Insert(requestor);
return(requestor);
}
public requestor Insert_requestor_select(int ID)
{
requestor = requestor.Select(ID);
Insert_EncounterID_txt.Text = Convert.ToString(requestor.EncounterID);
Insert_Requestor_Type_txt.Text = Convert.ToString(requestor.Requestor_Type);
Insert_MobilUnitID_txt.Text = Convert.ToString(requestor.MobilUnitID);
Insert_PersonID_txt.Text = Convert.ToString(requestor.PersonID);
Insert_AgencyID_txt.Text = Convert.ToString(requestor.AgencyID);
return requestor;
}
public requestor Delete_requestor_select(int ID)
{
requestor = requestor.Select(ID);
Delete_RequestorID_txt_lbl.Text = Convert.ToString(requestor.RequestorID);
Delete_EncounterID_txt_lbl.Text = Convert.ToString(requestor.EncounterID);
Delete_Requestor_Type_txt_lbl.Text = Convert.ToString(requestor.Requestor_Type);
Delete_MobilUnitID_txt_lbl.Text = Convert.ToString(requestor.MobilUnitID);
Delete_PersonID_txt_lbl.Text = Convert.ToString(requestor.PersonID);
Delete_AgencyID_txt_lbl.Text = Convert.ToString(requestor.AgencyID);
return requestor;
}
public requestor Delete_requestor_select(int ID)
{
requestor = requestor.Select(ID);
Delete_RequestorID_txt_lbl.Text = Convert.ToString(requestor.RequestorID);
Delete_EncounterID_txt_lbl.Text = Convert.ToString(requestor.EncounterID);
Delete_Requestor_Type_txt_lbl.Text = Convert.ToString(requestor.Requestor_Type);
Delete_MobilUnitID_txt_lbl.Text = Convert.ToString(requestor.MobilUnitID);
Delete_PersonID_txt_lbl.Text = Convert.ToString(requestor.PersonID);
Delete_AgencyID_txt_lbl.Text = Convert.ToString(requestor.AgencyID);
return(requestor);
}
public requestor requestor_insert()
{
requestor.EncounterID = Convert.ToInt32(Insert_EncounterID_txt.Text);
requestor.Requestor_Type = Insert_Requestor_Type_txt.Text;
requestor.MobilUnitID = Convert.ToInt32(Insert_MobilUnitID_txt.Text);
requestor.PersonID = Convert.ToInt32(Insert_PersonID_txt.Text);
requestor.AgencyID = Convert.ToInt32(Insert_AgencyID_txt.Text);
requestor = requestor.Insert(requestor);
Insert_requestor_GridView.DataBind();
Update_requestor_GridView.DataBind();
Delete_requestor_GridView.DataBind();
return(requestor);
}
public requestor requestor_update(int ID)
{
requestor = requestor.Select(ID);
requestor.RequestorID = Convert.ToInt32(Update_RequestorID_txt.Text);
requestor.EncounterID = Convert.ToInt32(Update_EncounterID_txt.Text);
requestor.Requestor_Type = Update_Requestor_Type_txt.Text;
requestor.MobilUnitID = Convert.ToInt32(Update_MobilUnitID_txt.Text);
requestor.PersonID = Convert.ToInt32(Update_PersonID_txt.Text);
requestor.AgencyID = Convert.ToInt32(Update_AgencyID_txt.Text);
requestor.Update(requestor);
Insert_requestor_GridView.DataBind();
Update_requestor_GridView.DataBind();
Delete_requestor_GridView.DataBind();
return(requestor);
}
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 Update_Select_Record(object sender, EventArgs e)
{
requestor = Update_requestor_select(Convert.ToInt32(Update_requestor_GridView.SelectedValue));
}
protected void Update_Select_Record(object sender, EventArgs e)
{
requestor = Update_requestor_select(Convert.ToInt32(Update_requestor_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
requestor = requestor_update(Convert.ToInt32(Update_requestor_GridView.SelectedValue));
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
requestor = Insert_requestor_select(Convert.ToInt32(Insert_requestor_GridView.SelectedValue));
}
protected void INSERT(object sender, EventArgs e)
{
requestor = requestor_insert();
}
protected void UPDATE(object sender, EventArgs e)
{
requestor = requestor_update(Convert.ToInt32(Update_requestor_GridView.SelectedValue));
}
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 requestor_insert()
{
requestor.EncounterID = Convert.ToInt32(Insert_EncounterID_txt.Text);
requestor.Requestor_Type = Insert_Requestor_Type_txt.Text;
requestor.MobilUnitID = Convert.ToInt32(Insert_MobilUnitID_txt.Text);
requestor.PersonID = Convert.ToInt32(Insert_PersonID_txt.Text);
requestor.AgencyID = Convert.ToInt32(Insert_AgencyID_txt.Text);
requestor = requestor.Insert(requestor);
Insert_requestor_GridView.DataBind();
Update_requestor_GridView.DataBind();
Delete_requestor_GridView.DataBind();
return requestor;
}
protected void INSERT(object sender, EventArgs e)
{
requestor = requestor_insert();
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
requestor = Insert_requestor_select(Convert.ToInt32(Insert_requestor_GridView.SelectedValue));
}
public requestor requestor_update(int ID)
{
requestor = requestor.Select(ID);
requestor.RequestorID = Convert.ToInt32(Update_RequestorID_txt.Text);
requestor.EncounterID = Convert.ToInt32(Update_EncounterID_txt.Text);
requestor.Requestor_Type = Update_Requestor_Type_txt.Text;
requestor.MobilUnitID = Convert.ToInt32(Update_MobilUnitID_txt.Text);
requestor.PersonID = Convert.ToInt32(Update_PersonID_txt.Text);
requestor.AgencyID = Convert.ToInt32(Update_AgencyID_txt.Text);
requestor.Update(requestor);
Insert_requestor_GridView.DataBind();
Update_requestor_GridView.DataBind();
Delete_requestor_GridView.DataBind();
return requestor;
}
public requestor requestor_insert()
{
requestor.EncounterID = encounter.encounter_id;
requestor.Requestor_Type = "Warehouse";
requestor.MobilUnitID = 0;//null
requestor.PersonID = 0;//null
requestor.AgencyID = 0;//null
requestor = requestor.Insert(requestor);
return requestor;
}
