private void search(string query)
        {
            header();

            if (!Regex.IsMatch(query, "^[^()\\*;+='\\\\/]*$") || query.Contains("--"))
            {
                MessageBox.Show("Invalid characters detected.");
                return;
            }

            if (!refresh())
            {
                return;
            }

            SqlCommand cmd = new SqlCommand("select * from clients WHERE name LIKE '%" + query + "%'");

            cmd.Connection = cn;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("That name (or part of it) were not found in the database."); return; //no data
            }

            int t = dataSet.Tables[0].Rows.Count;

            Style idStyle   = App.Current.FindResource("clientIDBorderStyle") as Style;
            Style nameStyle = App.Current.FindResource("clientNameBorderStyle") as Style;
            Style nifStyle  = App.Current.FindResource("clientNIFBorderStyle") as Style;
            Style textStyle = App.Current.FindResource("BorderTextStyle") as Style;
            Style spbStyle  = App.Current.FindResource("spBorderStyle") as Style;

            Border[]     bordersout = new Border[t];
            StackPanel[] entry      = new StackPanel[t];

            Border[]    bordersID   = new Border[t];
            Border[]    bordersName = new Border[t];
            Border[]    bordersNIF  = new Border[t];
            TextBlock[] ids         = new TextBlock[t];
            TextBlock[] names       = new TextBlock[t];
            TextBlock[] nifs        = new TextBlock[t];

            for (int i = 0; i < t; i++)
            {
                bordersout[i]        = new Border();
                entry[i]             = new StackPanel();
                entry[i].Orientation = Orientation.Horizontal;

                bordersID[i]   = new Border();
                bordersName[i] = new Border();
                bordersNIF[i]  = new Border();

                ids[i]   = new TextBlock();
                names[i] = new TextBlock();
                nifs[i]  = new TextBlock();

                bordersout[i].Style  = spbStyle;
                bordersID[i].Style   = idStyle;
                bordersName[i].Style = nameStyle;
                bordersNIF[i].Style  = nifStyle;
                ids[i].Style         = textStyle;
                names[i].Style       = textStyle;
                nifs[i].Style        = textStyle;

                ids[i].Text   = ((int)dataSet.Tables[0].Rows[i]["id"]).ToString();
                names[i].Text = (string)dataSet.Tables[0].Rows[i]["name"];
                nifs[i].Text  = ((int)dataSet.Tables[0].Rows[i]["nif"]).ToString();

                bordersID[i].Child   = ids[i];
                bordersName[i].Child = names[i];
                bordersNIF[i].Child  = nifs[i];
                entry[i].Children.Add(bordersID[i]);
                entry[i].Children.Add(bordersName[i]);
                entry[i].Children.Add(bordersNIF[i]);
                bordersout[i].Child = entry[i];
                list.Items.Add(bordersout[i]);
            }
        }
        private void search(int idquery)
        {
            header();

            if (!refresh())
            {
                return;
            }

            SqlCommand cmd = new SqlCommand("SELECT id, name, nif FROM CLIENTS WHERE nif=" + idquery);

            cmd.Connection = cn;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("That NIF was not found in the database."); return; //no data
            }

            int t = dataSet.Tables[0].Rows.Count;

            Style idStyle   = App.Current.FindResource("clientIDBorderStyle") as Style;
            Style nameStyle = App.Current.FindResource("clientNameBorderStyle") as Style;
            Style nifStyle  = App.Current.FindResource("clientNIFBorderStyle") as Style;
            Style textStyle = App.Current.FindResource("BorderTextStyle") as Style;
            Style spbStyle  = App.Current.FindResource("spBorderStyle") as Style;

            Border[]     bordersout = new Border[t];
            StackPanel[] entry      = new StackPanel[t];

            Border[]    bordersID   = new Border[t];
            Border[]    bordersName = new Border[t];
            Border[]    bordersNIF  = new Border[t];
            TextBlock[] ids         = new TextBlock[t];
            TextBlock[] names       = new TextBlock[t];
            TextBlock[] nifs        = new TextBlock[t];

            for (int i = 0; i < t; i++)
            {
                bordersout[i]        = new Border();
                entry[i]             = new StackPanel();
                entry[i].Orientation = Orientation.Horizontal;

                bordersID[i]   = new Border();
                bordersName[i] = new Border();
                bordersNIF[i]  = new Border();

                ids[i]   = new TextBlock();
                names[i] = new TextBlock();
                nifs[i]  = new TextBlock();

                bordersout[i].Style  = spbStyle;
                bordersID[i].Style   = idStyle;
                bordersName[i].Style = nameStyle;
                bordersNIF[i].Style  = nifStyle;
                ids[i].Style         = textStyle;
                names[i].Style       = textStyle;
                nifs[i].Style        = textStyle;

                ids[i].Text   = ((int)dataSet.Tables[0].Rows[i]["id"]).ToString();
                names[i].Text = (string)dataSet.Tables[0].Rows[i]["name"];
                nifs[i].Text  = ((int)dataSet.Tables[0].Rows[i]["nif"]).ToString();

                bordersID[i].Child   = ids[i];
                bordersName[i].Child = names[i];
                bordersNIF[i].Child  = nifs[i];
                entry[i].Children.Add(bordersID[i]);
                entry[i].Children.Add(bordersName[i]);
                entry[i].Children.Add(bordersNIF[i]);
                bordersout[i].Child = entry[i];
                list.Items.Add(bordersout[i]);
            }
        }
