Databases
StackOverflow2013
Postsdbo
POAjax function doesn't seem working
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAjax function doesn't seem working
    primarykey
    data
    text
    <p>I'm developing an online application of tennis club management... (MVC 3, Entity Framework Code first,...) </p> <p>I've an Interface that allows the user to consult the <strong>available tennis court</strong> :</p> <p><img src="https://i.stack.imgur.com/lmqeo.jpg" alt="enter image description here"></p> <p><strong>In my "AvailableCourtController", I've a function which return the tennis courts :</strong></p> <pre><code> [HttpPost] public JsonResult GetTennisCourt(DateTime date) { var reservations = db.Reservations.Include(c =&gt; c.Customer); foreach (var reservation in reservations) { //Verify that a court is available or not if (reservation.Date ==date) { if (date.Hour &gt; reservation.FinishTime.Hour || date.Hour &lt; reservation.StartTime.Hour) { var id = reservation.TennisCourtID; TennisCourt tennisCourt = (TennisCourt) db.TennisCourts.Where(t =&gt; t.ID == id); tennisCourt.Available = true; db.Entry(tennisCourt).State = EntityState.Modified; db.SaveChanges(); } else { var id = reservation.TennisCourtID; TennisCourt tennisCourt = (TennisCourt) db.TennisCourts.Where(s =&gt; s.ID == id); tennisCourt.Available = false; db.Entry(tennisCourt).State = EntityState.Modified; db.SaveChanges(); break; } } } var courts = from c in db.TennisCourts select c; courts = courts.OrderBy(c =&gt; c.ID); return Json(courts, JsonRequestBehavior.AllowGet ); } </code></pre> <p><strong>So, I would like to change the color of my label if the tennis court is busy or free... For that I use "Ajax":</strong> </p> <p><em>"View"</em> <em>(What I've tried to make)</em></p> <pre><code>&lt;input id="datePicker" type= "text" onchange="loadCourts"/&gt; &lt;script type="text/javascript"&gt; $('#datePicker').datetimepicker(); &lt;/script&gt; &lt;script type="text/javascript"&gt; function loadCourts() { var myDate = $('#datePicker').value(); $.ajax({ url: ("/AvailableCourt/GetTennisCourt?date=myDate "), success: function (data) { alert('test'); //change label's color } }); } &lt;/script&gt; </code></pre> <p>I never get the message "test"... So I have make something wrong with my Ajax function or my controller's method... My goal is to get the tennis court, check if they're free or not and change color in red if busy, and in green if free...</p> <p><strong>Can you help me to find what I'm doing wrong please?</strong> Sorry :( But I'm a beginner with Ajax...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRazor
    1. USRazor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAjax function doesn't seem working
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAre you seeing any JS errors with firebug/chrome dev tools? Have you tried putting a break point on the var myDate = line and seeing if it reaches there?
      singulars
      1. POAjax function doesn't seem working
      1. USShane Courtrille
    2. COAlso.. using things like onchange is considered bad practice.. it's better to do $(document).ready(function () { $('#datePicker').change(loadCourts); });
      singulars
      1. POAjax function doesn't seem working
      1. USShane Courtrille
    3. COYes, I'm using firebug, I never reach the "Ajax" function... But my "js" function seems working...
      singulars
      1. POAjax function doesn't seem working
      1. USRazor
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload