public void debt_delete(int ID)
 {
     debt.Delete(ID);
     Insert_debt_GridView.DataBind();
     Update_debt_GridView.DataBind();
     Delete_debt_GridView.DataBind();
 }
 public debt debt_insert()
 {
     debt.amt_paid          = Convert.ToDecimal(Insert_amt_paid_txt.Text);
     debt.case_id           = Convert.ToInt32(Insert_case_id_txt.Text);
     debt.client_id         = Convert.ToInt32(Insert_client_id_txt.Text);
     debt.creditor_name     = Insert_creditor_name_txt.Text;
     debt.debt_amt          = Convert.ToDecimal(Insert_debt_amt_txt.Text);
     debt.item_purchased    = Insert_item_purchased_txt.Text;
     debt.last_payment_date = Convert.ToDateTime(Insert_last_payment_date_txt.Text);
     debt.purchase_date     = Convert.ToDateTime(Insert_purchase_date_txt.Text);
     debt.value_amt         = Convert.ToDecimal(Insert_value_amt_txt.Text);
     debt = debt.Insert(debt);
     Insert_debt_GridView.DataBind();
     Update_debt_GridView.DataBind();
     Delete_debt_GridView.DataBind();
     return(debt);
 }
 public debt debt_update(int ID)
 {
     debt                   = debt.Select(ID);
     debt.debt_id           = Convert.ToInt32(Update_debt_id_txt.Text);
     debt.amt_paid          = Convert.ToDecimal(Update_amt_paid_txt.Text);
     debt.case_id           = Convert.ToInt32(Update_case_id_txt.Text);
     debt.client_id         = Convert.ToInt32(Update_client_id_txt.Text);
     debt.creditor_name     = Update_creditor_name_txt.Text;
     debt.debt_amt          = Convert.ToDecimal(Update_debt_amt_txt.Text);
     debt.item_purchased    = Update_item_purchased_txt.Text;
     debt.last_payment_date = Convert.ToDateTime(Update_last_payment_date_txt.Text);
     debt.purchase_date     = Convert.ToDateTime(Update_purchase_date_txt.Text);
     debt.value_amt         = Convert.ToDecimal(Update_value_amt_txt.Text);
     debt.Update(debt);
     Insert_debt_GridView.DataBind();
     Update_debt_GridView.DataBind();
     Delete_debt_GridView.DataBind();
     return(debt);
 }