protected void btnAddGuest_Click(object sender, EventArgs e)
{
if (txtName.Text != "" && txtLname.Text != "" && txtSalary.Text != "" && txtAff.SelectedValue != "")
{
string sql = "INSERT INTO tbl_guest_list ( guest_id, guest_list_profix, guest_list_name, guest_list_lname, guest_list_pos, guest_list_salary, guest_list_cpoint, guest_list_status, guest_list_idcard ) VALUES ('" + txtGuest_id.Value.ToString() + "', '" + txtProfix.SelectedValue + "', '" + txtName.Text.Trim() + "', '" + txtLname.Text.Trim() + "', '" + txtPos.Text + "', '" + double.Parse(txtSalary.Text) + "', '" + txtCpoint.Text + "', '0', '')";
string guest_pk = dBScript.InsertQueryPK(sql);
if (guest_pk != "")
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('บันทึกสำเร็จ')", true);
BindData();
clearDataGreat();
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('Error : ล้มเหลว')", true);
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", "alert('กรุณากรอกข้อมูลให้ครบถ้วน')", true);
}
}