public static MilitaryUnit getEditedMilitaryUnit(MilitaryUnit m)
{
addMilitaryUnit wndM = new addMilitaryUnit(m);
wndM.ShowDialog();
return(wndM.mUnit);
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
if (txName.Text != "" && txShortName.Text != "" && txNumber.Text != "")
{
if (mUnit == null)
{
mUnit = new MilitaryUnit(
0,
txFullName.Text,
txName.Text,
txShortName.Text,
txNumber.Text,
txQuantity.Text == "" ? 0 : Int32.Parse(txQuantity.Text),
1);
}
else
{
mUnit.FullName = txFullName.Text;
mUnit.Name = txName.Text;
mUnit.ShortName = txShortName.Text;
mUnit.Number = txNumber.Text;
mUnit.Quantity = txQuantity.Text == "" ? 0 : Int32.Parse(txQuantity.Text);
}
this.Close();
}
else
{
MessageBox.Show("Не заполнены поля обязательные поля!");
}
}
internal static ObservableCollection <MilitaryUnit> getMilitaryUnitList(DataTable table)
{
ObservableCollection <MilitaryUnit> list = new ObservableCollection <MilitaryUnit>();
if (table.Rows.Count > 0 && table.Columns.Count == 7)
{
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
MilitaryUnit r = new MilitaryUnit(
Int32.Parse(table.Rows[i][0].ToString()),
table.Rows[i][1].ToString(),
table.Rows[i][2].ToString(),
table.Rows[i][3].ToString(),
table.Rows[i][4].ToString(),
Int32.Parse(table.Rows[i][5].ToString() == "" ? "1" : table.Rows[i][5].ToString()),
Int32.Parse(table.Rows[i][6].ToString()));
list.Add(r);
}
}
catch (Exception ex)
{
throw new Exception("Некорректные данные в БД:\n" + ex.Message);
}
}
return(list);
}
internal void update(MilitaryUnit s)
{
for (int i = 0; i < values.Count; i++)
{
if (values[i].Id == s.Id)
{
values[i] = s;
}
}
}
public addMilitaryUnit(MilitaryUnit m)
{
InitializeComponent();
txFullName.Focus();
mUnit = m;
txFullName.Text = m.FullName;
txName.Text = m.Name;
txShortName.Text = m.ShortName;
txNumber.Text = m.Number;
txQuantity.Text = m.Quantity.ToString();
}
private void lbMilitaryUnit_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
MilitaryUnit m = addMilitaryUnit.getEditedMilitaryUnit(lbMilitaryUnit.SelectedItem as MilitaryUnit);
if (m != null)
{
if (sqlWorker.updateMilitaryUnit(m))
{
mList.update(m);
lbMilitaryUnit.Items.Refresh();
}
else
{
MessageBox.Show("Ошибка при изменении элемента");
}
}
}
internal bool updateMilitaryUnit(MilitaryUnit m)
{
try
{
executeQuery("UPDATE MilitaryUnit SET " +
"fullName = " + (m.FullName == "" ? "NULL" : "'" + m.FullName + "'") +
", name = '" + m.Name +
"', shortName = '" + m.ShortName +
"', number = '" + m.Number +
"', quantity = " + (m.Quantity == 0 ? "NULL" : m.Quantity.ToString()) +
" WHERE idMilitaryUnit = " + m.Id + ";");
return(true);
}
catch
{
return(false);
}
}
internal bool addMilitaryUnit(int id, MilitaryUnit newItem)
{
try
{
executeQuery("INSERT INTO MilitaryUnit VALUES(" +
id + ",'" +
newItem.FullName + "','" +
newItem.Name + "','" +
newItem.ShortName + "','" +
newItem.Number + "'," +
(newItem.Quantity == 0 ? "NULL" : newItem.Quantity.ToString()) + "," +
"1);");
return(true);
}
catch
{
return(false);
}
}
private void btnAddMilitaryUnit_Click(object sender, RoutedEventArgs e)
{
MilitaryUnit m = addMilitaryUnit.getNewMilitaryUnit();
if (m != null)
{
if (mList == null)
{
mList = new MilitaryUnitList();
}
int id = sqlWorker.getNewId("MilitaryUnit");
m.Id = id;
if (sqlWorker.addMilitaryUnit(id, m))
{
mList.values.Add(m);
}
else
{
MessageBox.Show("Ошибка при добавлении элемента");
}
}
}