Breaking News: Grepper is joining You.com. Read the official announcement!

database connection mvc

Sore Sardine answered on April 22, 2024 Popularity 1/10 Helpfulness 3/10

answer database connection mvc

database connection mvc

Comment

using System;
using  VLE_MVC_2._0.Models;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.Common;

namespace  VLE_MVC_2._0.Services
{
    public class UsersDAO
    {
        string cnn = @"Data Source=localhost;Initial Catalog=dbTest;Integrated Security=True;Encrypt=False";

        public bool StaffFindUsernameandPassword(login user)//uses the staff login to test the database works currently
        {//the database would need to be changed to the staff table at a later data
            //username or USERNAME works
            //@Username or @USERNAME works, you can shorten this usr so long as in add parameters too.
            bool success = false;
            string sql = "select username, password from tblUsers WHERE username = @StaffUsr AND password = @StaffPass";//@blahblah is the variable name
            //uses System.Data.SqlClient Nuget extension
            using (SqlConnection conn = new SqlConnection(cnn))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Add("@StaffUsr", SqlDbType.VarChar, 40).Value = user.StaffUser;//sets filler variables in sql string
                cmd.Parameters.Add("@StaffPass", SqlDbType.VarChar, 40).Value = user.StaffPass;

                try
                {
                    conn.Open();
                    SqlDataReader reader = cmd.ExecuteReader();
                    success = true ? reader.HasRows : false;
                    conn.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }

            return success;

        }
        public bool AddUsernameandPassword(login user)
        {
            bool success = false;
            string insertSQL = "INSERT INTO tblStuUsers VALUES (@StuSignUpEmail, @StuSignUpPass, @Firstname, @Surname)";
            using (SqlConnection conn = new SqlConnection(cnn))
            {
                SqlCommand cmd = new SqlCommand(insertSQL, conn);
                cmd.Parameters.Add("@StuSignUpEmail", SqlDbType.VarChar, 40).Value = user.StuSignUpEmail;
                cmd.Parameters.Add("@StuSignUpPass", SqlDbType.VarChar, 50).Value = user.StuSignUpPass;
                cmd.Parameters.Add("@Firstname", SqlDbType.VarChar, 40).Value = user.FirstName;
                cmd.Parameters.Add("@Surname", SqlDbType.VarChar, 40).Value = user.Surname;
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    success = true;
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            return success;
        }
        public bool StuFindUsernameandPassword(login user)
        {
            bool success = false;
            string selectSQL = "select username, password from tblStuUsers WHERE username = @StuEmail AND password = @StuPass";
            using (SqlConnection conn = new SqlConnection(cnn))
            {
                SqlCommand cmd = new SqlCommand(selectSQL, conn);
                cmd.Parameters.Add("@StuEmail", SqlDbType.VarChar, 40).Value = user.StuEmail;
                cmd.Parameters.Add("@StuPass", SqlDbType.VarChar, 50).Value = user.StuPass;
                try
                {
                    conn.Open();
                    SqlDataReader reader = cmd.ExecuteReader();
                    success = true ? reader.HasRows : success = false;
                    conn.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            return success;
        }
    }
}

Popularity 1/10 Helpfulness 3/10 Language csharp

Source: Grepper

Tags: c# database-connection

Link to this answer
Share Copy Link

Contributed on Apr 22 2024

Sore Sardine

0 Answers Avg Quality 2/10

database connection mvc

Contents

More Related Answers

database connection mvc

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.