private void createeveButton_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["My Connection"].ConnectionString); connection.Open(); string sql = "INSERT INTO Events (EventName, Date, LastUpdated, Picture, Caption) VALUES ('" + EventTextBox.Text + "','" + eventdateTimePicker.Text + "','" + eventdateTimePicker.Text + "','" + PictureBox.Image + "', '" + CaptionTextBox.Text + "')"; SqlCommand command = new SqlCommand(sql, connection); int result = command.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("Event Added"); //UploadPicture upload = new UploadPicture(); EventManagment events = new EventManagment(); this.Hide(); events.Show(); //upload.Show(); } else { MessageBox.Show("Error!!"); } connection.Close(); }
private void BackButton_Click(object sender, EventArgs e) { EventManagment eventmanagment = new EventManagment(); eventmanagment.Show(); this.Hide(); }
private void submitButton_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["My Connection"].ConnectionString); connection.Open(); string sql = "SELECT Username, Password FROM USERS"; SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader = command.ExecuteReader(); List <User> users = new List <User>(); User user = new User(); bool ispassmatch = false; while (reader.Read()) { user.Username = reader["Username"].ToString(); user.Password = reader["Password"].ToString(); if (user.Username == userNameTextBox.Text && user.Password == passwordTextBox.Text) { EventManagment eve = new EventManagment(); eve.Show(); this.Hide(); ispassmatch = true; break; } //users.Add(user); } if (ispassmatch = false) { MessageBox.Show("Wrong Credentials given"); } }
private void DeleteButton_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["My Connection"].ConnectionString); connection.Open(); string sql = "DELETE FROM Events WHERE ID= " + Convert.ToInt32(EventIDTextBox.Text); SqlCommand command = new SqlCommand(sql, connection); int result = command.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("Event Deleted"); //UploadPicture upload = new UploadPicture(); EventManagment events = new EventManagment(); this.Hide(); events.Show(); //upload.Show(); } else { MessageBox.Show("ERROR!!"); } connection.Close(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["My Connection"].ConnectionString); connection.Open(); string sql = "UPDATE EVENTS SET EventName='" + EventTextBox.Text + "', LastUpdated= '" + EventDateTimePicker.Text + "', Caption= '" + CaptionTextBox.Text + "' WHERE ID= " + Convert.ToInt32(EventIDTextBox.Text); SqlCommand command = new SqlCommand(sql, connection); int result = command.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("Event Updated"); //UploadPicture upload = new UploadPicture(); EventManagment events = new EventManagment(); this.Hide(); events.Show(); //upload.Show(); } else { MessageBox.Show("You Havent made any change!!"); } connection.Close(); }