ASP.NET

Re: MVC Razor, routevalues [solved]

5-Feb-16 4:37

Presumably because "action" is already defined in the route as the name of the controller action you're calling?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

jkirkerx5-Feb-16 6:28

jkirkerx

5-Feb-16 6:28

There it is!
I looked at it several times, thought maybe I needed a new route.

There I go again taking the examples literally. I need to stop that, but in foresight I will get the hang of MVC. I'm starting to like this MVC, but less time to write things.

At least I'm typing out c# pretty naturally now without having to lookup things.

Thanks Richard for pointing that out!
Wink | ;)

routes.MapRoute(
                name: "Default",
                url: "{controller}/{action}/{id}",
                defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
            );

DetailsView - Dropdown in ItemTemplate

Member 121716134-Feb-16 2:51

Member 12171613

4-Feb-16 2:51

MS SQL Server 2012 Database

Table = ZoningInfo

Field = DistrictID from Table ZDistrict

Would like to display DistrictDesc instead of DistrictID in DetailsView.

Changed the Text Box to a DropDownbox.

When I display the page is shows the dropdown but not the underlying DistrictID/DistrictDesc. It displays the first item in the List for ZDistrict.

Any Help would be great.

Thanks

Jack

ZurdoDev4-Feb-16 4:17

ZurdoDev

4-Feb-16 4:17

I don't understand what you are asking.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 121716134-Feb-16 4:36

Member 12171613

4-Feb-16 4:36

Asp.net detailview
The table that is connected to it has a field called District.
That field is populated from another table called Zdistrict.
The bound field is DistrictID.
I want to display the description(distdesc) instead of the number. I was thinking of using a drop down to do this.
How do I get this to work?
Thanks

ZurdoDev4-Feb-16 4:51

ZurdoDev

4-Feb-16 4:51

Member 12171613 wrote:
I want to display the description(distdesc) instead of the number.

But where are you stuck? If you have code that is showing a field from your database and you want it to be a different field, then change the field. Where is the issue?

There are only 10 types of people in the world, those who understand binary and those who don't.

Richard Deeming4-Feb-16 4:35

Phone system dashboard (Broadsoft)

4-Feb-16 4:35

If I'm reading that correctly, your list is binding to the table, but not selecting the correct value. If that's the case, it sounds like you're missing the binding on the SelectedValue property of the list:

aspx

<asp:DropDownList id="DistrictList" runat="server"
    DataSourceID="..."
    DataValueField="DistrictID"
    DataTextField="DistrictDesc"
    SelectedValue='<%# Bind("DistrictID") %>'
/>

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

dannyvkempen3-Feb-16 21:15

dannyvkempen

3-Feb-16 21:15

Hi All,

I am trying to build an telephone central dashboard (broadsoft).
This system is using httpwebrequests to select data.

First i need to build an channel to broadsoft. This works correct. I do get an channelId and expire time back from this server.

Then i would like to subscribe an event over this channel. When i try that i get an error that the channel that i just made doesn't exist (expiry time for this channel did not expired).

This is my code:

1. URL

public DataSet EventRequest(string request, string id = null)
    {
        string method = string.Empty;
        string url = string.Empty;
        string xml = string.Empty;
        bool chunked = false;

        switch (request)
        {
            case "CreateEventChannel":
                method = "POST";
                url = "http://xsp.voipit.nl/com.broadsoft.async/com.broadsoft.xsi-events/v2.0/channel/";
                xml = "<?xml version='1.0' encoding='UTF-8'?><Channel xmlns='http://schema.broadsoft.com/xsi'><channelSetId>SomeChannelSetId</channelSetId><priority>1</priority><weight>50</weight><expires>3600</expires></Channel>";
                chunked = true;
                break;             
            case "CreateSubscription":
                method = "POST";
                url = "http://xsp.voipit.nl/com.broadsoft.xsi-events/v2.0/user/<userId>";
                xml = "<?xml version='1.0' encoding='UTF-8'?><Subscription xmlns='http://schema.broadsoft.com/xsi'> <targetIdType>User</targetIdType> <event>Standard Call</event> <expires>300000</expires> <channelSetId>SomeChannelSetId</channelSetId> <applicationId>SomeApplicationId</applicationId></Subscription>";
                break;
            default:
                url = "";
                break;
        }

        return GetData(url, method, xml, chunked);
    }

2. Request method

