/// <summary> /// Delete Item /// </summary> private void DeleteItemBorrowing() { databaseEntities db = new databaseEntities(); int count = olvBorrowing.SelectedObjects.Count; if (count == 1) // If selected Item { // Find Object Borrowing borr = db.Borrowing.Find(((Borrowing)olvBorrowing.SelectedObject).ID); if (Dialogs.ShowQuest(Lng.Get("DeleteItem", "Really delete item") + " \"" + borr.Item + "\"?", Lng.Get("Delete")) == DialogResult.Yes) { db.Borrowing.Remove(borr); // Delete Item db.SaveChanges(); // Save to DB UpdateBorrowingOLV(); // Update Borrowing OLV } } else if (count > 1) // If selected Item { if (Dialogs.ShowQuest(Lng.Get("DeleteItems", "Really delete selected items") + " (" + count.ToString() + ")?", Lng.Get("Delete")) == DialogResult.Yes) { foreach (var item in olvBorrowing.SelectedObjects) // Find Object { Borrowing itm = db.Borrowing.Find(((Borrowing)item).ID); db.Borrowing.Remove(itm); // Delete Item } db.SaveChanges(); // Save to DB UpdateBorrowingOLV(); // Update Borrowing OLV } } }
/// <summary> /// Delete Item /// </summary> private void DeleteItemLending() { databaseEntities db = new databaseEntities(); int count = olvLending.SelectedObjects.Count; if (count == 1) // If selected Item { // Find Object Lending borr = db.Lending.Find(((Lending)olvLending.SelectedObject).ID); if (Dialogs.ShowQuest(Lng.Get("DeleteItem", "Really delete item") + " \"" + global.GetLendingItemName(borr.CopyType.Trim(), borr.CopyID ?? Guid.Empty) + "\"?", Lng.Get("Delete")) == DialogResult.Yes) { db.Lending.Remove(borr); // Delete Item db.SaveChanges(); // Save to DB UpdateLendingOLV(); // Update Lending OLV UpdateAllItemsOLV(); } } else if (count > 1) // If selected Item { if (Dialogs.ShowQuest(Lng.Get("DeleteItems", "Really delete selected items") + " (" + count.ToString() + ")?", Lng.Get("Delete")) == DialogResult.Yes) { foreach (var item in olvLending.SelectedObjects) // Find Object { Lending itm = db.Lending.Find(((Lending)item).ID); db.Lending.Remove(itm); // Delete Item } db.SaveChanges(); // Save to DB UpdateLendingOLV(); // Update Lending OLV UpdateAllItemsOLV(); } } }
/// <summary> /// Delete Item /// </summary> private void DeleteItemContacts() { databaseEntities db = new databaseEntities(); int count = olvContacts.SelectedObjects.Count; if (count == 1) // If selected Item { // Find Object Contacts contact = db.Contacts.Find(((Contacts)olvContacts.SelectedObject).ID); if (Dialogs.ShowQuest(Lng.Get("DeleteItem", "Really delete item") + " \"" + contact.Name.Trim() + " " + contact.Surname.Trim() + "\"?", Lng.Get("Delete")) == DialogResult.Yes) { db.Contacts.Remove(contact); // Delete Item db.SaveChanges(); // Save to DB UpdateConOLV(); // Update Contacts OLV } } else if (count > 1) // If selected Item { if (Dialogs.ShowQuest(Lng.Get("DeleteItems", "Really delete selected items") + " (" + count.ToString() + ")?", Lng.Get("Delete")) == DialogResult.Yes) { foreach (var item in olvContacts.SelectedObjects) // Find Object { Contacts contact = db.Contacts.Find(((Contacts)item).ID); db.Contacts.Remove(contact); // Delete Item } db.SaveChanges(); // Save to DB UpdateConOLV(); // Update Contacts OLV } } }
/// <summary> /// Save edited items to DB /// </summary> private void SaveItem() { Items itm; // ----- Save last Specimen values ----- SaveCopy(); // ----- Check Duplicate InvNum ----- foreach (var item in CopiesList) { string DulpicateInvNUm = ""; if (global.IsDuplicate(item.InventoryNumber, item.ID)) { if (Dialogs.ShowQuest(String.Format(Lng.Get("DuplicateInvNum", "The inventory number {0} is already in use. Do you really write to database?"), DulpicateInvNUm), Lng.Get("Warning")) != DialogResult.Yes) { return; } } } // ----- Item ID ----- if (ID != Guid.Empty) { itm = db.Items.Find(ID); } else { itm = new Items(); itm.ID = Guid.NewGuid(); } // ----- Delete original Copies ----- foreach (var item in OriginalCopies) { db.Copies.Remove(item); } db.SaveChanges(); // ----- Add Copies to DB ----- foreach (var item in CopiesList) { item.ItemID = itm.ID; db.Copies.Add(item); } db.SaveChanges(); // ----- Fill Item values ----- FillItem(ref itm); // ----- Update database ----- if (ID == Guid.Empty) { db.Items.Add(itm); } db.SaveChanges(); }
/// <summary> /// Button Ok /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOk_Click(object sender, EventArgs e) { // ----- Find selected person in DB ----- FindPerson(); // ----- Check if record valid ----- if (PersonGuid == Guid.Empty) { Dialogs.ShowWar(Lng.Get("NoSelPerson", "Not selected person!"), Lng.Get("Warning")); return; } if (selItemList.Count == 0) { Dialogs.ShowWar(Lng.Get("NoSelItem", "Not selected item!"), Lng.Get("Warning")); return; } databaseEntities db = new databaseEntities(); Lending borr; // ----- Delete old data ----- if (ID.Count > 0) { foreach (var itm in ID) { borr = db.Lending.Find(itm); db.Lending.Remove(borr); } db.SaveChanges(); } // ----- Create new ----- foreach (var itm in selItemList) { borr = new Lending(); borr.ID = Guid.NewGuid(); FillLend(ref borr, itm); db.Lending.Add(borr); } // ----- Save to DB ----- db.SaveChanges(); // ----- Refresh Copy Status ----- global.RefreshCopiesStatus(selItemList, (short)cbStatus.SelectedIndex); // ----- Refresh Available Items in Items Tables ----- RefreshAvailableItems(selItemList); // ----- Close Barcode reader connection ----- com.Close(); this.DialogResult = DialogResult.OK; }
private void SaveItem() { Contacts contact; // ----- ID ----- if (ID != Guid.Empty) { contact = db.Contacts.Find(ID); } else { contact = new Contacts(); contact.ID = Guid.NewGuid(); } FillContact(ref contact); if (ID == Guid.Empty) { db.Contacts.Add(contact); } db.SaveChanges(); ID = contact.ID; }
/// <summary> /// Save edited items to DB /// </summary> private void SaveItem() { Recipes itm; // ----- Item ID ----- if (ID != Guid.Empty) { itm = db.Recipes.Find(ID); } else { itm = new Recipes(); itm.ID = Guid.NewGuid(); } // ----- Fill Item values ----- FillItem(ref itm); // ----- Update database ----- if (ID == Guid.Empty) { db.Recipes.Add(itm); } db.SaveChanges(); }
/// <summary> /// Delete Item /// </summary> private void DeleteItemBoard() { databaseEntities db = new databaseEntities(); int count = olvBoard.SelectedObjects.Count; if (count == 1) // If selected Item { // Find Object Boardgames itm = db.Boardgames.Find(((Boardgames)olvBoard.SelectedObject).ID); if (Dialogs.ShowQuest(Lng.Get("DeleteItem", "Really delete item") + " \"" + itm.Name.Trim() + "\"?", Lng.Get("Delete")) == DialogResult.Yes) { db.Boardgames.Remove(itm); // Delete Item // ----- Remove copies ----- var copies = db.Copies.Where(x => (x.ItemType.Trim() == ItemTypes.boardgame.ToString()) && (x.ItemID == ((Boardgames)olvBoard.SelectedObject).ID)).ToList(); foreach (var copy in copies) { db.Copies.Remove(copy); // Remove copy } db.SaveChanges(); // Save to DB UpdateBoardOLV(); // Update Items OLV UpdateCopOLV(); // Update Copies OLV } } else if (count > 1) // If selected Item { if (Dialogs.ShowQuest(Lng.Get("DeleteItems", "Really delete selected items") + " (" + count.ToString() + ")?", Lng.Get("Delete")) == DialogResult.Yes) { foreach (var item in olvBoard.SelectedObjects) // Find Object { Boardgames itm = db.Boardgames.Find(((Boardgames)item).ID); db.Boardgames.Remove(itm); // Delete Item // ----- Remove copies ----- var copies = db.Copies.Where(x => (x.ItemType.Trim() == ItemTypes.boardgame.ToString()) && (x.ItemID == ((Boardgames)item).ID)).ToList(); foreach (var copy in copies) { db.Copies.Remove(copy); // Remove copy } } db.SaveChanges(); // Save to DB UpdateBoardOLV(); // Update Items OLV UpdateCopOLV(); // Update Copies OLV } } }
/// <summary> /// Save changes to DB /// </summary> private void SaveChanges() { // ----- Save changes ----- db.SaveChanges(); // ----- No changes indicator ----- changed = false; }
private void btnOk_Click(object sender, EventArgs e) { FindPerson(); FindItem(); if (PersonGuid == Guid.Empty) { Dialogs.ShowWar(Lng.Get("NoSelPerson", "Not selected person!"), Lng.Get("Warning")); return; } if (ItemGuid == Guid.Empty) { Dialogs.ShowWar(Lng.Get("NoSelItem", "Not selected item!"), Lng.Get("Warning")); return; } if (Conv.ToIntDef(cbItemNum.Text, 0) == 0) { Dialogs.ShowWar(Lng.Get("NoSelItemNum", "Not selected item number!"), Lng.Get("Warning")); return; } databaseEntities db = new databaseEntities(); Borrowing borr; // ----- ID ----- if (ID != Guid.Empty) { borr = db.Borrowing.Find(ID); } else { borr = new Borrowing(); borr.ID = Guid.NewGuid(); } FillBorr(ref borr); if (ID == Guid.Empty) { db.Borrowing.Add(borr); } db.SaveChanges(); RefreshAvailableItems(); this.DialogResult = DialogResult.OK; }
/// <summary> /// Set Fast Tags /// </summary> /// <param name="tag">Tags Mask</param> private void SetTagItemBoard(short tag) { if (olvBoard.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvBoard.SelectedObjects) // Find Object { Boardgames itm = db.Boardgames.Find(((Boardgames)item).ID); itm.FastTags |= tag; } db.SaveChanges(); // Save to DB UpdateBoardOLV(); // Update Contacts OLV } }
/// <summary> /// Set Fast Tags /// </summary> /// <param name="tag">Tags Mask</param> private void SetTagItemContacts(short tag) { if (olvContacts.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvContacts.SelectedObjects) // Find Object { Contacts contact = db.Contacts.Find(((Contacts)item).ID); contact.FastTags |= tag; } db.SaveChanges(); // Save to DB UpdateConOLV(); // Update Contacts OLV } }
/// <summary> /// Save changes to DB /// </summary> private void SaveChanges() { // ----- Save changes ----- db.SaveChanges(); // ----- Refresh Copy Status ----- global.RefreshCopiesStatus(lendList); // ----- Refresh Available Items ----- RefreshAvailableItems(); // ----- No changes indicator ----- changed = false; }
/// <summary> /// Set active (excluded) /// </summary> /// <param name="active"></param> private void SetActiveBoard(bool active) { if (olvBoard.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvBoard.SelectedObjects) // Find Object { Boardgames itm = db.Boardgames.Find(((Boardgames)item).ID); itm.Excluded = !active; } db.SaveChanges(); // Save to DB UpdateBoardOLV(); // Update Contacts OLV } }
/// <summary> /// Set Fast Tags /// </summary> /// <param name="tag">Tags Mask</param> private void SetTagItemLending(short tag) { if (olvLending.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvLending.SelectedObjects) // Find Object { Lending itm = db.Lending.Find(((Lending)item).ID); itm.FastTags |= tag; } db.SaveChanges(); // Save to DB UpdateLendingOLV(); // Update Contacts OLV } }
/// <summary> /// Set active (excluded) /// </summary> /// <param name="active"></param> private void SetActiveContacts(bool active) { if (olvContacts.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvContacts.SelectedObjects) // Find Object { Contacts itm = db.Contacts.Find(((Contacts)item).ID); itm.Active = active; } db.SaveChanges(); // Save to DB UpdateConOLV(); // Update Contacts OLV } }
/// <summary> /// Set Fast Tags /// </summary> /// <param name="tag">Tags Mask</param> private void SetTagItemCopies(short tag) { if (olvRecipes.SelectedObjects != null) // If selected Item { databaseEntities db = new databaseEntities(); foreach (var item in olvRecipes.SelectedObjects) // Find Object { Recipes itm = db.Recipes.Find(((Recipes)item).ID); itm.FastTags |= tag; } db.SaveChanges(); // Save to DB UpdateRecOLV(); // Update Contacts OLV } }
private void ImportObjects(string fileName) { List <Objects> con; if (Path.GetExtension(fileName) == "csv") { con = global.ImportObjectsCSV(fileName); } else { con = global.ImportObjectsXML(fileName); } if (con == null) { Dialogs.ShowErr(Lng.Get("ParseFileError", "Parse file error") + ".", Lng.Get("Error")); return; } databaseEntities db = new databaseEntities(); foreach (var item in con) { Objects itm; // ----- ID ----- if (item.ID != Guid.Empty) { itm = db.Objects.Find(item.ID); if (itm != null) { Conv.CopyClassPropetries(itm, item); } else { db.Objects.Add(item); } } else { item.ID = Guid.NewGuid(); db.Objects.Add(item); } } db.SaveChanges(); UpdateObjOLV(); Dialogs.ShowInfo(Lng.Get("SuccesfullyImport", "Import was succesfully done") + ".", Lng.Get("Import")); }
private void RefreshAvailableItems() { List <short?> borr = new List <short?>(); if (cbItemType.SelectedIndex == 0) { borr = db.Borrowing.Where(p => (p.ItemID == ItemGuid) && p.ItemType.Contains("item") && !(p.Returned ?? false)).Select(c => c.ItemNum).ToList(); Items itm = db.Items.Find(ItemGuid); itm.Available = (short)(itm.Count - borr.Count); db.SaveChanges(); } else if (cbItemType.SelectedIndex == 1) { borr = db.Borrowing.Where(p => (p.ItemID == ItemGuid) && p.ItemType.Contains("book") && !(p.Returned ?? false)).Select(c => c.ItemNum).ToList(); Books itm = db.Books.Find(ItemGuid); //itm.Available = (short)(itm.Count - borr.Count); //db.SaveChanges(); } }
/// <summary> /// Refresh Available Items /// </summary> /// <param name="list"></param> private void RefreshAvailableItems() { databaseEntities db = new databaseEntities(); foreach (var itm in lendList) { var copy = db.Copies.Find(itm.CopyID); if (copy != null) { var borr = db.Copies.Where(p => (p.ItemID == copy.ItemID) && p.ItemType.Contains(copy.ItemType.ToString()) && ((p.Status ?? 1) == (short)LendStatus.Reserved || (p.Status ?? 1) == (short)LendStatus.Lended)).Select(c => c.ID).ToList(); if (global.GetItemType(copy.ItemType) == ItemTypes.item) { Items item = db.Items.Find(copy.ItemID); if (item != null) { item.Available = (short)((item.Count ?? 1) - borr.Count); } } else if (global.GetItemType(copy.ItemType) == ItemTypes.book) { Books book = db.Books.Find(copy.ItemID); if (book != null) { book.Available = (short)((book.Count ?? 1) - borr.Count); } } else if (global.GetItemType(copy.ItemType) == ItemTypes.boardgame) { Boardgames board = db.Boardgames.Find(copy.ItemID); if (board != null) { board.Available = (short)((board.Count ?? 1) - borr.Count); } } } } db.SaveChanges(); }
private void ImportContacts(string fileName) { List <Contacts> con = global.ImportContactsCSV(fileName); if (con == null) { Dialogs.ShowErr(Lng.Get("ParseFileError", "Parse file error") + ".", Lng.Get("Error")); return; } databaseEntities db = new databaseEntities(); foreach (var item in con) { Contacts contact; // ----- ID ----- if (item.ID != Guid.Empty) { contact = db.Contacts.Find(item.ID); if (contact != null) { Conv.CopyClassPropetries(contact, item); } else { db.Contacts.Add(item); } } else { item.ID = Guid.NewGuid(); db.Contacts.Add(item); } } db.SaveChanges(); UpdateConOLV(); Dialogs.ShowInfo(Lng.Get("SuccesfullyImport", "Import was succesfully done") + ".", Lng.Get("Import")); }