Sunday, February 23, 2020

Realtime online software to see Corona Virus(COVID-19) affected areas, confirmed & recovered cases and deaths.


Corona virus(COVID-19) is an infectious disease originated at Wuhan city of China. It is a fatal virus that hadn't been identified previously in human and is spreading within all over the world instantly.

Is your area affected? Is your beloved one's area affected?
Don't be afraid. 
Now, there's way to get updated about the corona virus affected areas. 

Features
* Affected areas are illustrated in the world map.
* Confirmed cases.
* Number of deaths.
* How many people recovered.
* Most serious area at the moment. 
* Timeline.

This online software is maintained by Johns Hopkins University Center for Systems Science Engineering with the information from WHO, DXY website, CCDC and Centers for Disease prevention and Control in USA, Europe and China.

You can visit the online tool by clicking here


Posted By Software Guru LankaFebruary 23, 2020

Wednesday, December 25, 2019

Software guru wishes you all a merry christmas and happy 2️⃣0️⃣2️⃣0️⃣

Filled under:

Posted By Software Guru LankaDecember 25, 2019

Sunday, October 14, 2018

Android studio for beginners (with curd functions)

Filled under:

SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.
SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC,ODBC e.t.c

Database - Package

The main package is android.database.sqlite that contains the classes to manage your own databases

Database - Creation

In order to create a database you just need to call this method openOrCreateDatabase with your database name and mode as a parameter. It returns an instance of SQLite database which you have to receive in your own object.Its syntax is given below
Home The application will consist of an activity and a database handler class (MyDBHandler class). The database handler will be a subclass of SQLiteOpenHelper and will provide an abstract layer between the underlying SQLite database and the activity class. A third class (Student class) will need to be implemented to hold the database entry data as it is passed between the activity and the handler.


public class Home extends AppCompatActivity {

    private Button login, reg;    
    private EditText uname, pass;    
    private DBHelper dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);        
        setContentView(R.layout.activity_home);

        dbHelper = new DBHelper(this);

        login = findViewById(R.id.btnLogin);   
        reg = findViewById(R.id.btnReg);        
        uname = findViewById(R.id.uname); 
        pass = findViewById(R.id.pass);

        login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                ArrayList<User> list = dbHelper.readAllInfo();
                for (User u : list){

                    if(u.getUserName().equals(uname.getText().toString())){
                        if(u.getPassword().equals(pass.getText().toString())){

                           Intent intent = new Intent(Home.this, ProfileManagement.class);                            
                            intent.putExtra("id", u.getUserId());    
                            startActivity(intent);                        }
                    }
                }
            }
        });
        reg.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View view) {

                String user = uname.getText().toString();               
               String passwrd = pass.getText().toString();
               dbHelper.addInfo(user, passwrd);

                Toast.makeText(Home.this, "User Registered!", Toast.LENGTH_SHORT).show();            }
        });    }
}


Database - Fetching

We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data.
Cursor resultSet = mydatbase.rawQuery("Select * from TutorialsPoint",null);
resultSet.moveToFirst();
String username = resultSet.getString(0);
String password = resultSet.getString(1);
There are other functions available in the Cursor class that allows us to effectively retrieve the data. That includes DB helper 



public class DBHelper extends SQLiteOpenHelper {

    private final static String DATABASE_NAME = "UserInfo.db";
    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {

        String CREATE_TABLE =
                "CREATE TABLE " + UserProfile.Users.TABLE_NAME + " (" +
                        UserProfile.Users._ID + " INTEGER PRIMARY KEY," +
                        UserProfile.Users.COLUMN_USERNAME + " TEXT," +
                        UserProfile.Users.COLUMN_DOB + " TEXT," +
                        UserProfile.Users.COLUMN_GENDER + " TEXT," +
                        UserProfile.Users.COLUMN_PASSWORD + " TEXT )";
        sqLiteDatabase.execSQL(CREATE_TABLE);    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }

    public long addInfo(String username, String password){

        SQLiteDatabase sqLiteDatabase = getWritableDatabase();

        ContentValues contentValues = new ContentValues();       
        contentValues.put(UserProfile.Users.COLUMN_USERNAME, username);      
        contentValues.put(UserProfile.Users.COLUMN_PASSWORD, password);
    long rowId = sqLiteDatabase.insert(UserProfile.Users.TABLE_NAME, null, contentValues);
        return rowId;   
 }
 public int updateInfo(String userId, String userName, String password, String dob, 
String gender){

        SQLiteDatabase sqLiteDatabase = getWritableDatabase();
        ContentValues values = new ContentValues();     
        values.put(UserProfile.Users.COLUMN_USERNAME, userName);        
        values.put(UserProfile.Users.COLUMN_PASSWORD, password);     
        values.put(UserProfile.Users.COLUMN_GENDER, gender);        
        values.put(UserProfile.Users.COLUMN_DOB, dob);

        String selection = UserProfile.Users._ID + " = ?";       
        String args[] = {userId};

 int count = sqLiteDatabase.update(UserProfile.Users.TABLE_NAME, values, selection, args);
        return count;   
 }

    public ArrayList readAllInfo(){

        SQLiteDatabase sqLiteDatabase = getReadableDatabase();
        String[] projection = {

                UserProfile.Users._ID,                
                UserProfile.Users.COLUMN_USERNAME,                
                UserProfile.Users.COLUMN_DOB,                
                UserProfile.Users.COLUMN_GENDER,               
                UserProfile.Users.COLUMN_PASSWORD
        };

        String sortOrder = UserProfile.Users._ID + " DESC";
        Cursor cursor = sqLiteDatabase.query(
             UserProfile.Users.TABLE_NAME, projection,null,null,null,null,sortOrder
        );
        ArrayList<User> list = new ArrayList<>();
        if (cursor.getCount() > 0){

            while(cursor.moveToNext()){

                User newUser = new User();
              int id = cursor.getInt(cursor.getColumnIndexOrThrow(UserProfile.Users._ID));                String user = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_USERNAME));                String date = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_DOB));                String gen = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_GENDER));                String pass = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_PASSWORD));
                newUser.setUserId(id+"");                
                newUser.setUserName(user);                
                newUser.setDateOfBirth(date);                
                newUser.setGender(gen);                
                newUser.setPassword(pass);
                list.add(newUser);          
  }
        }

        return list;    
}

    public ArrayList readAllInfo(String userId, String userName){

        String selection;        
        String[] args = {""};

        if(userId == null){

            selection = UserProfile.Users.COLUMN_USERNAME + " LIKE ?";
            args[0] = userName;        
        }
        else {
            selection = UserProfile.Users._ID + " = ?";            
            args[0] = userId;        
        }

        SQLiteDatabase sqLiteDatabase = getReadableDatabase();
        String[] projection = {

                UserProfile.Users._ID,                
                UserProfile.Users.COLUMN_USERNAME,                
                UserProfile.Users.COLUMN_DOB,                
                UserProfile.Users.COLUMN_GENDER,                
                UserProfile.Users.COLUMN_PASSWORD
        };


        String sortOrder = UserProfile.Users._ID + " DESC";
        Cursor cursor = sqLiteDatabase.query(
            UserProfile.Users.TABLE_NAME, projection, selection,args,null,null, sortOrder
        );
        ArrayList<User> list = new ArrayList<>();
        if (cursor.getCount() > 0){

            while(cursor.moveToNext()){

            User newUser = new User();
            int id = cursor.getInt(cursor.getColumnIndexOrThrow(UserProfile.Users._ID));                String user = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_USERNAME));                String date = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_DOB));                String gen = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_GENDER));                String pass = cursor.getString(cursor.getColumnIndexOrThrow(UserProfile.Users.COLUMN_PASSWORD));
            newUser.setUserId(id+"");               
            newUser.setUserName(user);                
            newUser.setDateOfBirth(date);                
            newUser.setGender(gen);                
            newUser.setPassword(pass);

                list.add(newUser);            
          }
        }

        return list;    }

    public int deleteInfo(String username){

        SQLiteDatabase sqLiteDatabase = getReadableDatabase();
        String selection = UserProfile.Users._ID + " = ?";        
        String[] args = {username};

   int deletedRows = sqLiteDatabase.delete(UserProfile.Users.TABLE_NAME, selection, args);
     return deletedRows;    
}
}

n software applications, it is mostly required to save information for some internal use 
or off course to provide user to great features depending on the data. And when we talk
about android so SQLite is that default feature which is used as a database and also 
used as a local database for any application. This tutorial shows a very simple example
 which is to just store important data like Profile Management shops address or contacts using 
SQLite Database in the android studio.




public class ProfileManagement extends AppCompatActivity {

