/// <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 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.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.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();
}
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]);
}
}
}