Esempio n. 3
0
        private void search(string query)
        {
            header();

            if (!Regex.IsMatch(query, "^[^()\\*;+='\\\\/]*$") || query.Contains("--"))
            {
                MessageBox.Show("Invalid characters detected.");
                return;
            }

            if (!refresh())
            {
                return;
            }

            SqlCommand cmd = new SqlCommand("select loans.id, descr, reqval, name, nif from (loans join loan_type on loan_type.ltype=loans.ltype) join clients on clients.id=cid where appr='yes' and name LIKE '%" + query + "%'");

            cmd.Connection = cn;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("That name (or part of it) were not found in the database."); return; //no data
            }

            int t = dataSet.Tables[0].Rows.Count;

            Style accountIDStyle = App.Current.FindResource("loanIDBorderStyle") as Style;
            Style typeStyle      = App.Current.FindResource("loanTypeBorderStyle") as Style;
            Style valueStyle     = App.Current.FindResource("loanValueBorderStyle") as Style;
            Style interestStyle  = App.Current.FindResource("loanInterestBorderStyle") as Style;
            Style textStyle      = App.Current.FindResource("BorderTextStyle") as Style;
            Style spbStyle       = App.Current.FindResource("spBorderStyle") as Style;

            Border[]     bordersout = new Border[t];
            StackPanel[] entry      = new StackPanel[t];

            Border[]    bordersID       = new Border[t];
            Border[]    bordersType     = new Border[t];
            Border[]    bordersValue    = new Border[t];
            Border[]    bordersInterest = new Border[t];
            TextBlock[] ids             = new TextBlock[t];
            TextBlock[] types           = new TextBlock[t];
            TextBlock[] values          = new TextBlock[t];
            TextBlock[] interests       = new TextBlock[t];

            for (int i = 0; i < t; i++)
            {
                bordersout[i]        = new Border();
                entry[i]             = new StackPanel();
                entry[i].Orientation = Orientation.Horizontal;


                bordersID[i]       = new Border();
                bordersType[i]     = new Border();
                bordersValue[i]    = new Border();
                bordersInterest[i] = new Border();

                ids[i]       = new TextBlock();
                types[i]     = new TextBlock();
                values[i]    = new TextBlock();
                interests[i] = new TextBlock();

                bordersout[i].Style      = spbStyle;
                bordersID[i].Style       = accountIDStyle;
                bordersType[i].Style     = typeStyle;
                bordersValue[i].Style    = valueStyle;
                bordersInterest[i].Style = interestStyle;
                ids[i].Style             = textStyle;
                types[i].Style           = textStyle;
                values[i].Style          = textStyle;
                interests[i].Style       = textStyle;

                ids[i].Text       = ((int)dataSet.Tables[0].Rows[i]["id"]).ToString();
                types[i].Text     = (string)dataSet.Tables[0].Rows[i]["descr"];
                values[i].Text    = String.Format("{0:0.00}€", (decimal)dataSet.Tables[0].Rows[i]["reqval"]);
                interests[i].Text = (string)dataSet.Tables[0].Rows[i]["name"];

                bordersID[i].Child       = ids[i];
                bordersType[i].Child     = types[i];
                bordersValue[i].Child    = values[i];
                bordersInterest[i].Child = interests[i];
                entry[i].Children.Add(bordersID[i]);
                entry[i].Children.Add(bordersInterest[i]);
                entry[i].Children.Add(bordersType[i]);
                entry[i].Children.Add(bordersValue[i]);
                bordersout[i].Child = entry[i];
                list.Items.Add(bordersout[i]);
            }
        }
        private void init(string sql)
        {
            header();

            if (!refresh())
            {
                return;
            }

            SqlCommand cmd = new SqlCommand(sql);

            cmd.Connection = cn;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                return; //no data
            }

            int t = dataSet.Tables[0].Rows.Count;

            Style idStyle   = App.Current.FindResource("empIDBorderStyle") as Style;
            Style nameStyle = App.Current.FindResource("empNameBorderStyle") as Style;
            Style sStyle    = App.Current.FindResource("empSBorderStyle") as Style;
            Style textStyle = App.Current.FindResource("BorderTextStyle") as Style;
            Style spbStyle  = App.Current.FindResource("spBorderStyle") as Style;

            Border[]     bordersout = new Border[t];
            StackPanel[] entry      = new StackPanel[t];

            Border[]    bordersID   = new Border[t];
            Border[]    bordersName = new Border[t];
            Border[]    bordersS    = new Border[t];
            TextBlock[] ids         = new TextBlock[t];
            TextBlock[] names       = new TextBlock[t];
            TextBlock[] s           = new TextBlock[t];

            for (int i = 0; i < t; i++)
            {
                bordersout[i]        = new Border();
                entry[i]             = new StackPanel();
                entry[i].Orientation = Orientation.Horizontal;

                bordersID[i]   = new Border();
                bordersName[i] = new Border();
                bordersS[i]    = new Border();

                ids[i]   = new TextBlock();
                names[i] = new TextBlock();
                s[i]     = new TextBlock();

                bordersout[i].Style  = spbStyle;
                bordersID[i].Style   = idStyle;
                bordersName[i].Style = nameStyle;
                bordersS[i].Style    = sStyle;
                ids[i].Style         = textStyle;
                names[i].Style       = textStyle;
                s[i].Style           = textStyle;

                ids[i].Text   = ((int)dataSet.Tables[0].Rows[i]["id"]).ToString();
                names[i].Text = (string)dataSet.Tables[0].Rows[i]["name"];
                s[i].Text     = String.Format("{0:0.00}€", (decimal)dataSet.Tables[0].Rows[i]["salary"]);

                bordersID[i].Child   = ids[i];
                bordersName[i].Child = names[i];
                bordersS[i].Child    = s[i];
                entry[i].Children.Add(bordersID[i]);
                entry[i].Children.Add(bordersName[i]);
                entry[i].Children.Add(bordersS[i]);
                bordersout[i].Child = entry[i];
                list.Items.Add(bordersout[i]);
            }
        }
