private void cmb_MemberNumber_SelectedIndexChanged(object sender, EventArgs e) { if (cmb_MemberNumber.Text != "") { string strMemberNumber = cmb_MemberNumber.Text; SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { SqlCommand SQLCommand = new SqlCommand("SELECT DISTINCT First_Name, Last_Name, Hometown FROM tbl_Driver WHERE Member_Number = '" + strMemberNumber + "'", SQL); SqlDataReader SQLReader = SQLCommand.ExecuteReader(); { while (SQLReader.Read()) { cmb_FirstName.Text = SQLReader.GetString(0); cmb_LastName.Text = SQLReader.GetString(1); cmb_Hometown.Text = SQLReader.GetString(2); } SQLReader.Close(); } } SQL.Close(); } }
private void btn_Delete_Click(object sender, EventArgs e) { if (Resources.Confirm_Delete() == false) { return; } //Delete row SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { foreach (DataGridViewRow tempRow in dgv_TimeEntry.SelectedRows) { using (var transaction = SQL.BeginTransaction()) { try { int intID; intID = Convert.ToInt32(tempRow.Cells[0].Value); string strQuery = "DELETE FROM tbl_Time WHERE Time_ID = @ID"; SqlCommand Command = new SqlCommand(strQuery, SQL, transaction); Command.Parameters.AddWithValue("@ID", intID); Command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); transaction.Rollback(); } } } } SQL.Close(); //Update Stages Completed SQL_Commands.Timing.Controls.Stages_Completed(dgv_Stages_Completed); //Update Time Datagrid SQL_Commands.Timing.Controls.Stage_Times(dgv_TimeEntry); //Update Class Results Reports.ExportClassResults(); //Export Query to Wordpress Reports.UploadClassResults(); Reports.UploadOverallResults(); Reports.UploadStages(); //Export Overall Stages Reports.ExportStages(); //Upload Results to FTP FTP_Commands.FTP_Upload_Recent_Stages(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { List <Timing_Data> lst_TD = SQL_Commands.Timing.Get.DNF(SQL); SQL_Commands.Timing.Set.DNF(lst_TD, SQL); } SQL.Close(); }
private void btn_Update_Click(object sender, EventArgs e) { SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { foreach (DataGridViewRow tempRow in dgv_Drivers.Rows) { if (tempRow.IsNewRow == false) { int intID = Convert.ToInt32(tempRow.Cells[0].Value); string strLast = tempRow.Cells[1].Value.ToString(); string strFirst = tempRow.Cells[2].Value.ToString(); string strMemberNumber = tempRow.Cells[3].Value.ToString(); string strHometown = tempRow.Cells[4].Value.ToString(); string strEmail = tempRow.Cells[5].Value.ToString(); using (var dbTransaction = SQL.BeginTransaction()) { try { string strQuery = "UPDATE tbl_Driver " + "SET Last_Name = @LN, First_Name = @FN, Member_Number = @MN, Hometown = @H, Email = @E " + "WHERE Driver_ID = @T"; SqlCommand dbCommand = new SqlCommand(strQuery, SQL, dbTransaction); dbCommand.Parameters.AddWithValue("@T", intID); dbCommand.Parameters.AddWithValue("@LN", strLast); dbCommand.Parameters.AddWithValue("@FN", strFirst); dbCommand.Parameters.AddWithValue("@MN", strMemberNumber); dbCommand.Parameters.AddWithValue("@H", strHometown); dbCommand.Parameters.AddWithValue("@E", strEmail); dbCommand.ExecuteNonQuery(); dbTransaction.Commit(); } catch (Exception exception) { dbTransaction.Rollback(); MessageBox.Show(exception.ToString()); } } } } } SQL.Close(); SQL_Commands.Drivers.Controls.Update_DataGridView(dgv_Drivers); }
public frm_Main_Menu() { InitializeComponent(); if (SQL_Commands.IsServerConnected() == false) { MessageBox.Show("SQL Server is not currently online." + Environment.NewLine + "All data will be locally cached until server returns online."); tslbl_SQLStatus.BackColor = Color.OrangeRed; } else { tslbl_SQLStatus.BackColor = Color.Green; } }
private void btn_Remove_Click(object sender, EventArgs e) { //Cancel Delete if selected as NO if (Resources.Confirm_Delete() == false) { return; } //Delete row SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { using (var transaction = SQL.BeginTransaction()) { foreach (DataGridViewRow tempRow in dgv_Registration.SelectedRows) { try { int intRegistrationID; intRegistrationID = Convert.ToInt32(tempRow.Cells[0].Value); string strQuery = "DELETE FROM tbl_Registration WHERE Registration_ID = @ID"; SqlCommand Command = new SqlCommand(strQuery, SQL, transaction); Command.Parameters.AddWithValue("@ID", intRegistrationID); Command.ExecuteNonQuery(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); transaction.Rollback(); SQL.Close(); return; } } transaction.Commit(); } } SQL.Close(); SQL_Commands.Registration.Update.Registration(dgv_Registration); SQL_Commands.Registration.Get.Registration(dgv_Registration); Reports.ExportRegistration(); Reports.ExportDriverReport(); Reports.UploadDriverReport(); }
private void btn_Delete_Click(object sender, EventArgs e) { if (Resources.Confirm_Delete() == false) { return; } //Delete row SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { foreach (DataGridViewRow tempRow in dgv_Drivers.SelectedRows) { using (var transaction = SQL.BeginTransaction()) { try { int intID; intID = Convert.ToInt32(tempRow.Cells[0].Value); string strQuery = "DELETE FROM tbl_Driver WHERE Driver_ID = @ID"; SqlCommand Command = new SqlCommand(strQuery, SQL, transaction); Command.Parameters.AddWithValue("@ID", intID); Command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception exception) { MessageBox.Show(exception.ToString()); transaction.Rollback(); } } } } SQL.Close(); SQL_Commands.Drivers.Controls.Update_DataGridView(dgv_Drivers); }
private int Get_Venue_ID(string Venue) { int tempID = 0; SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { SqlCommand Command; SqlDataReader Reader; Command = new SqlCommand("SELECT DISTINCT Venue_ID FROM tbl_Venue WHERE Name = '" + Venue + "'", SQL); Reader = Command.ExecuteReader(); while (Reader.Read()) { tempID = Reader.GetInt32(0); } Reader.Close(); } return(tempID); }
private void btn_Create_Click(object sender, EventArgs e) { string str_EventNumber = txt_Number.Text; int int_VenueID = Get_Venue_ID(cmb_Venue.Text); string str_EventName = txt_Name.Text; DateTime dt_Date = Convert.ToDateTime(dt_Event_Date.Text); SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (var Transaction = SQL.BeginTransaction()) { try { String Query = "INSERT INTO tbl_Event " + "(Number,Name,Date,Status,Venue_ID) " + "VALUES (@Num,@N,@D,@S,@V)"; SqlCommand Command = new SqlCommand(Query, SQL, Transaction); Command.Parameters.AddWithValue("@Num", str_EventNumber); Command.Parameters.AddWithValue("@N", str_EventName); Command.Parameters.AddWithValue("@D", dt_Date); Command.Parameters.AddWithValue("@S", false); Command.Parameters.AddWithValue("@V", int_VenueID); Command.ExecuteNonQuery(); Transaction.Commit(); } catch (Exception excepted) { MessageBox.Show(excepted.ToString()); Transaction.Rollback(); } } SQL.Close(); //Clear Form After Event Created MessageBox.Show("Event Created Sucessfully"); cmb_Venue.SelectedIndex = -1; txt_Name.Text = ""; txt_Number.Text = ""; }
private void Update_Venues() { SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { List <string> lst_Temp = new List <string>(); SqlCommand Command; SqlDataReader Reader; Command = new SqlCommand("SELECT DISTINCT Name FROM tbl_Venue", SQL); Reader = Command.ExecuteReader(); while (Reader.Read()) { lst_Temp.Add(Reader.GetString(0)); } Reader.Close(); lst_Temp.Sort(); cmb_Venue.DataSource = lst_Temp.ToArray(); cmb_Venue.Update(); } }
private void btn_Update_Click(object sender, EventArgs e) { SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { foreach (DataGridViewRow tempRow in dgv_TimeEntry.Rows) { int intTimeID = Convert.ToInt32(tempRow.Cells[0].Value); int intStage = Convert.ToInt32(tempRow.Cells[4].Value); decimal decStageTime = Convert.ToDecimal(tempRow.Cells[5].Value); int intCones = Convert.ToInt32(tempRow.Cells[6].Value); int intGates = Convert.ToInt32(tempRow.Cells[7].Value); bool Off_Course = Convert.ToBoolean(tempRow.Cells[8].Value); decimal decTotalTime = Resources.Caluclate_FinishTime(decStageTime, intCones, intGates, Off_Course); using (var dbTransaction = SQL.BeginTransaction()) { try { string strQuery = "UPDATE tbl_Time " + "SET Stage_Number = @SN, Stage_Time = @ST, Cones_Hit = @C, Gates_Missed = @G, Off_Course = @OC, Total_Time = @TT " + "WHERE Time_ID = @T"; SqlCommand dbCommand = new SqlCommand(strQuery, SQL, dbTransaction); dbCommand.Parameters.AddWithValue("@SN", intStage); dbCommand.Parameters.AddWithValue("@ST", decStageTime); dbCommand.Parameters.AddWithValue("@C", intCones); dbCommand.Parameters.AddWithValue("@G", intGates); dbCommand.Parameters.AddWithValue("@OC", Off_Course); dbCommand.Parameters.AddWithValue("@TT", decTotalTime); dbCommand.Parameters.AddWithValue("@T", intTimeID); dbCommand.ExecuteNonQuery(); dbTransaction.Commit(); } catch (Exception exception) { dbTransaction.Rollback(); MessageBox.Show(exception.ToString()); } } } } SQL.Close(); //Update Stages Completed SQL_Commands.Timing.Controls.Stages_Completed(dgv_Stages_Completed); //Update Time Datagrid SQL_Commands.Timing.Controls.Stage_Times(dgv_TimeEntry); //Export Query to Wordpress Reports.UploadClassResults(); Reports.UploadOverallResults(); Reports.UploadStages(); //Export Overall Stages Reports.ExportStages(); //Upload Results to FTP FTP_Commands.FTP_Upload_Recent_Stages(); }
private void btn_Submit_Click(object sender, EventArgs e) { //Verify All Fields Have Data if (CheckSwitches() == false) { return; } //Define Variables required double dblEvent = Convert.ToDouble(cmb_Event.Text); double dblPaymentAmount = Convert.ToDouble(txt_PaymentAmount.Text); int intEventID = 0; int intDriverID = 0; int intNumberID = 0; int intVehicleID = 0; int intClassID = 0; int intVehicleNumber = Convert.ToInt32(txt_VehicleNumber.Text); int intYear = Convert.ToInt32(cmb_Year.Text); string strFirstName = cmb_FirstName.Text; string strLastName = cmb_LastName.Text; string strHometown = cmb_Hometown.Text; string strMemberNumber = cmb_MemberNumber.Text; string strClass = cmb_Class.Text; string strMake = cmb_Make.Text; string strModel = cmb_Model.Text; string strPaymentType = cmb_PaymentType.Text; bool blPaymentReceived = Convert.ToBoolean(cmb_PaymentReceived.Text); bool blCheckedIn = Convert.ToBoolean(cmb_CheckedIn.Text); //Update Current Registration Data SQL_Commands.Registration.Update.Registration(dgv_Registration); //Insert New Drivers SqlConnection SQL = SQL_Commands.Connect(); SQL.Open(); using (SQL) { //Get Event_ID intEventID = SQL_Commands.Registration.Get.Event(dblEvent, SQL); //Get Driver_ID intDriverID = SQL_Commands.Registration.Get.Driver(strLastName, strFirstName, SQL); if (intDriverID == 0) { SQL_Commands.Registration.Create.Driver(strLastName, strFirstName, strMemberNumber, strHometown, SQL); intDriverID = SQL_Commands.Registration.Get.Driver(strLastName, strFirstName, SQL); } //Get Number ID intNumberID = SQL_Commands.Registration.Get.Number(intVehicleNumber, SQL); if (intNumberID == 0) { SQL_Commands.Registration.Create.Number(intVehicleNumber, SQL); intNumberID = SQL_Commands.Registration.Get.Number(intVehicleNumber, SQL); } //Get Class ID intClassID = SQL_Commands.Registration.Get.Class(strClass, SQL); //Get Vehicle ID intVehicleID = SQL_Commands.Registration.Get.Vehicle(intYear, strMake, strModel, SQL); if (intVehicleID == 0) { SQL_Commands.Registration.Create.Vehicle(intYear, strMake, strModel, SQL); intVehicleID = SQL_Commands.Registration.Get.Vehicle(intYear, strMake, strModel, SQL); } //Check for Duplicates if (SQL_Commands.Registration.Find_Dup_Reg(intClassID, intNumberID, SQL) == true) { MessageBox.Show("Duplicate Number/Class Combination. Please verify registration data."); SQL.Close(); return; } if (SQL_Commands.Registration.Find_Dup_Driver(intDriverID, SQL) == true) { MessageBox.Show("Driver is already registered. Please verify registration data."); SQL.Close(); return; } SQL_Commands.Registration.Submit_Registration(intEventID, intDriverID, intClassID, intVehicleID, intNumberID, strPaymentType, dblPaymentAmount, blPaymentReceived, blCheckedIn, false, SQL); } SQL.Close(); SQL_Commands.Registration.Get.Registration(dgv_Registration); Reports.ExportRegistration(); Reports.ExportDriverReport(); Reports.UploadDriverReport(); Clear_Form(); }