private void BtnSave_Click(object sender, RoutedEventArgs e)
        {
            Int32 _CustID = Convert.ToInt32(ClsCantierDB.GetCustomerByCode(customercode).Rows[0][0].ToString().Trim());

            SqlCommand cmd = new SqlCommand("ChangeFGLocation");

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@RackNo", location);

            cmd.Parameters.AddWithValue("@NewRackNo", cboNewRack.SelectedValue.ToString().Trim());

            cmd.Parameters.AddWithValue("@Cust_ID", _CustID);

            cmd.Parameters.AddWithValue("@PartCode", partcode);

            cmd.Parameters.AddWithValue("@LotNo", lotno);

            SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd);

            MessageBox.Show("Location Successfully Changed.");

            this.Close();
        }