private void lbxParts_ItemClick(object sender, EventArgs e)
{
iPart = lbxParts.SelectedIndex;
if (iPart > -1)
{
DevComponents.DotNetBar.ListBoxItem i = (DevComponents.DotNetBar.ListBoxItem)lbxParts.Items[iPart];
if (i.Tag != null && i.Tag.ToString().Length > 0)
{
txtPart.Text = i.Tag.ToString();
}
}
}
private void tv_NodeClick(object sender, DevComponents.AdvTree.TreeNodeMouseEventArgs e)
{
if (e.Node.Tag != null && e.Node.Tag.ToString().All(char.IsDigit))
{
iID = Convert.ToInt32(e.Node.Tag);
txtPart.Text = "";
chkMultiPart.Checked = false;
cbxSection.SelectedItem = -1;
cbxLetter.SelectedItem = -1;
cbxNumber.SelectedItem = -1;
Program.SQL.AddParameter("id", iID);
DataSet d = !frmSchedules.bIsQuestion ? Program.SQL.SelectAll("SELECT note FROM schedules_notes WHERE id=@id;") : Program.SQL.SelectAll("SELECT section,letter,number,question,parts FROM schedules_questions WHERE id=@id;");
if (d.Tables.Count == 1 && d.Tables[0].Rows.Count > 0)
{
DataRow r = d.Tables[0].Rows[0];
txtEntry.Text = !frmSchedules.bIsQuestion ? r["note"].ToString() : r["question"].ToString();
if (frmSchedules.bIsQuestion)
{
foreach (DevComponents.Editors.ComboItem i in cbxSection.Items)
{
if (i.Tag != null && i.Tag.ToString() == r["section"].ToString())
{
cbxSection.SelectedItem = i;
break;
}
}
for (int i = 0; i < cbxLetter.Items.Count; i++)
{
if (cbxLetter.Items[i].ToString().Equals(r["letter"].ToString()))
{
cbxLetter.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbxNumber.Items.Count; i++)
{
if (cbxNumber.Items[i].ToString().Equals(r["number"].ToString()))
{
cbxNumber.SelectedIndex = i;
break;
}
}
if (r["parts"] != DBNull.Value && r["parts"].ToString().Length > 0)
{
string[] sParts = r["parts"].ToString().TrimStart('{').TrimEnd('}').Split(new char[] { '}', '{' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < sParts.Length; i++)
{
DevComponents.DotNetBar.ListBoxItem li = new DevComponents.DotNetBar.ListBoxItem();
li.Tag = sParts[i].Trim();
li.Text = sParts[i].Trim().Substring(0, sParts[i].Trim().Length > 50 ? 50 : sParts[i].Trim().Length);
lbxParts.Items.Add(li);
}
chkMultiPart.Checked = true;
}
}
}
}
}
private void btnPartSave_Click(object sender, EventArgs e)
{
DevComponents.DotNetBar.ListBoxItem i = (DevComponents.DotNetBar.ListBoxItem)lbxParts.Items[iPart];
i.Tag = txtPart.Text.Trim();
i.Text = txtPart.Text.Trim().Substring(0, txtPart.Text.Trim().Length > 50 ? 50 : txtPart.Text.Trim().Length);
}
private void tv_NodeClick(object sender, DevComponents.AdvTree.TreeNodeMouseEventArgs e)
{
if (e.Node.Tag != null && e.Node.Tag.ToString().All(char.IsDigit))
{
iID = Convert.ToInt32(e.Node.Tag);
txtPart.Text = "";
chkMultiPart.Checked = false;
cbxSection.SelectedItem = -1;
cbxLetter.SelectedItem = -1;
cbxNumber.SelectedItem = -1;
Program.SQL.AddParameter("id", iID);
DataSet d = !frmSchedules.bIsQuestion ? Program.SQL.SelectAll("SELECT note FROM schedules_notes WHERE id=@id;") : Program.SQL.SelectAll("SELECT section,letter,number,question,parts FROM schedules_questions WHERE id=@id;");
if (d.Tables.Count == 1 && d.Tables[0].Rows.Count > 0)
{
DataRow r = d.Tables[0].Rows[0];
txtEntry.Text = !frmSchedules.bIsQuestion ? r["note"].ToString() : r["question"].ToString();
if (frmSchedules.bIsQuestion)
{
foreach (DevComponents.Editors.ComboItem i in cbxSection.Items)
{
if (i.Tag != null && i.Tag.ToString() == r["section"].ToString())
{
cbxSection.SelectedItem = i;
break;
}
}
for (int i = 0; i < cbxLetter.Items.Count; i++)
{
if (cbxLetter.Items[i].ToString().Equals(r["letter"].ToString()))
{
cbxLetter.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbxNumber.Items.Count; i++)
{
if (cbxNumber.Items[i].ToString().Equals(r["number"].ToString()))
{
cbxNumber.SelectedIndex = i;
break;
}
}
if (r["parts"] != DBNull.Value && r["parts"].ToString().Length > 0)
{
string[] sParts = r["parts"].ToString().TrimStart('{').TrimEnd('}').Split(new char[] { '}', '{' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < sParts.Length; i++)
{
DevComponents.DotNetBar.ListBoxItem li = new DevComponents.DotNetBar.ListBoxItem();
li.Tag = sParts[i].Trim();
li.Text = sParts[i].Trim().Substring(0, sParts[i].Trim().Length > 50 ? 50 : sParts[i].Trim().Length);
lbxParts.Items.Add(li);
}
chkMultiPart.Checked = true;
}
}
}
}
}
