public ScholarUser GetUserByName(string name)
{
try
{
cmdStr = "select * from scholarUsers where [name] = '" + name + "'";
cmd = new SqlCommand(cmdStr, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
//int id = Convert.ToInt32(reader["suId"]);
string affiliation = reader["affiliation"].ToString();
int id = Convert.ToInt32(reader["suId"]);
string email = reader["email"].ToString();
string image = reader["image"].ToString();
ScholarUser user = new ScholarUser(id, name, affiliation, email, image);
return(user);
}
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
return(null);
}
private ScholarUser GetUserLine(SqlDataReader reader)
{
int id = Convert.ToInt32(reader["suId"]);
string affiliation = reader["affiliation"].ToString();
string name = reader["name"].ToString();
string email = reader["email"].ToString();
string image = reader["image"].ToString();
ScholarUser user = new ScholarUser(id, name, affiliation, email, image);
return(user);
}
public void DeleteAmit()
{
User user = new User().GetUserByEmail("*****@*****.**");
ScholarUser scholarUser = sdbs.GetUserByName("amit rechavi");
if (scholarUser != null)
{
sdbs.RemoveScholarUser(scholarUser.Id);
}
db.RemoveEntity(user);
//Remove from Scholar
}
//--------------------------------------------------------------------------
//--------------------------------------------------------------------------
public string FindUserAutomatically(string name, string email)
{
try
{
//User user = js.Deserialize<User>(userString);
User user = new global::User().GetUserByEmail(email);
//user.FixNulls();
//user.InsertUserToDatabase();
//user = user.GetUserByEmail(user.Email);
// user.GetFullInfo();
//div_res.InnerText = py.GetPath();
//div_res.InnerHtml = py.Run_cmd("InsertUser.py", "Noga alon");
ScholarDBServices sdbs = new ScholarDBServices();
ScholarUser sUser = sdbs.GetUserByName(user.Name);
if (sUser == null)
{
PythonServices py = new PythonServices();
py.Run_cmd("InsertUser.py", user.Name);
sUser = sdbs.GetUserByName(user.Name);
}
sdbs.IntegrateIntoUser(sUser.Id, user.Id);
user = user.GetUserById(user.Id);
//string res = user.InsertUserToDatabase().ToString();
user = user.Relog();
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(user));
// PythonServices py = new PythonServices();
// User user = new global::User("amit", " ", "rechavi", null);
}
catch (Exception ex)
{
LogManager.Report(ex);
return(ex.ToString());
}
}
public void IntegrateIntoUser(int suId, int uId)
{
//get ScholarUser object
ScholarUser scholarUser = GetUserById(suId);
User user = new User().GetUserById(uId);
user.ImagePath = scholarUser.Image;
user.FixNulls();
//user.Id = uId;
db.UpdateUser(user);
//db.InsertUser(user);
//get User uId from db
user = db.GetUserByName(user.FirstName, user.MiddleName, user.LastName);
//get user publications
List <ScholarPublication> publications = GetUserPublications(scholarUser.Id);
List <Article> articles = new List <Article>();
//insert user articles
foreach (ScholarPublication pub in publications)
{
Article a = (new Article(0, pub.Title, pub.EPrint));
a.UpdateUsers(new List <User>()
{
user
});
if (pub.Publisher.Contains("IEEE"))
{
try
{
List <string> terms = new IEEE().GetArticleTerms(pub.Title);
List <Keyword> articleKeywords = new List <Keyword>();
foreach (var item in terms)
{
articleKeywords.Add(new Keyword(0, item));
}
a.UpdateKeywords(articleKeywords);
}
catch (Exception ex)
{
continue;
}
}
db.FullArticleInsert(a);
}
//add interests
scholarUser.Interests = GetUserInterests(scholarUser.Id);
foreach (var item in scholarUser.Interests)
{
db.InsertInterest(user.Id, item);
}
Institute scholarInstitute = GetEmailAffiliation(scholarUser.Email);
Institute emailInstitute = GetEmailAffiliation(user.Email);
List <Institute> institutes = new List <Institute>()
{
scholarInstitute
};
if (emailInstitute != scholarInstitute)
{
institutes.Add(emailInstitute);
}
user.UpdateAffiliations(institutes);
//return;
}
public void IntegrateNewUser(int suId)
{
//get ScholarUser object
ScholarUser scholarUser = GetUserById(suId);
//Make User object
string[] names = scholarUser.Name.Split(' ');
User user = new User();
if (names.Length == 2)
{
user.FirstName = names[0];
user.MiddleName = "";
user.LastName = names[1];
}
else if (names.Length == 3)
{
user.FirstName = names[0];
user.MiddleName = names[1];
user.LastName = names[2];
}
else
{
LogManager.Report("trying to add scholar user with 1 name", scholarUser);
return;
}
//Insert User Object to db
user.ImagePath = scholarUser.Image;
user.FixNulls();
db.InsertUser(user);
//get User uId from db
user = db.GetUserByName(user.FirstName, user.MiddleName, user.LastName);
//get user publications
List <ScholarPublication> publications = GetUserPublications(scholarUser.Id);
List <Article> articles = new List <Article>();
//insert user articles
foreach (ScholarPublication pub in publications)
{
Article a = (new Article(0, pub.Title, pub.EPrint));
a.UpdateUsers(new List <User>()
{
user
});
if (pub.Publisher.Contains("IEEE"))
{
List <string> terms = new IEEE().GetArticleTerms(pub.Title);
List <Keyword> articleKeywords = new List <Keyword>();
foreach (var item in terms)
{
articleKeywords.Add(new Keyword(0, item));
}
a.UpdateKeywords(articleKeywords);
}
db.FullArticleInsert(a);
}
//add interests
scholarUser.Interests = GetUserInterests(scholarUser.Id);
foreach (var item in scholarUser.Interests)
{
db.InsertInterest(user.Id, item);
}
//return;
}
