public Domain.Myfashion.Domain.LinkedinCompanyPage getCompanyPageInformation(Guid userid, string lipageid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of account.
NHibernate.IQuery query = session.CreateQuery("from LinkedinCompanyPage where LinkedinPageId = :LinkedinPageId And UserId=:UserId");
query.SetParameter("UserId", userid);
query.SetParameter("LinkedinPageId", lipageid);
Domain.Myfashion.Domain.LinkedinCompanyPage result = query.UniqueResult <Domain.Myfashion.Domain.LinkedinCompanyPage>();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public Domain.Myfashion.Domain.LinkedinCompanyPage getCompanyPageInformation(string liPageid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of account.
List <Domain.Myfashion.Domain.LinkedinCompanyPage> objlst = session.CreateQuery("from LinkedinCompanyPage where LinkedinPageId = :linkedinpageid ")
.SetParameter("linkedinpageid", liPageid)
.List <Domain.Myfashion.Domain.LinkedinCompanyPage>().ToList <Domain.Myfashion.Domain.LinkedinCompanyPage>();
Domain.Myfashion.Domain.LinkedinCompanyPage result = new Domain.Myfashion.Domain.LinkedinCompanyPage();
if (objlst.Count > 0)
{
result = objlst[0];
}
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public string PutLikeOnLinkedinCompanyPageUpdate(string UserId, string PageId, string Updatekey, string IsLike)
{
try
{
string msg = string.Empty;
int isLike = Convert.ToInt16(IsLike);
if (isLike == 1)
{
msg = "false";
}
else
{
msg = "true";
}
Domain.Myfashion.Domain.LinkedinCompanyPage objlicompanypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
objlicompanypage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(PageId);
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = objlicompanypage.OAuthVerifier;
Linkedin_oauth.TokenSecret = objlicompanypage.OAuthSecret;
Linkedin_oauth.Token = objlicompanypage.OAuthToken;
Linkedin_oauth.Id = objlicompanypage.LinkedinPageId;
Linkedin_oauth.FirstName = objlicompanypage.LinkedinPageName;
Company company = new Company();
string res = company.SetLikeUpdateOnPagePost(Linkedin_oauth, Updatekey, msg);
return(new JavaScriptSerializer().Serialize(res));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public void addLinkenCompanyPage(Domain.Myfashion.Domain.LinkedinCompanyPage linkedincompanypage)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to save data
session.Save(linkedincompanypage);
transaction.Commit();
} //End Transaction
} //End Session
}
public void updateLinkedinPage(Domain.Myfashion.Domain.LinkedinCompanyPage linkedinPage)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
session.CreateQuery("Update LinkedinCompanyPage set LinkedinPageName =:LinkedinPageName,EmailDomains =:EmailDomains,OAuthToken =:OAuthToken,OAuthSecret=:OAuthSecret,OAuthVerifier=:OAuthVerifier,Description=:Description,FoundedYear=:FoundedYear,EndYear =:EndYear,Locations=:Locations,Specialties=:Specialties,WebsiteUrl=:WebsiteUrl,Status=:Status,EmployeeCountRange=:EmployeeCountRange,Industries=:Industries,CompanyType=:CompanyType,LogoUrl=:LogoUrl,SquareLogoUrl=:SquareLogoUrl,BlogRssUrl=:BlogRssUrl,UniversalName=:UniversalName,NumFollowers=:NumFollowers where LinkedinPageId = :linkedinpageid and UserId = :UserId")
.SetParameter("LinkedinPageName", linkedinPage.LinkedinPageName)
.SetParameter("EmailDomains", linkedinPage.EmailDomains)
.SetParameter("OAuthToken", linkedinPage.OAuthToken)
.SetParameter("OAuthSecret", linkedinPage.OAuthSecret)
.SetParameter("OAuthVerifier", linkedinPage.OAuthVerifier)
.SetParameter("Description", linkedinPage.Description)
.SetParameter("FoundedYear", linkedinPage.FoundedYear)
.SetParameter("EndYear", linkedinPage.EndYear)
.SetParameter("Locations", linkedinPage.Locations)
.SetParameter("Specialties", linkedinPage.Specialties)
.SetParameter("WebsiteUrl", linkedinPage.WebsiteUrl)
.SetParameter("Status", linkedinPage.Status)
.SetParameter("EmployeeCountRange", linkedinPage.EmployeeCountRange)
.SetParameter("Industries", linkedinPage.Industries)
.SetParameter("CompanyType", linkedinPage.CompanyType)
.SetParameter("LogoUrl", linkedinPage.LogoUrl)
.SetParameter("SquareLogoUrl", linkedinPage.SquareLogoUrl)
.SetParameter("BlogRssUrl", linkedinPage.BlogRssUrl)
.SetParameter("UniversalName", linkedinPage.UniversalName)
.SetParameter("NumFollowers", linkedinPage.NumFollowers)
.SetParameter("linkedinpageid", linkedinPage.LinkedinPageId)
.SetParameter("UserId", linkedinPage.UserId)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}
}
}
public string GetLinkedinCompanyPageDetailsByUserIdAndPageId(string UserId, string LinkedinPageId)
{
Domain.Myfashion.Domain.LinkedinCompanyPage LinkedinCompanyPage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
try
{
Guid Userid = Guid.Parse(UserId);
if (objLinkedCmpnyPgeRepo.checkLinkedinPageExists(LinkedinPageId, Userid))
{
LinkedinCompanyPage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(Userid, LinkedinPageId);
}
else
{
LinkedinCompanyPage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(LinkedinPageId);
}
return(new JavaScriptSerializer().Serialize(LinkedinCompanyPage));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new JavaScriptSerializer().Serialize("Please Try Again"));
}
}
public string PsotCommentOnLinkedinCompanyPageUpdate(string UserId, string PageId, string Updatekey, string Comment)
{
try
{
Domain.Myfashion.Domain.LinkedinCompanyPage objlicompanypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
objlicompanypage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(PageId);
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = objlicompanypage.OAuthVerifier;
Linkedin_oauth.TokenSecret = objlicompanypage.OAuthSecret;
Linkedin_oauth.Token = objlicompanypage.OAuthToken;
Linkedin_oauth.Id = objlicompanypage.LinkedinPageId;
Linkedin_oauth.FirstName = objlicompanypage.LinkedinPageName;
Company company = new Company();
string res = company.SetCommentOnPagePost(Linkedin_oauth, PageId, Updatekey, Comment);
return(new JavaScriptSerializer().Serialize(res));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string GetLinkedinCompanyPageDetailsByUserIdAndPageId(string UserId, string LinkedinPageId)
{
Domain.Myfashion.Domain.LinkedinCompanyPage LinkedinCompanyPage=new Domain.Myfashion.Domain.LinkedinCompanyPage ();
try
{
Guid Userid = Guid.Parse(UserId);
if (objLinkedCmpnyPgeRepo.checkLinkedinPageExists(LinkedinPageId, Userid))
{
LinkedinCompanyPage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(Userid, LinkedinPageId);
}
else
{
LinkedinCompanyPage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(LinkedinPageId);
}
return new JavaScriptSerializer().Serialize(LinkedinCompanyPage);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return new JavaScriptSerializer().Serialize("Please Try Again");
}
}
public string PutLikeOnLinkedinCompanyPageUpdate(string UserId, string PageId, string Updatekey, string IsLike)
{
try
{
string msg = string.Empty;
int isLike = Convert.ToInt16(IsLike);
if (isLike == 1)
{
msg = "false";
}
else
{ msg = "true"; }
Domain.Myfashion.Domain.LinkedinCompanyPage objlicompanypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
objlicompanypage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(PageId);
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = objlicompanypage.OAuthVerifier;
Linkedin_oauth.TokenSecret = objlicompanypage.OAuthSecret;
Linkedin_oauth.Token = objlicompanypage.OAuthToken;
Linkedin_oauth.Id = objlicompanypage.LinkedinPageId;
Linkedin_oauth.FirstName = objlicompanypage.LinkedinPageName;
Company company = new Company();
string res = company.SetLikeUpdateOnPagePost(Linkedin_oauth, Updatekey, msg);
return new JavaScriptSerializer().Serialize(res);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return "Something Went Wrong";
}
}
public string PsotCommentOnLinkedinCompanyPageUpdate(string UserId, string PageId, string Updatekey, string Comment)
{
try
{
Domain.Myfashion.Domain.LinkedinCompanyPage objlicompanypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
objlicompanypage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(PageId);
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = objlicompanypage.OAuthVerifier;
Linkedin_oauth.TokenSecret = objlicompanypage.OAuthSecret;
Linkedin_oauth.Token = objlicompanypage.OAuthToken;
Linkedin_oauth.Id = objlicompanypage.LinkedinPageId;
Linkedin_oauth.FirstName = objlicompanypage.LinkedinPageName;
Company company = new Company();
string res = company.SetCommentOnPagePost(Linkedin_oauth, PageId, Updatekey, Comment);
return new JavaScriptSerializer().Serialize(res);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return "Something Went Wrong";
}
}
public void GetPageProfile(dynamic data, oAuthLinkedIn _OAuth, string UserId, string CompanyPageId, string GroupId)
{
Domain.Myfashion.Domain.SocialProfile socioprofile = new Domain.Myfashion.Domain.SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
Domain.Myfashion.Domain.LinkedinCompanyPage objLinkedincmpnypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
LinkedinCompanyPageRepository objLinkedCmpnyPgeRepo = new LinkedinCompanyPageRepository();
try
{
objLinkedincmpnypage.UserId = Guid.Parse(UserId);
try
{
objLinkedincmpnypage.LinkedinPageId = data.Pageid.ToString();
}
catch
{
}
objLinkedincmpnypage.Id = Guid.NewGuid();
try
{
objLinkedincmpnypage.EmailDomains = data.EmailDomains.ToString();
}
catch { }
objLinkedincmpnypage.LinkedinPageName = data.name.ToString();
objLinkedincmpnypage.OAuthToken = _OAuth.Token;
objLinkedincmpnypage.OAuthSecret = _OAuth.TokenSecret;
objLinkedincmpnypage.OAuthVerifier = _OAuth.Verifier;
try
{
objLinkedincmpnypage.Description = data.description.ToString();
}
catch { }
try
{
objLinkedincmpnypage.FoundedYear = data.founded_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EndYear = data.end_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Locations = data.locations.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Specialties = data.Specialties.ToString();
}
catch { }
try
{
objLinkedincmpnypage.WebsiteUrl = data.website_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Status = data.status.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EmployeeCountRange = data.employee_count_range.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Industries = data.industries.ToString();
}
catch { }
try
{
string NuberOfFollower = data.num_followers.ToString();
objLinkedincmpnypage.NumFollowers = Convert.ToInt16(NuberOfFollower);
}
catch { }
try
{
objLinkedincmpnypage.CompanyType = data.company_type.ToString();
}
catch { }
try
{
objLinkedincmpnypage.LogoUrl = data.logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.SquareLogoUrl = data.square_logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.BlogRssUrl = data.blog_rss_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.UniversalName = data.universal_name.ToString();
}
catch { }
#region SocialProfiles
socioprofile.UserId = Guid.Parse(UserId);
socioprofile.ProfileType = "linkedincompanypage";
socioprofile.ProfileId = data.Pageid.ToString(); ;
socioprofile.ProfileStatus = 1;
socioprofile.ProfileDate = DateTime.Now;
socioprofile.Id = Guid.NewGuid();
#endregion
#region TeamMemberProfile
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "linkedincompanypage";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = socioprofile.ProfileId;
#endregion
}
catch
{
}
try
{
if (!objSocialProfilesRepository.checkUserProfileExist(socioprofile))
{
objSocialProfilesRepository.addNewProfileForUser(socioprofile);
}
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeamMemberProfile.TeamId, objLinkedincmpnypage.LinkedinPageId))
{
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
}
if (!objLinkedCmpnyPgeRepo.checkLinkedinPageExists(CompanyPageId, Guid.Parse(UserId)))
{
objLinkedCmpnyPgeRepo.addLinkenCompanyPage(objLinkedincmpnypage);
}
else
{
objLinkedincmpnypage.LinkedinPageId = CompanyPageId;
objLinkedCmpnyPgeRepo.updateLinkedinPage(objLinkedincmpnypage);
}
}
catch
{
}
}
public void GetPageProfile(dynamic data, oAuthLinkedIn _OAuth, string UserId, string CompanyPageId, string GroupId)
{
Domain.Myfashion.Domain.SocialProfile socioprofile = new Domain.Myfashion.Domain.SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
Domain.Myfashion.Domain.LinkedinCompanyPage objLinkedincmpnypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
LinkedinCompanyPageRepository objLinkedCmpnyPgeRepo = new LinkedinCompanyPageRepository();
try
{
objLinkedincmpnypage.UserId = Guid.Parse(UserId);
try
{
objLinkedincmpnypage.LinkedinPageId = data.Pageid.ToString();
}
catch
{
}
objLinkedincmpnypage.Id = Guid.NewGuid();
try
{
objLinkedincmpnypage.EmailDomains = data.EmailDomains.ToString();
}
catch { }
objLinkedincmpnypage.LinkedinPageName = data.name.ToString();
objLinkedincmpnypage.OAuthToken = _OAuth.Token;
objLinkedincmpnypage.OAuthSecret = _OAuth.TokenSecret;
objLinkedincmpnypage.OAuthVerifier = _OAuth.Verifier;
try
{
objLinkedincmpnypage.Description = data.description.ToString();
}
catch { }
try
{
objLinkedincmpnypage.FoundedYear = data.founded_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EndYear = data.end_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Locations = data.locations.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Specialties = data.Specialties.ToString();
}
catch { }
try
{
objLinkedincmpnypage.WebsiteUrl = data.website_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Status = data.status.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EmployeeCountRange = data.employee_count_range.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Industries = data.industries.ToString();
}
catch { }
try
{
string NuberOfFollower = data.num_followers.ToString();
objLinkedincmpnypage.NumFollowers = Convert.ToInt16(NuberOfFollower);
}
catch { }
try
{
objLinkedincmpnypage.CompanyType = data.company_type.ToString();
}
catch { }
try
{
objLinkedincmpnypage.LogoUrl = data.logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.SquareLogoUrl = data.square_logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.BlogRssUrl = data.blog_rss_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.UniversalName = data.universal_name.ToString();
}
catch { }
#region SocialProfiles
socioprofile.UserId = Guid.Parse(UserId);
socioprofile.ProfileType = "linkedincompanypage";
socioprofile.ProfileId = data.Pageid.ToString();;
socioprofile.ProfileStatus = 1;
socioprofile.ProfileDate = DateTime.Now;
socioprofile.Id = Guid.NewGuid();
#endregion
#region TeamMemberProfile
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "linkedincompanypage";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = socioprofile.ProfileId;
#endregion
}
catch
{
}
try
{
if (!objSocialProfilesRepository.checkUserProfileExist(socioprofile))
{
objSocialProfilesRepository.addNewProfileForUser(socioprofile);
}
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeamMemberProfile.TeamId, objLinkedincmpnypage.LinkedinPageId))
{
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
}
if (!objLinkedCmpnyPgeRepo.checkLinkedinPageExists(CompanyPageId, Guid.Parse(UserId)))
{
objLinkedCmpnyPgeRepo.addLinkenCompanyPage(objLinkedincmpnypage);
}
else
{
objLinkedincmpnypage.LinkedinPageId = CompanyPageId;
objLinkedCmpnyPgeRepo.updateLinkedinPage(objLinkedincmpnypage);
}
}
catch
{
}
}
public Domain.Myfashion.Domain.LinkedinCompanyPage getCompanyPageInformation(string liPageid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of account.
List<Domain.Myfashion.Domain.LinkedinCompanyPage> objlst = session.CreateQuery("from LinkedinCompanyPage where LinkedinPageId = :linkedinpageid ")
.SetParameter("linkedinpageid", liPageid)
.List<Domain.Myfashion.Domain.LinkedinCompanyPage>().ToList<Domain.Myfashion.Domain.LinkedinCompanyPage>();
Domain.Myfashion.Domain.LinkedinCompanyPage result = new Domain.Myfashion.Domain.LinkedinCompanyPage();
if (objlst.Count > 0)
{
result = objlst[0];
}
return result;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return null;
}
}//End Transaction
}//End Session
}