ASP.NET

C:\Windows\system32>svcutil.exe /language:vb /out:D:\WSDLRepository-Proxy\DocRetrieveService\DocRetrieveService.vb /config:D:\source\SourceCode\StayatWork-VS2010\BusinessLogicLayer\app.config http://xxxxxxtumecr21:8000/FilenetDocRetrieve/DocRetrieveService?wsdl
command

I am getting the below error

WS-Metadata Exchange Error
    URI: http://xxxxxtumecr21:8000/FilenetDocRetrieve/DocRetrieveService?wsdl

    Metadata contains a reference that cannot be resolved: 'http://lnidaptumecr21:8000/FilenetDocRetrieve/DocRetrieveService?wsdl'.

    <?xml version="1.0" encoding="utf-16"?><Fault xmlns="http://www.w3.org/2003/05/soap-envelope"><Code><Value>Sender</Value><Subcode><Value xmlns:a="http://www.w3.org/2005/08/addressing">a:ActionNotSupported</Value></Subcode></Code><Reason><Text xml:lang="en-US">The message with Action 'http://schemas.xmlsoap.org/ws/2004/09/transfer/Get' cannot be processed at the receiver, due to a ContractFilter mismatch at the EndpointDispatcher. This may be because of either a contract mismatch (mismatched Actions between sender and receiver) or a binding/security mismatch between the sender and the receiver.  Check that sender and receiver have the same contract and the same binding (including security requirements, e.g. Message, Transport, None).</Text></Reason></Fault>


HTTP GET Error
    URI: http://xxxxxtumecr21:8000/FilenetDocRetrieve/DocRetrieveService?wsdl

    The document was understood, but it could not be processed.
  - The WSDL document contains links that could not be resolved.
  - There was an error downloading 'http://localhost:8000/FilenetDocRetrieve/DocRetrieveService?wsdl=wsdl0'.
  - Unable to connect to the remote server
  - No connection could be made because the target machine actively refused it 127.0.0.1:8000

If you would like more help, type "svcutil /?" 

svcutil.exe /language:vb /out:D:\WSDLRepository-Proxy\DocRetrieveService\DocRetrieveService.vb /config:D:\source\SourceCode\StayatWork-VS2010\BusinessLogicLayer\app.config http://lnidaptumecr21:8000/FilenetDocRetrieve/DocRetrieveService?wsdl
Command 

I am getting the following error

Error: An error occurred in the tool.

Error: The given path's format is not supported.

Quote:

Microsoft Office Excel cannot access the file 'C:\usr\SVN\ePROM\EffOnePMA\Files\QuestionStructure.xls'.

There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

