using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.OleDb;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

    }

    public static long SaveFileData()

        {

            SqlConnection con = new SqlConnection("Data Source=[SERVERNAME];Initial Catalog=[DATABASENAME];Integrated Security=True");

            SqlCommand cmd = new SqlCommand("SPNAME", con);

            long fileid = 0;

            try

            {

​

                cmd.CommandType = CommandType.StoredProcedure;

                //cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = uploadedFile.MerchantId;

                //cmd.Parameters.Add("@Createddate", SqlDbType.DateTime).Value = DateTime.Now;

​

                if (con.State != ConnectionState.Closed)

                {

                    con.Close();

                }

                con.Open();

                cmd.ExecuteNonQuery();

                fileid = Convert.ToInt64(cmd.Parameters["@fileid"].Value.ToString());

​

            }

            catch (Exception exc)

            {

                Console.WriteLine(exc.Message);

            }

            finally

            {

                if (con.State != ConnectionState.Closed)

                {

                    con.Close();

                }

            }

            return fileid;

        }

}