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