public bool LocationDelete(Location location)
{
return Execute<bool>(dal =>
{
Location locationDelete = dal.Location.Where(x => x.LocationID == location.LocationID).FirstOrDefault();
if (locationDelete != null)
{
dal.Location.DeleteOnSubmit(locationDelete);
dal.SubmitChanges();
return true;
}
return false;
});
}
public bool LocationAdd(Location location)
{
return Execute<bool>(dal =>
{
Location locationAdd = dal.Location.Where(x => x.LocationID == location.LocationID).FirstOrDefault();
if (locationAdd != null)
{
dal.Location.InsertOnSubmit(locationAdd);
dal.SubmitChanges();
return true;
}
return false;
});
}
public bool LocationUpdate(Location location)
{
return Execute<bool>(dal =>
{
Location locationUpdate = dal.Location.Where(x => x.LocationID == location.LocationID).FirstOrDefault();
if (locationUpdate != null)
{
locationUpdate.LocationID = location.LocationID;
locationUpdate.Name = location.Name;
locationUpdate.CostRate = location.CostRate;
locationUpdate.Availability = location.Availability;
locationUpdate.ModifiedDate = location.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
});
}
partial void DeleteLocation(Location instance);
partial void UpdateLocation(Location instance);
partial void InsertLocation(Location instance);
public void LocationUpdate(Location location)
{
adventureWorks_BC.LocationUpdate(location);
}
public void LocationAdd(Location location)
{
adventureWorks_BC.LocationAdd(location);
}
