Asp.Net MVC: With Product example 1

Web.config - Add the connection string

<connectionStrings>
    <add name="ProductDBConnectionString" connectionString="Data Source=LK-PRK\SQL2012DEV;Initial Catalog=ProductDB;Integrated Security=True"
        providerName="System.Data.SqlClient" />
  </connectionStrings>

Connections.cs - in Model section

using System.Configuration;
using System.Data.SqlClient;

namespace TestStock.Models
{
    public class Connection
    {
        public static SqlConnection GetConnection()
        {
            var conn = ConfigurationManager.ConnectionStrings["ProductDBConnectionString"].ConnectionString;
            return new SqlConnection(conn);
        }
    }
}
Products.cs - in Models section

namespace TestStock.Models
{
    public class Product
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public double Price { get; set; }
    }
}

ProductHelper.cs - in Model section

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace TestStock.Models
{
    public class ProductHelper
    {
        public static List<Product> GetProducts()
        {
            var conn = Connection.GetConnection();
            conn.Open();
            var cmd = new SqlCommand("SELECT * FROM Products", conn);
            SqlDataReader dr = cmd.ExecuteReader();
            var products = new List<Product>();
            while (dr.Read())
            {
                var p = new Product
                {
                    Id = int.Parse(dr.GetValue(0).ToString()),
                    Name = dr.GetValue(1).ToString(),
                    Price = double.Parse(dr.GetValue(2).ToString())
                };
                products.Add(p);
            }
            return products;
        }

        public static string AddProduct(Product product)
        {
            string message;
            try
            {
                var name = new SqlParameter("@name", product.Name);
                var price = new SqlParameter("@price", product.Price);

                var conn = Connection.GetConnection();
                conn.Open();

                var cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "AddProducts";

                cmd.Parameters.Add(name);
                cmd.Parameters.Add(price);

                cmd.ExecuteNonQuery();
                conn.Close();

                message = "Product Added !";
            }
            catch (Exception ex)
            {
                message = String.Format("Error: {0}", ex);
            }

            return message;
        }
    }
}

ProductsController - in Controller section

using System.Web.Mvc;
using TestStock.Models;

namespace TestStock.Controllers
{
    public class ProductsController : Controller
    {
        //
        // GET: /Products/

        public ActionResult Index()
        {
            var products = ProductHelper.GetProducts();
            return View(products);
        }

    }
}

Index - from Products Controller

@using TestStock.Models
@model List<Product>

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <div>
        <table>
            <tr>
                <td>Name: </td>
                <td><input id="txtProductName"/></td>
            </tr>
            <tr>
                <td>Price: </td>
                <td><input id="txtProductPrice" /></td>
            </tr>
            <tr>
                <td></td>
                <td><button id="btnAddProduct" onclick="AddProduct()">Add Product</button></td>
            </tr>
        </table>
        <br/>
        <table>
            <tr>
                <td>Id</td>
                <td>Name</td>
                <td>Price</td>
            </tr>
            @foreach (Product t in Model)
            {
                <tr>
                    <td>@t.Id</td>
                    <td>@t.Name</td>
                    <td>@t.Price</td>
                </tr>
            }
        </table>
    </div>
</body>
</html>




Comments

Post a Comment

Popular posts from this blog

Deploy Angular 8 app to Azure with Azure DevOps

Image
1. Create a Azure Web App. Use the following Configurations:      Runtime Stack: ASP.NET V4.7      Operating System: Windows You can select your own subscription plan, resource group and region.  2. Create a Git repository to hold the Angular app 2.1. Initialize your angular application 2.2. Commit and Push the code.  3. Create a Pipeline in Azure DevOps.  3.1. Login to the Azure DevOps. ( https://dev.azure.com/ ) 3.2. Create a project:          I'll select Private as visibility and Git as Version control.  NOTE: Azure DevOps provides different features.               For this task we are going to focus on Pipelines.  4. Pipeline Part 1: Integrate Git  From the Connect section select: Use the classic editor. 4.1. Select a Source as GitHub and authenticate with your GitHub account using OAuth.  4.2. Select your repository which holds the angular app. 4.3. Select the branch. This is the branch that Azure DevOps will
Read more

Apache ActiveMQ 5 with .Net Core 3.1 and C#

Image
Hi All..   In this post I'm going to explain how to use Apache ActiveMQ 5 (which is a popular Java based messaging server) for .Net Core 3.0+ with C#.  Let's get started. Prerequisites 1. Visual Studio (I'll be using 2019 Community)  2. .Net Core framework (I'll be using 3.1) 3. Java JDK or JRE Installed and Java Environment variable has been set (Since I'm doing in a Windows 10 computer)  Ok.. If you have the above requirements then let's get start the actual work. 1. Download and install ActiveMQ 5  Go to http://activemq.apache.org/components/classic/download/ and download according to your operating system.  I'll download .zip package for Windows 2. Copy the .zip file and put it inside a folder as you like or install with the installers if you download the installer.  If you got the .zip file like me; then extract it inside the folder that you paste the .zip file Then you will get a folder with the ActiveMQ package  3. Start the Active MQ Server  Open th
Read more

Firebase with.Net Core and C#

Image
Hi folks, Are you developing web applications with .net ? Are you supporting mobile applications to communicate with your applications ? Are you thinking of providing realtime capabilities with your apps? Then I suggest you to read on Firebase Real-Time Dataabses by Google. " The Firebase Realtime Database is a cloud-hosted database. Data is stored as JSON and synchronized in realtime to every connected client. " - Google Firebase Team Read more:  https://firebase.google.com/docs/database/ In this post I'm going to discuss what is firebase but I'm going to discuss how to work with it with .Net C#. Firebase doesn't provide a separate library or a nugget to work with .Net, so you might find this bit tricky when you have to work with it from the backend. Senario To demonstrate the solution I will create a scenario. In my scenario we have created a video call function (which is implemented with OpenTok library) and it allows users to create sessions and i
Read more