// delete with EF context stored procedure private bool delete_sitetype_dependants(long typeId) { // sp_typeId wll do delete type and depandants( rate, place, coord ) DataContext contextForProcedure = new DataContext(); ObjectParameter success = new ObjectParameter("success", typeof(bool)); ObjectParameter errMsg = new ObjectParameter("errMsg", typeof(string)); ObjectResult<sp_delete_sitetype_dependants_Result> rslt = contextForProcedure.sp_delete_sitetype_dependants(typeId, success, errMsg); rslt.ToList(); // can pass errMsg to html, if error condition success.Value.GetType(); return Convert.ToBoolean(success.Value); }
// save with EF context procedure : not currently used private bool saveCoordinatesWithProcedure() { DataContext contextForProcedure = new DataContext(); contextForProcedure.Configuration.AutoDetectChangesEnabled = false; Polygons poly = Polygons.GetInstance(); for (int i = 0; i < poly.Coords.Count; i++) { ObjectParameter success = new ObjectParameter("success", typeof(bool)); ObjectParameter errMsg = new ObjectParameter("errMsg", typeof(string)); //ObjectResult<sp_insert_coordinates_Result> rslt = contextForProcedure.sp_insert_coordinates(poly.Coords[i].eventId, // (int)poly.Coords[i].placeId, poly.Coords[i].seqCoordinate, poly.Coords[i].y, poly.Coords[i].x, // success, errMsg); //rslt.Dispose(); //rslt.ToList(); if (Convert.ToBoolean(success.Value) == true) return false; } contextForProcedure.Configuration.AutoDetectChangesEnabled = false; return true; }
// delete with EF context stored procedure public bool DeleteEventObjects(int eventId) { // sp_reset_event_derivatives wll do clear event related tables DataContext contextForProcedure = new DataContext(); ObjectParameter success = new ObjectParameter("success", typeof(bool)); ObjectParameter errMsg = new ObjectParameter("errMsg", typeof(string)); ObjectResult<sp_reset_event_derivatives_Result> rslt = contextForProcedure.sp_reset_event_derivatives(eventId, success, errMsg); rslt.ToList(); // can pass errMsg to html, if error condition success.Value.GetType(); return Convert.ToBoolean(success.Value); }