public static FormUserInfo queryUserInfo(string channel, string id) { FormUserInfo result = null; try { using (var db = new UserKeywords()) { var query = db.UserInfo .Where(b => b.channel == channel && b.userID == id).FirstOrDefault(); if (query == null) { return(result); } result = new FormUserInfo(); result.Email = query.Email; result.GitHubUID = query.GitHubLogin; } } catch (Exception e) { System.Diagnostics.Trace.TraceError("Exception in queryUserInfo for {0}, Message:{1};{2}", channel + ":" + id, e.Message, e.InnerException.Message); //Console.WriteLine("e:{0}", e.Message); return(result); } return(result); }
//public static Dictionary<string, string> queryUser(string keyword) //{ // Console.WriteLine("enter query user,keyword:{0}...", keyword); // Dictionary<string, string> result = new Dictionary<string, string>(); // using (var connection = new SQLiteConnection(@"Data Source=\\\\msralpa\Users\v-rumeng\public\Github\Colla_Github.db;Version=3;")) // { // connection.Open(); // using (var transaction = connection.BeginTransaction()) // { // var selectCommand = connection.CreateCommand(); // selectCommand.Transaction = transaction; // //selectCommand.CommandText = String.Format("select * from User_Keywords where KeywordsList like '%{0}%'",keyword); // selectCommand.CommandText = string.Format(@"select * from User_Keywords where KeywordsList like '%{0}%' limit 50", keyword); // using (var reader = selectCommand.ExecuteReader()) // { // while (reader.Read()) // { // Console.WriteLine("read line here"); // string name = reader.GetString(0); // //double score = 1.0; // string klist = reader.GetString(1); // result.Add(name, klist); // //+": " + reader.GetString(1); // } // reader.Close(); // } // transaction.Commit(); // } // } // return result; //} //public static Dictionary<string, string> queryProject(string keyword) //{ // Console.WriteLine("enter query user..."); // Dictionary<string, string> result = new Dictionary<string, string>(); // using (var connection = new SQLiteConnection(@"Data Source=\\\\msralpa\Users\v-rumeng\public\Github\Colla_Github.db;Version=3;")) // { // connection.Open(); // using (var transaction = connection.BeginTransaction()) // { // var selectCommand = connection.CreateCommand(); // selectCommand.Transaction = transaction; // //selectCommand.CommandText = String.Format("select * from User_Keywords where KeywordsList like '%{0}%'",keyword); // selectCommand.CommandText = string.Format(@"select RepoName,Description from RepoText where Description like '%{0}%' limit 50", keyword); // using (var reader = selectCommand.ExecuteReader()) // { // while (reader.Read()) // { // string repoName = reader.GetString(0); // string descrip = reader.GetString(1); // //double score = 1.0; // //string klist = reader.GetString(1); // //HashSet<string> keywords = deDuplicateBy(descrip, ','); // //foreach(string s in keywords) // result.Add(repoName, descrip); // //+": " + reader.GetString(1); // } // } // transaction.Commit(); // } // } // return result; //} //public static string GetEmailByUserLogin(string u) //{ // string result = ""; // Console.WriteLine("enter get email by userlogin for :{0}...", u); // using (var connection = new SQLiteConnection(@"Data Source=\\\\msralpa\Users\v-rumeng\public\Github\Colla_Github.db;Version=3;")) // { // connection.Open(); // using (var transaction = connection.BeginTransaction()) // { // var selectCommand = connection.CreateCommand(); // selectCommand.Transaction = transaction; // //selectCommand.CommandText = String.Format("select * from User_Keywords where KeywordsList like '%{0}%'",keyword); // selectCommand.CommandText = string.Format(@"select * from UserEmail where Login = '******'", u); // using (var reader = selectCommand.ExecuteReader()) // { // if (reader.Read()) // { // Console.WriteLine("read line here"); // string email = reader.GetString(1); // //+": " + reader.GetString(1); // } // reader.Close(); // } // transaction.Commit(); // } // } // return result; //} public static Dictionary <string, string> queryProject(string keyword) { keyword = keyword.ToLower(); Dictionary <string, string> result = new Dictionary <string, string>(); using (var db = new UserKeywords()) { try { var query = (from p in db.RepoTexts where p.Description.ToLower().Contains(keyword) select p).Take(100); foreach (var p in query) { if (!result.ContainsKey(p.RepoName)) { result.Add(p.RepoName, p.Description); } } } catch (Exception e) { Console.WriteLine("Exception:{0}", e.Message); return(result); } //var query = (from u in db.User_Keywords where u.KeywordsList.Contains("java") select u).First(); } return(result); }
public static void InsertUserInfo(FormUserInfo userinfo, string channel, string id) { using (var db = new UserKeywords()) { var UserInfo = new UserInfo(); UserInfo.GitHubLogin = userinfo.GitHubUID; UserInfo.Email = userinfo.Email; UserInfo.channel = channel; UserInfo.userID = id; db.UserInfo.Add(UserInfo); db.SaveChanges(); } }
public static void UpdateUserInfo(FormUserInfo userinfo, string channel, string id) { using (var db = new UserKeywords()) { var UserInfo = new UserInfo(); UserInfo.GitHubLogin = userinfo.GitHubUID; UserInfo.Email = userinfo.Email; UserInfo.channel = channel; UserInfo.userID = id; db.UserInfo.Attach(UserInfo); db.Entry(UserInfo).State = EntityState.Modified; db.SaveChanges(); } }
public static Dictionary <string, string> queryUser(string keyword) { keyword = keyword.ToLower(); Dictionary <string, string> result = new Dictionary <string, string>(); if (keyword.Trim().Equals("")) { return(result); } try { using (var db = new UserKeywords()) { var query = (from u in db.User_Keyword_Score where u.Keyword.Equals(keyword, StringComparison.OrdinalIgnoreCase) orderby u.Score descending select u ).Take(10); if (query == null || !query.Any()) { return(result); } foreach (var u in query) { if (!result.ContainsKey(u.UserLogin)) { result.Add(u.UserLogin, u.Score.ToString()); } } } } catch (Exception e) { System.Diagnostics.Trace.TraceError("Exception in queryUser for {0}, Message:{1};{2}", keyword, e.Message, e.InnerException.Message); //Console.WriteLine("e:{0}", e.Message); return(result); } return(result); }