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