public DataSet GetData(string destinationUrl, string method = null, string requestXml = null, bool chunked = false)
    {
        string output = string.Empty;
        HttpWebRequest request = (HttpWebRequest)WebRequest.Create(destinationUrl);
        request.ProtocolVersion = HttpVersion.Version10;
        request.KeepAlive = true;
        request.Timeout =
        request.ReadWriteTimeout = 60000;
        request.Accept = @"application/xml";
        request.PreAuthenticate = true;
        request.ContentType = "application/xml; encoding='utf-8'";        
        request.SendChunked = chunked;
        request.Method = method;        
        request.Credentials = new NetworkCredential(WebConfigurationManager.AppSettings["Username"], WebConfigurationManager.AppSettings["Password"]);
        
        if (requestXml != string.Empty)
        {
            byte[] bytes;
            bytes = System.Text.Encoding.ASCII.GetBytes(requestXml);
            request.ContentLength = bytes.Length;
            Stream requestStream = request.GetRequestStream();
            requestStream.Write(bytes, 0, bytes.Length);            
        }      

        return CreateRequestDataSet(request);
    }

3. Get data

public DataSet CreateRequestDataSet(HttpWebRequest request)
    {
        string output = string.Empty;
        HttpWebResponse response = null;
        try
        {
            response = (HttpWebResponse)request.GetResponse();
            WebHeaderCollection header = response.Headers;
            string StatusCode           = Convert.ToString(response.StatusCode);
            string StatusDescription    = response.StatusDescription;            
        }
        catch (WebException e)
        {
            using (WebResponse responseTest = e.Response)
            {
                HttpWebResponse httpResponse = (HttpWebResponse)responseTest;
                string ErrorCode = httpResponse.StatusCode.ToString();
                using (Stream data = responseTest.GetResponseStream())
                using (var reader = new StreamReader(data))
                {
                    string ErrorResponse = reader.ReadToEnd();                    
                }
            }
        }

        try
        {
            var encoding = ASCIIEncoding.UTF8;
            using (var reader = new System.IO.StreamReader(response.GetResponseStream(), encoding))
            {
                output = reader.ReadToEnd();
            }
        }
        catch (Exception) { }


        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        using (StringReader stringReader = new StringReader(output))
        {
            if (output != string.Empty)
            {
                ds = new DataSet();
                try
                {
                    ds.ReadXml(stringReader);
                }
                catch (Exception) { }
            }
        }

        return ds;
    }

Can someone maybe tell me why my channel doesn't exist anymore when i call CreateSubscription

Re: Phone system dashboard (Broadsoft)

Richard Deeming4-Feb-16 1:36

4-Feb-16 1:36

Does the site you're calling rely on cookies? If so, you'll need to find a way to pass the same CookieContainer[^] instance to the HttpWebRequest.CookieContainer property[^] for both the channel and subscription requests. How you do that depends on how you're calling the code.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Populate word with data

Praveen Kandari3-Feb-16 0:05

Praveen Kandari

3-Feb-16 0:05

Hi, I have a word document i.e. the report I want. I have already written the lines i want in my document. The issue is I have 15 such files and I want to populate those documents with data from SQL.

Is there any way to populate document with sql data. Not talking about export to word.
Using Asp.net
SQL 2012

TIA

Nathan Minier3-Feb-16 1:17

Nathan Minier

3-Feb-16 1:17

Sure, use OpenXML.

There's a quick intro at:
How to: Open and add text to a word processing document (Open XML SDK)[^]

Praveen Kandari3-Feb-16 1:20

Praveen Kandari

3-Feb-16 1:20

Thanks is there any expample online?? and will this dll cause any issue after publishing in server???

Nathan Minier3-Feb-16 2:21

Nathan Minier

3-Feb-16 2:21

Yes, please feel free to Google them at your leisure.

As for causing issues....like what? I honestly don't know a blessed thing about your server infrastructure and if adding document processing libraries has been known to cause it problems, I daresay that you have bigger issues to address than report generation.

Praveen Kandari3-Feb-16 18:11

Praveen Kandari

3-Feb-16 18:11

Thank you for your wonderful reply. by issue I mean Last time I used Interop and after publishing my code in server I was unable to generate any reports...

Richard Deeming4-Feb-16 1:31

4-Feb-16 1:31

Office Interop is not supported in ASP.NET, or any other unattended application:

Considerations for server-side Automation of Office[^]

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

OpenXML is supported, and doesn't require Office to be installed on the server.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer