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();
}
}
