public ViewActivity GetActivity(int activityId)
{
ViewActivity viewActivity = new ViewActivity();
using (OnATripEntities tr = new OnATripEntities())
{
var dbActivity = (from a in tr.Activities where a.ActivityID == activityId select a).FirstOrDefault();
Mapper.Map(dbActivity, viewActivity);
}
return viewActivity;
}
public ViewActivity CreateActivity(ViewActivity viewActivity,int id)
{
// nacteni spravneho tripID ktere se overi v controlleru ze uzivatel je
// vlastnikem tohoto vyletu
viewActivity.TripID = id;
using (OnATripEntities tr = new OnATripEntities())
{
Activity dbActivity = tr.Activities.Add(Mapper.Map<Activity>(viewActivity));
var point = string.Format("POINT({1} {0})", viewActivity.gps.lat, viewActivity.gps.lon);
dbActivity.GPS = System.Data.Entity.Spatial.DbGeography.FromText(point);
tr.SaveChanges();
viewActivity.ActivityID = dbActivity.ActivityID;
}
return viewActivity;
}
public ViewActivity UpdateActivity(ViewActivity viewActivity, int id)
{
using (OnATripEntities tr = new OnATripEntities())
{
Activity dbActivity = tr.Activities.Where(act => act.ActivityID == id).Select(act => act).FirstOrDefault();
tr.ActivityActivityTypeMaps.RemoveRange(tr.ActivityActivityTypeMaps.Where(at => at.ActivityID == id));
tr.SaveChanges();
// odstranim z viewActivity objekty activityType, aby se znovu nepridaly do activityType
foreach (var at in viewActivity.activityActivityTypeMaps)
{
at.activityType = null;
}
Mapper.Map(viewActivity, dbActivity);
dbActivity.ActivityID = id;
var point = string.Format("POINT({1} {0})", viewActivity.gps.lat, viewActivity.gps.lon);
dbActivity.GPS = System.Data.Entity.Spatial.DbGeography.FromText(point);
tr.SaveChanges();
}
return viewActivity;
}
public ViewActivity Update(ViewActivity activity)
{
ICollection<ViewActivity> activities = new HashSet<ViewActivity>();
using (OnATripEntities tr = new OnATripEntities())
{
Activity activityDb = tr.Activities.Where(a => a.ActivityID == activity.ActivityID).Select(a => a).FirstOrDefault();
Mapper.Map(activity, activityDb);
//tr.Entry(u1).State = System.Data.Entity.EntityState.Modified;
tr.SaveChanges();
}
return activity;
}
public ViewActivity UpdateActivity(ViewActivity activity, int id)
{
// id = activityId
return activityRepo.UpdateActivity(activity, id);
}
public ViewActivity CreateActivity(ViewActivity activity, int id)
{
// id = tripId
return activityRepo.CreateActivity(activity,id);
}