public int InsertRouteMark(RouteMark routeMark) { using (var db = new ServiceContext()) { if (routeMark.RouteSheet != null) { RouteSheet routeSheet = db.RouteSheets.FirstOrDefault(x => x.Barcode == routeMark.RouteSheet.Barcode); if (routeSheet != null) { routeMark.RouteSheetId = routeSheet.RouteSheetId; } else { db.Add(routeMark.RouteSheet); } } if (routeMark.RoutePoint != null) { RoutePoint routePoint = db.RoutePoints.FirstOrDefault(x => x.Name == routeMark.RoutePoint.Name); if (routePoint != null) { routeMark.RoutePointId = routePoint.RoutePointId; } else { db.Add(routeMark.RoutePoint); } } db.Add(routeMark); db.SaveChanges(); return(routeMark.RouteMarkId); } }
public void UpdateRouteMark(RouteMark routeMark) { using (var db = new ServiceContext()) { db.Update(routeMark); db.SaveChanges(); } }
public void DeleteRouteMark(int routeMarkId) { using (var db = new ServiceContext()) { RouteMark routeMark = new RouteMark { RouteMarkId = routeMarkId }; db.RouteMarks.Attach(routeMark); db.RouteMarks.Remove(routeMark); db.SaveChanges(); } }