public medical_assistance Insert_medical_assistance_select(int ID)
 {
     medical_assistance    = medical_assistance.Select(ID);
     Insert_em_id_txt.Text = Convert.ToString(medical_assistance.em_id);
     Insert_medical_assist_date_txt.Text            = Convert.ToString(medical_assistance.medical_assist_date);
     Insert_medical_assist_doctor_id_txt.Text       = Convert.ToString(medical_assistance.medical_assist_doctor_id);
     Insert_medical_assist_hosp_price_txt.Text      = Convert.ToString(medical_assistance.medical_assist_hosp_price);
     Insert_medical_assist_hospital_name_txt.Text   = Convert.ToString(medical_assistance.medical_assist_hospital_name);
     Insert_medical_assist_script_meds_txt.Text     = Convert.ToString(medical_assistance.medical_assist_script_meds);
     Insert_medical_assist_script_price_txt.Text    = Convert.ToString(medical_assistance.medical_assist_script_price);
     Insert_medical_assist_script_quantity_txt.Text = Convert.ToString(medical_assistance.medical_assist_script_quantity);
     return(medical_assistance);
 }
 public medical_assistance Insert_medical_assistance_select(int ID)
 {
     medical_assistance = medical_assistance.Select(ID);
     Insert_em_id_txt.Text = Convert.ToString(medical_assistance.em_id);
     Insert_medical_assist_date_txt.Text = Convert.ToString(medical_assistance.medical_assist_date);
     Insert_medical_assist_doctor_id_txt.Text = Convert.ToString(medical_assistance.medical_assist_doctor_id);
     Insert_medical_assist_hosp_price_txt.Text = Convert.ToString(medical_assistance.medical_assist_hosp_price);
     Insert_medical_assist_hospital_name_txt.Text = Convert.ToString(medical_assistance.medical_assist_hospital_name);
     Insert_medical_assist_script_meds_txt.Text = Convert.ToString(medical_assistance.medical_assist_script_meds);
     Insert_medical_assist_script_price_txt.Text = Convert.ToString(medical_assistance.medical_assist_script_price);
     Insert_medical_assist_script_quantity_txt.Text = Convert.ToString(medical_assistance.medical_assist_script_quantity);
     return medical_assistance;
 }
 public medical_assistance medical_assistance_insert()
 {
     medical_assistance.em_id = Convert.ToInt32(Insert_em_id_txt.Text);
     medical_assistance.medical_assist_date            = Convert.ToDateTime(Insert_medical_assist_date_txt.Text);
     medical_assistance.medical_assist_doctor_id       = Convert.ToInt32(Insert_medical_assist_doctor_id_txt.Text);
     medical_assistance.medical_assist_hosp_price      = Convert.ToDecimal(Insert_medical_assist_hosp_price_txt.Text);
     medical_assistance.medical_assist_hospital_name   = Insert_medical_assist_hospital_name_txt.Text;
     medical_assistance.medical_assist_script_meds     = Insert_medical_assist_script_meds_txt.Text;
     medical_assistance.medical_assist_script_price    = Convert.ToDecimal(Insert_medical_assist_script_price_txt.Text);
     medical_assistance.medical_assist_script_quantity = Convert.ToInt32(Insert_medical_assist_script_quantity_txt.Text);
     medical_assistance = medical_assistance.Insert(medical_assistance);
     Insert_medical_assistance_GridView.DataBind();
     Update_medical_assistance_GridView.DataBind();
     Delete_medical_assistance_GridView.DataBind();
     return(medical_assistance);
 }
 public medical_assistance medical_assistance_update(int ID)
 {
     medical_assistance = medical_assistance.Select(ID);
     medical_assistance.medical_assist_order_id = Convert.ToInt32(Update_medical_assist_order_id_txt.Text);
     medical_assistance.em_id = Convert.ToInt32(Update_em_id_txt.Text);
     medical_assistance.medical_assist_date            = Convert.ToDateTime(Update_medical_assist_date_txt.Text);
     medical_assistance.medical_assist_doctor_id       = Convert.ToInt32(Update_medical_assist_doctor_id_txt.Text);
     medical_assistance.medical_assist_hosp_price      = Convert.ToDecimal(Update_medical_assist_hosp_price_txt.Text);
     medical_assistance.medical_assist_hospital_name   = Update_medical_assist_hospital_name_txt.Text;
     medical_assistance.medical_assist_script_meds     = Update_medical_assist_script_meds_txt.Text;
     medical_assistance.medical_assist_script_price    = Convert.ToDecimal(Update_medical_assist_script_price_txt.Text);
     medical_assistance.medical_assist_script_quantity = Convert.ToInt32(Update_medical_assist_script_quantity_txt.Text);
     medical_assistance.Update(medical_assistance);
     Insert_medical_assistance_GridView.DataBind();
     Update_medical_assistance_GridView.DataBind();
     Delete_medical_assistance_GridView.DataBind();
     return(medical_assistance);
 }
 protected void INSERT(object sender, EventArgs e)
 {
     medical_assistance = medical_assistance_insert();
 }
 protected void Insert_Select_Record(object sender, EventArgs e)
 {
     medical_assistance = Insert_medical_assistance_select(Convert.ToInt32(Insert_medical_assistance_GridView.SelectedValue));
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     medical_assistance = medical_assistance_update(Convert.ToInt32(Update_medical_assistance_GridView.SelectedValue));
 }
 public medical_assistance medical_assistance_insert()
 {
     medical_assistance.em_id = Convert.ToInt32(Insert_em_id_txt.Text);
     medical_assistance.medical_assist_date = Convert.ToDateTime(Insert_medical_assist_date_txt.Text);
     medical_assistance.medical_assist_doctor_id = Convert.ToInt32(Insert_medical_assist_doctor_id_txt.Text);
     medical_assistance.medical_assist_hosp_price = Convert.ToDecimal(Insert_medical_assist_hosp_price_txt.Text);
     medical_assistance.medical_assist_hospital_name = Insert_medical_assist_hospital_name_txt.Text;
     medical_assistance.medical_assist_script_meds = Insert_medical_assist_script_meds_txt.Text;
     medical_assistance.medical_assist_script_price = Convert.ToDecimal(Insert_medical_assist_script_price_txt.Text);
     medical_assistance.medical_assist_script_quantity = Convert.ToInt32(Insert_medical_assist_script_quantity_txt.Text);
     medical_assistance = medical_assistance.Insert(medical_assistance);
     Insert_medical_assistance_GridView.DataBind();
     Update_medical_assistance_GridView.DataBind();
     Delete_medical_assistance_GridView.DataBind();
     return medical_assistance;
 }
 protected void Update_Select_Record(object sender, EventArgs e)
 {
     medical_assistance = Update_medical_assistance_select(Convert.ToInt32(Update_medical_assistance_GridView.SelectedValue));
 }
 protected void UPDATE(object sender, EventArgs e)
 {
     medical_assistance = medical_assistance_update(Convert.ToInt32(Update_medical_assistance_GridView.SelectedValue));
 }
 protected void INSERT(object sender, EventArgs e)
 {
     medical_assistance = medical_assistance_insert();
 }
 public medical_assistance medical_assistance_update(int ID)
 {
     medical_assistance = medical_assistance.Select(ID);
     medical_assistance.medical_assist_order_id = Convert.ToInt32(Update_medical_assist_order_id_txt.Text);
     medical_assistance.em_id = Convert.ToInt32(Update_em_id_txt.Text);
     medical_assistance.medical_assist_date = Convert.ToDateTime(Update_medical_assist_date_txt.Text);
     medical_assistance.medical_assist_doctor_id = Convert.ToInt32(Update_medical_assist_doctor_id_txt.Text);
     medical_assistance.medical_assist_hosp_price = Convert.ToDecimal(Update_medical_assist_hosp_price_txt.Text);
     medical_assistance.medical_assist_hospital_name = Update_medical_assist_hospital_name_txt.Text;
     medical_assistance.medical_assist_script_meds = Update_medical_assist_script_meds_txt.Text;
     medical_assistance.medical_assist_script_price = Convert.ToDecimal(Update_medical_assist_script_price_txt.Text);
     medical_assistance.medical_assist_script_quantity = Convert.ToInt32(Update_medical_assist_script_quantity_txt.Text);
     medical_assistance.Update(medical_assistance);
     Insert_medical_assistance_GridView.DataBind();
     Update_medical_assistance_GridView.DataBind();
     Delete_medical_assistance_GridView.DataBind();
     return medical_assistance;
 }