private void button1_Click(object sender, EventArgs e) { if (Helper.Exists("users", "name", nameTxtBx.Text)) { MessageBox.Show("User name exists"); return; } if (Helper.Exists("users", "contact", contactTxtBx.Text)) { MessageBox.Show("User contact exists"); return; } string userID = Guid.NewGuid().ToString(); string paths = @"c:\Case\images"; if (!Directory.Exists(paths)) { DirectoryInfo dim = Directory.CreateDirectory(paths); Console.WriteLine("The directory was created successfully at {0}.", Directory.GetCreationTime(paths)); } string filename = @"c:\Case\\images\" + userID.Trim() + ".jpg"; FileStream fstream = new FileStream(filename, FileMode.Create); imgCapture.Image.Save(fstream, System.Drawing.Imaging.ImageFormat.Jpeg); fstream.Close(); string image = @"c:\Case\\images\" + userID.Trim() + ".jpg"; if (System.IO.File.Exists(image)) { try { string filepath = image; string localPath = new Uri(filepath).LocalPath; string remotePath = Helper.uploadUrl; WebClient theClient = new WebClient(); byte[] responseArray = theClient.UploadFile(remotePath, filepath); Console.WriteLine("\nResponse Received.The contents of the file uploaded are:\n{0}", System.Text.Encoding.ASCII.GetString(responseArray)); theClient.Dispose(); } catch (Exception c) { } } try { string Query = "INSERT INTO users(userID, orgID, name, email, password, designation, status, contact, image, address, category, created, sync, charge, supervisor) VALUES ('" + userID + "','" + Helper.orgID + "','" + this.nameTxtBx.Text + "','" + this.emailTxtBx.Text + "','" + Helper.MD5Hash(this.passwordTxtBx.Text) + "','" + this.designationCbx.Text + "','" + this.statusCbx.Text + "','" + this.contactTxtBx.Text + "','" + userID.Trim() + ".jpg" + "','" + this.addressTxtBx.Text + "','staff','" + DateTime.Now.Date.ToString("yyyy-MM-dd") + "','f','" + this.chargeTxtBx.Text + "','" + supervisorCbx.Text + "');"; Helper.Execute(Query, DBConnect.conn); MessageBox.Show("Information saved"); UserForm frm = new UserForm(); frm.MdiParent = MainForm.ActiveForm; frm.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }