async Task<bool> UploadDB()
        {
            try
            {
            ServiceReference1.IService1 s = new ServiceReference1.Service1Client();
            Windows.Storage.StorageFolder storageFolder = Windows.Storage.ApplicationData.Current.LocalFolder;
            Windows.Storage.StorageFile sampleFile = await storageFolder.GetFileAsync("SQLITEV2.sqlite");

            byte[] result;
            using (Stream stream = await sampleFile.OpenStreamForReadAsync())
            {
                using (var memoryStream = new MemoryStream())
                {
                    stream.CopyTo(memoryStream);
                    result = memoryStream.ToArray();
                }
            }

            await s.UploadFileAsync(result);

                return true;
            }
            catch (Exception)
            {
                return false;
                throw;
            }


        }

 protected void Button2_Click(object sender, EventArgs e)
 {
     ServiceReference1.Service1Client crime = new ServiceReference1.Service1Client();
     string a = TextBox9.Text;
     int x= crime.CrimeData(a);
     TextBox10.Text = Convert.ToString(x);
 }

 protected void Search_User(string user_name)
 {
     ServiceReference1.Get_User_By_UserName_v2_Result user = new ServiceReference1.Service1Client().Get_User_By_UserName_v2(user_name);
     username = user.Username;
     pass = user.Password;
     security_code = user.Security_Code;
     txtUsername.Text = user.Username;
     txtEmail.Text = user.Email;
     txtPhone.Text = user.Phone_Number;
     switch (user.Gender)
     {
         case "Male": rdMale.Checked = true;
             break;
         case "Female": rdFemale.Checked = true;
             break;
         case "Other": rdOther.Checked = true;
             break;
     }
     ddlUserType.SelectedValue = user.Role_ID.ToString();
     if (user.Role_Name == "Admin")
     {
         ddlUserType.Enabled = false;
         btnDelete.Visible = false;
     }
     else
     {
         ddlUserType.Enabled = true;
         btnDelete.Visible = true;
     }
     txtUsername.Enabled = false;
     btnAdd.Visible = false;
     btnUpdate.Visible = true;
     btnCancel.Visible = true;
 }

        static void Main(string[] args)
        {
            ServiceReference1.Service1Client SvcProxy = new ServiceReference1.Service1Client("tcpWcfSvcLib1EP");
            SvcProxy.Open();

            //2,147,483,647
            byte[] valuesBytes;
            valToTransfer[] mivs = null;

            for (int x = 0; x < TEST_COUNT; x++)
            {
                DateTime startTime = DateTime.Now;
                valuesBytes = SvcProxy.GetData();
                mivs = HandDeserialize(valuesBytes);
                DateTime endTime = DateTime.Now;
                TimeSpan ts = new TimeSpan(endTime.Ticks - startTime.Ticks);
                aggregateMilliseconds += ts.Milliseconds;

                Console.WriteLine("time for call:[" + ts.Milliseconds + "]");
                Console.WriteLine("size of data passed [" + valuesBytes.Length + "]");
                Console.WriteLine("packet number[" + mivs[0].struct2_data_len + "]"); // hijacked for testing purposes..
                Console.WriteLine("500th item audit[" + mivs[499].struct1_ulong1 + "]");
                Console.WriteLine("9000th item audit[" + mivs[8999].struct1_ulong1 + "]");
            }
            Console.WriteLine("avg time per call [" + aggregateMilliseconds/TEST_COUNT + "]");

            SvcProxy.Close();
        }

        static void Main(string[] args)
        {
            ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();

            try
            {
                string retorno = client.GetData(1232);

                Console.WriteLine(retorno);
            }
            catch (EndpointNotFoundException e)
            {
                Console.WriteLine("Servidor desligado");
            }
            catch (Exception e)
            {
                Console.WriteLine("Deu algo errado");
            }
            finally
            {
                Console.WriteLine("Finalizou");
            }

            Console.Read();
        }

 public ActionResult TestConnection()
 {
     ServiceReference1.Service1Client proxy = new ServiceReference1.Service1Client();
     ViewBag.Message = proxy.getResponse();
     proxy.Close();
     return View();
 }

 protected void Button1_Click(object sender, EventArgs e)
 {
     string r = TextBox1.Text;
     ServiceReference1.Service1Client ob = new ServiceReference1.Service1Client();
     Label2.Text = ob.nearbyhotels(r);
     Label2.Visible = true;
 }

        protected void btnAddMission2_Click(object sender, EventArgs e)
        {
            ServiceReference1.Service1Client x = new ServiceReference1.Service1Client();
            setFields();
            ServiceReference1.CompositeMission mission = new ServiceReference1.CompositeMission();
            mission.Description = Description;

            int oid = Convert.ToInt32(ddOffice.SelectedValue);
            ServiceReference1.CompositeOffice office = new ServiceReference1.CompositeOffice();
            office = x.GetOffice(oid);
            mission.OID = office.OID;

            int eid = Convert.ToInt32(ddEmployee.SelectedValue);
            ServiceReference1.CompositeEmployee employee = new ServiceReference1.CompositeEmployee();
            employee = x.GetEmployee(eid);
            mission.EID = employee.EID;

            mission.StartDate = Date;

            int manager = Convert.ToInt32(ddManager.SelectedValue);
            ServiceReference1.CompositeEmployee mana = new ServiceReference1.CompositeEmployee();
            mana = x.GetEmployee(manager);
            mission.Manager = mana.EID;

            x.SaveMission(mission);

            buttonsAddMission2();
            setFieldsEnabled(false);
            updateGW();
        }

 protected void btnlogin_Click(object sender, EventArgs e)
 {
     var user = new ServiceReference1.Service1Client().Get_User_By_UserName_v2(txtusername.Text);
     if (user != null && txtmail.Text == user.Email)
     {
         try
         {
             new CheckValidate.CheckDataValidate().send_Mail(user.Username, user.Email, "Message from ONLINE RAILWAY RESERVATION SYSTEM", "<h2 style='color:#0091d4; text-align:center'>ONLINE RAILWAY RESERVATION SYSTEM</h2><br/> " + "<h3 style='text-align:center; font-weight:bold'>YOUR NEW PASSWORD</h3><br/><br/>" + "Username: " + user.Username + "<br/>" + "Password: " + user.Security_Code);
             string pass = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(user.Security_Code, "SHA1"); // encrypt password
             ServiceReference1.User u = new ServiceReference1.User();
             u.Username = user.Username;
             u.Password = pass;
             if(new ServiceReference1.Service1Client().Update_Password(u) == 1){
                 lblkq.Text = "Check mail to receive new password";
             }
         }
         catch (Exception)
         {
             ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Can not send mail !!!');", true);
         }
     }
     else
     {
         lblkq.Text = "Username or email are incorrect";
     }
 }

    protected void dgCoaches_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        Label lbl = (Label)e.Item.FindControl("lblid");
        id = int.Parse(lbl.Text);
        ServiceReference1.Service1Client sv = new ServiceReference1.Service1Client();
        ServiceReference1.get_Coach_By_ID_Result coaches = sv.Get_Coach_By_ID(id);
        // get train name
        string trainname = sv.get_Train_By_ID(int.Parse(coaches.Train_ID.ToString())).Train_Name;
        // show data
        ddlTrainName.SelectedValue = coaches.Train_ID.ToString();
        ddlCoachesType.SelectedItem.Text = coaches.Coach_Type;
        txtSeats.Text = coaches.Number_Of_Seats.ToString();
        _train_id = int.Parse(coaches.Train_ID.ToString());
        txtPrices.Text = coaches.Price.ToString();
        if (coaches.Status.ToString() == "Active")
        {
            RadioButton1.Checked = true;
            RadioButton2.Checked = false;
        }
        else
        {
            RadioButton2.Checked = true;
            RadioButton1.Checked = false;
        }

        ddlTrainName.Enabled = false;
        ddlCoachesType.Enabled = false;
        btnUpdate.Visible = true;
        btnDelete.Visible = true;
        btnCancel.Visible = true;
        btnAdd.Visible = false;
    }

 protected void Button1_Click(object sender, EventArgs e)
 {
     ServiceReference1.Service1Client ob = new ServiceReference1.Service1Client();
     Label1.Text = searchkey;
     Label1.Text = ob.NewsFocusService(searchkey);
     Label1.Visible = true;
 }

 static void Main(string[] args)
 {
     var client = new ServiceReference1.Service1Client();
     var result = client.GetData(5);
     Console.WriteLine(result);
     Console.ReadLine();
 }

 protected void Page_Load(object sender, EventArgs e)
 {
     var client = new ServiceReference1.Service1Client();
     var list = client.getPreviews();
     gdPreview.DataSource = list;
     gdPreview.DataBind();
 }

 private void AllContacts_Button_Click(object sender, RoutedEventArgs e)
 {
     using (var db = new ServiceReference1.Service1Client())
     {
         ContactsGrid.ItemsSource = db.GetFullAddrs();
     }
 }

 private void Add_Button_Click(object sender, RoutedEventArgs e)
 {
     using (var db = new ServiceReference1.Service1Client())
     {
         LogBlock.Text+="Add new row: " + db.AddNewName(fio.Text, tel.Text) + ("\n");
     }
 }

 private void bt_dangbai_Click(object sender, EventArgs e)
 {
     if (tb_monan.Text!=""&&tb_gia.Text!="")
     {
         ThucDon thd = new ThucDon();
         thd.IdNhaHang = nh.Id;
         thd.MonAn = tb_monan.Text;
         thd.NguyenLieu = tb_nguyenlieu.Text;
         thd.PhuongPhap = tb_phuongphap.Text;
         thd.Gia = int.Parse(tb_gia.Text);
         try
         {
             ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
             client.DangThucDonCompleted += new EventHandler<ServiceReference1.DangThucDonCompletedEventArgs>(DangThucDonCallBack);
             client.DangThucDonAsync(thd);
         }
         catch
         {
             MessageBox.Show("Lỗi Dịch Vụ !", "Warning: ", MessageBoxButtons.OK, MessageBoxIcon.Error);
         }
     }
     else
     {
         MessageBox.Show("Bạn phải nhập tên và giá của món ăn");
     }
 }

 private void DangThucDon_Load(object sender, EventArgs e)
 {
     lv_dsketqua.Items.Clear();
     client = new ServiceReference1.Service1Client();
     client.TimnguoidangCompleted += new EventHandler<ServiceReference1.TimnguoidangCompletedEventArgs>(TimnguoidangCallBack);
     client.TimnguoidangAsync(Form1.username);
 }

 public MainPage()
 {
     InitializeComponent();
     ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
     client.getUsernamesAsync();
     client.getUsernamesCompleted += client_getUsernamesCompleted;
 }

        protected void LoadMissions()
        {
            using (var client = new ServiceReference1.Service1Client())
            {

                List<UppdragStatus> missionList = new List<UppdragStatus>();
                //String currUser = HttpContext.Current.User.Identity.Name;

                //int eid = client.GetEmployeeByIdNumber(currUser);

                //missionList = client.GetMissionsByEid(eid);

                uppdrag.Mission.Description = "CGI";
                uppdrag.Mission.StartDate = DateTime.Today;
                uppdrag.Mission.EID = 1;
                uppdrag.Mission.MID = 1;
                uppdrag.TravelOrder.Sent = false;
                uppdrag.TravelOrder.Approved = false;
                uppdrag.TravelOrder.Answered = false;

                //Sent, Ap, An
                // Skickad      1, 0, 0
                // Ej godkänd   1, 0, 1
                // Godkänd      1, 1, 1
                // Ej skickad   0, 0, 0

                missionList.Add(uppdrag);

                GridView1.DataSource = missionList;
                GridView1.DataBind();

            }
        }

 private void Button_Click(object sender, RoutedEventArgs e)
 {
     int check = 0;
     if (isEmail(username.Text) == false)
     {
         MessageBox.Show("Email is not correct!");
     }
     else if (userpass.Password.Trim().Length == 0)
     {
         MessageBox.Show("Write a password!");
     }
     else
     {
         for (int i = 0; i < userList.Count; i++)
         {
             if (username.Text == userList[i].username)
             {
                 if (userpass.Password == userList[i].password)
                 {
                     userID = userList[i].ID_user;
                     loginpanel.Visibility = Visibility.Collapsed;
                     tabPanel.Visibility = Visibility.Visible;
                     check = 1;
                     ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
                     client.getSnakeScoreDataAsync(userID);
                     client.getSnakeScoreDataCompleted += client_getSnakeScoreDataCompleted;
                 }
             }
         }
         if (check == 0)
         {
             MessageBox.Show("Incorrect password or username!");
         }
     }
 }