public int Save(utblMstTourPackageActivity activity)
{
int result = 0;
if (activity.PackageActivityID == 0)
{
try
{
_db.utblMstTourPackageActivities.Add(activity);
_db.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
}
}
else
{
utblMstTourPackageActivity dbEntry = _db.utblMstTourPackageActivities.Find(activity.PackageActivityID);
if (dbEntry != null)
{
dbEntry.ActivityID = activity.ActivityID;
dbEntry.OvernightDestinationID = activity.OvernightDestinationID;
dbEntry.OvernightDestination = activity.OvernightDestination;
dbEntry.ActivityRemarks = activity.ActivityRemarks;
}
_db.SaveChanges();
result = 1;
}
return(result);
}
public int ManageDayLost(short totalDays, short newDays, long id)
{
int result = 0;
utblMstTourPackageActivity obj = _db.utblMstTourPackageActivities.Where(R => R.DayNo == totalDays && R.PackageID == id).FirstOrDefault();
utblMstTourPackageActivity dbentry = _db.utblMstTourPackageActivities.Where(r => r.DayNo == newDays && r.PackageID == id).First();
int i = Convert.ToInt32(newDays + 1);
try
{
dbentry.ActivityID = obj.ActivityID;
dbentry.ActivityRemarks = obj.ActivityRemarks;
dbentry.OvernightDestinationID = obj.OvernightDestinationID;
for (int j = i; j <= totalDays; j++)
{
utblMstTourPackageActivity removeEntry = _db.utblMstTourPackageActivities.Where(r => r.DayNo == j && r.PackageID == id).First();
_db.utblMstTourPackageActivities.Remove(removeEntry);
}
_db.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 2;
}
return(result);
}
public utblMstTourPackageActivity GetTourPackageActivityByID(long id)
{
utblMstTourPackageActivity obj = _db.utblMstTourPackageActivities.FirstOrDefault(p => p.PackageActivityID == id);
return(obj);
}
