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