private void loadfrom(string Employee_ID) { table = new DataTable(); sua = new Sua_thong_tin(); table = sua.form_loadSqlServer(Employee_ID); this.inputEmployeeID.Text = table.Rows[0]["EMPLOYMENT_ID"].ToString(); this.inputFirstName.Text = table.Rows[0]["CURRENT_FIRST_NAME"].ToString(); this.inputMiddleName.Text = table.Rows[0]["CURRENT_MIDDLE_NAME"].ToString(); this.inputLastName.Text = table.Rows[0]["CURRENT_LAST_NAME"].ToString(); this.inputSocial.Text = table.Rows[0]["SOCIAL_SECURITY_NUMBER"].ToString(); this.exampleFormGender.Text = table.Rows[0]["CURRENT_GENDER"].ToString(); this.inputEthnicity.Text = table.Rows[0]["ETHNICITY"].ToString(); this.inputAddress.Text = table.Rows[0]["CURRENT_ADDRESS_1"].ToString(); this.inputEmail.Text = table.Rows[0]["CURRENT_PERSONAL_EMAIL"].ToString(); this.inputPhone.Text = table.Rows[0]["CURRENT_PHONE_NUMBER"].ToString(); this.inputShare.Text = table.Rows[0]["SHAREHOLDER_STATUS"].ToString(); this.inputDayWorking.Text = table.Rows[0]["NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH"].ToString(); this.inputDivision.Text = table.Rows[0]["DIVISION"].ToString(); this.inputBenefit.Text = table.Rows[0]["BENEFIT_PLAN_ID"].ToString(); // DateTime date = DateTime.ParseExact(table.Rows[0]["BIRTH_DATE"].ToString(), "dd/MM/yyyy", null); this.inputBirthDate.Text = table.Rows[0]["BIRTH_DATE"].ToString(); // DateTime date1 = DateTime.ParseExact(table.Rows[0]["FROM_DATE"].ToString(), "dd/MM/yyyy", null); this.inputFromDate.Text = table.Rows[0]["FROM_DATE"].ToString(); // DateTime date2 = DateTime.ParseExact(table.Rows[0]["HIRE_DATE_FOR_WORKING"].ToString(), "dd/MM/yyyy", null); this.inputHireDate.Text = table.Rows[0]["HIRE_DATE_FOR_WORKING"].ToString(); // var date3 = DateTime.ParseExact(table.Rows[0]["THRU_DATE"].ToString(), "dd/MM/yyyy", null); this.inputThruDate.Text = table.Rows[0]["THRU_DATE"].ToString(); table = new DataTable(); table = sua.from_loadMySql(Employee_ID); this.inputPayAmount.Text = table.Rows[0]["Pay_Rate"].ToString(); this.inputPayRateID.Text = table.Rows[0]["Pay_Rates_idPay_Rates"].ToString(); }
protected void Submit_Click(object sender, EventArgs e) { sua = new Sua_thong_tin(); try { sua.update_SQLserver(Employee_ID, this.inputEmployeeID.Text, this.inputFirstName.Text, this.inputLastName.Text, this.inputMiddleName.Text, Convert.ToDateTime(this.inputBirthDate.Text), this.inputSocial.Text, this.inputAddress.Text, this.exampleFormGender.SelectedValue, this.inputPhone.Text, this.inputEmail.Text, this.inputEthnicity.Text, Convert.ToInt32(this.inputShare.Text), Convert.ToInt32(this.inputBenefit.SelectedValue), Convert.ToInt32(this.inputDayWorking.Text), this.inputDivision.Text, Convert.ToDateTime(this.inputThruDate.Text), Convert.ToDateTime(this.inputFromDate.Text), Convert.ToDateTime(this.inputHireDate.Text)); sua.update_MySql(Employee_ID, this.inputEmployeeID.Text.ToString(), Convert.ToInt32(this.inputPayRateID.SelectedValue), this.inputPayAmount.Text, this.inputFirstName.Text.ToString(), this.inputLastName.Text.ToString(), this.inputMiddleName.Text.ToString()); loadfrom(Employee_ID); Response.Write("<script>alert('sua thanh cong'); </script>"); } catch (Exception) { } }
private void load_dropdowlist() { sua = new Sua_thong_tin(); table = new DataTable(); table = sua.load_dropdowlist_server(); for (int i = 0; i < table.Rows.Count; i++) { this.inputBenefit.Items.Add(table.Rows[i]["BENEFIT_PLANS_ID"].ToString()); } table = sua.load_dropdowlist_mysql(); for (int i = 0; i < table.Rows.Count; i++) { this.inputPayRateID.Items.Add(table.Rows[i]["idPay_Rates"].ToString()); } }