using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;


public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void AddGoods(SqlString GoodsID,SqlString TypeName,
        SqlString Unit,SqlString GoodsName,SqlString Amount,SqlString Price,
        SqlString Description)
    {
        using ( SqlConnection cnn = new SqlConnection("context connection=true") )
        {
            SqlCommand cmd = new SqlCommand();
            string strType = " (SELECT TypeID FROM Tbl_TypesOfGoods WHERE TypeName='" + TypeName.ToString() + "')";
            string strUnit = " (SELECT UnitID FROM Tbl_Units WHERE UnitName='" + Unit.ToString() + "')";

            cmd.CommandText = "INSERT INTO Tbl_Goods(GoodsID, TypeID, UnitID, GoodsName, " +
                "Amount, Price, Description)" + " VALUES('" + GoodsID.ToString() + "'," +
                strType + "," + strUnit + ", '" + GoodsName.ToString() + "', '" +
                Amount.ToString() + "', '" + Price.ToString() + "', '" +
                Description.ToString() + "');";
           
            cmd.Connection = cnn;
            cnn.Open();
            cmd.ExecuteNonQuery();
            cnn.Close();
        }
    }
};