예제 #1
0
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            string        food          = commandbox.Text.Trim();
            SqlConnection sqlConnection = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Sayan\Documents\erfanrestudb.mdf; Integrated Security = True; Connect Timeout = 30");

            sqlConnection.Open();

            string         sql            = "select * from food where foodname='" + food + "'";
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, sqlConnection);
            DataTable      dataTable      = new DataTable();

            sqlDataAdapter.Fill(dataTable);
            string res = string.Join(Environment.NewLine, dataTable.Rows.OfType <DataRow>().Select(x => string.Join(" ; ", x.ItemArray)));

            if (dataTable.Rows.Count == 1)
            {
                sql = "DELETE FROM food WHERE foodname = '" + food + "'";
                SqlCommand command = new SqlCommand(sql, sqlConnection);
                command.ExecuteNonQuery();
                editmenu editmenuobj = new editmenu();
                editmenuobj.Show();
                this.Close();
            }
            else
            {
                MessageBox.Show("didnt found a match");
            }
            //DELETE FROM table_name WHERE condition
        }
예제 #2
0
        private void Button_Click_6(object sender, RoutedEventArgs e)
        {
            editmenu editmenuobj = new editmenu();

            editmenuobj.Show();
            this.Close();
        }
예제 #3
0
        private void Button_Click_2(object sender, RoutedEventArgs e)
        {
            string[] komaki = commandbox.Text.Trim().Split(';');

            SqlConnection sqlConnection = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Sayan\Documents\erfanrestudb.mdf; Integrated Security = True; Connect Timeout = 30");

            sqlConnection.Open();

            string         sql            = "select * from food";
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, sqlConnection);
            DataTable      dataTable      = new DataTable();

            sqlDataAdapter.Fill(dataTable);
            string res = string.Join(Environment.NewLine, dataTable.Rows.OfType <DataRow>().Select(x => string.Join(" ; ", x.ItemArray)));

            bool flag = true;

            string[] all2 = res.Split('\n');
            string[] all;

            try
            {
                for (int i = 0; i < (all2.Length); i++)
                {
                    all = all2[i].Split(';');
                    if (all[1].Trim() == komaki[0])
                    {
                        flag = false;
                    }
                }
                int.Parse(komaki[1]);
                int.Parse(komaki[3]);
                if (flag == true && komaki.Length == 4 && komaki[0] != "" && int.Parse(komaki[1]) >= 0 && komaki[2] != "" && komaki[3] != "")
                {
                    SqlCommand sqlCommand;
                    sql        = "insert into food (foodname,foodquantity,description,price) values('" + komaki[0] + "','" + komaki[1] + "','" + komaki[2] + "','" + komaki[3] + "')";
                    sqlCommand = new SqlCommand(sql, sqlConnection);
                    sqlDataAdapter.InsertCommand = new SqlCommand(sql, sqlConnection);
                    sqlDataAdapter.InsertCommand.ExecuteNonQuery();

                    editmenu editmenuobj = new editmenu();
                    editmenuobj.Show();
                    this.Close();
                }
                else
                {
                    MessageBox.Show("input is not valid");
                }
            }
            catch (Exception)
            {
                MessageBox.Show("input is not valid");
            }
        }