c# - Connecting SQL to FullCalendar -

-

मेरे पास इस लेआउट के साथ एक SQL सर्वर डाटाबेस है 

  टेबल (Giftee int UserEmail varchar 100) बीडीएडेट दिनांक ());

मैं एक पूर्ण दिन का ईवेंट बनाने के लिए इसे पूर्ण कैलेंडर से कनेक्ट करना चाहता हूं। मुझे एक प्रारंभ और समाप्ति समय की ज़रूरत नहीं है मैं पूर्ण कैलेंडर के लिए "आईडी" और "शीर्षक" फ़ील्ड के रूप में "Giftee" मान का उपयोग करने की कोशिश कर रहा हूं। मैं "full date" के लिए "शुरुआत" तिथि के रूप में "BDayDate" का उपयोग करने का भी प्रयास कर रहा हूं।

मैं संदर्भ के लिए इस पोस्ट का उपयोग कर रहा हूं

मेरे पास एक Events.cshtml पृष्ठ है: 

  @ {var origin = new DateTime (1970, 1, 1, 0, 0 , 0, 0); Var डीबी = डाटाबेस। ओपन ("टेबल"); Var zach = webSecurity.CurrentUserName; Var sql = "SELECT BDayDate, Giftee_Info से GIFtee WHERE UserEmail = @ 0"; Var परिणाम = db.Query (एसक्यूएल, ज़ैक); Var डेटा = परिणाम। चयन (x = & gt; नया {id = x.Giftee, title = x.Giftee, start = x.BDayDate.ToString ("yyyy-MM-dd"), allDay = true})। ToArray ( ); जेसन। लिखें (डेटा, प्रतिक्रिया। आउटपुट); Response.ContentType = "एप्लिकेशन / जेसन"; }

मेरे पास ईवेंट.cshtml पृष्ठ से कनेक्ट करने के लिए एक अलग कैलेंडर.cshtml पृष्ठ भी है। कैलेंडर पृष्ठ में यह कोड है: 

  & lt; स्क्रिप्ट & gt; $ (दस्तावेज़) .ready (फ़ंक्शन () {$ ('# कैलेंडर')। FullCalendar ({संपादन योग्य: झूठी घटनाएं: '/Events.cshtml'})}}; & Lt; / स्क्रिप्ट & gt;

जब मैं कैलेंडर का परीक्षण करता हूं, यह सही तरीके से खुलता है, लेकिन वर्तमान में एसक्यूएल तालिका में कोई भी दिनांक प्रदर्शित नहीं करता है। मुझे यकीन नहीं है कि कोड गलत कहां था। क्या मुझे बदलने या जोड़ने की जरूरत है? मुझे यकीन नहीं है कि मेरा कैलेंडर पृष्ठ और ईवेंट पृष्ठ ठीक से कनेक्ट हो रहा है।

Events.cshtml पृष्ठ @ {} के बाहर कुछ भी खाली 100% खाली होने की आवश्यकता है उपरोक्त कोड काम करेगा।


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Chart control: Design messed Up after clearing and re-adding Y-Values -

-
Image
The day was struggling with this. I have three series on a chart that looks like this. Note: I am using vanof control. They are being added on the basis of input from the calculation. I am using this code to add value to each series. this.chart1.Series ["green"]. Points. AddY (greenvalue); This.chart1.Series ["totalsaving"] Points.AddY (totalsavingvalue). This.chart1.Series ["blue"] Points.AddY (bluevalue). I have set series properties like this. Both green and totalsaving are set to StackedColumn, the blue chart is set to the column for type. I started then To do is a button that brings the user back to the input field and then I am using this code to clear the series values ​​on the start code. chart 1. Series ["totaling"]. Points. clear (); Chart1.Series ["green"] Points.Clear () .; Chart1.Series ["blue"] Points.Clear () .; The same calculation click above is being calculated for the calculation of th...
Read more

ruby on rails - Apipie interferes with proper error codes -

-
I can not find this little bit in the API's docs. Let me make this special AP ready, and I thought I would document it with APP, all fine and dandy, and the ultimate verification is good, but I feel that the response to failure in verification I can not seem to throw the right HTTP code in For example, I have this post / user method, which obviously makes the user in my database good, right? Well, this is something wrong, and it's ok, but if, say, I throw the standards that it does not pass the validity of the apipie, chops apipies and throws a good old-fashioned error, if something is wrong, 422 responds with a fixed unit failure / error: post '/users.json' ,: user = & gt; D Apipie :: ParamInvalid: Invalid parameter 'Email' value "": Regular expression / [a-zA-Z0-9 will match - -] + \ @ [a-zA-Z0-9 \ -.] + \. [Az] {2,} /. # ./spec/requests/usersapi_spec.rb:66:in `In Block (Level 3) & lt; Top (required) & gt; ' Let me assume ...
Read more