private void btn_teach_reg_Click(object sender, EventArgs e) { this.Hide(); Registered_teachers teacher = new Registered_teachers(); teacher.Show(); }
private void button1_Click(object sender, EventArgs e) { this.Hide(); Registered_teachers obj = new Registered_teachers(); obj.Show(); }
public void save() { if ((text_tchname.Text == "") || (text_tchlastname.Text == "") || (text_tchfathername.Text == "") || (text_tchCNIC.Text == "") || (text_tchemail.Text == "") || (text_tchmobile.Text == "") || (combo_course.Text == "") || (tchdob.Text == "") || (text_tchaddress.Text == "") || (combo_tchprovince.Text == "") || (combo_tchcity.Text == "") || (combo_tchcountry.Text == "") || (tchpictureBox.Image == null) || (rdn_tchmale.Checked == false) && (rdn_tchfemale.Checked == false)) { MessageBox.Show("One or more Fields are Empty..!"); } else { con.openconn(); if (flag == 0) { if (rdn_tchmale.Checked) { gender = "Male"; } else { gender = "Female"; } SqlCommand cmd = new SqlCommand("INSERT INTO Teacher(fname,lname,fathername,cnic,email,mobile,crsid,dateofbirth,address,gender,con_id,c_id,pro_id,pic) VALUES ('" + text_tchname.Text + "','" + text_tchlastname.Text + "','" + text_tchfathername.Text + "','" + text_tchCNIC.Text + "','" + text_tchemail.Text + "','" + text_tchmobile.Text + "','" + Convert.ToInt32(combo_course.SelectedValue.ToString()) + "','" + Convert.ToDateTime(tchdob.Text) + "','" + text_tchaddress.Text + "','" + gender + "','" + Convert.ToInt32(combo_tchcountry.SelectedValue.ToString()) + "','" + Convert.ToInt32(combo_tchcity.SelectedValue.ToString()) + "','" + Convert.ToInt32(combo_tchprovince.SelectedValue.ToString()) + "',@pic)", con.openconn()); MemoryStream stream = new MemoryStream(); tchpictureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] pic = stream.ToArray(); cmd.Parameters.AddWithValue("@pic", pic); j = cmd.ExecuteNonQuery(); if (j > 0) { MessageBox.Show("Record Save Successfully!"); } } else { SqlCommand cmd = new SqlCommand("update Teacher set fname='" + text_tchname.Text + "', lname='" + text_tchlastname.Text + "',fathername='" + text_tchfathername.Text + "',cnic='" + text_tchCNIC.Text + "',email='" + text_tchemail.Text + "', mobile='" + text_tchmobile.Text + "', pic='" + tchpictureBox.Image + "',crsid='" + combo_course.SelectedValue.ToString() + "',dateofbirth='" + Convert.ToDateTime(tchdob.Text) + "',address='" + text_tchaddress.Text + "',gender='" + gender + "',con_id='" + Convert.ToInt32(combo_tchcountry.SelectedValue) + "',pro_id='" + Convert.ToInt32(combo_tchprovince.SelectedValue) + "',c_id='" + Convert.ToInt32(combo_tchcity.SelectedValue) + "' Where teacherid = '" + id + "'", con.openconn()); cmd.ExecuteNonQuery(); MessageBox.Show("Record Update Successfully!"); Registered_teachers r = new Registered_teachers(); r.Show(); this.Dispose(); } con.connclose(); } }