protected void ImageButton_login_Click(object sender, ImageClickEventArgs e)
{
if (!TextBox_name.Equals("") && !TextBox_password.Equals(""))
{
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["connectionstring"].ToString());
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
string Tsql = "select User_Name from Web_User where User_Name=@name and User_Password=@password";
com.CommandText = Tsql;
com.Parameters.AddWithValue("name", TextBox_name.Text.Trim());
com.Parameters.AddWithValue("password", TextBox_password.Text.Trim());
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
Session["User_Name"] = dr["User_Name"].ToString();
Response.Redirect("Main.aspx");
}
else
{
Response.Write("<script>alert('登录失败！ 1.用户名不存在 2.用户密码错误');</script>");
}
}
else
{
Response.Write("<script>alert('用户名或密码不能为空！');</script>");
}
}
private void Button_insert_Click(object sender, EventArgs e)
{
if (TextBox_name.Text == "" || textBox_Birth_city.Text == "" || textBoxTIN.Text == "" || textBoxSSN.Text == "" || textBoxAddress.Text == "" || textBoxROOM.Text == "")
{
MessageBox.Show("Az össszes mező kitöltése kötelező!");
}
else
{
string[] BirthDate = Convert.ToString(dateTime_BirthDate.Value).Split('.');
string[] check_in = Convert.ToString(dateTime_check_in.Value).Split('.');
string[] check_out = Convert.ToString(dateTime_check_out.Value).Split('.');
Person person = new Person(TextBox_name.Text, textBoxTIN.Text, textBoxSSN.Text, textBoxAddress.Text, BirthDate[0] + "-" + BirthDate[1] + "-" + BirthDate[2], textBox_Birth_city.Text, "F", check_out[0] + "-" + check_out[1] + "-" + check_out[2], check_in[0] + "-" + check_in[1] + "-" + check_in[2], int.Parse(textBoxROOM.Text));
manager_studentsTable.Insert(person);
Button_view_Click(sender, e);
TextBox_name.Clear();
textBox_Birth_city.Clear();
textBoxTIN.Clear();
textBoxSSN.Clear();
textBoxAddress.Clear();
textBoxROOM.Clear();
}
}
