convert the comma from the database into a dot

2021-01-17 02:24 Erhan Şimşek imported from Stackoverflow

I take the data from the database with the following code and display it to the screen. Incoming data ',' comes with a comma. Sample : Coordinate: 38,5226900 27,0439733

I am this ',' comma '.' I want to turn to the dot. After convert, I will put the translated version below into the script below. and I want it to open in a new page with a separate button.

<script>
                         // [START maps_streetview_controls]
                         function initPano() {
                             // Note: constructed panorama objects have visible: true
                             // set by default.
                             const panorama = new google.maps.StreetViewPanorama(
                                 document.getElementById("map2"),
                                 {
                                     position: { lat: <%#Eval("Latitude") %>, lng: <%#Eval("Longtitude") %> },
                                     addressControlOptions: {
                                         position: google.maps.ControlPosition.BOTTOM_CENTER,
                                     },
                                     linksControl: false,
                                     panControl: true,
                                     enableCloseButton: true,
                                 }
                             );
                         }
// [END maps_streetview_controls]
                     </script>

 <td ><asp:Label ID="Label24" runat="server" Text=":&nbsp;&nbsp;&nbsp;"><%#Eval("Latitude") %>'  <%#Eval("Longtitude") %>' </asp:Label>

2 answers

answered 2021-01-17 02:41 Insomnimatic
You'll need to perform a string replace on all instances of commas and turn them into decimal points.

This link explains the replaceAll() function and has examples: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/replaceAll

answered 2021-01-17 03:32 Erhan Şimşek

<script>
                        const longstring = '<%#Eval("Latitude") %>';
                        longString = lng.toString().replaceAll(",", ".");
                    </script>
                    
                    
                    <script>
                         // [START maps_streetview_controls]
                         function initPano() {
                             // Note: constructed panorama objects have visible: true
                             // set by default.
                             const panorama = new google.maps.StreetViewPanorama(
                                 document.getElementById("map2"),
                                 {
                                     position: { lat: 'longstring', lng: 27.1576267 },
                                     addressControlOptions: {
                                         position: google.maps.ControlPosition.BOTTOM_CENTER,
                                     },
                                     linksControl: true,
                                     panControl: true,
                                     enableCloseButton: true,
                                 }
                             );
                         }

See also questions close to this topic

How to handle String mechanism in react js
I have written a small piece of code inside the return. for example
```
const Demo = (props) => {
    return (
        <div>
            props.map((val, index) => (
                <h2>{val.fileName}</h2>
            ))
        </div>
    )  
}
```
The output is coming like this: F:\test\form\student.html But inside I don't want this type of output. I want to modify the output like: F:\test\form\form.pdf
1. The last student.html will remove and the form must become 2 times will repeat and lastly, the extension is pdf
```
 original output: F:\test\form\student.html
 desired output: F:\test\form\form.pdf
```
can you help how to solve this problem?

How to display alert mail using Php?

I am using wamp server and MYSQL . I have designed a login page and connected to database that stores username and password .If SQL Injection happens in login page then a alert mail need to be sent to admin. But I am getting mail even if the user logged in correctly and also if SQL Injection happens. Loginpage.html

<!DOCTYPE html>
 <html lang="en" dir="ltr">
<head>
<meta charset="UTF-8">
<title>Login form </title>
 <link rel="stylesheet" type="text/css" href="style1.css">
 </head>
 <body>
     <div class="box">
     <form  action="insert.php" method="POST">
         <h1>Login</h1>
         <input type="text" name="username" placeholder="name">
         <input type="text" name="password" placeholder="Password">
         <input type="submit" name="submit" value="Login">
     </form>
    </div>
     </body>
 </html>

insert.php

<?php
if(isset($_POST['submit'])){ 
    $conn = mysqli_connect('localhost:3308','root', '')or die("connection error");
    mysqli_select_db($conn,"sqllogin");
$username =$_POST["username"];
$password=$_POST["password"];
$query="SELECT * FROM users WHERE username='$username' AND password='$password'";
    $result=mysqli_query($conn,$query);
    $count = mysqli_num_rows($result);

if($count > 0)
    {
    require 'PHPMailer/PHPMailerAutoload.php';
    $mail = new PHPMailer;

//$mail->SMTPDebug = 4;                               // Enable verbose debug output

$mail->isSMTP();                                      // Set mailer to use SMTP
$mail->Host = 'smtp.gmail.com';  // Specify main and backup SMTP servers
$mail->SMTPAuth = true;                               // Enable SMTP authentication
$mail->Username = 'user@gmail.com';                 // SMTP username
$mail->Password = 'secret';                           // SMTP password
$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
$mail->Port = 587;                                    // TCP port to connect to

$mail->setFrom('user@gmail.com', 'user');
$mail->addAddress('admin@gmail.com');     // Add a recipient
//$mail->addAddress('ellen@example.com');               // Name is optional
//$mail->addReplyTo('info@example.com', 'Information');
//$mail->addCC('cc@example.com');
//$mail->addBCC('bcc@example.com');

//$mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
//$mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name
$mail->isHTML(true);                                  // Set email format to HTML

$mail->Subject = 'ALERT MAIL';
$mail->Body    = 'Your website is hacked';
//$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';
header("Location:indexbook.html");

if(!$mail->send()) {

    echo 'Message could not be sent.';
    echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
    
    echo"<h1> success</h1>";
    echo 'Message has been sent';
}
}
}
?>

I have an array that I want to grab some values from and add them as a object to a inititalValues in a Ant Design Form Componenet

I have a Ant Design Form Component that takes some initital vales. I need to populate them from an array, but I it needs to be in this format.

 <Form
    {...layout}
    name="basic"
    initialValues={{ "name-0": "fdsanfdsk", "name-1": "fdsafjasf9" }} // I need the name values 
                                                                      // from the array here
    onFinish={onFinish}
    onFinishFailed={onFinishFailed}
  >

My array looks like so

[{
    "__typename": "FormInputVal",
    "name": "name",
    "_id": "291541872966369805",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "name",
    "_id": "291541888089981453",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291644307943719437",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291649317517656585",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291649666387280392",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291651264892109325",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291651422325309961",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291651568083665417",
    "type": "text"
}, {
    "__typename": "FormInputVal",
    "name": "test",
    "_id": "291653619769410057",
    "type": "text"
}]

I just need the names from the array, and inserted into the initalValues object in the Form Component, with a -0, -1, -2 tacked on.

I have tried the following

const test = formState?.map((item, idx) => {
      return `${item.name}-${idx}:"fdsjfs"`;
    });

and then I end up with another array, and I have tried turning that array test into a Object with Object.assign({},test) but then it has keys on it.

Any help would be greatley appreciated

getting prob on reading nested class c#

Hi really need assistance here,

I have 2 classes which i use to read from json i need to save into 2 tables (root and participants) in 1 submission. i will have only 1 root with 1 or many participants. i have no prob saving the root but i have prob reading if i am sending both (root with participants}

[
  {
    "NoIC": "122233243",
    "Nama": "TEST NAME",
    ...
    "Participant": [
        {
            "Nama" : "Participant 1",
            "Bil" : "1",
            ...
        }, 
        {
            "Nama" : "Participant 2",
            "Bil" : "1",
            ....
        }
    ] 
  }
 ]


public class Participant
{
    public string ref_no { get; set; }
    public string Nama { get; set; }
    public string Bil { get; set; }
    public string Price { get; set; }
    public string RequestedPlace { get; set; }
    public string RequestedExe { get; set; }
    public string RequestedDate { get; set; }
    public string Type { get; set; }
}

public class Root
{
    public string NoIC { get; set; }
    public string Nama { get; set; }
    public string HPNo { get; set; }
    public string Email { get; set; }
    public string Type { get; set; }
    public string RegisterBy { get; set; }
    public List<Participant> Participant { get; set; }
}



    public string RegisterApplication([FromBody] Root register, Participant participants)
    {
        try
        {
            using (MySqlConnection sql = new MySqlConnection(_connectionString))
            {
                using (MySqlCommand cmd = new MySqlCommand("GetInsertApplication", sql))
                {
                    sql.Open();
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    // cmd.Parameters.AddWithValue("@refNo", register.RefNo);
                    cmd.Parameters.AddWithValue("@NoIC", register.NoIC);
                    cmd.Parameters.AddWithValue("@Nama", register.Nama.ToUpper());
                    cmd.Parameters.AddWithValue("@NoFonHp", register.HPNo);
                    cmd.Parameters.AddWithValue("@Email", register.Email);
                    cmd.Parameters.AddWithValue("@refType", register.Type);
                    cmd.Parameters.AddWithValue("@RegisterBy", register.RegisterBy);

                   ......

                    ref_no = refnoParameter.Value.ToString(); //will pass this refno to child/participant

my prob is here. i need to read the child (1 Root can have more than 1 participant)

    List<Participant> participants = new List<Participant>();

                using (MySqlCommand cmd2 = new MySqlCommand("GetInsertParticipant", sql))
                {
                    cmd2.Parameters.AddWithValue("@ref_no", ref_no);
                    cmd2.Parameters.AddWithValue("@Nama", participant.Nama.ToUpper());
                    cmd2.Parameters.AddWithValue("@Bil", participant.Bil);
                    cmd2.Parameters.AddWithValue("@Price", participant.Price);
                    cmd2.Parameters.AddWithValue("@RequestedPlace", participant.RequestedPlace);
                    cmd2.Parameters.AddWithValue("@RequestedExe", participant.RequestedExe);
                    cmd2.Parameters.AddWithValue("@RequestedDate", participant.RequestedDate);
                    cmd2.Parameters.AddWithValue("@Type", participant.Type);
                    cmd2.Connection.Open();

                    cmd2.CommandType = CommandType.Text;
                    cmd2.ExecuteNonQuery();

}}}}}

anybody please, i stuck here for few days and i really need your help/opinion. thaks in advanced

How do I insert input from form to database?

My model looks like this:

public class Customer
{
    public int CustomerId { get; set; }

    [Required(ErrorMessage = "Please enter a valid first name")]
    public string FirstName { get; set; }

    [Required(ErrorMessage = "Please enter a valid last name")]
    public string LastName { get; set; }

    [Required(ErrorMessage = "Please enter a valid address")]
    public string Address { get; set; }

    public string Email { get; set; }

    [Required(ErrorMessage = "Please enter a valid city")]
    public string City { get; set; }

    public string Phone { get; set; }

    [Range(1, 5, ErrorMessage = "Please enter a valid country")]
    public int CountryId { get; set; }

    public Country Country { get; set; }

    [Required(ErrorMessage = "Please enter a valid state")]
    public string State { get; set; }

    [Required(ErrorMessage = "Please enter a valid postal code")]
    public string PostalCode { get; set; }

    public string fullname => FirstName + LastName;
}

My controller looks like this:

public class CustomerController : Controller
{
    private CustomerContext context { get; set; }

    public CustomerController(CustomerContext ctx)
    {
        context = ctx;
    }

    public IActionResult List()
    {
        var customers = context.Customers.ToList();
        return View(customers);
    }

    [HttpGet]
    public IActionResult Add()
    {
        ViewBag.Action = "Add";
        ViewBag.Countries = context.Countries.OrderBy(c => c.Name).ToList();
        return View("Edit", new Customer());
    }

    [HttpGet]
    public IActionResult Edit(int id)
    {
        ViewBag.Action = "Edit";
        ViewBag.Countries = context.Countries.OrderBy(c => c.Name).ToList();

        var customer = context.Customers
            .Include(c => c.Country)
            .FirstOrDefault(c => c.CustomerId == id);

        return View(customer);
    }

    [HttpPost]
    public IActionResult Edit(Customer customer)
    {
        string action = (customer.CustomerId == 0) ? "Add" : "Edit";

        if (ModelState.IsValid)
        {
            if (action == "Add")
            {
                context.Customers.Add(customer);
            }
            else
            {
                context.Customers.Update(customer);

            }
            context.SaveChanges();
            return RedirectToAction("List", "Customer");
        }
        else
        {
            ViewBag.Action = action;
            ViewBag.Countries = context.Countries.OrderBy(c => c.Name).ToList();
            return View(customer);
        }
    }

I also have a DbContext file with data i created to test other things:

public class CustomerContext : DbContext
{
    public CustomerContext(DbContextOptions<CustomerContext> options)
        :base(options)
    { }

    public DbSet<Customer> Customers { get; set; }

    public DbSet<Country> Countries { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Country>().HasData(
            new Country { CountryId = 1, Name = "Canada"},
            new Country { CountryId = 2, Name = "United States"},
            new Country { CountryId = 3, Name = "United Kingdom" },
            new Country { CountryId = 4, Name = "Mexico" },
            new Country { CountryId = 5, Name = "Russia" }
            );

        modelBuilder.Entity<Customer>().HasData(
            new Customer
            {
                CustomerId = 1,
                FirstName = "Bruce",
                LastName = "Wayne",
                Phone = "416-123-4567",
                Email = "bruce.wayne@gmail.com",
                CountryId = 1,
                Address = "123 sesame street",
                City = "Toronto",
                PostalCode = "L812A",
                State = "Ontario"
            }
            );
    }

I already did the add-migration and updated my database via the package manager console. I created a form in the view that looks like this:

<form method="post" asp-action="Add">
<div asp-validation-summary="All">

    <div>
        <label asp-for="FirstName">First Name</label>
        <input type="text" name="FirstName" asp-for="FirstName" />
    </div>

    <div>
        <label asp-for="LastName">Last Name</label>
        <input type="text" name="LastName" asp-for="LastName" />
    </div>

    <div>
        <label asp-for="Address">Address</label>
        <input type="text" name="Address" asp-for="Address" />
    </div>

    <div>
        <label asp-for="City">City</label>
        <input type="text" name="City" asp-for="City" />
    </div>

    <div>
        <label asp-for="State">State</label>
        <input type="text" name="State" asp-for="State" />
    </div>

    <div>
        <label asp-for="PostalCode">Postal Code</label>
        <input type="text" name="Postal Code" asp-for="PostalCode" />
    </div>

    <div>
        <label asp-for="CountryId">Country</label>
        <select name="Country" asp-for="CountryId">
            @foreach (Country country in ViewBag.Countries)
            {
                <option value="@country.CountryId">@country.Name</option>
            }
        </select>
    </div>

    <div>
        <label asp-for="Email">Email</label>
        <input type="text" name="Email" asp-for="Email" />
    </div>

    <div>
        <label asp-for="Phone">Phone</label>
        <input type="text" name="Phone" asp-for="Phone" />
    </div>

    <input type="hidden" asp-for="CustomerId" />
</div>

<button type="submit" value="Save" asp-controller="Customer" asp-action="List">Save</button>

Cancel

I've tried looking up multiple different solutions to solve my issue but I cant seem to figure out how to solve it. If someone could help me that would be much appreciated. thanks in advance.

Submit button doenst work with script asp.net mvc5
I have a maybe simple problem but I don`t have that much experience with scripts:

I have this Skript in my _Layout.cshtml:
```
<script>
    $('button').click(function () {
        $(this).prop('disabled', true);
    });
</script>
```
and one of my views:
```
@using (Html.BeginForm("Create", "Home", FormMethod.Post, null))
{
    @Html.AntiForgeryToken()

    <div class="mt-5 d-flex flex-row">
        <textarea class="form-control" name="TextArea"></textarea>

        <button class="btn btn-secondary btn-block mt-2 post-btn" type="submit" id="PostButton">Post</button>

    </div>
}
```
This form works great without the script, but for any reason with the script it doesn`t work.

I placed the script in the _layout.cshtml because I want to have it for all buttons in my asp.net page.

After click on the button the button is disabled - as I wish - but the action result "Create" in the HomeController will not called.

I think I need to extend the script but can someone help me how to do it?

Thanks all

convert datetime passed into parameter to a string c#

I would like to convert a datetime passed into parameter into a string using this function but it doesn't work. Could anyone help me ? Thank you in advance

Here is my function

public string ConvertDateTimeToString(DateTime date)
        {
            string date_str = date.ToString("dd/MM/yyyy HH:mm:ss");
            return date_str;
        }

and after when i create a new dateTime object

DateTime dateTest = new DateTime(2008, 5, 1, 8, 30, 52);
ConvertDateTimeToString(dateTest);
Console.WriteLine(dateTest); /// show this {01/05/2008 08:30:52}

How to cast bytes received from TCP socket to a class in flutter
i am developing a chat app in flutter and i need help for casting received bytes to a class that i created. Here is the class:
```
class ChatMessage {
    
    String userName;
    String message
    
    ChatMessage({this.userName, this.message});
}
```
I use this piece of code to receive from server:
```
Socket.connect("192.168.1.102", 12345).then((Socket socket) {
  socket.listen((event) {
    //I need event in a ChatMessage variable not string!
  });
});
```
Received bytes are stored in event variable of type Uint8List but i need it in a variable with type ChatMessage. How can i do it?

Odd transparency issues with SVG converting

I'm trying to convert SVG images to jpeg or png (quality doesn't matter)

I'm using a NuGet package named SVG.

Here's my vb code

Dim svgDocument = Svg.SvgDocument.Open(TextBox2.Text & "\" & filename & ".svg")    ' Replace with correct FileName                                      
                Dim bmp As Bitmap = svgDocument.Draw(100, 100)                            ' Draw Bitmap in any Size you need - for example 12px x 12px                  
                bmp.Save(TextBox2.Text & "\" & "jpeg" & "\" & filename & ".jpeg", ImageFormat.Jpeg)                 ' save Bitmap as PNG-File

The thing that's working wrong is: The background of the text becomes black. Which is not like that when I look at them in a browser.

And here is the original file of the SVG

The original SVG file

I'm not sure exactly what is wrong, thanks for your time.

Related questions

convert the comma from the database into a dot

2 answers

See also questions close to this topic