private void FillMemberFromDataReader(CodeProjectMember member, DbDataReader r) { object idAsObject = r["Key"]; member.Id = int.Parse(idAsObject.ToString()); member.Name = r["Name"].ToString(); member.ArticleCount = int.Parse(r["ArticleCnt"].ToString()); member.BlogCount = int.Parse(r["BlogCnt"].ToString()); member.Reputation = r["Reputation"].ToString(); }
public override bool OnContextItemSelected(IMenuItem item) { AdapterView.AdapterContextMenuInfo info = (AdapterView.AdapterContextMenuInfo)item.MenuInfo; CodeProjectMember memberToDelete = members [info.Position]; CodeProjectDatabase db = new CodeProjectDatabase(); db.DeleteMember(memberToDelete.Id); members = db.GetMembers(); ListAdapter = new CodeProjectMemberAdapter(this.Activity, members); return(true); }
public void LoadMember(TaskScheduler uiContext) { Dictionary<String, String> param = new Dictionary<string, string> (); param.Add ("Id", MemberId.ToString()); Member = new CodeProjectMember (); Member.Id = MemberId; ObjectBuilder objectBuilder = new ObjectBuilder (); Task<object> fillMemberTask = objectBuilder.FillAsync (Member, param, CancellationToken.None); fillMemberTask.Start (); fillMemberTask .ContinueWith (x => LoadGravatar ()) .ContinueWith (x => MemberLoaded (), uiContext); }
public static UITableViewCell FillCellWithMember(UITableViewCell cell, CodeProjectMember member) { (cell.ViewWithTag (100) as UILabel).Text = member.Name; (cell.ViewWithTag (101) as UILabel).Text = "Posts: " + (member.ArticleCount + member.BlogCount); (cell.ViewWithTag (102) as UILabel).Text = member.Reputation; CodeProjectDatabase database = new CodeProjectDatabase (); byte[] gravatar = database.GetGravatar (member.Id); if (gravatar != null) { UIImage image = UIImage.LoadFromData (NSData.FromArray (gravatar)); (cell.ViewWithTag (105) as UIImageView).Image = image; } return cell; }
public void LoadMember(TaskScheduler uiContext) { Dictionary <String, String> param = new Dictionary <string, string> (); param.Add("Id", MemberId.ToString()); Member = new CodeProjectMember(); Member.Id = MemberId; ObjectBuilder objectBuilder = new ObjectBuilder(); Task <object> fillMemberTask = objectBuilder.FillAsync(Member, param, CancellationToken.None); fillMemberTask.Start(); fillMemberTask .ContinueWith(x => LoadGravatar()) .ContinueWith(x => MemberLoaded(), uiContext); }
public bool AddMember(CodeProjectMember member) { var connection = new SqliteConnection("Data Source=" + dbPath); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "SELECT [Key] FROM [Member] WHERE [Key]=" + member.Id; var r = command.ExecuteReader(); if (r.HasRows) { using (var uc = connection.CreateCommand()) { uc.CommandText = "UPDATE [Member] SET " + " [Name] = '" + member.Name + "'," + " [ArticleCnt] = '" + member.ArticleCount + "'," + " [BlogCnt] = '" + member.BlogCount + "'," + " [Reputation] = '" + member.Reputation + "'," + " WHERE [Key]=" + member.Id; uc.ExecuteNonQuery(); } } else { using (var ic = connection.CreateCommand()) { ic.CommandText = "INSERT INTO [Member] ([Key], [Name], [ArticleCnt], [BlogCnt], [Reputation])" + " VALUES(" + member.Id + ", '" + member.Name + "', '" + member.ArticleCount + "', '" + member.BlogCount + "', '" + member.Reputation + "')"; ic.ExecuteNonQuery(); } } } connection.Close(); FileStorageService storage = new FileStorageService(); if (member.Avatar != null) { storage.WriteBytes(member.Avatar, member.Id.ToString()); } return(true); }
public CodeprojectMemberViewModel(CodeProjectMember member, Action<string> gotoPageAction, Action<string> deleteMember) { this.GotoPageCommand = new ButtonCommandBinding<string>(gotoPageAction); this.DeleteMemberCommand = new ButtonCommandBinding<string>(deleteMember); this.member = member; var db = new CodeProjectDatabase(); byte[] avatar = db.GetGravatar(this.member.Id); if (avatar != null) { BitmapImage bitmapImage = new BitmapImage(); MemoryStream ms = new MemoryStream(avatar); bitmapImage.SetSource(ms); AvatarImage = bitmapImage; } }
public CodeprojectMemberViewModel(CodeProjectMember member, Action <string> gotoPageAction, Action <string> deleteMember) { this.GotoPageCommand = new ButtonCommandBinding <string>(gotoPageAction); this.DeleteMemberCommand = new ButtonCommandBinding <string>(deleteMember); this.member = member; var db = new CodeProjectDatabase(); byte[] avatar = db.GetGravatar(this.member.Id); if (avatar != null) { BitmapImage bitmapImage = new BitmapImage(); MemoryStream ms = new MemoryStream(avatar); bitmapImage.SetSource(ms); AvatarImage = bitmapImage; } }
public List <CodeProjectMember> GetMembers() { List <CodeProjectMember> memberList = new List <CodeProjectMember> (); var connection = new SqliteConnection("Data Source=" + dbPath); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "SELECT [Key], [Name], [ArticleCnt], [BlogCnt], [Reputation], [IsMe] FROM [Member]"; var r = command.ExecuteReader(); while (r.Read()) { CodeProjectMember member = new CodeProjectMember(); FillMemberFromDataReader(member, r); memberList.Add(member); } } connection.Close(); return(memberList); }
public CodeProjectMember GetMember(int memberId) { var connection = new SqliteConnection("Data Source=" + dbPath); connection.Open(); CodeProjectMember member = new CodeProjectMember(); member.Id = memberId; using (var command = connection.CreateCommand()) { command.CommandText = "SELECT [Key], [Name], [ArticleCnt], [BlogCnt], [Reputation], [IsMe] FROM [Member] WHERE [Key]=" + memberId; var r = command.ExecuteReader(); while (r.Read()) { FillMemberFromDataReader(member, r); } } connection.Close(); return(member); }
public void SaveMember(CodeProjectMember member) { SaveMember(); }
public void SaveMember(CodeProjectMember member) { SaveMember(); }
public void SetMember(CodeProjectMember member) { viewModel.MemberId = member.Id; viewModel.MemberReputationGraphUrl = member.ReputationGraph; }