Esempio n. 5
0
        public void init(string sql)
        {
            header();

            if (!refresh())
            {
                return;
            }

            SqlCommand cmd = new SqlCommand(sql);

            cmd.Connection = cn;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = cmd;
            DataSet dataSet = new DataSet();

            adapter.Fill(dataSet);

            if (dataSet.Tables[0].Rows.Count == 0)
            {
                return; //no data
            }

            int t = dataSet.Tables[0].Rows.Count;

            Style accountIDStyle = App.Current.FindResource("loanIDBorderStyle") as Style;
            Style typeStyle      = App.Current.FindResource("loanTypeBorderStyle") as Style;
            Style valueStyle     = App.Current.FindResource("loanValueBorderStyle") as Style;
            Style interestStyle  = App.Current.FindResource("loanInterestBorderStyle") as Style;
            Style textStyle      = App.Current.FindResource("BorderTextStyle") as Style;
            Style spbStyle       = App.Current.FindResource("spBorderStyle") as Style;

            Border[]     bordersout = new Border[t];
            StackPanel[] entry      = new StackPanel[t];

            Border[]    bordersID       = new Border[t];
            Border[]    bordersType     = new Border[t];
            Border[]    bordersValue    = new Border[t];
            Border[]    bordersInterest = new Border[t];
            TextBlock[] ids             = new TextBlock[t];
            TextBlock[] types           = new TextBlock[t];
            TextBlock[] values          = new TextBlock[t];
            TextBlock[] interests       = new TextBlock[t];

            for (int i = 0; i < t; i++)
            {
                bordersout[i]        = new Border();
                entry[i]             = new StackPanel();
                entry[i].Orientation = Orientation.Horizontal;

                bordersID[i]       = new Border();
                bordersType[i]     = new Border();
                bordersValue[i]    = new Border();
                bordersInterest[i] = new Border();

                ids[i]       = new TextBlock();
                types[i]     = new TextBlock();
                values[i]    = new TextBlock();
                interests[i] = new TextBlock();

                bordersout[i].Style      = spbStyle;
                bordersID[i].Style       = accountIDStyle;
                bordersType[i].Style     = typeStyle;
                bordersValue[i].Style    = valueStyle;
                bordersInterest[i].Style = interestStyle;
                ids[i].Style             = textStyle;
                types[i].Style           = textStyle;
                values[i].Style          = textStyle;
                interests[i].Style       = textStyle;

                ids[i].Text       = ((int)dataSet.Tables[0].Rows[i]["id"]).ToString();
                types[i].Text     = (string)dataSet.Tables[0].Rows[i]["descr"];
                values[i].Text    = String.Format("{0:0.00}€", (decimal)dataSet.Tables[0].Rows[i]["reqval"]);
                interests[i].Text = (string)dataSet.Tables[0].Rows[i]["name"];

                bordersID[i].Child       = ids[i];
                bordersType[i].Child     = types[i];
                bordersValue[i].Child    = values[i];
                bordersInterest[i].Child = interests[i];
                entry[i].Children.Add(bordersID[i]);
                entry[i].Children.Add(bordersInterest[i]);
                entry[i].Children.Add(bordersType[i]);
                entry[i].Children.Add(bordersValue[i]);

                bordersout[i].Child = entry[i];
                list.Items.Add(bordersout[i]);
            }
        }