Exemple #1
0
        private void LoadReorderLevelData()
        {
            lvReorderList.Items.Clear();
            CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
            CResult         oResult         = new CResult();
            CReorderLevel   oReorderLevel   = new CReorderLevel();

            oResult = oReorderLevelBO.ReadAllReorderLevelData(oReorderLevel);
            if (oResult.IsSuccess)
            {
                foreach (CReorderLevel obj in oResult.Data as ArrayList)
                {
                    ListViewItem oItem = new ListViewItem();
                    oItem.Text = obj.OID.ToString();

                    oItem.SubItems.Add(obj.Item_ID).ToString();
                    oItem.SubItems.Add(obj.Location_ID).ToString();
                    oItem.SubItems.Add(obj.Branch_Name).ToString();
                    oItem.SubItems.Add(obj.Item_Name).ToString();
                    oItem.SubItems.Add(obj.Location_Name).ToString();
                    oItem.SubItems.Add(obj.Quantity).ToString();
                    oItem.SubItems.Add(obj.Remarks).ToString();


                    lvReorderList.Items.Add(oItem);
                }
            }
            else
            {
                MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Exemple #2
0
        private CReorderLevel GetToSaveData()
        {
            CReorderLevel oReorderLevel = new CReorderLevel();

            oReorderLevel.OID         = txtID.Text;
            oReorderLevel.Branch_ID   = currentBranch.CompBrn_OId.Trim().ToString();
            oReorderLevel.Item_ID     = cmbItemName.SelectedValue.ToString();
            oReorderLevel.Location_ID = cmbLocation.SelectedValue.ToString();
            oReorderLevel.Quantity    = txtRQTY.Text;
            oReorderLevel.Remarks     = txtRemarks.Text;

            return(oReorderLevel);
        }
            public CResult Import(CReorderLevel oReorderLevel)
            {
                oResult = new CResult();
                conn    = oConnManager.GetConnection(out s_DBError);
                if (conn != null)
                {
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = conn;

                    cmd.Transaction = oConnManager.BeginTransaction();
                    try
                    {
                        cmd.CommandText = "sp_ReorderLevel_Import";
                        cmd.CommandType = CommandType.StoredProcedure;
                        //cmd.Parameters.AddWithValue("@Cust_OID", oReorderLevel.OID);
                        //cmd.Parameters.AddWithValue("@Cust_Branch", "XXXXX");
                        cmd.Parameters.AddWithValue("@OID", oReorderLevel.OID);
                        cmd.Parameters.AddWithValue("@Cust_Branch", oReorderLevel.Branch_ID);
                        cmd.Parameters.AddWithValue("@ItemID", oReorderLevel.Item_ID);
                        cmd.Parameters.AddWithValue("@LocationID", oReorderLevel.Location_ID);
                        cmd.Parameters.AddWithValue("@Quantity", oReorderLevel.Quantity);
                        cmd.Parameters.AddWithValue("@Remarks", oReorderLevel.Remarks);

                        cmd.ExecuteNonQuery();

                        oConnManager.Commit();
                        oResult.IsSuccess = true;
                    }
                    catch (SqlException e)
                    {
                        string sRollbackError = oConnManager.Rollback();

                        oResult.IsSuccess = false;
                        oResult.ErrMsg    = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
                    }

                    finally
                    {
                        oConnManager.Close();
                    }
                }
                else
                {
                    oResult.IsSuccess = false;
                    oResult.ErrMsg    = s_DBError;
                }

                return(oResult);
            }
            public CResult ReadAllReorderLevelData(CReorderLevel oReorderLevel)
            {
                ArrayList oReorderLevelList = new ArrayList();

                oResult = new CResult();
                conn    = oConnManager.GetConnection(out s_DBError);
                if (conn != null)
                {
                    try
                    {
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection  = conn;
                        cmd.CommandText = "sp_ReadALLReOrdLvl";
                        cmd.CommandType = CommandType.StoredProcedure;

                        DataSet        ds = new DataSet();
                        SqlDataAdapter da = new SqlDataAdapter(cmd);
                        da.Fill(ds);
                        DataTable dt = ds.Tables[0];

                        foreach (DataRow dr in dt.Rows)
                        {
                            oReorderLevelList.Add(GetresultoReorderLevel(dr));
                        }


                        oResult.Data = oReorderLevelList;

                        oResult.IsSuccess = true;
                    }
                    catch (SqlException e)
                    {
                        string sRollbackError = oConnManager.Rollback();

                        oResult.IsSuccess = false;
                        oResult.ErrMsg    = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
                    }
                    finally
                    {
                        oConnManager.Close();
                    }
                }
                else
                {
                    oResult.IsSuccess = false;
                    oResult.ErrMsg    = s_DBError;
                }
                return(oResult);
            }
            private CReorderLevel GetresultoReorderLevel(DataRow dr)
            {
                CReorderLevel oReorderLevel = new CReorderLevel();

                oReorderLevel.OID           = dr[0].ToString();
                oReorderLevel.Branch_Name   = dr[8].ToString();
                oReorderLevel.Branch_ID     = dr["ReOrdLvl_Branch"].ToString();
                oReorderLevel.Item_ID       = dr[2].ToString();
                oReorderLevel.Location_ID   = dr[3].ToString();
                oReorderLevel.Quantity      = dr[4].ToString();
                oReorderLevel.Remarks       = dr[5].ToString();
                oReorderLevel.Item_Name     = dr[6].ToString();
                oReorderLevel.Location_Name = dr[7].ToString();
                return(oReorderLevel);
            }
Exemple #6
0
        private void AlertForItemShortage()
        {
            CReorderLevelBO oReorderLevelBO     = new CReorderLevelBO();
            CResult         oResultReorderLevel = new CResult();
            CReorderLevel   oReorderLevel       = new CReorderLevel();
            String          ItemName            = null;

            oResultReorderLevel = oReorderLevelBO.ReadAllReorderLevelData(oReorderLevel);
            if (oResultReorderLevel.IsSuccess)
            {
                foreach (CReorderLevel obj in oResultReorderLevel.Data as ArrayList)
                {
                    oReorderLevel.Quantity = obj.Quantity;

                    CInventoryBO oInventoryBO     = new CInventoryBO();
                    CResult      oResultInventory = new CResult();
                    CInventory   oInventory       = new CInventory();
                    oInventory.Invt_BranchOID = obj.Branch_ID;
                    oInventory.Invt_LocOID    = obj.Location_ID;
                    oInventory.Invt_ItemOID   = obj.Item_ID;
                    oResultInventory          = oInventoryBO.ReadForROL(oInventory);
                    if (oResultInventory.IsSuccess)
                    {
                        foreach (CInventory oInv in oResultInventory.Data as ArrayList)
                        {
                            if (int.Parse(oInv.Invt_QTY.ToString()) < int.Parse(oReorderLevel.Quantity.ToString()))
                            {
                                ItemName = ItemName + oInv.Invt_ItemName.ToString() + "\n";
                                // MessageBox.Show("Item", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                        }
                    }
                }
                //MessageBox.Show("Shortage Of Following Items "+ItemName+"", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                if (ItemName != null)
                {
                    frmPopup ofrmPopUp = new frmPopup(PopupSkins.AlertSkin);
                    ofrmPopUp.ShowPopup("Item Shortage!!", "Shortage Of Following Items-" + ItemName + "", 500, 2000, 500);
                }
            }
        }