private void return_btn_Click(object sender, EventArgs e) { Mail_form m = new Mail_form(); m.Show(); this.Hide(); }
private void send_btn_Click(object sender, EventArgs e) { try { dataBase dataBase = new dataBase(); SqlConnection con = dataBase.connect_to_scheduluz_DB(); string reciver_username = to_txt.Text.Replace(" ", ""); string query = "Select id from connection_details Where userName = '******'"; SqlDataAdapter sda = new SqlDataAdapter(query, con); DataTable dtb = new DataTable(); sda.Fill(dtb); if (dtb.Rows.Count > 0) { reciver_id = dtb.Rows[0][0].ToString().Trim(); con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO Mail_box (user_id_send,user_id_get,date_and_time,msg_txt,subject) VALUES (@user_id_send,@user_id_get,@date_and_time,@msg_txt,@subject)", con); cmd.Parameters.Add("@user_id_send", log_in_page.userId); cmd.Parameters.Add("@user_id_get", reciver_id); cmd.Parameters.Add("@date_and_time", DateTime.Now); cmd.Parameters.Add("@msg_txt", msg_txt.Text); cmd.Parameters.Add("@subject", subject_txt.Text); cmd.ExecuteNonQuery(); MessageBox.Show("Your Message has been sent."); Mail_form n = new Mail_form(); n.Show(); this.Hide(); } else { MessageBox.Show("Wrong student name."); } } catch { MessageBox.Show("Problem detected. please contact your Scheduluz Guide for more information."); } }