protected void LoadSet()
        {
            var itemDetais = new vmItemDetais();

            try
            {
                int lUserID    = Convert.ToInt16(Session["UserID"]);
                int lCompanyID = Convert.ToInt16(Session["CompanyID"]);

                itemDetais.loggeduser    = lCompanyID;
                itemDetais.loggedCompany = lUserID;
                itemDetais.ItemId        = Convert.ToInt32(ddlItem.SelectedValue);

                List <vmItemDetais> itemList = _allProdDdl.GetSets(itemDetais).ToList();

                ddlSet.DataSource     = itemList;
                ddlSet.DataValueField = "ItemID";
                ddlSet.DataTextField  = "ItemName";
                ddlSet.DataBind();

                ListItem item = new ListItem("--Select Set--", "0");
                ddlSet.Items.Insert(0, item);
            }
            catch (Exception e)
            {
                e.ToString();
            }
        }
        protected void LoadMachine()
        {
            var itemDetais = new vmItemDetais();

            try
            {
                int lUserID    = Convert.ToInt16(Session["UserID"]);
                int lCompanyID = Convert.ToInt16(Session["CompanyID"]);

                itemDetais.loggeduser    = lCompanyID;
                itemDetais.loggedCompany = lUserID;
                itemDetais.ItemType      = 4;
                itemDetais.ItemGroup     = 50;

                List <vmItemDetais> itemList = _allProdDdl.GetMachines(itemDetais).ToList();

                ddlMachine.DataSource     = itemList;
                ddlMachine.DataValueField = "ItemID";
                ddlMachine.DataTextField  = "ItemName";
                ddlMachine.DataBind();

                ListItem item = new ListItem("--Select Machine--", "0");
                ddlMachine.Items.Insert(0, item);
            }
            catch (Exception e)
            {
                e.ToString();
            }
        }
        protected void LoadItem()
        {
            var itemDetais = new vmItemDetais();

            try
            {
                int lUserID    = Convert.ToInt16(Session["UserID"]);
                int lCompanyID = Convert.ToInt16(Session["CompanyID"]);

                //using (_ctxCmn = new ERP_Entities())
                //{
                //    itemDetais = (from IM in _ctxCmn.CmnItemMasters
                //                  where IM.ItemTypeID == 1
                //                  select new
                //                  {
                //                      ItemId = IM.ItemID,
                //                      ItemName = IM.ItemName
                //                  })
                //                         .Select(x => new vmItemDetais
                //                         {
                //                             ItemId = (int)x.ItemId,
                //                             ItemName = x.ItemName,
                //                             loggeduser = lUserID,
                //                             loggedCompany = lCompanyID
                //                         }).FirstOrDefault();
                //}

                itemDetais.loggeduser    = lCompanyID;
                itemDetais.loggedCompany = lUserID;

                List <vmItemDetais> itemList = _allProdDdl.GetItems(itemDetais).ToList();

                ddlItem.DataSource     = itemList;
                ddlItem.DataValueField = "ItemID";
                ddlItem.DataTextField  = "ItemName";
                ddlItem.DataBind();

                ListItem item = new ListItem("--Select Item--", "0");
                ddlItem.Items.Insert(0, item);
            }
            catch (Exception e)
            {
                e.ToString();
            }
        }