/// <summary> /// Handles Delete of an item /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolBtnDelete_Click(object sender, EventArgs e) { DataRow drv = gridView1.GetFocusedDataRow(); if (drv != null) { Items itm = new Items(); ProductsCategory proCat = new ProductsCategory(); int itemId = Convert.ToInt32(drv["ID"]); if (!itm.HasTransactions(itemId)) { if (XtraMessageBox.Show("Are You Sure, You want to delete this Transaction? You will not be able to restore this data.", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { proCat.GetCategoryByItem(itemId); foreach (DataRowView drcat in proCat.DefaultView) { ProductsCategory cat = new ProductsCategory(); cat.LoadByPrimaryKey(Convert.ToInt32(drcat["ID"])); cat.MarkAsDeleted(); cat.Save(); } itm.LoadByPrimaryKey(itemId); itm.MarkAsDeleted(); itm.Save(); XtraMessageBox.Show("Item Deleted!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { XtraMessageBox.Show("Unable to Delete, This Item has been Received or Issued.", "Unable to Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
private void removeToolStripMenuItem_Click(object sender, EventArgs e) { if (lstCat.SelectedItems.Count > 0) { if (lstCat.SelectedItems[0] != null) { ProductsCategory prodCate = new ProductsCategory(); int id = Convert.ToInt32(lstCat.SelectedItems[0].Tag); if (prodCate.CategoryExists(_itemId, id)) { prodCate.GetProductCategory(_itemId, id); prodCate.MarkAsDeleted(); prodCate.Save(); } lstCat.Items.Remove(lstCat.SelectedItems[0]); } } }
private void btnSave_Click(object sender, EventArgs e) { Items itm = new Items(); if (_itemId != 0) { itm.LoadByPrimaryKey(_itemId); } else { itm.AddNew(); itm.IsInHospitalList = true; Items itms = new Items(); itm.ID = itms.GetNextItemID(); itm.StorageTypeID = 1; itm.NearExpiryTrigger = 0; } itm.IINID = Convert.ToInt32(cboIIN.SelectedValue); //itm.StockCode = txtCatCode.Text + "-" + txtStockCode.Text; itm.StockCode = txtStockCode.Text; itm.Code = txtStock2.Text; itm.StockCodeDACA = txtStock3.Text; itm.Strength = txtStrength.Text; itm.DosageFormID = Convert.ToInt32(cboDosageForm.SelectedValue); itm.IsDiscontinued = ckIsDiscontinued.Checked; itm.IsFree = ckIsFree.Checked; itm.EDL = ckIsEDL.Checked; itm.UnitID = Convert.ToInt32(cboUnit.SelectedValue); itm.Pediatric = ckIsPedatric.Checked; itm.Refrigeratored = ckIsRefrigerated.Checked; itm.NeedExpiryBatch = true; itm.Save(); ProductsCategory prodCate = new ProductsCategory(); foreach (ListViewItem lstC in lstCat.Items) { int catId = Convert.ToInt32(lstC.Tag); if (prodCate.CategoryExists(itm.ID, catId)) { continue; } prodCate.AddNew(); prodCate.ItemId = itm.ID; prodCate.SubCategoryID = catId; prodCate.Save(); } if (itm.IsColumnNull("StockCode")) { // Update the Stock Code prodCate.Rewind(); SubCategory sc = new SubCategory(); sc.LoadByPrimaryKey(prodCate.SubCategoryID); if (sc.RowCount > 0) { itm.StockCode = string.Format("{0}.{1}.{2}.{3}", sc.SubCategoryCode, 1, itm.DosageFormID, 1); itm.Save(); } } XtraMessageBox.Show("Item is Saved Successfully!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
/// <summary> /// Saves the item policy /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { var itm = new Items(); var itmSup = new ItemSupplier(); if (_itemId != 0) { itm.LoadByPrimaryKey(_itemId); } else { itm.AddNew(); var prodCate = new ProductsCategory(); prodCate.AddNew(); prodCate.ItemId = itm.ID; prodCate.SubCategoryID = Convert.ToInt32(_categoryId); prodCate.Save(); } //if (rdA.Checked || rdB.Checked || rdC.Checked) // itm.ABC = ((rdA.Checked) ? 1 : (rdB.Checked) ? 2 : 3); //if (rdV.Checked || rdE.Checked || rdN.Checked) // itm.VEN = ((rdV.Checked) ? 1 : (rdE.Checked) ? 2 : 3); itm.IsInHospitalList = ckExculed.Checked; //itm.NeedExpiryBatch = chkNeedExpiryBatch.Checked; string valid = ValidateFields(); if (valid == "true") { itm.NeedExpiryBatch = chkNeedExpiryBatch.Checked; itm.Pediatric = chkIsVaccine.Checked; //wrong coulmn name but used to identify the vaccine items itm.StockCodeDACA = txtText.Text; itm.Cost = txtQuantityPerPack.Text; itm.Save(); } else { XtraMessageBox.Show(valid, "Validation", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } //TODO: To add categories //Needs some modification on edit // this will only add the suppliers //do some thing on edit itmSup.DeleteAllSupForItem(itm.ID); Supplier sup = new Supplier(); foreach (object t in lstSuppliers.CheckedItems) { sup.GetSupplierByName(t.ToString()); itmSup.AddNew(); itmSup.ItemID = itm.ID; itmSup.SupplierID = sup.ID; itmSup.Save(); } var progItm = new ProgramProduct(); progItm.DeleteAllProgramsForItem(_itemId); var prog = new Programs(); //prog.AddNew(); //prog.Name = cboPrograms.Text; //prog.Save(); //foreach (object t in lstPrograms.CheckedItems) //{ // prog.GetProgramByName(t.ToString()); // progItm.AddNew(); // progItm.ItemID = itm.ID; // progItm.ProgramID = prog.ID; // progItm.StoreID = (progItm.ProgramID == 1000) ? 8 : 9; // progItm.Save(); //} if (rdSubProgram.EditValue != null) { progItm.AddNew(); progItm.ItemID = itm.ID; progItm.ProgramID = Convert.ToInt32(rdSubProgram.EditValue); progItm.StoreID = 9; progItm.Save(); } var duItem = new DUsItemList(); var dus = new ReceivingUnits(); foreach (object t in lstDUs.CheckedItems) { dus.GetDUByName(t.ToString()); duItem.AddNew(); duItem.DUID = dus.ID; duItem.ItemID = _itemId; try { duItem.Save(); } catch { } } XtraMessageBox.Show("Item Detail is Saved Successfully!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }