public ActionResult WorldRefPromotionDetails(string PromotionID) { PromotionProductListDAO obj = new PromotionProductListDAO(); List<PromotionProductListDAO> objPromotionlist = new List<PromotionProductListDAO>(); List<PromotionOtherDocument> lstOtherDocuments = new List<PromotionOtherDocument>(); List<PromotionCertificate> lstCertificate = new List<PromotionCertificate>(); List<PromotionIndustryDAO> lstpromotionIndustry = new List<PromotionIndustryDAO>(); // List<PromotionIndustry> lstpromotionIndustry = new List<PromotionIndustry>(); int PId = Convert.ToInt32(PromotionID); var result = (from pd in db.PromotionProductLists where pd.PromotionLibraryID == PId select new { pd.ProductName, pd.ProductBrochure, pd.URSFormat }); foreach (var data in result) { objPromotionlist.Add(new PromotionProductListDAO() { ProductName = data.ProductName, ProductBrochure = data.ProductBrochure, URSFormat = data.URSFormat }); } var otherDocuments = (from od in db.PromotionOtherDocuments where od.PromotionLibraryID == PId select new { od.OtherDocumentName, od.DocumentAttachment }); foreach (var dataDocumnet in otherDocuments) { lstOtherDocuments.Add(new PromotionOtherDocument() { OtherDocumentName = dataDocumnet.OtherDocumentName, DocumentAttachment = dataDocumnet.DocumentAttachment }); } var certificate = (from c in db.PromotionCertificates where c.PromotionLibraryID == PId select new { c.CertificateName, c.CertificateAttachment }); foreach (var certificateData in certificate) { lstCertificate.Add(new PromotionCertificate() { CertificateName = certificateData.CertificateName, CertificateAttachment = certificateData.CertificateAttachment }); } var industry = (from i in db.Industries join pi in db.PromotionIndustries on i.IndustriesID equals pi.IndustriesID where pi.PromotionLibraryID == PId select new { i.IndustriesName }); foreach (var ind in industry) { lstpromotionIndustry.Add(new PromotionIndustryDAO() { IndustriesName = ind.IndustriesName }); } obj.cindustrylist = lstpromotionIndustry; obj.certificatelist = lstCertificate; obj._Productlist = objPromotionlist; obj.documentlist = lstOtherDocuments; return View(obj); }
public ActionResult PromotionDetails(string PromotionID) { PromotionProductListDAO obj = new PromotionProductListDAO(); List<PromotionProductListDAO> objPromotionlist = new List<PromotionProductListDAO>(); List<PromotionOtherDocument> lstOtherDocuments = new List<PromotionOtherDocument>(); List<PromotionCertificate> lstCertificate = new List<PromotionCertificate>(); List<PromotionIndustry> lstpromotionIndustry = new List<PromotionIndustry>(); int PId = Convert.ToInt32(PromotionID); var result = (from pd in db.PromotionProductLists where pd.PromotionLibraryID == PId select new { pd.ProductName, pd.ProductBrochure, pd.URSFormat, pd.ProductIndustry }); foreach (var data in result) { TempData["indusId"] = data.ProductIndustry; objPromotionlist.Add(new PromotionProductListDAO() { ProductName = data.ProductName, ProductBrochure = data.ProductBrochure, URSFormat = data.URSFormat, PromotionLibraryID = PId }); } var otherDocuments = (from od in db.PromotionOtherDocuments where od.PromotionLibraryID == PId select new { od.OtherDocumentName, od.DocumentAttachment }); foreach (var dataDocumnet in otherDocuments) { lstOtherDocuments.Add(new PromotionOtherDocument() { OtherDocumentName = dataDocumnet.OtherDocumentName, DocumentAttachment = dataDocumnet.DocumentAttachment }); } var certificate = (from c in db.PromotionCertificates where c.PromotionLibraryID == PId select new { c.CertificateName, c.CertificateAttachment }); foreach (var certificateData in certificate) { lstCertificate.Add(new PromotionCertificate() { CertificateName = certificateData.CertificateName, CertificateAttachment = certificateData.CertificateAttachment }); } List<PromotionLibraryDAO> _objlist = new List<PromotionLibraryDAO>(); List<PromotionLibraryDAO> _objlistuser = new List<PromotionLibraryDAO>(); int industryId = Convert.ToInt32(TempData["indusId"]); string indId = industryId.ToString(); var dataAssociateName = (from a in db.Industries join p in db.AssociateProjectIndustries on a.IndustriesID equals p.IndustriesID join r in db.RegisterUsers on p.Id equals r.Id where a.IndustriesID == industryId && r.UserRole == "A" select new { r.UserNo, r.Id, r.CountryName, r.UserFirstName } ); foreach (var objData in dataAssociateName) { _objlist.Add(new PromotionLibraryDAO() { USerNo = objData.UserNo, Id = objData.Id, CountryName = objData.CountryName, UserFirstName = objData.UserFirstName }); } //code for get worldref user //var re = (from a in db.RegisterUsers // where a.Industries == indId && a.UserRole == "W" // select new { a.UserNo, a.Id, a.CountryName, a.UserFirstName } // ); //foreach (var objData in re) //{ // _objlistuser.Add(new PromotionLibraryDAO() // { // USerNo = objData.UserNo, // Id = objData.Id, // CountryName = objData.CountryName, // UserFirstName = objData.UserFirstName // }); //} obj.objlistpromotionlib = _objlist; //obj.worlrefUserList = _objlistuser; obj.certificatelist = lstCertificate; obj._Productlist = objPromotionlist; obj.documentlist = lstOtherDocuments; return View(obj); }