public void AdultClass(int studentID, int TutorID, int RoomID) { DialogResult DR = MessageBox.Show("This slot is reserved for Adults! Do you wish to proceed?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (DR == DialogResult.Yes) { switch (cboLessons.Text) { case "20": MessageBox.Show("There is a 5% Discount available with the 20 Lessons. Please Use Promo Code: 20L5%"); break; case "30": MessageBox.Show("There is a 10% Discount available with the 30 Lessons. Please Use Promo Code: 30L10%"); break; default: MessageBox.Show("No Discount Available"); break; } DAL.BookingDAL.addNewBooking(studentID, TutorID, RoomID, cboBlock.Text, cboDay.Text, cboTime.Text, cboPayment.Text, int.Parse(tbAmount.Text), int.Parse(cboLessons.Text)); this.Hide(); frmViewBookings NextScreen = new frmViewBookings(); NextScreen.ShowDialog(); this.Dispose(); } else { } }
private void btnCancel_Click(object sender, EventArgs e) { this.Hide(); frmViewBookings nextScreen = new frmViewBookings(); nextScreen.ShowDialog(); }
private void btnSave_Click(object sender, EventArgs e) { try { string _Connectionstring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\MitchellMusicDB.mdf;Integrated Security=True"; int studentID, TutorID, RoomID; string[] nameParts = cboStudent.Text.Split(' '); string firstName = nameParts[0]; string lastName = nameParts[1]; string[] nameParts1 = cboTutor.Text.Split(' '); string firstName1 = nameParts1[0]; string lastName1 = nameParts1[1]; bool studentBooking = false, TutorAvailable = true, RoomUsed = false; using (SqlConnection connection = new SqlConnection(_Connectionstring)) { connection.Open(); string sqlQuery = string.Format("SELECT * FROM tbl_Student where Student_Name = '{0}' and Student_Surname = '{1}'", firstName, lastName); string sqlQuery1 = string.Format("SELECT * FROM Tbl_Tutor where Tutor_Name = '{0}' and Tutor_Surname = '{1}'", firstName1, lastName1); // string sqlQuery2 = string.Format("SELECT * FROM tbl_Lesson where Student_ID = '{0}' and Lesson_Allocated = '{1}'", studentID, cboBlock.Text); SqlCommand insertCommand = new SqlCommand(sqlQuery, connection); //SqlCommand insertCommand1 = new SqlCommand(sqlQuery1, connection); SqlDataReader rdr = insertCommand.ExecuteReader(); // if (rdr.Read()) { studentID = int.Parse(rdr[0].ToString()); rdr.Close(); } else { studentID = 0; } rdr.Close(); SqlCommand insertCommand1 = new SqlCommand(sqlQuery1, connection); SqlDataReader rdr1 = insertCommand1.ExecuteReader(); if (rdr1.Read()) { TutorID = int.Parse(rdr1[0].ToString()); rdr1.Close(); } else { TutorID = 0; } #region student Double Booked Check string sqlQuery2 = string.Format("SELECT * FROM tbl_Lesson where Student_ID = '{0}' and Lesson_Allocated = '{1}'", studentID, cboBlock.Text); SqlCommand insertCommand2 = new SqlCommand(sqlQuery2, connection); SqlDataReader rdr2 = insertCommand2.ExecuteReader(); if (rdr2.HasRows) { studentBooking = false; } else { studentBooking = true; } rdr2.Close(); #endregion #region Room Check string sqlQuery3 = string.Format("SELECT * FROM tbl_Lesson where Room_ID = '{0}' and Lesson_Allocated = '{1}' and Lesson_Day = '{2}' and Lesson_Time = '{3}'", int.Parse(cboRooms.Text), cboBlock.Text, cboDay.Text, cboTime.Text); SqlCommand insertCommand3 = new SqlCommand(sqlQuery3, connection); SqlDataReader rdr3 = insertCommand3.ExecuteReader(); if (rdr3.HasRows) { RoomUsed = false; } else { RoomUsed = true; } rdr3.Close(); #endregion #region Tutor Already used string sqlQuery4 = string.Format("SELECT * FROM tbl_Lesson where Tutor_ID = '{0}' and Lesson_Allocated = '{1}' and Lesson_Day = '{2}' and Lesson_Time = '{3}'", TutorID, cboBlock.Text, cboDay.Text, cboTime.Text); SqlCommand insertCommand4 = new SqlCommand(sqlQuery4, connection); SqlDataReader rdr4 = insertCommand3.ExecuteReader(); if (rdr4.HasRows) { TutorAvailable = false; } else { TutorAvailable = true; } rdr4.Close(); #endregion connection.Dispose(); connection.Close(); //MessageBox.Show("Student ID: " + studentID.ToString() + "Tutor ID: " + TutorID.ToString()); } RoomID = int.Parse(cboRooms.Text); try { DAL.BookingDAL.UpdateBooking(studentID, TutorID, cboBlock.Text, int.Parse(cboLessons.Text), cboPayment.Text, int.Parse(tbAmount.Text), cboTime.Text, cboDay.Text); } catch (Exception ex) { if (count < 1) { add.showBalloonTip("Error", "Something Went Wrong"); } System.IO.StreamWriter writer = new System.IO.StreamWriter("../../ErrorLog.txt", true); writer.WriteLine("- " + DateTime.Now + " " + ex.Message, true); writer.Flush(); writer.Close(); count++; } this.Hide(); frmViewBookings nextScreen = new frmViewBookings(); nextScreen.ShowDialog(); this.Dispose(); this.Hide(); } catch (Exception ex) { if (count1 < 1) { add.showBalloonTip("Error", "Something Went Wrong"); } System.IO.StreamWriter writer = new System.IO.StreamWriter("../../ErrorLog.txt", true); writer.WriteLine("- " + DateTime.Now + " " + ex.Message, true); writer.Flush(); writer.Close(); count1++; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (Controls.OfType <TextBox>().Any(t => t.Text == "")) { add.showBalloonTip("Field entries", "All Fields must be used"); } else if (Controls.OfType <ComboBox>().Any(t => t.Text == "")) { add.showBalloonTip("Field entries", "All Fields must be used"); } else { string _Connectionstring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\MitchellMusicDB.mdf;Integrated Security=True"; int studentID, TutorID, RoomID; string[] nameParts = cboStudent.Text.Split(' '); string firstName = nameParts[0]; string lastName = nameParts[1]; string[] nameParts1 = cboTutor.Text.Split(' '); string firstName1 = nameParts1[0]; string lastName1 = nameParts1[1]; bool studentBooking, TutorAvailable, RoomUsed; using (SqlConnection connection = new SqlConnection(_Connectionstring)) { connection.Open(); string sqlQuery = string.Format("SELECT * FROM tbl_Student where Student_Name = '{0}' and Student_Surname = '{1}'", firstName.ToString(), lastName.ToString()); string sqlQuery1 = string.Format("SELECT * FROM Tbl_Tutor where Tutor_Name = '{0}' and Tutor_Surname = '{1}'", firstName1.ToString(), lastName1.ToString()); // string sqlQuery2 = string.Format("SELECT * FROM tbl_Lesson where Student_ID = '{0}' and Lesson_Allocated = '{1}'", studentID, cboBlock.Text); SqlCommand insertCommand = new SqlCommand(sqlQuery, connection); //SqlCommand insertCommand1 = new SqlCommand(sqlQuery1, connection); SqlDataReader rdr = insertCommand.ExecuteReader(); // if (rdr.Read()) { studentID = int.Parse(rdr[0].ToString()); rdr.Close(); } else { studentID = 0; } rdr.Close(); SqlCommand insertCommand1 = new SqlCommand(sqlQuery1, connection); SqlDataReader rdr1 = insertCommand1.ExecuteReader(); if (rdr1.Read()) { TutorID = int.Parse(rdr1[0].ToString()); rdr1.Close(); } else { TutorID = 0; } #region student Double Booked Check string sqlQuery2 = string.Format("SELECT COUNT(*) FROM tbl_Lesson where Student_ID = '{0}' and Lesson_Allocated = '{1}'", studentID, cboBlock.Text); SqlCommand insertCommand2 = new SqlCommand(sqlQuery2, connection); SqlDataReader rdr2 = insertCommand2.ExecuteReader(); if (rdr2.Read()) { int x = int.Parse(rdr2[0].ToString()); if (x <= 1) { studentBooking = true; } else { studentBooking = false; } } else { studentBooking = false; } rdr2.Close(); #endregion #region Room Check string sqlQuery3 = string.Format("SELECT * FROM tbl_Lesson where Room_ID = '{0}' and Lesson_Allocated = '{1}' and Lesson_Day = '{2}' and Lesson_Time = '{3}'", int.Parse(cboRooms.Text), cboBlock.Text, cboDay.Text, cboTime.Text); SqlCommand insertCommand3 = new SqlCommand(sqlQuery3, connection); SqlDataReader rdr3 = insertCommand3.ExecuteReader(); if (rdr3.HasRows) { RoomUsed = false; } else { RoomUsed = true; } rdr3.Close(); #endregion #region Tutor Already used string sqlQuery4 = string.Format("SELECT * FROM tbl_Lesson where Tutor_ID = '{0}' and Lesson_Allocated = '{1}' and Lesson_Day = '{2}' and Lesson_Time = '{3}'", TutorID, cboBlock.Text, cboDay.Text, cboTime.Text); SqlCommand insertCommand4 = new SqlCommand(sqlQuery4, connection); SqlDataReader rdr4 = insertCommand3.ExecuteReader(); if (rdr4.HasRows) { TutorAvailable = false; } else { TutorAvailable = true; } rdr4.Close(); #endregion connection.Dispose(); connection.Close(); //MessageBox.Show("Student ID: " + studentID.ToString() + "Tutor ID: " + TutorID.ToString()); } RoomID = int.Parse(cboRooms.Text); try { if (studentBooking == false) { MessageBox.Show("Student Booking Already Exists"); } else if (TutorAvailable == false) { MessageBox.Show("Tutor already Utilised"); } else if (RoomUsed == false) { MessageBox.Show("Room Already in use"); } else { switch (cboTime.Text) { case "13:00-13:30": AdultClass(studentID, TutorID, RoomID); break; case "13:30-14:00": AdultClass(studentID, TutorID, RoomID); break; case "14:00-14:30": AdultClass(studentID, TutorID, RoomID); break; case "14:30-15:00": AdultClass(studentID, TutorID, RoomID); break; default: break; } switch (cboLessons.Text) { case "20": MessageBox.Show("There is a 5% Discount available with the 20 Lessons. Please Use Promo Code: 20L5%"); break; case "30": MessageBox.Show("There is a 10% Discount available with the 30 Lessons. Please Use Promo Code: 30L10%"); break; default: MessageBox.Show("No Discount Available"); break; } int rowsAffected = DAL.BookingDAL.addNewBooking(studentID, TutorID, RoomID, cboBlock.Text, cboDay.Text, cboTime.Text, cboPayment.Text, int.Parse(tbAmount.Text), int.Parse(cboLessons.Text)); if (rowsAffected == 1) { this.Hide(); frmViewBookings nextScreen = new frmViewBookings(); nextScreen.ShowDialog(); this.Dispose(); } else { } } } catch (Exception ex) { if (count < 1) { add.showBalloonTip("Error", "Something Went Wrong"); } System.IO.StreamWriter writer = new System.IO.StreamWriter("../../ErrorLog.txt", true); writer.WriteLine("- " + DateTime.Now + " " + ex.Message, true); writer.Flush(); writer.Close(); count++; } } } catch (Exception ex) { if (count1 < 1) { add.showBalloonTip("Error", "Something Went Wrong"); } System.IO.StreamWriter writer = new System.IO.StreamWriter("../../ErrorLog.txt", true); writer.WriteLine("- " + DateTime.Now + " " + ex.Message, true); writer.Flush(); writer.Close(); count1++; } }