private void label1_Click_1(object sender, EventArgs e)
{
Form UserQueue = new User_Ticket_View_Screen();
this.Hide();
UserQueue.Show();
}
private void Submit_btn_Click(object sender, EventArgs e)//NEEDS MORE CODE NAVIGATIONAL ONLY NOW
{
try
{
connectionstring = "Data Source = isys4363.walton.uark.edu; Initial Catalog = TicketingSystem; User ID = isys4363a; Password = GohogsUA20";
connection = new SqlConnection(connectionstring);
int answer;
string sql2 = null;
sql = "SELECT CatID from Category where Category = '" + CategoryCB.ToString() + "'";
sql2 = "INSERT INTO Ticket VALUES (@UserID, @Status, @AssignedTo, @Priority, @DateIssued, @DateR, @CatID, @Category, @Description, @UserName) ";
connection.Open();
string UID2 = "";
string CatID2 = "";
command = new SqlCommand(sql2, connection);
command.Parameters.AddWithValue("@UserID", DBNull.Value);
command.Parameters.AddWithValue("@Status", "Active"); //
command.Parameters.AddWithValue("@AssignedTo", " ");
command.Parameters.AddWithValue("@Priority", PriorityCB.SelectedItem.ToString());
command.Parameters.AddWithValue("@DateIssued", Datetxt.Text);
command.Parameters.AddWithValue("@DateR", "Ongoing");
command.Parameters.AddWithValue("@CatID", DBNull.Value);
command.Parameters.AddWithValue("@Category", CategoryCB.SelectedItem.ToString());
command.Parameters.AddWithValue("@Description", DescribeTxt.Text);
command.Parameters.AddWithValue("@UserName", UserIDtxt.Text);
answer = command.ExecuteNonQuery();
command.Dispose();
connection.Close();
connection = new SqlConnection(connectionstring);
sql = "UPDATE Ticket SET CatID = @CATID WHERE TicketID = @TID";
connection.Open();
command = new SqlCommand(sql, connection);
// int UID = int.Parse(UserIDtxt.Text);
int CATID = int.Parse(CATIDtxt.Text) + 1;
command.Parameters.AddWithValue("@TID", TicketIDtxt.Text);
command.Parameters.AddWithValue("@CATID", CATID);
answer = command.ExecuteNonQuery();
command.Dispose();
connection.Close();
MessageBox.Show("Your Ticket has been Submitted and added to our queue. Your ticket will be resolved shortly.");
Form UserQueue = new User_Ticket_View_Screen();
this.Hide();
UserQueue.Show();
}
catch (Exception ex)
{
MessageBox.Show("An error occurred while inserting data " + ex);
}
////////////////
}