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 UpdateRoutePoint(RoutePoint routePoint)
{
using (var db = new ServiceContext())
{
db.Update(routePoint);
db.SaveChanges();
}
}
public int InsertRoutePoint(RoutePoint routePoint)
{
using (var db = new ServiceContext())
{
db.Add(routePoint);
db.SaveChanges();
return(routePoint.RoutePointId);
}
}
public void DeleteRoutePoint(int routePointId)
{
using (var db = new ServiceContext())
{
RoutePoint routePoint = new RoutePoint {
RoutePointId = routePointId
};
db.RoutePoints.Attach(routePoint);
db.RoutePoints.Remove(routePoint);
db.SaveChanges();
}
}