void BorrowUnborrowToolStripMenuItemClick(object sender, EventArgs e)
{
BorrowDialog dlg = new BorrowDialog();
ListView.SelectedListViewItemCollection list = this.listView1.SelectedItems;
if (list.Count == 0)
{
MessageBox.Show("What you want to borrow? There is nothing selected");
}
else
{
ListViewItem item = list[0];
IEnumerable <Item> result = from Item i in DBConnection.Instance.DB where i.Title.Equals(item.SubItems[1].Text) && i.type.Name.Equals(item.SubItems[0].Text) select i;
if (dlg.ShowDialog() == DialogResult.OK)
{
ListView.SelectedListViewItemCollection listp = dlg.listView1.SelectedItems;
if (listp.Count == 0)
{
MessageBox.Show("Who you want to borrow? There is none selected");
}
else
{
ListViewItem itemp = listp[0];
IEnumerable <Lender> resultp = from Lender j in DBConnection.Instance.DB where j.FirstName.Equals(itemp.SubItems[0].Text) && j.LastName.Equals(itemp.SubItems[1].Text) select j;
foreach (Lender ln in resultp)
{
foreach (Item it in result)
{
it.Lender = ln;
it.IsBorrow = true;
it.BorrowDate = dlg.dateTimePicker1.Value;
DBConnection.Instance.DB.Store(it);
}
}
this.refreshItems();
}
}
else if (dlg.DialogResult.Equals(DialogResult.Yes))
{
foreach (Item it in result)
{
it.IsBorrow = false;
DBConnection.Instance.DB.Store(it);
}
this.refreshItems();
}
}
}
void BorrowUnborrowToolStripMenuItemClick(object sender, EventArgs e)
{
BorrowDialog dlg = new BorrowDialog();
ListView.SelectedListViewItemCollection list = this.listView1.SelectedItems;
if(list.Count == 0){
MessageBox.Show("What you want to borrow? There is nothing selected");
}
else{
ListViewItem item = list[0];
IEnumerable<Item> result = from Item i in DBConnection.Instance.DB where i.Title.Equals(item.SubItems[1].Text) && i.type.Name.Equals(item.SubItems[0].Text) select i;
if (dlg.ShowDialog() == DialogResult.OK)
{
ListView.SelectedListViewItemCollection listp = dlg.listView1.SelectedItems;
if(listp.Count == 0){
MessageBox.Show("Who you want to borrow? There is none selected");
}
else{
ListViewItem itemp = listp[0];
IEnumerable<Lender> resultp = from Lender j in DBConnection.Instance.DB where j.FirstName.Equals(itemp.SubItems[0].Text) && j.LastName.Equals(itemp.SubItems[1].Text) select j;
foreach(Lender ln in resultp) {
foreach(Item it in result){
it.Lender = ln;
it.IsBorrow = true;
it.BorrowDate = dlg.dateTimePicker1.Value;
DBConnection.Instance.DB.Store(it);
}
}
this.refreshItems();
}
}
else if (dlg.DialogResult.Equals(DialogResult.Yes))
{
foreach(Item it in result){
it.IsBorrow = false;
DBConnection.Instance.DB.Store(it);
}
this.refreshItems();
}
}
}
