public List <TeamMember> ParseFile(string rawFileContent)
{
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(rawFileContent);
var docNode = doc.DocumentNode;
var managerNode = docNode.SelectSingleNode("//section[@class='organigramma']/table[1]/tbody/tr/td[2]");
var manager = new TeamMember();
manager.Role = MemberRole.Manager;
manager.Fullname = Capitalize(managerNode.InnerText);
manager.Team = new Domain.Teams.Team
{
Name = GetTeamName(docNode)
};
var additionalDetails = new AdditionalDetails();
additionalDetails.AddDetail("Website", "legaseriea.it", "http://www.legaseriea.it/en");
additionalDetails.AddDetail("Manager Profile", manager.Fullname, GetProfileUrl(manager.Fullname));
additionalDetails.AddDetail("League", "Serie A");
additionalDetails.AddDetail("Country", "Italy");
additionalDetails.AddImportMethod("Local Html Parsing");
additionalDetails.AddTimeStampNow("Imported On");
manager.AdditionalDetailsJson = additionalDetails.ToJson();
return(new List <TeamMember> {
manager
});
}
public static AdditionalDetails CreateFootbalTeamsLocalCreationDetails()
{
var addtionalDetails = new AdditionalDetails();
addtionalDetails.AddTimeStampNow("Created On");
return(addtionalDetails);
}
public bool AdditionalDetails(AdditionalDetails req)
{
try
{
_context.AdditionalDetails.Add(req);
_context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public void AddAddtionalDetails(AdditionalDetails ad)
{
string command = "INSERT INTO dbo.AdditionalDetails(MemberID ,Club , TrainerID, JoiningDate , SalesRepID , SourcePromotionID ,ReferredMemberBy , Occupation , Organisation, InvolvementType) VALUES(@MemberID ,@Club , @TrainerID, @JoiningDate , @SalesRepID , @SourcePromotionID ,@ReferredMemberBy , @Occupation , @Organisation, @InvolvementType)";
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@MemberID", ad.MemberID);
param[1] = new SqlParameter("@Club", ad.Club);
param[2] = new SqlParameter("@TrainerID", ad.TrainerID);
param[3] = new SqlParameter("@JoiningDate", ad.JoiningDate);
param[4] = new SqlParameter("@SalesRepID", ad.SalesRepID);
param[5] = new SqlParameter("@SourcePromotionID", ad.SourcePromotionID);
param[6] = new SqlParameter("@ReferredMemberBy", ad.ReferredMemberBy);
param[7] = new SqlParameter("@Occupation", ad.Occupation);
param[8] = new SqlParameter("@Organisation", ad.Organisation);
param[9] = new SqlParameter("@InvolvementType", ad.InvolvementType);
da.Insert(param, command);
}
public List <Team> ParseFile(string rawFileContent)
{
List <Team> results = new List <Team>();
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(rawFileContent);
var docNode = doc.DocumentNode;
var team = new Team();
var additionalDetails = new AdditionalDetails();
var teamName = GetName(docNode);
var teamLongName = GetLongName(docNode);
var teamProfileUrl = GetProfileUrl(docNode, teamName);
var teamWebsiteName = GetWebsite(docNode);
var teamWebsiteUrl = GetWebsiteUrl(docNode);
var stadiumName = GetStadium(docNode);
var stadiumUrl = "https://www.bing.com/images/search?q=" + HttpUtility.UrlEncode(stadiumName + " stadium");
var address = GetAddress(docNode);
additionalDetails.AddDetail("Website", "legaseriea.it", "http://www.legaseriea.it/en");
additionalDetails.AddDetail("Original Team", teamName, teamProfileUrl);
additionalDetails.AddDetail("Official Website", teamWebsiteName, teamWebsiteUrl);
additionalDetails.AddDetail("Original Stadium", stadiumName, stadiumUrl);
additionalDetails.AddDetail("Full Name", teamLongName);
additionalDetails.AddDetail("Imported Address", address);
additionalDetails.AddDetail("League", "Serie A");
additionalDetails.AddDetail("Country", "Italy");
additionalDetails.AddImportMethod("Local Html Parsing");
additionalDetails.AddTimeStampNow("Imported On");
team.AdditionalDetailsJson = additionalDetails.ToJson();
team.Name = teamName;
team.Address = address;
results.Add(team);
return(results);
}
private TeamMember ParsePlayer(HtmlNode playerNode, string teamName)
{
var player = new TeamMember();
player.Team = new Domain.Teams.Team
{
Name = teamName
};
player.Number = GetPlayerNumber(playerNode);
player.Fullname = GetFullName(playerNode);
player.Role = MemberRole.Player;
player.Position = GetPlayerPosition(playerNode);
player.DateOfBirth = GetDateOfbirth(playerNode);
var nationalityFIFA = GetNationalityFIFA(playerNode);
var profileUrl = GetProfileUrl(playerNode);
var goals = GetGoals(playerNode);
var y = GetYellowCards(playerNode);
var r = GetRedCards(playerNode);
var additionalDetails = new AdditionalDetails();
additionalDetails.AddDetail("Website", "legaseriea.it", "http://www.legaseriea.it/en");
additionalDetails.AddDetail("Player Profile", player.Fullname, profileUrl);
//additionalDetails.AddDetail("Original Team", teamName, teamProfileUrl);
additionalDetails.AddDetail("Nationality", nationalityFIFA);
additionalDetails.AddDetail("Goals", goals);
additionalDetails.AddDetail("Yellow", y);
additionalDetails.AddDetail("Red", r);
additionalDetails.AddDetail("League", "Serie A");
additionalDetails.AddDetail("Country", "Italy");
additionalDetails.AddImportMethod("Local Html Parsing");
additionalDetails.AddTimeStampNow("Imported On");
player.AdditionalDetailsJson = additionalDetails.ToJson();
return(player);
}
public ResponseModel RegisterCandidate([FromBody] RegistrationModel req)
{
ResponseModel response = new ResponseModel();
bool eduDetails = false;
bool empDetails = false;
bool skillsDetails = false;
bool addressDetails = false;
bool canData = false;
bool curEmpDetails = false;
bool visaDetails = false;
bool projDetails = false;
try
{
CandidateData cd = new CandidateData();
cd.CandidateId = req.CandidateId;
cd.Pwd = req.Pwd;
cd.Email = req.Email;
cd.PhoneNumber = req.PhoneNumber;
cd.FirstName = req.FirstName;
cd.MiddleName = req.MiddleName;
cd.LastName = req.LastName;
cd.Address = req.Address;
cd.Gender = req.Gender;
cd.TempAddress = req.TempAddress;
cd.PerAddress = req.PerAddress;
cd.Nationality = req.Nationality;
cd.PassportNo = req.PassportNo;
cd.Resume = req.Resume;
cd.ProfilePic = req.ProfilePic;
cd.AdharNumber = req.AdharNumber;
canData = _repo.RegisterCandidate(cd);
AdditionalDetails ad = new AdditionalDetails();
ad.CandidateId = req.CandidateId;
ad.Channel = req.Channel;
ad.Reason = req.Reason;
ad.WhyValueLabs = req.WhyValueLabs;
ad.ReferredBy = req.ReferredBy;
ad.ReferredById = req.ReferredById;
ad.IsExEmployee = req.IsExEmployee;
ad.Duration = req.Duration;
ad.AdditionalDocs = "NO";
bool addDetails = _repo.AdditionalDetails(ad);
//dynamic dynJson = JsonConvert.DeserializeObject(json);
foreach (var item in req.EduDTO)
{
item.CandidateId = req.CandidateId;
eduDetails = _repo.EducationDetails(item);
}
if (req.EmpType == 1)// If he is fresher, no need to insert in Employee details.
{
empDetails = true;
projDetails = true;
}
else
{
foreach (var item in req.EmpDTO)
{
// Console.WriteLine("{0} {1} {2} {3}\n", item.id, item.displayName,
// item.slug, item.imageUrl);
item.CandidateId = req.CandidateId;
empDetails = _repo.EmploymentDetails(item);
}
foreach (var item in req.ProjectsDTO)
{
item.CandidateId = req.CandidateId;
empDetails = _repo.ProjectDetails(item);
}
}
foreach (var item in req.SkillsDTO)
{
// Console.WriteLine("{0} {1} {2} {3}\n", item.id, item.displayName,
// item.slug, item.imageUrl);
item.CandidateId = req.CandidateId;
skillsDetails = _repo.SkillsDetails(item);
}
foreach (var item in req.AddressDTO)
{
item.CandidateId = req.CandidateId;
addressDetails = _repo.AddressDetails(item);
}
if (req.EmpType == 1)
{
curEmpDetails = true;
visaDetails = true;
}
else
{
foreach (var item in req.CurEmpDTO)
{
item.CandidateId = req.CandidateId;
curEmpDetails = _repo.CurrentEmploymentDetails(item);
}
foreach (var item in req.VisaDTO)
{
item.CandidateId = req.CandidateId;
visaDetails = _repo.VisaDetails(item);
}
}
if (eduDetails && empDetails && skillsDetails && addressDetails && canData && curEmpDetails && visaDetails)
{
response.Message = "Success";
response.Status = true;
response.Data = null;
return(response);
}
else
{
response.Message = "Failed";
response.Status = false;
response.Data = null;
return(response);
}
}
catch (Exception ex)
{
response.Message = ex.Message;
response.Status = false;
response.Data = null;
return(response);
}
}
