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 UpdateRouteSheet(RouteSheet routeSheet) { using (var db = new ServiceContext()) { db.Update(routeSheet); db.SaveChanges(); } }
public int InsertRouteSheet(RouteSheet routeSheet) { using (var db = new ServiceContext()) { db.Add(routeSheet); db.SaveChanges(); return(routeSheet.RouteSheetId); } }
public void DeleteRouteSheet(int routeSheetId) { using (var db = new ServiceContext()) { RouteSheet routeSheet = new RouteSheet { RouteSheetId = routeSheetId }; db.Attach(routeSheet); db.Remove(routeSheet); db.SaveChanges(); } }