server program load_server for form load using reftab assignments; using reftab drivers; //use the dacsem schema name using dacs statusUpdate; { var confirmedTask = db.assignments.Read({usr:form.user.name, status:"Confirmed"}).Single(); var dacsUpdate = messages.statusUpdate.New(); var statusUpdate = dacsUpdate.statusUpdate; statusUpdate.assignmentId = confirmedTask.assignment_id; var driver = db.drivers.Read({userid:confirmedTask.usr}).Single(); statusUpdate.driver.userId = driver.userid; statusUpdate.driver.name = driver.name; statusUpdate.oldStatus = confirmedTask.status; statusUpdate.changedAt = dtu.Now(); statusUpdate.photosNew(); foreach (var photo in form.root.loadDetails.Single().loadPhoto) { statusUpdate.photos.Add(photo.value.mediaid.ToStringN()); } statusUpdate.signature = form.root.Signature.Single().value.mediaid.ToStringN(); if(form.controlSubmit == form.root.loadCancel.load) { db.assignments.Update(confirmedTask,{status:"Loaded", load_type:form.root.loadDetails.Single().loadType.value, comments:form.root.loadDetails.Single().comments.value}); statusUpdate.newStatus = "Loaded"; } else { db.assignments.Update(confirmedTask,{status:"Cancelled", comments:form.root.loadDetails.Single().comments.value}); statusUpdate.newStatus = "Cancelled"; } dacsUpdate.Send(); }