C#

 CREATE PROCEDURE spGetMiti (
@engdate varchar(10)
) with encryption AS
BEGIN
   DECLARE @RC int
   DECLARE @RomanDate DATETIME
   DECLARE @PrnLine nvarchar (4000)

   EXEC @RC = [HRDB].[dbo].[s_GetNepaliDate] @engdate, @RomanDate OUTPUT
   SELECT @PrnLine = isnull(CONVERT(nvarchar, @RomanDate, 111), '')
   SELECT @PrnLine [Tarikh]
 END

EXEC spGetMiti '1978/02/03'

private string _engdate = string.Empty;
        public string Engdate
        {
            get { return _engdate; }
            set {
                if (value.Length < 10)
                {
                    throw new Exception("Correct date is required");
                } _engdate = value;
            }
        }

        public DataTable GetMiti()
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@engdate", _engdate)
            };
            return DAO.GetTable("spGetMiti", null);
        }

MtCommon mtcom = new MtCommon();
     mtxtDOB.Text = string.Empty;
     mtcom.Engdate = mtxtEngDate.Text;
     DataTable dt = mtcom.GetMiti();
     mtxtDOB.Text = dt.Rows[0]["Tarikh"].ToString();

<rewrite>
            <rules>
                <rule name="http to https" stopProcessing="true">
                    <match url="(.*)" />
                    <conditions>
                        <add input="{HTTPS}" pattern="^off$" />
                    </conditions>
                    <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Found" />
                </rule>
            </rules>
        </rewrite>

'Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.VCCodeModel.VCCodeModel'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{A590E96B-CC8C-48AF-9E8F-7C3FE7865586}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155).'

private void buttonExtract_Click(object sender, EventArgs e)
{
    EnvDTE80.DTE2 dte2 =
        (DTE2) System.Runtime.InteropServices.Marshal.GetActiveObject("VisualStudio.DTE.15.0");

    int Count = dte2.Solution.Projects.Count;
    Project P = null;
    Project FW32 = null;

    for (int a = 1; a <= Count; a++)
    {
        P = dte2.Solution.Projects.Item(a);

        if (P.FullName.Contains("ConsoleApplication"))
        {
            break;
        }
    }

    VCCodeModel vcCodeModel = (VCCodeModel) P.CodeModel; // <<<<< BOMBS HERE WITH THE ERROR ABOVE (P is not null)
}