public ActionResult ShowIndustryWiseAssociate(string PromotionID)
        {
            PromotionLibraryDAO obj = new PromotionLibraryDAO();

            int plId = Convert.ToInt32(PromotionID);

            TempData["PLibraryID"] = plId.ToString();
            List <PromotionLibraryDAO.SelectListItem> Industrieslist = new List <PromotionLibraryDAO.SelectListItem>();
            var _industries = (from p in db.Industries
                               select new { p.IndustriesID, p.IndustriesName }).AsEnumerable();

            Industrieslist.Add(new PromotionLibraryDAO.SelectListItem()
            {
                Text = "Select Industry", Value = 0
            });
            foreach (var item in _industries)
            {
                Industrieslist.Add(new PromotionLibraryDAO.SelectListItem()
                {
                    Text = item.IndustriesName, Value = item.IndustriesID
                });
            }
            obj.IndustriesListModel = Industrieslist;

            return(View(obj));
        }
        public ActionResult PromotionLibraryForm()
        {
            List <PromotionLibraryDAO> listResult = new List <PromotionLibraryDAO>();
            PromotionLibraryDAO        _objPl     = new PromotionLibraryDAO();
            List <PromotionLibraryDAO.SelectListItem> Industrieslist = new List <PromotionLibraryDAO.SelectListItem>();
            var _industries = (from p in db.Industries
                               select new { p.IndustriesID, p.IndustriesName }).AsEnumerable();


            foreach (var item in _industries)
            {
                Industrieslist.Add(new PromotionLibraryDAO.SelectListItem()
                {
                    Text = item.IndustriesName, Value = item.IndustriesID
                });
            }
            _objPl.IndustriesListModel = Industrieslist;
            string Uid   = Request.Cookies["UserId"].Value;
            int    uid   = Convert.ToInt32(Uid);
            var    uName = (from c in db.RegisterUsers where c.Id == uid select c.UserNo).FirstOrDefault();

            // HttpCookie userNameCookies = new HttpCookie("UserId");
            //userNameCookies.Value = "asad";
            if (!string.IsNullOrEmpty(uName))
            {
                var userdetails = (from t in db.RegisterUsers
                                   join proj in db.WorldRefExcelDataProjects on t.Id equals proj.userid
                                   where t.UserNo == uName
                                   select  new { t.Email, proj.CustomerName, t.Industries, t.phone, t.ProfileAttach }).Distinct().AsEnumerable();
                foreach (var project in userdetails)
                {
                    listResult.Add(new PromotionLibraryDAO()
                    {
                        PEmailId        = project.Email,
                        PContactNumber  = project.phone,
                        CertificateName = project.CustomerName,
                        IndustriesName  = project.Industries,
                        PCompanyProfile = project.ProfileAttach
                    });
                }

                _objPl.details = listResult;

                _objPl.PEmailId        = _objPl.details[0].PEmailId.ToString();
                _objPl.PName           = _objPl.details[0].CertificateName.ToString();
                _objPl.PContactNumber  = _objPl.details[0].PContactNumber.ToString();
                _objPl.PCompanyProfile = _objPl.details[0].PCompanyProfile.ToString();
            }
            return(View(_objPl));
        }