public int Save(utblMstTourPackagePic photo) { int result = 0; if (photo.PackagePhotoID == 0) { try { _db.utblMstTourPackagePics.Add(photo); _db.SaveChanges(); result = 1; } catch (Exception ex) { result = 0; } } else { utblMstTourPackagePic dbEntry = _db.utblMstTourPackagePics.Find(photo.PackagePhotoID); if (dbEntry != null) { dbEntry.PhotoNormal = photo.PhotoNormal; dbEntry.PhotoThumb = photo.PhotoThumb; dbEntry.PhotoDescription = photo.PhotoDescription; } _db.SaveChanges(); result = 1; } return(result); }
public void MakeDefaultPhoto(long id, long packid) { utblMstTourPackagePic obj = _db.utblMstTourPackagePics.Find(id); utblMstTourPackagePic objOldPic = _db.utblMstTourPackagePics.Where(x => x.PackageID == packid && x.IsDefault == true).FirstOrDefault(); if (objOldPic != null) { objOldPic.IsDefault = false; } obj.IsDefault = true; _db.SaveChanges(); }
public ActionResult ManageTourMap(long id) { utblMstTourPackagePic pic = dbPhoto.GetDefaultPhoto(id); if (pic == null) { TempData["ErrMsg"] = 6; return(RedirectToAction("ManageTourPhotos", new { id = id })); } MstTourPackageMapModel obj = new MstTourPackageMapModel(); obj.MstTourPackage = dbTour.GetTourPackageDetailsByID(id); obj.MstTourPackageMap = dbMap.GetTourMapByID(id); return(View("ManageTourMap", obj)); }
public int Delete(long id) { int result = 0; utblMstTourPackagePic obj = _db.utblMstTourPackagePics.Find(id); try { _db.utblMstTourPackagePics.Remove(obj); _db.SaveChanges(); result = 1; return(result); } catch (Exception ex) { return(result); } }
public utblMstTourPackagePic GetDefaultPhoto(long packid) { utblMstTourPackagePic obj = _db.utblMstTourPackagePics.Where(x => x.PackageID == packid && x.IsDefault == true).FirstOrDefault(); return(obj); }
public utblMstTourPackagePic GetPhotoDetailsByID(long id) { utblMstTourPackagePic obj = _db.utblMstTourPackagePics.FirstOrDefault(m => m.PackagePhotoID == id); return(obj); }