    private Button update;    
    private EditText uname, dob, pass;    
    private RadioButton male, female;    
    private DBHelper dbHelper;    
    private String userId;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);        
        setContentView(R.layout.activity_profile_management);
        dbHelper = new DBHelper(this);        

        Intent intent = getIntent();        
        userId = intent.getStringExtra("id");

        uname = findViewById(R.id.user);        
        dob = findViewById(R.id.date);        
        pass = findViewById(R.id.word);     
        update = findViewById(R.id.btnUpdate);        
        male = findViewById(R.id.radioMale);        
        female = findViewById(R.id.radioFe);

        ArrayList<User> list =  dbHelper.readAllInfo(userId, null);
        for (User u : list){

            uname.setText(u.getUserName());            
            pass.setText(u.getPassword());            
            dob.setText(u.getDateOfBirth());

            if(u.getGender() != null){

                if(u.getGender().equals("Male")){

                    male.setChecked(true);                
                }
                else{
                    female.setChecked(true);                
                }
            }
        }

        update.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                Intent intent = new Intent(ProfileManagement.this, EditProfile.class);                intent.putExtra("id", userId);                startActivity(intent);            }
        });    }
}

User First, start with insert, we add a method addShop() which take Shop as a parameter 
and map our shop values with table’s column using ContentValues object. 
getWritableDatabase is used for creating and/or opening database. 

package com.example.prabuddhaabisheka.mock;
public class User {

    private String userId;    
    private String userName;    
    private String dateOfBirth;    
    private String gender;    
    private String password;

    public User() {
    }

    public String getUserId() {

        return userId;    }

    public void setUserId(String userId) {

        this.userId = userId;    }

    public String getUserName() {

        return userName;    }

    public void setUserName(String userName) {
        this.userName = userName;    }

    public String getDateOfBirth() {
        return dateOfBirth;    }

    public void setDateOfBirth(String dateOfBirth) {
        this.dateOfBirth = dateOfBirth;    }

    public String getGender() {
        return gender;    }

    public void setGender(String gender) {
        this.gender = gender;    }

    public String getPassword() {
        return password;    }

    public void setPassword(String password) {
        this.password = password;    }
}

User profile Android Studio is the official[7] integrated development environment (IDE) for
Google's Android operating system, built on JetBrainsIntelliJ IDEA software and designed specifically
 for Android development.[8] It is available for download on WindowsmacOS and Linux based 
operating systems.[9][10] It is a replacement for the Eclipse Android Development Tools (ADT) as 
primary IDE for native Android application development.

package com.example.prabuddhaabisheka.mock;
import android.provider.BaseColumns;
public final class UserProfile {

    private UserProfile() {    }

    public static class Users implements BaseColumns {

        public final static String TABLE_NAME = "userInfo";        
        public final static String COLUMN_USERNAME = "userName";        
       public final static String COLUMN_PASSWORD = "password";       
       public final static String COLUMN_GENDER = "gender";     
       public final static String COLUMN_DOB = "dateOfBirth";   
   }
}

Edit profile Today, Android Studio 3.2 is available for download. Android 
Studio 3.2 is the best way for app developers to cut into the latest Android 9 Pierelease 
and build the new Android App bundle. Since announcing this update of Android Studio
 at Google I/O '18, we have refined and polished 20+ new features and focused our efforts 
on improving the quality for this stable release of Android Studio 3.2.


public class EditProfile extends AppCompatActivity {

    private Button edit,delete,search;    
    private EditText uname, dob, pass;
    private RadioGroup radioGroup;
    private RadioButton male, female;
    private String gender;
    private DBHelper dbHelper;
    private String userId;  

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_edit_profile);
        dbHelper = new DBHelper(this);

        Intent intent = getIntent();
        userId = intent.getStringExtra("id");
        Toast.makeText(EditProfile.this, userId, Toast.LENGTH_SHORT).show();

        uname = findViewById(R.id.userName);
        dob = findViewById(R.id.dateOfB);
        pass = findViewById(R.id.psswrd);
        edit = findViewById(R.id.btnEdit);
        delete = findViewById(R.id.btnDelete);
        search = findViewById(R.id.btnSearch);
        radioGroup = findViewById(R.id.radio);
        male = findViewById(R.id.maleR);
        female = findViewById(R.id.femaleR);

        ArrayList<User> list =  dbHelper.readAllInfo(userId, null);
        if(!list.isEmpty()){

            for (User u : list){

                uname.setText(u.getUserName());                
                pass.setText(u.getPassword());
                dob.setText(u.getDateOfBirth());

                if(u.getGender() != null){

                    if(u.getGender().equals("Male")){

                        male.setChecked(true);
                    }
                    else
                    {
                        female.setChecked(true);
                    }
                }
            }
        }

        radioGroup.setOnCheckedChangeListener(new RadioGroup.OnCheckedChangeListener() {

            @Override
            public void onCheckedChanged(RadioGroup radioGroup, int view) {

                if(view == R.id.femaleR){

                    gender = "Female";
                }
                else{

                    gender = "Male";
                }
            }
        });
        search.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

            ArrayList<User> urs = dbHelper.readAllInfo(null, uname.getText().toString());
                for (User u : urs){

                    userId = u.getUserId();
                    uname.setText(u.getUserName());
                    pass.setText(u.getPassword());
                    dob.setText(u.getDateOfBirth());

                    if(u.getGender() != null){

                        if(u.getGender().equals("Male")){

                            male.setChecked(true);
                        }
                        else
                        {
                            female.setChecked(true);
                        }
                    }
                }
            }
        });
        edit.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                String userName = uname.getText().toString();
                String date = dob.getText().toString();
                String pwrd = pass.getText().toString();

                if(female.isChecked()){

                    gender = "Female";
                }
                else{

                    gender = "Male";
                }

                int count = dbHelper.updateInfo(userId, userName, pwrd, date, gender);
                if(count > 0){

                  Toast.makeText(EditProfile.this, "Updated!", Toast.LENGTH_SHORT).show();                }
                else{

     Toast.makeText(EditProfile.this, "Something went wrong!", Toast.LENGTH_SHORT).show();                }
            }
        });
        delete.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                int count = dbHelper.deleteInfo(userId);
                if(count > 0){

            Toast.makeText(EditProfile.this, "Deleted!", Toast.LENGTH_SHORT).show();                }
                else{
        Toast.makeText(EditProfile.this, "Something went wrong!", Toast.LENGTH_SHORT).show();                }
            }
        });    }
}

