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