public void UpdateCard(string path, BEBusinessCard card) { using (var client = GetClient()) { var response = client.PutAsJsonAsync(path, card).Result; } }
public int CreateCard(string path, BEBusinessCard card) { using (var client = GetClient()) { var response = client.PostAsJsonAsync(path, card).Result; return Convert.ToInt32(response.Content.ReadAsStringAsync().Result); } return 0; }
public void DeleteCard(BEBusinessCard card) { using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;")) { using (var com = new SQLiteCommand(con)) { string stm = "UPDATE Cards SET IsDeleted = 1 WHERE Id=@Id"; com.CommandText = stm; com.Parameters.AddWithValue("@Id", card.Id); con.Open(); com.ExecuteNonQuery(); } } }
public List<BEBusinessCard> GetAllBusinessCards() { List<BEBusinessCard> cards = new List<BEBusinessCard>(); using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;")) { using (var com = new SQLiteCommand(con)) { con.Open(); string stm = "SELECT * FROM Cards WHERE IsDeleted = 0"; com.CommandText = stm; using (SQLiteDataReader reader = com.ExecuteReader()) { while (reader.Read()) { BEBusinessCard card = new BEBusinessCard() { Id = reader.GetInt32(0), Firstname = reader.GetString(1), Lastname = reader.GetString(2), Address = reader.GetString(3), PhoneNumber = reader.GetString(4), Country = reader.GetString(5), City = reader.GetString(6), Company = reader.GetString(7), Title = reader.GetString(8), Homepage = reader.GetString(9), Fax = reader.GetString(10), Postal = reader.GetString(11), Email = reader.GetString(12), Other = reader.GetString(13), EncodedImage = reader.GetString(14), CreatedDate = reader.GetString(15), CreatedUserId = reader.GetInt32(16), IsDeleted = false }; cards.Add(card); // Console.WriteLine(reader["Key"] + " : " + reader["Value"]); // Display the value of the key and value column for every row } } } } return cards; }
public void UpdateCard(BEBusinessCard card) { using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;")) { using (var com = new SQLiteCommand(con)) { string stm = "UPDATE Cards SET Firstname = @Firstname, Lastname = @Lastname, Address = @Address, PhoneNumber = @PhoneNumber, Country = @Country, City = @City, Company = @Company, Title = @Title, Homepage = @Homepage, Fax = @Fax, Postal = @Postal, Email = @Email, Other = @Other WHERE Id=@Id"; com.CommandText = stm; com.Parameters.AddWithValue("@Firstname", card.Firstname); com.Parameters.AddWithValue("@Lastname", card.Lastname); com.Parameters.AddWithValue("@Address", card.Address); com.Parameters.AddWithValue("@PhoneNumber", card.PhoneNumber); com.Parameters.AddWithValue("@Country", card.Country); com.Parameters.AddWithValue("@City", card.City); com.Parameters.AddWithValue("@Company", card.Company); com.Parameters.AddWithValue("@Title", card.Title); com.Parameters.AddWithValue("@Homepage", card.Homepage); com.Parameters.AddWithValue("@Fax", card.Fax); com.Parameters.AddWithValue("@Postal", card.Postal); com.Parameters.AddWithValue("@Email", card.Email); com.Parameters.AddWithValue("@Other", card.Other); com.Parameters.AddWithValue("@Id", card.Id); con.Open(); com.ExecuteNonQuery(); } } }
public void InsertCard(BEBusinessCard card) { using (var con = new SQLiteConnection("Data Source=" + DB_NAME + ";Version=3;")) { using (var com = new SQLiteCommand(con)) { con.Open(); string insert = "INSERT INTO Cards (Firstname, Lastname, Address," + " PhoneNumber, Country, City, Company, Title, Homepage, " + "Fax, Postal, Email, Other, EncodedImage, CreatedDate, CreatedUserId, IsDeleted) " + "Values ('" + card.Firstname + "', '" + card.Lastname + "', '" + card.Address + "', '" + card.PhoneNumber + "', '" + card.Country + "', '" + card.City + "', '" + card.Company + "', '" + card.Title + "', '" + card.Homepage + "', '" + card.Fax + "', '" + card.Postal + "', '" + card.Email + "', '" + card.Other + "', '" + card.EncodedImage + "', '" + String.Format("{0:dd-MM-yyyy}", DateTime.Now) + "', '" + card.CreatedUserId + "', 0)"; com.CommandText = insert; com.ExecuteNonQuery(); } } }
private void btnSave_Click(object sender, EventArgs e) { if (pbScannedCard.Image == null) { MessageBox.Show("Please scan or select a card first"); } else { var scannedImage = new Bitmap(pbScannedCard.Image); Gateway gateway = new Gateway(); if (!_updating) { var card = new BEBusinessCard { Address = txtAddress.Text, City = txtCity.Text, Email = txtEmail.Text, Homepage = txtHomepage.Text, Company = txtCompany.Text, Country = txtCountry.Text, Fax = txtFax.Text, Firstname = txtFirstname.Text, Lastname = txtLastname.Text, PhoneNumber = txtPhone.Text, Postal = txtPostal.Text, Title = txtTitle.Text, Other = txtOther.Text, EncodedImage = _bllScanner.ToBase64String(scannedImage, ImageFormat.Bmp), CreatedDate = String.Format("{0:dd-MM-yyyy}", DateTime.Now), CreatedUserId = _loggedUser.Id }; string date = card.CreatedDate; foreach (var node in Collect(tViewClients.Nodes)) { if (node != null && node.Tag is BEUser) { BEUser currentUser = (BEUser)node.Tag; if (currentUser.Id == _loggedUser.Id) { CreateNodeForToday(node.Nodes); if (node.FirstNode.Tag.Equals(date)) { int cardId = gateway.CreateCard("Card/PostAndGetCardId", card); card.Id = cardId; CreateCardNode(date, card, node.FirstNode); //_bllScanner.InsertCard(card); _updating = true; MessageBox.Show("Contact added"); } } } } } else { var card = new BEBusinessCard { Address = txtAddress.Text, City = txtCity.Text, Email = txtEmail.Text, Homepage = txtHomepage.Text, Company = txtCompany.Text, Country = txtCountry.Text, Fax = txtFax.Text, Firstname = txtFirstname.Text, Lastname = txtLastname.Text, PhoneNumber = txtPhone.Text, Postal = txtPostal.Text, Title = txtTitle.Text, Other = txtOther.Text, CreatedDate = String.Format("{0:dd-MM-yyyy}", DateTime.Now), CreatedUserId = _loggedUser.Id }; var selectedCard = (BEBusinessCard)tViewClients.SelectedNode.Tag; var cardId = selectedCard.Id; tViewClients.SelectedNode.Text = txtFirstname.Text + " " + txtLastname.Text; card.Id = cardId; card.EncodedImage = selectedCard.EncodedImage; gateway.UpdateCard("Card",card); //_bllScanner.UpdateCard(card); tViewClients.SelectedNode.Tag = card; MessageBox.Show("Contact updated"); } } }
private void ShowResults(BEBusinessCard card) { txtFirstname.Text = card.Firstname; txtLastname.Text = card.Lastname; txtAddress.Text = card.Address; txtCity.Text = card.City; txtPostal.Text = card.Postal; txtCountry.Text = card.Country; txtTitle.Text = card.Title; txtCompany.Text = card.Company; txtPhone.Text = card.PhoneNumber; txtFax.Text = card.Fax; txtEmail.Text = card.Email; txtHomepage.Text = card.Homepage; txtOther.Text = card.Other; _updating = false; btnSave.Enabled = true; btnSave.Text = "Save contact"; }
private void CreateCardNode(string date, BEBusinessCard card, TreeNode localDateNode) { if (localDateNode == null) { var userNode = new TreeNode { Text = _loggedUser.Username, Tag = _loggedUser }; var dateNode = new TreeNode { Text = date, Tag = new object[] { date } }; var clientNode = new TreeNode { Text = card.Firstname + " " + card.Lastname, Tag = card }; dateNode.Nodes.Add(clientNode); userNode.Nodes.Add(dateNode); tViewClients.Nodes.Add(userNode); tViewClients.SelectedNode = clientNode; } else { var clientNode = new TreeNode { Text = card.Firstname + " " + card.Lastname, Tag = card }; localDateNode.Nodes.Add(clientNode); tViewClients.SelectedNode = clientNode; } }
public void DeleteCard(BEBusinessCard contact) { _sql.DeleteCard(contact); }
public void UpdateCard(BEBusinessCard card) { _sql.UpdateCard(card); }
public void SetupVcfContact(StringBuilder vcf, BEBusinessCard card) { vcf.Append("BEGIN:VCARD" + Environment.NewLine); vcf.Append("FN:" + card.Firstname + " " + card.Lastname + Environment.NewLine); vcf.Append("N:" + card.Lastname + ";" + card.Firstname + Environment.NewLine); vcf.Append("TITLE:" + card.Title + Environment.NewLine); vcf.Append("ORG:" + card.Company + Environment.NewLine); vcf.Append("EMAIL:" + card.Email + Environment.NewLine); vcf.Append("TEL;fax:" + card.Fax + Environment.NewLine); vcf.Append("ADR;TYPE=intl,work,postal,parcel:;;" + card.Address + ";" + card.City + ";;" + card.Postal + ";" + card.Country + Environment.NewLine); vcf.Append("TEL;WORK;VOICE:" + card.PhoneNumber + Environment.NewLine); if (!String.IsNullOrEmpty(card.Homepage)) vcf.Append(@"URL;type=pref:http\://" + card.Homepage + Environment.NewLine); vcf.Append("VERSION:2.1" + Environment.NewLine); vcf.Append("END:VCARD" + Environment.NewLine); }
public void InsertCard(BEBusinessCard card) { _sql.InsertCard(card); }
public BEBusinessCard GetScannedCard(BEUser loggedUser) { var card = new BEBusinessCard { Firstname = Sdk.GetText(SDKWrapper.Fields.FirstName) + " " + Sdk.GetText(SDKWrapper.Fields.MiddleName), Lastname = Sdk.GetText(SDKWrapper.Fields.LastName), Address = Sdk.GetText(SDKWrapper.Fields.Address1_Line1), City = Sdk.GetText(SDKWrapper.Fields.Address1_City), Postal = Sdk.GetText(SDKWrapper.Fields.Address1_PostalCode), Country = Sdk.GetText(SDKWrapper.Fields.Address1_Country), Title = Sdk.GetText(SDKWrapper.Fields.Title), Company = Sdk.GetText(SDKWrapper.Fields.Company), PhoneNumber = Sdk.GetText(SDKWrapper.Fields.Phone), Fax = Sdk.GetText(SDKWrapper.Fields.Fax), Email = Sdk.GetText(SDKWrapper.Fields.Email), Homepage = Sdk.GetText(SDKWrapper.Fields.WebSite), Other = Sdk.GetText(SDKWrapper.Fields.Other), EncodedImage = "d", CreatedDate = DateTime.Now.ToString(), CreatedUserId = loggedUser.Id }; return card; }