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]); } }
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]); } }