internal static AccompliceList getList(SqliteWorker sqlWorker, AccompliceList accompliceList)
{
SelectAccomplice wndS = new SelectAccomplice(sqlWorker, accompliceList);
wndS.ShowDialog();
return(wndS.aChoosedList);
}
internal bool updateCrime(Crime c, AccompliceList accompliceList, DBList categoryList, int oldId)
{
if (addCrime(c, accompliceList, categoryList) && deleteCrime(oldId))
{
return(true);
}
return(false);
}
private void menuAccomplice_Click(object sender, RoutedEventArgs e)
{
AccompliceList al = new AccompliceList(
DataWorker.getAccompliceList(
sqlWorker.selectData("SELECT R.shortName as rank, S.shortName as subUnit, SF.shortName as battalion, M.shortName as militaryUnit, A.*, R.priority " +
"FROM Accomplice A " +
"INNER JOIN SubUnit S ON S.idSubUnit = A.idSubUnit " +
"LEFT JOIN Rank R ON R.idRank = A.idRank " +
"LEFT JOIN SubUnit SF ON S.idFKSubUnit = SF.idSubUnit " +
"LEFT JOIN MilitaryUnit M ON M.idMilitaryUnit = S.idMilitaryUnit OR M.idMilitaryUnit = SF.idMilitaryUnit ")));
Accomplices wndR = new Accomplices(al, sqlWorker);
wndR.ShowDialog();
}
internal bool addCrime(Crime newItem, AccompliceList accompliceList, DBList categoryList)
{
try
{
executeQuery("INSERT INTO Crime VALUES(" +
newItem.Id + "," +
(newItem.IdOrgan == 0 ? "NULL" : newItem.IdOrgan.ToString()) + "," +
(newItem.IdClause == 0 ? "NULL" : newItem.IdClause.ToString()) + "," +
(newItem.IdMilitaryUnit == 0 ? "NULL" : newItem.IdMilitaryUnit.ToString()) + "," +
(newItem.DateRegistration == "" ? "NULL" : "'" + newItem.DateRegistration + "'") + "," +
(newItem.DateInstitution == "" ? "NULL" : "'" + newItem.DateInstitution + "'") + "," +
(newItem.DateCommit == "" ? "NULL" : "'" + newItem.DateCommit + "'") + "," +
(newItem.Story == "" ? "NULL" : "'" + newItem.Story + "'") + "," +
(newItem.Damage == "" ? "NULL" : "'" + newItem.Damage + "'") + "," +
(newItem.DateVerdict == "" ? "NULL" : "'" + newItem.DateVerdict + "'") + "," +
(newItem.Verdict == "" ? "NULL" : "'" + newItem.Verdict + "'") + "," +
(newItem.NumberCase == "" ? "NULL" : "'" + newItem.NumberCase + "'") + "," +
(newItem.IsRegistred == true ? "1" : "0") +
");");
if (accompliceList != null)
{
for (int i = 0; i < accompliceList.values.Count; i++)
{
executeQuery("INSERT INTO Portaking VALUES(" +
accompliceList.values[i].Id + "," +
newItem.Id + ");");
}
}
for (int i = 0; i < categoryList.values.Count; i++)
{
if (categoryList.values[i].IsCheked)
{
executeQuery("INSERT INTO InCategory VALUES(" +
categoryList.values[i].Key + "," +
newItem.Id + ");");
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public Accomplices(AccompliceList al, SqliteWorker sqlWorker)
{
InitializeComponent();
this.al = al;
this.sqlWorker = sqlWorker;
coll = new CollectionViewSource();
coll.Source = al.values;
coll.Filter += coll_Filter;
dataGrid.CanUserAddRows = false;
dataGrid.AutoGenerateColumns = false;
dataGrid.IsReadOnly = true;
dataGrid.ItemsSource = coll.View;
dgCrimes.CanUserAddRows = false;
dgCrimes.AutoGenerateColumns = false;
}
public SelectAccomplice(SqliteWorker _sqlWorker, AccompliceList accompliceList)
{
InitializeComponent();
lbChoosed.AutoGenerateColumns = false;
lbChoosed.IsReadOnly = true;
lbNotChoosed.AutoGenerateColumns = false;
lbNotChoosed.IsReadOnly = true;
sqlWorker = _sqlWorker;
aList = new AccompliceList(
DataWorker.getAccompliceList(
sqlWorker.selectData("SELECT R.shortName as rank, S.shortName as subUnit, SF.shortName as battalion, M.shortName as militaryUnit, A.*, R.priority " +
"FROM Accomplice A " +
"INNER JOIN SubUnit S ON S.idSubUnit = A.idSubUnit " +
"LEFT JOIN Rank R ON R.idRank = A.idRank " +
"LEFT JOIN SubUnit SF ON S.idFKSubUnit = SF.idSubUnit " +
"LEFT JOIN MilitaryUnit M ON M.idMilitaryUnit = S.idMilitaryUnit OR M.idMilitaryUnit = SF.idMilitaryUnit " +
"")));//сортировка хз по чему
if (accompliceList == null)
{
aChoosedList = new AccompliceList();
}
else
{
aChoosedList = accompliceList;
for (int i = 0; i < accompliceList.values.Count; i++)
{
aList.deleteById(accompliceList.values[i].Id);
}
}
aChoosedView = new CollectionViewSource();
aChoosedView.Source = aList.values;
aChoosedView.Filter += collectView_Filter;
lbChoosed.ItemsSource = aChoosedList.values;
lbNotChoosed.ItemsSource = aChoosedView.View;
txFilter.Focus();
}
public AddCrime(SqliteWorker _sqlWorker, Crime _c = null)
{
InitializeComponent();
sqlWorker = _sqlWorker;
organList = new DBList("Organ", DataWorker.getList(sqlWorker.selectData("SELECT * FROM Organ ORDER BY description")));
categoryList = new DBList("Category", DataWorker.getList(sqlWorker.selectData("SELECT * FROM Category ORDER BY description")));
militaryList = new MilitaryUnitList(DataWorker.getMilitaryUnitList(sqlWorker.selectData("SELECT * FROM MilitaryUnit")));
clauseList = new ClauseList(DataWorker.getClauseList(sqlWorker.selectData("SELECT * FROM Clause ORDER BY number, part, point")));
cbOrgan.ItemsSource = organList.values;
cbMilitaryUnit.ItemsSource = militaryList.values;
cbClause.ItemsSource = clauseList.values;
lbCategoty.ItemsSource = categoryList.values;
if (_c != null)
{
isEditing = true;
c = _c;
txDamage.Text = c.Damage;
txDateCommit.Text = c.DateCommit;
txDateInstitution.Text = c.DateInstitution;
txDateRegistration.Text = c.DateRegistration;
txDateVerdict.Text = c.DateVerdict;
txnumberCase.Text = c.NumberCase;
txStory.Text = c.Story;
txVerdict.Text = c.Verdict;
//если происшествие
if (c.Clause == "")
{
rbIncident.IsChecked = true;
}
chkIsRegistred.IsChecked = c.IsRegistred;
for (int i = 0; i < cbOrgan.Items.Count; i++)
{
if ((cbOrgan.Items[i] as KeyValue).Key == c.IdOrgan)
{
cbOrgan.SelectedIndex = i;
}
}
for (int i = 0; i < cbClause.Items.Count; i++)
{
if ((cbClause.Items[i] as Clause).Id == c.IdClause)
{
cbClause.SelectedIndex = i;
}
}
for (int i = 0; i < cbMilitaryUnit.Items.Count; i++)
{
if ((cbMilitaryUnit.Items[i] as MilitaryUnit).Id == c.IdMilitaryUnit)
{
cbMilitaryUnit.SelectedIndex = i;
}
}
accompliceList = new AccompliceList(
DataWorker.getAccompliceList(
sqlWorker.selectData("SELECT R.shortName as rank, S.shortName as subUnit, SF.shortName as battalion, M.shortName as militaryUnit, A.*, R.priority " +
"FROM Accomplice A " +
"INNER JOIN SubUnit S ON S.idSubUnit = A.idSubUnit " +
"INNER JOIN Portaking P ON P.idAccomplice = A.idAccomplice " +
"LEFT JOIN Rank R ON R.idRank = A.idRank " +
"LEFT JOIN SubUnit SF ON S.idFKSubUnit = SF.idSubUnit " +
"LEFT JOIN MilitaryUnit M ON M.idMilitaryUnit = S.idMilitaryUnit OR M.idMilitaryUnit = SF.idMilitaryUnit " +
"WHERE P.idCrime = " + c.Id)));
lbAccomplice.ItemsSource = accompliceList.values;
//categoryList
DBList categoryUsed = new DBList("", DataWorker.getList(sqlWorker.selectData("SELECT * FROM InCategory WHERE idCrime = " + c.Id + ";")));
for (int i = 0; i < categoryUsed.values.Count; i++)
{
for (int j = 0; j < categoryList.values.Count; j++)
{
if (categoryUsed.values[i].Key == categoryList.values[j].Key)
{
categoryList.values[j].IsCheked = true;
}
}
}
}
else
{
chkIsRegistred.IsChecked = true;
}
}
private void btnAddAccomplice_Click(object sender, RoutedEventArgs e)
{
accompliceList = SelectAccomplice.getList(sqlWorker, accompliceList);
lbAccomplice.ItemsSource = accompliceList.values;
}
