CSharf Custom Classes

Custom Classes for Windows Form Application using C# Developed by Wilfred V. Pine @2020

Classes

How to use?

Download the Classes folder
Create a Windows Form Application project for .Net Framework Desktop Application.
In your Solution Explorer, right click on your project and add a folder named "Classes"
Then right click on your created "Classes" folder and add existing item. Browse the classes that you downloaded from step 1.
From your project folder root directory (in oyur Solution Explorer), create a class named " Config " and create a public instance of all the classes from Classes folder. See the code below:

    using Classes; // include the "Classes" folder
    namespace MySampleProject
    {
        class Config
        {
            /*
            * Database Information
            */
                private static string host = "localhost";
                private static string dbname = "dbinformation";
                private static string dbuser = "root";
                private static string dbpassword = "";
            /*
            * Classes
            */
                public Database db;
                public Validation validate;
                public Form_UI ui;
                public Visualizer visualizer;
                public Str_Date_Time date_time;
                public Upload upload;
            /*
            * Constructor
            */
                public Config()
                {
                    this.db = new Database(host, dbuser, dbpassword, dbname);
                    this.validate = new Validation();
                    this.ui = new Form_UI();
                    this.visualizer = new Visualizer();
                    this.date_time = new Str_Date_Time();
                    this.upload = new Upload();
                }
        }
    }

To your Form (example; FormLogin), create an instance of your Config class.

    public partial class FormLogin : Form
    {
        Config config = new Config(); // your Config class

        public FormLogin()
        {
            InitializeComponent();
        }

You can now use Database , Validation , Visualizer , Upload , Date_Time , & Form_UI Class.

    config.db.....
    config.validate......
    config.ui......
    config.visualizer.....
    config.date_time.....
    config.upload.......

1. Using Database class - this is use for MySqlClient configurations, sql statements, & etc. This will also included the loading of data to a form control including dataGridView and comboBox.

Requirements

MySql Server (Wamp Server)
Install MySql Connector .Net
After you installed MySQL Connector .Net, go to C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.27\Assemblies\v4.5.2\ and use the MySql.Data.dll as a reference for your project. Note: \v4.5.2\ is the .Net version of your project, you can use other version inside C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.27\Assemblies\ folder.
& Now you can use MySQLClient, Good Luck!

Using Database' Methods

Sql Statements

select(string qry) or select() method is use for select statements and this method return MySqlDataReader that reads a forward-only stream of rows from a MySQL database.

var reader = config.db.select("select * from users");
while (reader.Read())
{
    //reader["userid"].ToString();
}

save(string table, string[] column, string[] bind, string msg = "Successfully saved.") or save() method is use for insert into statements and does not return a value. This methods display a MessageBox for showing the result of your sql statement.

The table parameter is use to pass your table_name from your database, while column parameter is use to pass your collection of column_name from your database table, and the bind parameter is for the collection of values of the columns. Since the msg parameter has a default value, it is optional.

string[] column = { "username", "password", "sex" };
string[] value = { txtUsername.Text, txtPassword.Text, cmbSex.Text };
config.db.save("users", column, value); // config.db.save("users", column, value, "User successfully saved!");

cud(string qry, string msg = "Transaction Completed!") or cud() method is use for your insert into , update , and delete statements. This method also does not return a value. This methods display a MessageBox for showing the result of your sql statement, or passing your custom notification message (optional) using msg parameter.

config.db.cud("Sql Query Here","Custom Notification Message");
//or
config.db.cud("Sql Query Here");

Example:

config.db.cud("INSERT INTO users (username,password,sex) VALUES ('" + txtUsername.Text + "','" + txtPassword.Text + "','" + cmbSex.Text + "')","User successfully saved!");

table(string qry, DataGridView dgv, string[] header = null) or table() method is use for displaying data to a DataGridView Control using the DataSource properties.

The qry parameter use for your sql satement select. The dgv parameter is use to pass the name of your DataGridView Control, while the header parameter (optional) is use to display the collection of custom header name for your DataGridView display.

//using custom header
string[] customheader = { "User ID", "Username", "Gender" };
//the table methods
config.db.table("select userid,username,sex from users", dgvUsers, customheader); // dgvUsers is the name of your datagridview

//the table methods without custom header
config.db.table("select userid,username,sex from users", dgvUsers);

list(string qry, ComboBox comboBox) or list() method is use to display data to your comboBox control as an items.

config.db.list("select course_name from courses", cmbCourse); // cmbCourse is the name of your comboBox control

exist(string qry) or exist() method is use to validate if a data is existing in your database. It will return true if exist.

if(config.db.exist("select username from courses where username = '"+ txtusername.Text +"'"))
{
    MessageBox.Show("Username already exist!");
}else{
    // save
}

maxid(String column, String tbl) or maxid() method is use to get the last inserted id in your database. The column parameter is the name of the column you want to select, and the tbl parameter is your table name.

int id = config.db.maxid('userid', 'users'); // it will return an int value

2. Using Form_UI class -

This class includes the traditional way of displaying form. Also includes the advanced UI manipulation using MDI or Multiple Document Interface.

The Basic :

Show(Form frmNew, Form frmOld) or Show() method is simply use for displaying new Form and hiding active Form.

Behind the methods: frmain.Show(); this.Hide();

frmMain frmain = new frmMain();
config.ui.Show(frmain, this); // or config.ui.Show(new frmMain());

Dialog(Form frm) or Dialog() methods use for displaying Form as Dialog.

frmMain frmain = new frmMain();
config.ui.Dialog(frmain); // or config.ui.Show(new frmMain());

The MDI :

FormShow(Form frm, string dstyle = "Fill") or FormShow() methods is use for displaying form child to your MdiParent Form.

Instantiate an object dash of a form frmDashboard.

frmDashboard dash = new frmDashboard();

Passing object dash to the first parameter, and "Top" (DockStyle property value) to second parameter (Optional). Top property value is use for Dock properties of a form child. The default Dock property value is DockStyle.Fill or Fill.

config.ui.FormShow(dash, "Top");

// Fill
frmDashboard dash = new frmDashboard();
config.ui.FormShow(dash); // or config.ui.FormShow(new frmDashboard());

3. Using Visualizer class - use for visualization of data.

chart(Chart chart, string SeriesName, string[] x, int[] y, string chartType = "Column") or chart() method

The chart parameter is the name of your Chart Control. You can add a Serries by passing to SeriesName parameter and AddXY using x and y parameter. x is the legend, name or label of every data you want to display while y is the number value or count.