Xamarin save data to database

Question

1.00/5 (3 votes)

See more:

, +

XML


<?xml version="1.0" encoding="utf-8" ?>
<ContentPage xmlns="http://xamarin.com/schemas/2014/forms"
             xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml"
             x:Class="RadniNalozi.AddEmployeePage" 
             Title="Dodaj radni nalog">
    <ContentPage.Content>
        <StackLayout Padding="5">
            <Label Text="Broj radnog naloga" 
            FontAttributes="Bold" TextColor="Black"/>
            <Entry Placeholder="Ordine di lavoro" FontSize="Small" 
            HorizontalOptions="FillAndExpand" x:Name="name"/>
            <Label Text="Narudžbenica" FontAttributes="Bold" 
            TextColor="Black"/>
            <Entry Placeholder="Ordine" FontSize="Small" 
            HorizontalOptions="FillAndExpand" x:Name="address"/>
            <Label Text="Commessa" FontAttributes="Bold" 
            TextColor="Black"/>
            <Entry Placeholder="Commessa" FontSize="Small" 
            HorizontalOptions="FillAndExpand" x:Name="phoneNumber" 
                   Keyboard="Numeric"/>
            <Label Text="Oracle narudbženica" FontAttributes="Bold" 
            TextColor="Black"/>
            <Entry Placeholder="Oracle ordine" FontSize="Small" 
            HorizontalOptions="FillAndExpand" 
            Keyboard="Email" x:Name="email"/>
            <Label Text="Naručilac" 
            FontAttributes="Bold" TextColor="Black"/>
            <Entry Placeholder="Cliente" FontSize="Small" 
                   HorizontalOptions="FillAndExpand" 
                   IsPassword="True" x:Name="password"/>

            <Button Text="Sačuvaj" Clicked="SaveEmployee" 
            HorizontalOptions="FillAndExpand" 
                    BackgroundColor="LightGreen" 
                    TextColor="Black" x:Name="saveBtn"/>
        </StackLayout>
    </ContentPage.Content>
</ContentPage>

What I have tried:

I have an error in this code, app work, when click save just close.
App just closes. Please give some recommendations.

Posted 7-Sep-23 2:10am

Stylus STYLUS

Updated 7-Sep-23 4:10am

Deeksha Shenoy

v2

Add a Solution

Comments

Graeme_Grant 7-Sep-23 8:23am

Where is the code for the SaveEmployee method?

Stylus STYLUS 7-Sep-23 8:26am

private void SaveEmployee(object sender, EventArgs e)
{
if (saveBtn.Text == "Potvrdi")
{
Employee employee = new Employee();
employee.Name = name.Text;
employee.Address = address.Text;
employee.PhoneNumber = phoneNumber.Text;
employee.Email = email.Text;
employee.Password = password.Text;

bool res = DependencyService.Get<isqlite>().SaveEmployee(employee);
if (res)
{
Navigation.PopAsync();
}
else
{
DisplayAlert("Message", "Data Failed To Save", "Ok");
}
}
else
{
// update employee
employeeDetails.Name = name.Text;
employeeDetails.Address = address.Text;
employeeDetails.PhoneNumber = phoneNumber.Text;
employeeDetails.Email = email.Text;

bool res = DependencyService.Get<isqlite>().UpdateEmployee(employeeDetails);
if (res)
{
Navigation.PopAsync();
}
else
{
DisplayAlert("Message", "Data Failed To Update", "Ok");
}
}
}

Richard Deeming 7-Sep-23 8:38am

Any unhandled exception in an event handler will normally terminate the process.

Start by wrapping the code in a try..catch block, and examining the exception that's being thrown.

Without that information, there's no way to diagnose the problem.

Richard Deeming 7-Sep-23 8:39am

Also, you appear to be storing your users' credentials in plain text. Don't do that!

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

Graeme_Grant 7-Sep-23 8:55am

Update your question using the "Improve question" link as here is inappropriate.

2 solutions

Solution 1

We can't tell: we have no idea what your code is doing, and no way to access it.

So start by looking at the SaveEmployee method, and use the debugger to find out what exactly it is doing. At a guess, it's your connections string, or the SQL command that is faulty - and throwing an exception which causes your app to close.

But we can't help with that as we can't run yoru code here!

Posted 7-Sep-23 2:22am

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2023-09-07T04:10:00

Solution 2

Statements such as:

C#

DependencyService.Get<isqlite>().UpdateEmployee(employeeDetails);

are a bad idea. If the Get call fails for any reason then a NullPointerException will follow. And since your code is not catching exceptions you will likely miss the critical information.

Posted 7-Sep-23 4:10am

Richard MacCutchan