private void btnSaveJob_Click(object sender, EventArgs e) { starth = cmb_startTimeJobH.Text; startm = cmb_endTimeJobM.Text; starttime = starth + startm; endh = cmb_endTimeJobH.Text; endm = cmb_endTimeJobM.Text; endtime = endh + endm; SqlConnection con = new SqlConnection(); if (txt_hierStatus.Text == "" || txt_specialtyJob.Text == "" || txt_establishmentJob.Text == "") { if (MondayJob.Checked == true || TuesdayJob.Checked == true || wednesdayJob.Checked == true || ThursdayJob.Checked == true || fridayJob.Checked == true || SaturdayJob.Checked == true || SundayJob.Checked == true) { //MessageBox.Show("Please fill all fields"); EmptyFields ef2 = new EmptyFields(); ef2.Show(); return; } } else { try { con.ConnectionString = @"Data Source=DESKTOP-69MM1NJ\SQLEXPRESS;Initial Catalog=NadhamniDB;Integrated Security=True;Pooling=False"; con.Open(); SqlCommand cmd = new SqlCommand("insert into Job(HierarchicalStatus,Department,Establishment,DaysOfWork,StartTime,EndTime,UserName) values(@HierarchicalStatus,@Department,@Establishment,@DaysOfWork,@StartTime,@EndTime,@UserName)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@HierarchicalStatus", txt_hierStatus.Text); cmd.Parameters.AddWithValue("@Department", txt_specialtyJob.Text); cmd.Parameters.AddWithValue("@Establishment", txt_establishmentJob.Text); cmd.Parameters.AddWithValue("@DaysOfWork", days); cmd.Parameters.AddWithValue("@StartTime", starttime); cmd.Parameters.AddWithValue("@EndTime", endtime); cmd.Parameters.AddWithValue("@UserName", Home.FK); //Execute Command cmd.ExecuteNonQuery(); sj.Show(); /* Dashboard d = new Dashboard(); * d.Show(); * this.Hide();*/ } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } }
private void btn_signIn_Click(object sender, EventArgs e) { try { con.Open(); cmd.Connection = con; cmd.CommandText = "select * from Profile where UserName='******'"; dr = cmd.ExecuteReader(); if (dr.HasRows) { //get the FK FK = txt_username.Text; Boolean ok = false; while (dr.Read() && ok == false) { if (!txt_password.Text.Equals(dr["Password"])) { PasswordCheck pw = new PasswordCheck(); pw.Show(); // MessageBox.Show("You need to check your password!"); ok = true; } else if (!txt_Email.Text.Equals(dr["Email"])) { //MessageBox.Show("You need to check your E-mail!"); EmailCheck ec = new EmailCheck(); ec.Show(); ok = true; } } if (ok == false) { dsh.Show(); this.Hide(); fb.Hide(); tw.Hide(); gp.Hide(); } } else { if (txt_password.Text.Equals("") && txt_Email.Text.Equals("") && txt_username.Text.Equals("")) { // MessageBox.Show("The fields are empty"); EmptyFields ep = new EmptyFields(); ep.Show(); } else { } // MessageBox.Show("You need to register!"); CheckRegistration crg1 = new CheckRegistration(); crg1.Show(); dr.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }