コード例 #1
0
 public void personDMCS_delete(int ID)
 {
     personDMCS.Delete(ID);
     Insert_personDMCS_GridView.DataBind();
     Update_personDMCS_GridView.DataBind();
     Delete_personDMCS_GridView.DataBind();
 }
コード例 #2
0
 public personDMCS personDMCS_insert()
 {
     personDMCS.Resource_ID        = Convert.ToInt32(Insert_Resource_ID_txt.Text);
     personDMCS.f_name             = Insert_f_name_txt.Text;
     personDMCS.l_name             = Insert_l_name_txt.Text;
     personDMCS.address            = Insert_address_txt.Text;
     personDMCS.city               = Insert_city_txt.Text;
     personDMCS.state              = Insert_state_txt.Text;
     personDMCS.zipcode            = Convert.ToInt32(Insert_zipcode_txt.Text);
     personDMCS.phone_primary      = Insert_phone_primary_txt.Text;
     personDMCS.email              = Insert_email_txt.Text;
     personDMCS.creditcard         = Insert_creditcard_txt.Text;
     personDMCS.availability_date  = Convert.ToDateTime(Insert_availability_date_txt.Text);
     personDMCS.availability_hours = Convert.ToInt32(Insert_availability_hours_txt.Text);
     personDMCS.birthdate          = Convert.ToDateTime(Insert_birthdate_txt.Text);
     personDMCS.marital_status     = Insert_marital_status_txt.Text;
     personDMCS.gender             = Insert_gender_txt.Text;
     personDMCS.jobtitle           = Insert_jobtitle_txt.Text;
     personDMCS.workdate           = Convert.ToDateTime(Insert_workdate_txt.Text);
     personDMCS.regpay             = Convert.ToDecimal(Insert_regpay_txt.Text);
     personDMCS.OT          = Convert.ToInt32(Insert_OT_txt.Text);
     personDMCS.OT_rate     = Convert.ToDecimal(Insert_OT_rate_txt.Text);
     personDMCS.hourly_rate = Convert.ToDecimal(Insert_hourly_rate_txt.Text);
     personDMCS             = personDMCS.Insert(personDMCS);
     Insert_personDMCS_GridView.DataBind();
     Update_personDMCS_GridView.DataBind();
     Delete_personDMCS_GridView.DataBind();
     return(personDMCS);
 }
コード例 #3
0
 public personDMCS personDMCS_update(int ID)
 {
     personDMCS                    = personDMCS.Select(ID);
     personDMCS.Person_ID          = Convert.ToInt32(Update_Person_ID_txt.Text);
     personDMCS.Resource_ID        = Convert.ToInt32(Update_Resource_ID_txt.Text);
     personDMCS.f_name             = Update_f_name_txt.Text;
     personDMCS.l_name             = Update_l_name_txt.Text;
     personDMCS.address            = Update_address_txt.Text;
     personDMCS.city               = Update_city_txt.Text;
     personDMCS.state              = Update_state_txt.Text;
     personDMCS.zipcode            = Convert.ToInt32(Update_zipcode_txt.Text);
     personDMCS.phone_primary      = Update_phone_primary_txt.Text;
     personDMCS.email              = Update_email_txt.Text;
     personDMCS.creditcard         = Update_creditcard_txt.Text;
     personDMCS.availability_date  = Convert.ToDateTime(Update_availability_date_txt.Text);
     personDMCS.availability_hours = Convert.ToInt32(Update_availability_hours_txt.Text);
     personDMCS.birthdate          = Convert.ToDateTime(Update_birthdate_txt.Text);
     personDMCS.marital_status     = Update_marital_status_txt.Text;
     personDMCS.gender             = Update_gender_txt.Text;
     personDMCS.jobtitle           = Update_jobtitle_txt.Text;
     personDMCS.workdate           = Convert.ToDateTime(Update_workdate_txt.Text);
     personDMCS.regpay             = Convert.ToDecimal(Update_regpay_txt.Text);
     personDMCS.OT                 = Convert.ToInt32(Update_OT_txt.Text);
     personDMCS.OT_rate            = Convert.ToDecimal(Update_OT_rate_txt.Text);
     personDMCS.hourly_rate        = Convert.ToDecimal(Update_hourly_rate_txt.Text);
     personDMCS.Update(personDMCS);
     Insert_personDMCS_GridView.DataBind();
     Update_personDMCS_GridView.DataBind();
     Delete_personDMCS_GridView.DataBind();
     return(personDMCS);
 }