private void DownLoadStrcture()
        {
            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Workbook xlTempWorkBook;
            Excel.Worksheet xlWorkSheet;
            Excel.Range range;
            range = null;
            int rCnt = 2;
            int cCnt = 2;
            string str;
            string fname = "QuestionStructure.xls";
            string Filepath = Server.MapPath("~/Files/" + fname);
            string TempFilename = "QuestionStructure_ " + Convert.ToInt32(Session[PageBase.SESSION_USER_ID]) + ".xls";
            string TempFilepath = Server.MapPath("~/Files/Temp/" + TempFilename);
            string dep = ddlDepartment.SelectedItem.Text.ToString();
            string area = ddlArea.SelectedItem.Text.ToString();
            string category = ddlCategory.SelectedValue != "-1" ? ddlCategory.SelectedItem.Text : "";
            string subCategory = ddlSubCategory.SelectedValue != "-1" ? ddlSubCategory.SelectedItem.Text : "";

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open(Filepath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
            range = xlWorkSheet.UsedRange;
            File.Copy(Filepath, TempFilepath);

            xlWorkBook.Close();
            xlApp.Quit();
            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);

            xlApp = new Excel.Application();
            xlTempWorkBook = xlApp.Workbooks.Open(TempFilepath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlTempWorkBook.Worksheets.get_Item(1);
            range = xlWorkSheet.UsedRange;

            str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2;
            string[] stringArray = new string[] { dep, area, category, subCategory };
            for (int i = 0; i < stringArray.Length; i++)
            {
                (range.Cells[rCnt, cCnt] as Excel.Range).Value2 = stringArray[i].ToString();
                str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2;
                rCnt++;
            }
            xlApp.DisplayAlerts = false;
            xlApp.ScreenUpdating = false;
            xlApp.Visible = false;
            xlApp.UserControl = false;
            xlApp.Interactive = false;
            string Deletefilepath = Server.MapPath("~/Files/Temp/");
            if (File.Exists(Deletefilepath + TempFilename))
                File.Delete(Deletefilepath + TempFilename);

            xlTempWorkBook.Close(SaveChanges: true);
            Marshal.ReleaseComObject(xlTempWorkBook);
            xlApp.Quit();
            GC.Collect();
            GC.WaitForPendingFinalizers();
            Marshal.FinalReleaseComObject(xlTempWorkBook);
            Marshal.FinalReleaseComObject(range);
            Marshal.FinalReleaseComObject(xlApp);
            
        }

System.ServiceModel.ProtocolException: The content type text/html of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>500 - Internal server error.</title>
<style type="text/css">
<!--
body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}
fieldset{padding:0 15px 10px 15px;} 
h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0;color:#CC0000;} 
h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;} 
#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
background-color:#555555;}
#content{margin:0 0 0 2%;position:relative;}
.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}
-->
</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
 <div class="content-container"><fieldset>
 '. ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
   at System.Net.HttpWebRequest.GetResponse()
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace: 
   at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
   at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at WA.LNI.StayAtWork.Public.Web.StayAtWorkServiceReference.IStayAtWorkService.SetContactInfo(UserInfo userInfo)
   at WA.LNI.StayAtWork.Public.Web.StayAtWorkServiceReference.StayAtWorkServiceClient.SetContactInfo(UserInfo userInfo) in D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\Service References\StayAtWorkServiceReference\Reference.vb:line 2848
   at WA.LNI.StayAtWork.Public.Web.JSONProxyService.SetContactInfoJSON(UserInfo dto) in D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\JSONProxyService.svc.vb:line 359

try
{
    sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
    sql_connection.Open();
    sql_command = new MySqlCommand("sp_add_support_ticket", sql_connection);
    sql_command.CommandType = CommandType.StoredProcedure;

    sql_command.Parameters.AddWithValue("param_support_incident_title", txtSubject.Text);
    sql_command.Parameters.AddWithValue("param_email_address", txtEmailAddress.Text);
    sql_command.Parameters.AddWithValue("param_support_ticket_description", txtMessage.XHTML);

    int result_rows = sql_command.ExecuteNonQuery();

    Session["message_title"] = "Thank you";
    Session["message_title_Color"] = Color.Blue.ToArgb();
    Session["message_text"] = "We have recieved your feedback and we will get back to you as soon as possible.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = "Home.aspx";

    Response.Redirect("Message.aspx", false);
}
catch (Exception exp)
{
    Session["message_title"] = "Error";
    Session["message_title_Color"] = Color.Red.ToArgb();
    Session["message_text"] = "Unable to send your message. Please try again later.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = Request.UrlReferrer.ToString();

    Response.Redirect("Message.aspx", false);
}
finally
{
    if (sql_connection != null)
    {
        if (sql_connection.State == ConnectionState.Open)
            sql_connection.Close();
    }
}

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_support_ticket`(IN `param_support_incident_title` varchar(255),IN `param_email_address` varchar(255),IN `param_support_ticket_description` text)
BEGIN
	INSERT INTO support_incidents (support_incident_title, email_address) VALUES (param_support_incident_title, param_email_address);
	INSERT INTO support_tickets (support_incident_id, support_ticket_description) VALUES (LAST_INSERT_ID(), param_support_ticket_description);
END

in support_incodents table with "Thank you" in support_incident_title field

in support_tickets table with "We have recieved your feedback and we will get back to you as soon as possible." in support_ticket_description field