protected void Button1Click(object sender, DirectEventArgs e) { SpacialDataSet sd = new SpacialDataSet(); sd.vehicule = vehicule.Text; sd.dateDepart = DateTime.Parse(dateDepart.Text) + TimeSpan.Parse(HD.Text); sd.dateArivee = DateTime.Parse(dateArivee.Text) + TimeSpan.Parse(HA.Text); if (pm.Checked == true) { SqlGeometry sqlG = SqlGeometry.Parse(trajet.Text); sd.trajet = DbGeometry.FromBinary(sqlG.STAsBinary().Buffer); } else if (pm.Checked == false) { SqlGeometry sqlG = SqlGeometry.Parse(trajet.Text); sd.trajet = DbGeometry.FromBinary(sqlG.STAsBinary().Buffer); } sd.active = (bool?)SqlBoolean.Parse(active.Text); db = new demoDB(); db.SpacialDataSets.Add(sd); db.SaveChanges(); X.Msg.Alert("INFO", "l'opération a été effectuée avec succès").Show(); ResetInputs(); Store1.Reload(); X.Call("resetMap"); }
protected void deleteRow(object sender, DirectEventArgs e) { db = new demoDB(); string varID = e.ExtraParams["Id"]; var ID = int.Parse(varID); SpacialDataSet sd = (from i in db.SpacialDataSets where i.Id == ID select i).SingleOrDefault(); sd.active = false; db.SaveChanges(); //ChargeGridPanel(); Store1.Reload(); }
protected void RowSelect(object sender, DirectEventArgs e) { string varID = e.ExtraParams["Id"]; SpacialDataSet sd = SpacialDataSet.GetSpacialDataSet(int.Parse(varID)); frmInfo.SetValues(new { sd.vehicule, sd.dateDepart, sd.dateArivee, V = trajet.Text = sd.trajet.AsText() }); X.Call("getTrajetFromDb"); }