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 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();
}
