MyForm14.h

#pragma once

namespace R {

	using namespace System;
	using namespace System::ComponentModel;
	using namespace System::Collections;
	using namespace System::Windows::Forms;
	using namespace System::Data;
	using namespace System::Drawing;
	using namespace System::Data::SqlClient;
	/// <summary>
	/// Summary for MyForm14
	/// </summary>
	public ref class MyForm14 : public System::Windows::Forms::Form
	{
	public:
		String^ I="";
	private: System::Windows::Forms::Button^ button1;
	public:
		String^ C = "";
		MyForm14(void)
		{
			InitializeComponent();
			//
			//TODO: Add the constructor code here
			//
		}
		MyForm14(String^ ID)
		{
			I = ID;
			C = ID;
		}
	protected:
		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		~MyForm14()
		{
			if (components)
			{
				delete components;
			}
		}
	private: System::Windows::Forms::Label^ label1;
	protected:
	private: System::Windows::Forms::Label^ label2;
	private: System::Windows::Forms::Label^ label3;
	private: System::Windows::Forms::TextBox^ textBox2;
	private: System::Windows::Forms::TextBox^ textBox1;
	private: System::Windows::Forms::TextBox^ textBox3;
	private: System::Windows::Forms::Button^ button2;

	private:
		/// <summary>
		/// Required designer variable.
		/// </summary>
		System::ComponentModel::Container ^components;

#pragma region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		void InitializeComponent(void)
		{
			System::ComponentModel::ComponentResourceManager^ resources = (gcnew System::ComponentModel::ComponentResourceManager(MyForm14::typeid));
			this->label1 = (gcnew System::Windows::Forms::Label());
			this->label2 = (gcnew System::Windows::Forms::Label());
			this->label3 = (gcnew System::Windows::Forms::Label());
			this->textBox2 = (gcnew System::Windows::Forms::TextBox());
			this->textBox1 = (gcnew System::Windows::Forms::TextBox());
			this->textBox3 = (gcnew System::Windows::Forms::TextBox());
			this->button2 = (gcnew System::Windows::Forms::Button());
			this->button1 = (gcnew System::Windows::Forms::Button());
			this->SuspendLayout();
			// 
			// label1
			// 
			this->label1->AutoSize = true;
			this->label1->BackColor = System::Drawing::Color::Transparent;
			this->label1->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
			this->label1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->label1->ForeColor = System::Drawing::SystemColors::ControlLightLight;
			this->label1->Location = System::Drawing::Point(25, 205);
			this->label1->Name = L"label1";
			this->label1->Size = System::Drawing::Size(262, 39);
			this->label1->TabIndex = 4;
			this->label1->Text = L"Economic Class";
			// 
			// label2
			// 
			this->label2->AutoSize = true;
			this->label2->BackColor = System::Drawing::Color::Transparent;
			this->label2->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
			this->label2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->label2->ForeColor = System::Drawing::SystemColors::ControlLightLight;
			this->label2->Location = System::Drawing::Point(27, 271);
			this->label2->Name = L"label2";
			this->label2->Size = System::Drawing::Size(260, 39);
			this->label2->TabIndex = 5;
			this->label2->Text = L"Business  Class";
			// 
			// label3
			// 
			this->label3->AutoSize = true;
			this->label3->BackColor = System::Drawing::Color::Transparent;
			this->label3->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
			this->label3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->label3->ForeColor = System::Drawing::SystemColors::ControlLightLight;
			this->label3->Location = System::Drawing::Point(27, 131);
			this->label3->Name = L"label3";
			this->label3->Size = System::Drawing::Size(178, 39);
			this->label3->TabIndex = 6;
			this->label3->Text = L"First Class";
			// 
			// textBox2
			// 
			this->textBox2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->textBox2->Location = System::Drawing::Point(368, 131);
			this->textBox2->Name = L"textBox2";
			this->textBox2->Size = System::Drawing::Size(97, 45);
			this->textBox2->TabIndex = 12;
			// 
			// textBox1
			// 
			this->textBox1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->textBox1->Location = System::Drawing::Point(368, 199);
			this->textBox1->Name = L"textBox1";
			this->textBox1->Size = System::Drawing::Size(97, 45);
			this->textBox1->TabIndex = 13;
			// 
			// textBox3
			// 
			this->textBox3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20));
			this->textBox3->Location = System::Drawing::Point(368, 268);
			this->textBox3->Name = L"textBox3";
			this->textBox3->Size = System::Drawing::Size(97, 45);
			this->textBox3->TabIndex = 14;
			// 
			// button2
			// 
			this->button2->BackColor = System::Drawing::Color::DimGray;
			this->button2->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
			this->button2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 15));
			this->button2->ForeColor = System::Drawing::SystemColors::ActiveCaptionText;
			this->button2->Location = System::Drawing::Point(178, 348);
			this->button2->Name = L"button2";
			this->button2->Size = System::Drawing::Size(151, 83);
			this->button2->TabIndex = 15;
			this->button2->Text = L"Modify Fare";
			this->button2->UseVisualStyleBackColor = false;
			this->button2->Click += gcnew System::EventHandler(this, &MyForm14::button2_Click);
			// 
			// button1
			// 
			this->button1->BackColor = System::Drawing::Color::DimGray;
			this->button1->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
			this->button1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 15));
			this->button1->ForeColor = System::Drawing::SystemColors::ControlText;
			this->button1->Location = System::Drawing::Point(417, 348);
			this->button1->Name = L"button1";
			this->button1->Size = System::Drawing::Size(151, 83);
			this->button1->TabIndex = 16;
			this->button1->Text = L"Back";
			this->button1->UseVisualStyleBackColor = false;
			this->button1->Click += gcnew System::EventHandler(this, &MyForm14::button1_Click);
			// 
			// MyForm14
			// 
			this->AutoScaleDimensions = System::Drawing::SizeF(8, 16);
			this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
			this->BackColor = System::Drawing::Color::Black;
			this->BackgroundImage = (cli::safe_cast<System::Drawing::Image^>(resources->GetObject(L"$this.BackgroundImage")));
			this->ClientSize = System::Drawing::Size(1067, 683);
			this->Controls->Add(this->button1);
			this->Controls->Add(this->button2);
			this->Controls->Add(this->textBox3);
			this->Controls->Add(this->textBox1);
			this->Controls->Add(this->textBox2);
			this->Controls->Add(this->label3);
			this->Controls->Add(this->label2);
			this->Controls->Add(this->label1);
			this->Icon = (cli::safe_cast<System::Drawing::Icon^>(resources->GetObject(L"$this.Icon")));
			this->Name = L"MyForm14";
			this->Text = L"Edit Fare";
			this->Load += gcnew System::EventHandler(this, &MyForm14::MyForm14_Load);
			this->ResumeLayout(false);
			this->PerformLayout();

		}
