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);
}
