public static string RenderControls(string contentHtml)
{
HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument();
HtmlAgilityPack.HtmlNode headNode;
HtmlAgilityPack.HtmlNode bodyNode;
IEnumerable <HtmlAgilityPack.HtmlNode> headScripts;
IEnumerable <HtmlAgilityPack.HtmlNode> headControls;
IEnumerable <HtmlAgilityPack.HtmlNode> bodyScripts;
IEnumerable <HtmlAgilityPack.HtmlNode> bodyControls;
htmlDoc.LoadHtml(contentHtml);
if (htmlDoc.ParseErrors != null && htmlDoc.ParseErrors.Count() > 0)
{
//O QUE FAZER QUANDO O HTML ESTÁ COM ERRO?
}
else
{
if (htmlDoc.DocumentNode != null)
{
headNode = htmlDoc.DocumentNode.SelectSingleNode("//head");
bodyNode = htmlDoc.DocumentNode.SelectSingleNode("//body");
if (headNode != null)
{
headScripts = headNode.ChildNodes.Where(cn => "script".Equals(cn.Name));
headControls = headNode.ChildNodes.Where(cn => "cc".Equals(cn.Name));
}
if (bodyNode != null)
{
bodyScripts = bodyNode.ChildNodes.Where(cn => "script".Equals(cn.Name));
bodyControls = bodyNode.ChildNodes.Where(cn => "cc".Equals(cn.Name));
}
}
}
PortalEntities portal = new PortalEntities(Account.Context.GetConnectionStringEntity("Portal"));
IEnumerable <Portal.porPagePartial> queryPagePartial;
queryPagePartial = from pp in portal.porPagePartials
where pp.Name.Equals("header")
select pp;
contentHtml = contentHtml.Replace("<cc:pagePartial name=\"header\" />", queryPagePartial.FirstOrDefault().Html);
return(contentHtml);
}
public List <getIsApprovedCandidatePlans_Result> GetApprovedCandidatePlan()
{
try
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.getIsApprovedCandidatePlans().ToList();
return(data);
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <MenuView> GetMenuByType(int typeId)
{
using (var db = new PortalEntities())
{
return(db.system_Menu.Where(x => x.Type == typeId && x.Status == (int)Portal.Infractructure.Utility.Define.Status.Active).OrderBy(x => x.SortOrder)
.Select(x => new MenuView
{
Id = x.Id,
Name = x.Name,
Url = x.Url,
Type = x.Type,
Icon = x.Icon
}).ToList());
}
}
public BannerViewModel GetBanners2ForHomePage()
{
int month = DateTime.Now.Month;
int brandType = 1;
switch (month)
{
case 1:
case 2:
case 3:
brandType = 2; //Spring
break;
case 4:
case 5:
case 6:
brandType = 3; //Summer
break;
case 7:
case 8:
case 9:
brandType = 4; //Autumn
break;
case 10:
case 11:
case 12:
brandType = 5; //Winter
break;
}
using (var db = new PortalEntities())
{
var banner2 = db.system_Banners.FirstOrDefault(x => x.Status == (int)Portal.Infractructure.Utility.Define.Status.Active && x.Type == brandType);
if (banner2 != null)
{
return(new BannerViewModel
{
Name = banner2.Name,
ImageName = banner2.share_Images.ImageName,
ImagePath = banner2.share_Images.ImagePath,
});
}
return(null);
}
}
public List <InterestedToCandidateViewModel> GetInterestedUsers(int user_id)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.get_candidate_show_interest_by_client(user_id).AsEnumerable().Select(x => new InterestedToCandidateViewModel
{
pk_interest_id = Convert.ToInt32(x.pk_candidate_interested_id),
requirement_title = x.requirement_title,
requested_date = x.requested_date.ToString("dd/MM/yyyy"),
experience = x.experience_years + " (" + x.level + ")",
expertise = x.expertise,
status = x.status
}).ToList();
return(data);
}
}
public ResponseOut PostRequirementUpload(PostRequirementImportViewModel data)
{
ResponseOut responseOut = new ResponseOut();
using (PortalEntities _context = new PortalEntities())
{
try
{
portal_post_requirement _requirement = new portal_post_requirement();
int user_id = 0;
if (user_id == 0)
{
user_id = _context.portal_user.Where(x => !string.IsNullOrEmpty(data.email_id) && x.email.ToLower() == data.email_id.ToLower()).Select(x => x.pk_user_id).FirstOrDefault();
}
if (user_id == 0)
{
user_id = _context.portal_user.Where(x => !string.IsNullOrEmpty(data.contact_details) && x.contact == data.contact_details).Select(x => x.pk_user_id).FirstOrDefault();
}
_requirement.mobile_no = data.contact_details;
_requirement.email_id = data.email_id;
_requirement.fullname = data.client_name;
_requirement.added_date = DateTime.Now;
_requirement.approved_status = 0;
if (user_id != 0)
{
_requirement.fk_client_id = user_id;
}
_requirement.subject = data.requirement_title;
_requirement.message = data.requirement_description;
_context.portal_post_requirement.Add(_requirement);
int result = _context.SaveChanges();
if (result > 0)
{
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.RequirementPost;
}
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
return(responseOut);
}
}
/// <summary>
/// GIPO: Retorna Url a ser redirecionado
/// </summary>
public static string GetUrlMappingTo()
{
PortalEntities portal = new PortalEntities(Account.Context.GetConnectionStringEntity("Portal"));
IEnumerable <Portal.porUrlMapping> queryUrlMapping;
string UrlTo = null;
queryUrlMapping = from um in portal.porUrlMappings
where um.IdWebSite == Account.Context.WebSite.IdWebSite && um.UrlFrom.Equals(Account.Context.PathAndQuery) && (um.DtFrom <= DateTime.Now && um.DtTo >= DateTime.Now)
select um;
if (queryUrlMapping.FirstOrDefault() != null)
{
UrlTo = queryUrlMapping.FirstOrDefault().UrlTo;
}
return(UrlTo);
}
public WhatClientSays GetSingleClientFeedback(int id)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_what_client_says.Where(x => x.pk_client_what_says_id == id).AsEnumerable().Select(x => new WhatClientSays
{
id = x.pk_client_what_says_id,
title = x.title,
description = x.discription,
client_name = x.client_name,
is_published = Convert.ToBoolean(x.is_published_by_admin),
client_image = x.image,
}).FirstOrDefault();
return(data);
}
}
public List <WhatClientSays> GetClientFeedback(string title = null)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_what_client_says.AsEnumerable().Select(x => new WhatClientSays
{
id = x.pk_client_what_says_id,
title = x.title,
description = x.discription,
client_name = x.client_name,
is_published = Convert.ToBoolean(x.is_published_by_admin),
client_image = x.image,
added_datetime = x.added_datetime != null ? x.added_datetime.Value.ToString("dd/MM/yyyy") : ""
}).ToList();
return(data);
}
}
public List <InterestedToCandidateViewModel> GetInterestedUsers(int user_id)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_for_interested_Candidate.AsEnumerable().Where(x => x.is_active == true && x.fk_vendor_id == user_id).Select(x => new InterestedToCandidateViewModel
{
pk_interest_id = x.pk_candidate_interested_id,
candidate_id = Convert.ToInt32(x.fk_candidate_id),
candidate_name = x.fk_candidate_id != null ? (x.portal_recruiter_profile.firstname + " " + x.portal_recruiter_profile.lastname) : "",
requirement_title = x.requirement_title,
requested_date = x.requested_date.ToString("dd/MM/yyyy"),
no_of_request = _context.portal_for_interested_Candidate.Where(y => y.fk_candidate_id == x.fk_candidate_id).Count(),
fk_user_id = Convert.ToInt32(x.fk_user_id)
}).ToList();
return(data);
}
}
public portal_vendor_plan AddUpdateSelectPlanDurationLeftByCandidate(int pk_plan_id)
{
//var data = _context.portal_vendor_plan.AsEnumerable().Where(x => x.is_active == true && x.is_deleted == false && x.fk_role_id == 4).Select(x => new VendorPlansPricing
portal_vendor_plan responseOut = new portal_vendor_plan();
using (PortalEntities _context = new PortalEntities())
{
try
{
responseOut = _context.portal_vendor_plan.Where(x => x.pk_vendor_plan_id == pk_plan_id).FirstOrDefault();
}
catch (Exception ex)
{
throw;
}
}
return(responseOut);
}
public bool UpdateCMSNewsCountView(int?newsId)
{
try
{
using (var db = new PortalEntities())
{
var news = db.cms_News.Find(newsId);
news.TotalView++;
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <BannerViewModel> GetBanners(int pageNumber, int pageSize, out int totalItems)
{
using (var db = new PortalEntities())
{
totalItems = db.system_Banners.Count(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete);
return(db.system_Banners.Where(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete)
.OrderBy(x => x.SortOrder).ThenBy(x => x.Id)
.Skip(pageSize * (pageNumber - 1)).Take(pageSize)
.Select(x => new BannerViewModel
{
Id = x.Id,
Name = x.Name,
Type = x.Type,
Status = x.Status
}).ToList());
}
}
public bool DeleteCMSNews(int id)
{
try
{
using (var db = new PortalEntities())
{
var news = db.cms_News.Find(id);
news.Status = (int)Portal.Infractructure.Utility.Define.Status.Delete;
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteBanner(int id)
{
try
{
using (var db = new PortalEntities())
{
var banner = db.system_Banners.Find(id);
banner.Status = (int)Portal.Infractructure.Utility.Define.Status.Delete;
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public SingleResponseOut <UserViewModel> ShowInterestOnPlan(int id)
{
using (PortalEntities _context = new PortalEntities())
{
SingleResponseOut <UserViewModel> responseOut = new SingleResponseOut <UserViewModel>();
var data = _context.portal_user.Where(x => x.pk_user_id == id).Select(x => new UserViewModel
{
user_name = x.user_name,
firstname = x.firstname,
contact = x.contact,
email = x.email
}).FirstOrDefault();
responseOut.Model = data;
return(responseOut);
}
}
public bool DeleteCMSCategory(int id)
{
try
{
using (var db = new PortalEntities())
{
var category = db.cms_Categories.Find(id);
category.Status = (int)Portal.Infractructure.Utility.Define.Status.Delete;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <PostYourRequirement> GetApprovedRequirements(int user_id, string requirement = null, string status = null)
{
using (PortalEntities _context = new PortalEntities())
{
var data = from map in _context.portal_requirement_vendor_mapping
join vendor in _context.portal_user
on map.fk_vendor_id equals vendor.pk_user_id
join post in _context.portal_post_requirement
on map.fk_post_id equals post.pk_requirement_id
//where map.fk_vendor_id == user_id
select new PostYourRequirement
{
created_Date = map.map_date,
requirement_title = post.requirement_title,
subject = post.subject,
fullname = vendor.firstname + " " + vendor.lastname,
post_id = post.pk_requirement_id,
status = post.approved_status,
message = post.message,
status_by_codelate = post.status_by_codelate
};
var final_result = data.AsEnumerable().Select(x => new PostYourRequirement
{
added_datetime = x.created_Date != null ? x.created_Date.Value.ToString("dd/MM/yyyy") : "",
requirement_title = x.requirement_title,
subject = x.subject,
fullname = x.fullname,
post_id = x.post_id,
status = x.status,
status_by_codelate = x.status_by_codelate,
message = x.message
});
if (!string.IsNullOrEmpty(requirement))
{
final_result = final_result.Where(x => x.requirement_title == requirement).ToList();
}
if (!string.IsNullOrEmpty(status))
{
final_result = final_result.Where(x => x.status == Convert.ToInt32(status)).ToList();
}
return(final_result.ToList());
}
}
public bool AddBanner(BannerViewModel bannerViewModel)
{
try
{
using (var db = new PortalEntities())
{
var banner = new system_Banners
{
ImageId = bannerViewModel.ImageId,
Name = bannerViewModel.Name,
Type = bannerViewModel.Type,
Status = (int)Portal.Infractructure.Utility.Define.Status.Active,
SortOrder = bannerViewModel.SortOrder,
CreatedDate = DateTime.Now
};
if (!string.IsNullOrEmpty(bannerViewModel.StartEndDate) && bannerViewModel.StartEndDate.Length == 23)
{
//Ex: 25/08/2016 - 26/08/2016
string startDate = bannerViewModel.StartEndDate.Substring(0, bannerViewModel.StartEndDate.IndexOf(" "));
string endDate = bannerViewModel.StartEndDate.Substring(bannerViewModel.StartEndDate.IndexOf(" ") + 3);
DateTime dateTime;
if (DateTime.TryParseExact(startDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dateTime))
{
banner.StartDate = dateTime;
}
if (DateTime.TryParseExact(endDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dateTime))
{
banner.EndDate = dateTime;
}
}
db.system_Banners.Add(banner);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Isler
public ActionResult Index(bool kontrolBekleyenIsler, bool onaylananIsler, int?RefBolgeID, int?SayfaNo)
{
ViewBag.SayfaSiraNo = SayfaNo ?? 1;
ViewBag.kontrolBekleyenIsler = kontrolBekleyenIsler;
ViewBag.onaylananIsler = onaylananIsler;
ViewBag.RefBolgeID = RefBolgeID;
int GosterilecekEleman = (SayfaNo ?? 1) * 10;
int baslanacakSira = GosterilecekEleman - 10;
using (var db = new PortalEntities())
{
string kullaniciID = User.Identity.GetUserId();
IEnumerable <isler> islerim = db.islers.GetirIsler(kontrolBekleyenIsler, onaylananIsler, kullaniciID, RefBolgeID).Skip(baslanacakSira).Take(10).ToList();
ViewBag.ToplamEleman = islerim.ToList().Count;
return(View(islerim));
}
}
public List <PostYourRequirement> GetAllPostRequirement(string title = null)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_get_post_requirement(title).AsEnumerable().Select(x => new PostYourRequirement
{
post_id = x.pk_requirement_id,
email_id = x.email_id,
fullname = x.fullname,
message = x.message,
mobile_no = x.mobile_no,
requirement_title = x.requirement_title,
subject = x.subject,
status = x.approved_status,
added_datetime = x.added_date != null ? x.added_date.Value.ToString("dd/MM/yyyy") : ""
}).ToList();
return(data);
}
}
public IList <CMSCategoryView> GetChildCategoriesByParentId(int?parentId)
{
if (parentId == null)
{
return(null);
}
using (var db = new PortalEntities())
{
var categories = db.cms_Categories.Where(x => x.ParentId == parentId.Value)
.Select(x => new CMSCategoryView
{
Id = x.Id,
ParentId = x.ParentId,
Title = x.Title,
Url = x.Url,
Description = x.Description,
Status = x.Status,
SortOrder = x.SortOrder
});
if (categories.Count() == 0)
{
var category = db.cms_Categories.Find(parentId);
return(db.cms_Categories.Where(x => x.ParentId == category.ParentId)
.Select(x => new CMSCategoryView
{
Id = x.Id,
ParentId = x.ParentId,
Title = x.Title,
Url = x.Url,
Description = x.Description,
Status = x.Status,
SortOrder = x.SortOrder
}).ToList());
}
else
{
return(categories.ToList());
}
}
}
public IList <CMSCategoryView> GetCMSCategories(int pageNumber, int pageSize, out int totalItems)
{
using (var db = new PortalEntities())
{
totalItems = db.cms_Categories.Count(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete);
return(db.cms_Categories.Where(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete)
.OrderBy(x => x.ParentId).ThenBy(x => x.SortOrder)
.Skip(pageSize * (pageNumber - 1)).Take(pageSize)
.Select(x => new CMSCategoryView
{
Id = x.Id,
ParentId = x.ParentId,
Title = x.Title,
Url = x.Url,
Description = x.Description,
Status = x.Status
}).ToList());
}
}
public ResponseOut AddUpdateSelectPlanByVendor(int plan_id, int vendor_id)
{
ResponseOut responseOut = new ResponseOut();
try
{
using (PortalEntities _context = new PortalEntities())
{
portal_userplan_mapping vendor_plan_mapping = null;
vendor_plan_mapping = _context.portal_userplan_mapping.Where(x => x.user_id == vendor_id).FirstOrDefault();
if (vendor_plan_mapping != null)
{
vendor_plan_mapping.plan_id = plan_id;
vendor_plan_mapping.is_active = false;
}
else
{
vendor_plan_mapping = new portal_userplan_mapping();
vendor_plan_mapping.user_id = vendor_id;
vendor_plan_mapping.plan_id = plan_id;
vendor_plan_mapping.plan_time = DateTime.Now;
vendor_plan_mapping.is_active = false;
_context.portal_userplan_mapping.Add(vendor_plan_mapping);
}
int result = _context.SaveChanges();
if (result > 0)
{
responseOut.status = ActionStatus.Success;
responseOut.message = ActionMessage.PlansSelectedSuccess;
}
}
}
catch (Exception ex)
{
responseOut.status = ActionStatus.Fail;
responseOut.message = ActionMessage.ApplicationException;
}
return(responseOut);
}
public List <UserViewModel> GetUserList(int?user_id = null)
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_user.AsEnumerable().Select(x => new UserViewModel
{
pk_user_id = x.pk_user_id,
firstname = x.firstname,
lastname = x.lastname,
user_name = x.user_name,
email = x.email,
user_role = x.portal_user_role_mapping.Where(y => y.fk_user_id == x.pk_user_id).Select(y => y.portal_role.role_name).FirstOrDefault(),
city_name = x.fk_city_id != null ? x.portal_city.city_name : "",
created_date = x.created_date.ToString("dd/MM/yyyy"),
active_or_not = x.is_active ? "Active" : "In Active",
is_paid_user = x.is_paid_user
}).ToList();
return(data);
}
}
public BannerViewModel GetActivePopupForHomePage()
{
using (var db = new PortalEntities())
{
var banner = db.system_Banners.FirstOrDefault(x => x.Status == (int)Portal.Infractructure.Utility.Define.Status.Active &&
x.Type == (int)Portal.Infractructure.Utility.Define.BannerTypes.Popup &&
x.StartDate <= DateTime.Now && x.EndDate >= DateTime.Now);
if (banner != null)
{
return(new BannerViewModel
{
Name = banner.Name,
ImageName = banner.share_Images.ImageName,
ImagePath = banner.share_Images.ImagePath,
});
}
return(null);
}
}
public IList <ProfileViewModel> GetProfiles(int pageNumber, int pageSize, out int totalItems)
{
using (var db = new PortalEntities())
{
totalItems = db.system_Profiles.Count(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete);
return(db.system_Profiles.Where(x => x.Status != (int)Portal.Infractructure.Utility.Define.Status.Delete)
.OrderBy(x => x.UserName)
.Skip(pageSize * (pageNumber - 1)).Take(pageSize)
.Select(x => new ProfileViewModel
{
UserId = x.UserId,
UserName = x.UserName,
Emaill = x.Emaill,
Password = x.Password,
Phone = x.Phone,
Address = x.Address,
Status = x.Status
}).ToList());
}
}
public List <PlansViewModel> GetPlans()
{
try
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_plan.AsEnumerable().Where(x => x.is_deleted == false).Select(x => new PlansViewModel
{
pk_plan_id = x.pk_plan_type_id,
is_active = Convert.ToBoolean(x.is_active),
plan_name = x.plan_name
}).ToList();
return(data);
}
}
catch (Exception ex)
{
throw ex;
}
}
public PlansViewModel GetPlansById(int id)
{
try
{
using (PortalEntities _context = new PortalEntities())
{
var data = _context.portal_plan.AsEnumerable().Where(x => x.pk_plan_type_id == id).Select(x => new PlansViewModel
{
pk_plan_id = x.pk_plan_type_id,
plan_name = x.plan_name,
is_active = Convert.ToBoolean(x.is_active)
}).FirstOrDefault();
return(data);
}
}
catch (Exception ex)
{
throw ex;
}
}
private static void RenderPagePartials(ref string contentHtml, List <HtmlAgilityPack.HtmlNode> controlElements)
{
Dictionary <string, string> dicPagePartials = new Dictionary <string, string>();
foreach (HtmlAgilityPack.HtmlNode controlElement in controlElements)
{
/*
* Estou esperando o elemento com a seguinte estrutura '<cc control="pagePartial" name="header"></cc>'
*/
HtmlAgilityPack.HtmlAttribute attrControl = controlElement.Attributes.FirstOrDefault(a => a.Name.ToLower().Equals("control")); //Guardo atributo "control" do elemento
HtmlAgilityPack.HtmlAttribute attrName = controlElement.Attributes.FirstOrDefault(a => a.Name.ToLower().Equals("name")); //Guardo atributo "name" do elemento
if (attrControl != null && attrName != null)
{
if (attrControl.Value.ToLower().Equals("pagepartial"))
{
dicPagePartials.Add(controlElement.OuterHtml, attrName.Value); //Adiciono ao dicionário o código html do controle e o valor do atributo name
}
}
}
PortalEntities portal = new PortalEntities(Account.Context.GetConnectionStringEntity("Portal"));
IEnumerable <Portal.porPagePartial> queryPagePartial;
foreach (var dic in dicPagePartials)
{
queryPagePartial = from pp in portal.porPagePartials
where pp.Name.Equals(dic.Value)
select pp;
if (queryPagePartial.FirstOrDefault() != null)
{
contentHtml = contentHtml.Replace(dic.Key, queryPagePartial.FirstOrDefault().Html);
}
else
{
contentHtml = contentHtml.Replace(dic.Key, string.Format("<!-- Erro de Configuração: Página parcial \"{0}\" não existe -->", dic.Value));
}
}
}
