private void btn_std_reg_Click(object sender, EventArgs e)
{
this.Hide();
registered_students student = new registered_students();
student.Show();
}
private void button1_Click(object sender, EventArgs e)
{
this.Close();
registered_students stu = new registered_students();
stu.Show();
}
//Method to insert data
public void save()
{
adpt = new SqlDataAdapter("Select username from LoginTable", con.openconn());
adpt.Fill(dt);
con.connclose();
int username = 0;
for (int i = 0; i < dt.Rows.Count - 1; i++)
{
if (dt.Rows[i]["username"].ToString() == username_textbox.Text)
{
username = 1;
}
}
if ((text_stdname.Text == "") || (text_lastname.Text == "") || (text_fathername.Text == "") ||
(text_fatherid.Text == "") || (text_email.Text == "") || (text_mobile.Text == "") ||
(combo_class.Text == "") || (dobpicker.Text == "") || (text_address.Text == "") || (combo_province.Text == "") || (combo_city.Text == "") || (combo_country.Text == "")
|| (StdpictureBox.Image == null) ||
(rdn_male.Checked == false) && (rdn_female.Checked == false))
{
MessageBox.Show("One or more Fields are Empty..!");
}
else if (username == 1)
{
MessageBox.Show("Username Already Exits");
}
else
{
if (flag == 0)
{
con.openconn();
if (rdn_male.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
SqlCommand cmd = new SqlCommand("INSERT INTO Student(Firstname,Lastname,Fathername,Fatherid,email,mobileno,Class,Datefbirth,Address,Gender,Countryid,Cityid,Provinceid,studentimage) VALUES ('" + text_stdname.Text + "','" + text_lastname.Text + "','" + text_fathername.Text + "','" + text_fatherid.Text + "','" + text_email.Text + "','" + text_mobile.Text + "','" + Convert.ToInt32(combo_class.SelectedValue) + "','" + Convert.ToDateTime(dobpicker.Text) + "','" + text_address.Text + "','" + gender + "','" + Convert.ToInt32(combo_country.SelectedValue) + "','" + Convert.ToInt32(combo_city.SelectedValue) + "','" + Convert.ToInt32(combo_province.SelectedValue) + "',@studentimage)", con.openconn());
MemoryStream stream = new MemoryStream();
StdpictureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
String user = "******";
SqlCommand login_table = new SqlCommand("Insert into LoginTable(username,password,role) values ('" + username_textbox.Text + "','" + pass_textBox.Text + "','" + user + "')", con.openconn());
byte[] pic = stream.ToArray();
cmd.Parameters.AddWithValue("@studentimage", pic);
j = cmd.ExecuteNonQuery();
login_table.ExecuteNonQuery();
if (j > 0)
{
MessageBox.Show("Record Save Successfully!" + j + "Row");
}
}
else
{
SqlCommand cmd = new SqlCommand("update Student set Firstname='" + text_stdname.Text + "', Lastname='" + text_lastname.Text + "',Fathername='" + text_fathername.Text + "',Fatherid='" + text_fatherid.Text + "',Email='" + text_email.Text + "',Mobileno='" + text_mobile.Text + "',studentimage='" + StdpictureBox.Image + "',Class='" + combo_class.SelectedValue.ToString() + "',Datefbirth='" + Convert.ToDateTime(dobpicker.Text) + "',Address='" + text_address.Text + "',Gender='" + gender + "',CountryID='" + combo_country.SelectedValue.ToString() + "',ProvinceID='" + combo_province.SelectedValue.ToString() + "',CityID='" + combo_city.SelectedValue.ToString() + "' Where Studentid = '" + id + "'", con.openconn());
cmd.ExecuteNonQuery();
}
con.connclose();
registered_students r = new registered_students();
r.Show();
this.Dispose();
}
}