#pragma endregion
	private: System::Void MyForm14_Load(System::Object^ sender, System::EventArgs^ e) {
		try {
			SqlConnection^ conn = gcnew SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=ADMIN;Integrated Security=True");
			conn->Open();

			// Prepare SQL query to select data from Lahore table
			SqlCommand^ cmd = gcnew SqlCommand("SELECT E_Fare, F_Fare, B_Fare FROM " + C + " WHERE Id=@Id", conn);


			cmd->Parameters->AddWithValue("@id", I);

			// Execute SQL query and get result set
			SqlDataReader^ reader = cmd->ExecuteReader();
			int e=10,f=10,b=10;
			bool open = false;
		
			// Check if there is a row returned
			if (reader->Read())
			{
				// Get the value of the UserName column from the current row
				e = reader->GetInt32(0);
				f = reader->GetInt32(1);
				b = reader->GetInt32(2);
				
				textBox1->Text = e.ToString();
				textBox2->Text = f.ToString();
				textBox3->Text = b.ToString();
				
				// Do something with the username...
				open = true;
			}
			else {
				MessageBox::Show("Enter Correct Train-ID", "Error", MessageBoxButtons::OK, MessageBoxIcon::Error);
				this->Close();
			}
			

			// Close the reader and the SqlConnection
			reader->Close();

		
			conn->Close();









		}
		catch (SqlException^ e)
		{
			MessageBox::Show(e->Message);
		}

	}
	private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) {
		SqlConnection^ conn = gcnew SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=ADMIN;Integrated Security=True");
		conn->Open();
		int e1 = Convert::ToInt32(textBox1->Text);
		int f = Convert::ToInt32(textBox2->Text);
		int b = Convert::ToInt32(textBox3->Text);
		SqlCommand^ cmd1 = gcnew SqlCommand("UPDATE " + C + " SET E_Fare = @NewValue1, F_Fare = @NewValue2, B_Fare = @Bf WHERE Id = @Id", conn);
		if (e1 > 100 && e1 < 5000 && f > 100 && f < 5000 && b < 5000 && b > 100)
		{
			cmd1->Parameters->AddWithValue("@id", I);
			cmd1->Parameters->AddWithValue("@NewValue1", textBox1->Text);
			cmd1->Parameters->AddWithValue("@NewValue2", textBox2->Text);
			cmd1->Parameters->AddWithValue("@Bf", textBox3->Text);

			cmd1->ExecuteNonQuery();
			MessageBox::Show("Train Fare modified Successfully", "Success", MessageBoxButtons::OK, MessageBoxIcon::Information);
			conn->Close();
			this->Close();
		}
		else
			MessageBox::Show("Train Fares Entered are too LOW or too HIGH ", "Invali Data Entry", MessageBoxButtons::OK, MessageBoxIcon::Error);
}
private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
	this->Close();

}
};
}