private void btn_add_Click(object sender, EventArgs e)
 {
     try
     {
         p.Insert();
         MessageBox.Show("Insert Success.");
         RefreshGrd();
     }
     catch (Exception ex)
     {
         MessageBox.Show(string.Format("Message : {0}", ex.Message));
     }
 }
        public person person_insert()
        {
            person.Resource_ID          = 0;
            person.address_id           = address.address_id;
            person.address_id2          = 0;
            person.f_name               = Insert_f_name_txt.Text;
            person.m_initial            = Insert_m_initial_txt.Text;
            person.l_name               = Insert_l_name_txt.Text;
            person.certification_number = "HI!";
            person.gender               = Insert_gender_ddl.SelectedValue;
            person.person_type          = "C";
            person.phone_primary        = Insert_phone_primary_txt.Text;
            person.ssn                               = Convert.ToInt32(Insert_ssn_txt.Text);
            person.birthdate                         = Convert.ToDateTime("1 / 1 / 1900");
            person.phone_secondary                   = "";
            person.email                             = "";
            person.ssn                               = 0;
            person.Maiden_Name                       = "";
            person.Visa_Issue_Date                   = Convert.ToDateTime("1 / 1 / 1900");
            person.Visa_Expire_Date                  = Convert.ToDateTime("1 / 1 / 1900");
            person.Visa_Selected_Value_B1            = 0;
            person.Visa_Selected_Value_B2            = 0;
            person.Visa_Selected_Value_K1            = 0;
            person.Visa_Selected_Value_K3            = 0;
            person.Visa_Selected_Value_L1            = 0;
            person.Visa_Selected_Value_L2            = 0;
            person.Visa_Selected_Value_H4            = 0;
            person.Visa_Selected_Value_F1            = 0;
            person.Visa_Selected_Value_J1            = 0;
            person.Visa_Selected_Value_M1            = 0;
            person.Visa_Selected_Value_H_1B          = 0;
            person.Visa_Selected_Value_H_2B          = 0;
            person.Visa_Selected_Value_B_2           = 0;
            person.Visa_Selected_Value_Schengen      = 0;
            person.Perm_Resident_Alien_Resid_Date    = Convert.ToDateTime("1 / 1 / 1900");
            person.Perm_Resident_Alien_Expire_Date   = Convert.ToDateTime("1 / 1 / 1900");
            person.Perm_Resident_Alien_A_number      = 0;
            person.Perm_Resident_Alien_USCIS_number  = 0;
            person.Perm_Resident_Alien_Birth_Country = "";
            person.Perm_Resident_Alien_Category      = "";
            person.Driver_State_ID                   = "";
            person.Citizenship                       = "";
            person.Marital_Status                    = "";
            person.Minor_Children                    = 0;


            person = person.Insert(person);
            ////Insert_gvClientSearchresult.DataBind();
            return(person);
        }
 public person person_insert()
 {
     person.Resource_ID          = Convert.ToInt32(Insert_Resource_ID_txt.Text);
     person.address_id           = Convert.ToInt32(Insert_address_id_txt.Text);
     person.address_id2          = Convert.ToInt32(Insert_address_id2_txt.Text);
     person.birthdate            = Convert.ToDateTime(Insert_birthdate_txt.Text);
     person.certification_number = Insert_certification_number_txt.Text;
     person.f_name                            = Insert_f_name_txt.Text;
     person.m_initial                         = Insert_m_initial_txt.Text;
     person.l_name                            = Insert_l_name_txt.Text;
     person.gender                            = Insert_gender_txt.Text;
     person.person_type                       = Insert_person_type_txt.Text;
     person.phone_primary                     = Insert_phone_primary_txt.Text;
     person.phone_secondary                   = Insert_phone_secondary_txt.Text;
     person.email                             = Insert_email_txt.Text;
     person.ssn                               = Convert.ToInt32(Insert_ssn_txt.Text);
     person.Maiden_Name                       = Insert_Maiden_Name_txt.Text;
     person.Visa_Issue_Date                   = Convert.ToDateTime(Insert_Visa_Issue_Date_txt.Text);
     person.Visa_Expire_Date                  = Convert.ToDateTime(Insert_Visa_Expire_Date_txt.Text);
     person.Visa_Selected_Value_B1            = Convert.ToInt32(Insert_Visa_Selected_Value_B1_txt.Text);
     person.Visa_Selected_Value_B2            = Convert.ToInt32(Insert_Visa_Selected_Value_B2_txt.Text);
     person.Visa_Selected_Value_K1            = Convert.ToInt32(Insert_Visa_Selected_Value_K1_txt.Text);
     person.Visa_Selected_Value_K3            = Convert.ToInt32(Insert_Visa_Selected_Value_K3_txt.Text);
     person.Visa_Selected_Value_L1            = Convert.ToInt32(Insert_Visa_Selected_Value_L1_txt.Text);
     person.Visa_Selected_Value_L2            = Convert.ToInt32(Insert_Visa_Selected_Value_L2_txt.Text);
     person.Visa_Selected_Value_H4            = Convert.ToInt32(Insert_Visa_Selected_Value_H4_txt.Text);
     person.Visa_Selected_Value_F1            = Convert.ToInt32(Insert_Visa_Selected_Value_F1_txt.Text);
     person.Visa_Selected_Value_J1            = Convert.ToInt32(Insert_Visa_Selected_Value_J1_txt.Text);
     person.Visa_Selected_Value_M1            = Convert.ToInt32(Insert_Visa_Selected_Value_M1_txt.Text);
     person.Visa_Selected_Value_H_1B          = Convert.ToInt32(Insert_Visa_Selected_Value_H_1B_txt.Text);
     person.Visa_Selected_Value_H_2B          = Convert.ToInt32(Insert_Visa_Selected_Value_H_2B_txt.Text);
     person.Visa_Selected_Value_B_2           = Convert.ToInt32(Insert_Visa_Selected_Value_B_2_txt.Text);
     person.Visa_Selected_Value_Schengen      = Convert.ToInt32(Insert_Visa_Selected_Value_Schengen_txt.Text);
     person.Perm_Resident_Alien_Resid_Date    = Convert.ToDateTime(Insert_Perm_Resident_Alien_Resid_Date_txt.Text);
     person.Perm_Resident_Alien_Expire_Date   = Convert.ToDateTime(Insert_Perm_Resident_Alien_Expire_Date_txt.Text);
     person.Perm_Resident_Alien_A_number      = Convert.ToInt32(Insert_Perm_Resident_Alien_A_number_txt.Text);
     person.Perm_Resident_Alien_USCIS_number  = Convert.ToInt32(Insert_Perm_Resident_Alien_USCIS_number_txt.Text);
     person.Perm_Resident_Alien_Birth_Country = Insert_Perm_Resident_Alien_Birth_Country_txt.Text;
     person.Perm_Resident_Alien_Category      = Insert_Perm_Resident_Alien_Category_txt.Text;
     person.Driver_State_ID                   = Insert_Driver_State_ID_txt.Text;
     person.Citizenship                       = Insert_Citizenship_txt.Text;
     person.Marital_Status                    = Insert_Marital_Status_txt.Text;
     person.Minor_Children                    = Convert.ToInt32(Insert_Minor_Children_txt.Text);
     person = person.Insert(person);
     Insert_person_GridView.DataBind();
     Update_person_GridView.DataBind();
     Delete_person_GridView.DataBind();
     return(person);
 }