public int SavePackageRouting(long id, string route)
{
int result = 0;
utblMstTourPackage obj = _db.utblMstTourPackages.Find(id);
if (obj != null)
{
obj.PackageRouting = route;
_db.SaveChanges();
result = 7;
}
return(result);
}
public int Delete(long id)
{
int result = 0;
utblMstTourPackage obj = _db.utblMstTourPackages.Find(id);
try
{
_db.utblMstTourPackages.Remove(obj);
_db.SaveChanges();
result = 1;
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public void RaiseHitCount(long id)
{
long count = _db.utblMstTourPackages.Where(r => r.PackageID == id).Select(r => r.PackageHitCount).First();
count++;
utblMstTourPackage obj = _db.utblMstTourPackages.Find(id);
if (obj != null)
{
try
{
obj.PackageHitCount = count;
_db.SaveChanges();
}
catch (Exception ex)
{
}
}
}
public int Save(utblMstTourPackage tour)
{
int result = 0;
if (tour.PackageID == 0)
{
try
{
_db.utblMstTourPackages.Add(tour);
_db.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
}
}
else
{
utblMstTourPackage dbEntry = _db.utblMstTourPackages.Find(tour.PackageID);
if (dbEntry != null)
{
dbEntry.PackageName = tour.PackageName;
dbEntry.PackageRouting = tour.PackageRouting;
dbEntry.PickupPoint = tour.PickupPoint;
dbEntry.DropPoint = tour.DropPoint;
dbEntry.TotalDays = tour.TotalDays;
dbEntry.Price = tour.Price;
dbEntry.PackageTypeID = tour.PackageTypeID;
}
_db.SaveChanges();
result = 1;
}
return(result);
}
public utblMstTourPackage GetTourPackageByID(long id)
{
utblMstTourPackage obj = _db.utblMstTourPackages.FirstOrDefault(p => p.PackageID == id);
return(obj);
}