insert - return value = long
if long = -1 --->  false
else   ---->  true
db.insert(tablename,null,contentValues)

Update - return value = long 
if long = -1 --->  false
else   ---->  true
db.update(tablename,contentValue,_ID+"=?",new String[]{id});

Delete - return value = integer (no of rows deleted)
db.delete(tablename,_ID+"=?",new String[]{id});

Posted By UnknownOctober 14, 2018

Sunday, August 26, 2018

Android 9 Pie released with improved artificial intelligence and multiple bluetooth connection.

Filled under: , ,

Google introduced android 9 with the name of a delicious food called "Pie" containing a lot of latest technologies. It comes with the artificial intelligence which has been improved to do the things smarter and faster than before.


Below are the extracted features among the thousands of smart features.

Features:

  • Adaptive battery.
  • Adaptive brightness.
  • When you connect your headphone, recent music playlist will appear.
  • Improved keyword suggestions when you search.
  • Switch between apps easily using gestures without any button.
  • Dashboard: to see where you spend the time. For example app names and the time spent.
  • Set daily time limits for the app: when an app reaches the limit, It's icon will be gray out.
  • Screen fades to grayscale when do not disturb is activated.
  • Sound amplifier.
  • Select to speak - Optical Character Recognition(OCR) in camera view.
  • Multi-camera support.
  • Multiple bluetooth connections.
  • At a Glance Always on Display.
To get that smarter experience, you can upgrade your Pixel phone to Android 9 Pie.
You can explore additional features by visiting here.

Posted By Software Guru LankaAugust 26, 2018

Saturday, April 14, 2018

Software guru wishes you a happy new year!

Filled under:

As a team we brings you the latest softwares and tools to fulfil your requirements.
Dear friends thank you for being with us for more than 5 years.
We're proud to say that we have about million users at the moment.

So, We wish you a peaceful, prosperous, healthy and happy new year for all friends!

You can add your wishes on the comment box given below. Keep in touch with us.

Posted By Software Guru LankaApril 14, 2018

Monday, February 26, 2018

Sri Lanka MOHE introduced interest free Loan Scheme for A/L passed student.

Filled under:

Sri Lanka Ministry of Higher Education introduced an interest free loan scheme for Advance Level(A/L) qualified students for some selected degree programs.

 

This offer is only valid for students passed the A/L exam

in 2016.

 

How to apply:

1.      Visit  http://studentloans.mohe.gov.lk/StudentEApp/

2.      Enter your index number of A/L 2016.

3.      Enter you National Identity Card(NIC) number.

4.      Click Sign in

 

If you heard this news for the first time, don't hesitate to share it with the friends who have passed the A/L exam in 2016.

 

Comment any questions or suggestions regarding this matter on the comment box given below.

 

Posted By Software Guru LankaFebruary 26, 2018

Sunday, February 4, 2018

🇱🇰 Google celebrates Sri Lanka's 70th Independence day. 🇱🇰

Filled under:

Once you visit google search engine you can be amazed with the newest animated logo(gif) with Sri Lankan flag.
Google added it to celebrate the Independence which Sri Lankans got on 04th of February 1948 by safeguarding our Mother country from Britain.

Software Guru also wishes all Sri Lankans a Happy Independence Day with peace and prosperity!

                      

We must salute all the greatest heroes on that era who helped to achieve this independence.

Posted By Software Guru LankaFebruary 04, 2018