//Add button action
private void AddButton_Click(object sender, EventArgs e)
{
string firstName = NameText.Text;
string lastName = SurnameText.Text;
string information = InformationText.Text;
string text = "photo_url";
using (var w = new WebClient())
{
string clientID = "d4a165a802843b0";
w.Headers.Add("Authorization", "Client-ID " + clientID);
var values = new NameValueCollection
{
{ "image", Convert.ToBase64String(File.ReadAllBytes(@"Image1.jpg")) }
};
byte[] response = w.UploadValues("https://api.imgur.com/3/upload.xml", values);
var xx = XDocument.Load(new MemoryStream(response)).ToString();
// MessageBox.Show(xx);
}
if (errorcode1 == 0 || errorcode2 == 0 || string.IsNullOrWhiteSpace(firstName) || string.IsNullOrWhiteSpace(lastName) || string.IsNullOrWhiteSpace(information))
{
ErrorHandling.Show_Inserting_Error();
}
else
{
DatabaseInfo data = LazyData.Value;
//data.Myevent += delegate (object ) { }
var connection = data.GetConfigInfo();
User user = new User(firstName, lastName, information);
WebService.WebService service = new WebService.WebService();
//service.InsertRow(user, connection);
data.InsertRow(user, connection);// Inesrt row to table
var Users = new List <User> {
};
//service.GetDataFromDatabase(Users, connection);
data.GetDataFromDatabase(Users, connection);// Read information to Collectionion
UsersInfo userPhoto = new UsersInfo(firstName, lastName, text);
var UsersPhotos = new List <UsersInfo> {
};
data.GetDataFromDatabase(Users, connection); // Read photo information to Collection
var OrderedUsers = Users.OrderBy(p => p.FirstName); // Linq ordering by name ascending
//var JoinedUsers = data.GroupJoinCollections(Users, UsersPhotos);
var JoinedUsers = from p in OrderedUsers
join c in UsersPhotos
on p.FirstName equals c.FirstName
select new
{
PersonName = p.FirstName,
PersonSurname = c.LastName,
PersonInfo = p.Information,
PersonPhoto = c.Text
};
NameText.Text = String.Empty;
SurnameText.Text = String.Empty;
InformationText.Text = String.Empty;
ImageView.Image = null;
icon1.Image = null;
icon2.Image = null;
}
}