public App_Class.ServiceResponse Delete(int PackageImageId)
        {
            Air_PackagesImage result = _ent.Air_PackagesImage.Where(x => x.PackageImageId == PackageImageId).FirstOrDefault();

            try
            {
                AirPackageProvider _p = new AirPackageProvider();
                string             PackageImageFolder = _p.GetPackageImageFolderName(result.PackageId);
                string             imageName          = result.ImageName;

                _ent.DeleteObject(result);
                _ent.SaveChanges();
                if (!string.IsNullOrEmpty(PackageImageFolder) && !string.IsNullOrEmpty(imageName))
                {
                    AirPackageImageModel model = new AirPackageImageModel();
                    AppUploader.DeleteFileByName(model.PackageImageRootPath + "\\" + PackageImageFolder, imageName);
                    AppUploader.DeleteFileByName(model.PackageImageRootPath + "\\" + PackageImageFolder + "\\Images", imageName);
                    AppUploader.DeleteFileByName(model.PackageImageRootPath + "\\" + PackageImageFolder + "\\Thumbnail", imageName);
                }
                _response = new ServiceResponse("Successfully deleted!!", MessageType.Success, true, "Delete");
                return(_response);
            }
            catch (SqlException ex)
            {
                _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
            }
            catch (Exception ex)
            {
                _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Delete");
            }
            return(_response);
        }
        public ServiceResponse Save(AirPackageImageModel model)
        {
            try
            {
                using (var ts = new TransactionScope(TransactionScopeOption.Required))
                {
                    _response = ManagePackageFolder(model);
                    if (!_response.ResponseStatus)
                    {
                        return(_response);
                    }

                    foreach (var item in model.ImageUploader)
                    {
                        var    file             = item.UploadedFile;
                        string UploadedFileName = ManageImage(file);

                        Air_PackagesImage obj = new Air_PackagesImage
                        {
                            PackageId    = model.PackageId,
                            ImageName    = UploadedFileName,
                            ImageCaption = item.UploadedImageCaption,
                        };
                        _ent.AddToAir_PackagesImage(obj);
                        _ent.SaveChanges();
                    }
                    ts.Complete();
                    _response = new ServiceResponse("Record successfully created!!", MessageType.Success, true, "Save");
                    return(_response);
                }
            }
            catch (SqlException ex)
            {
                _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
            }
            catch (Exception ex)
            {
                _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Edit");
            }
            return(_response);
        }
        public App_Class.ServiceResponse SetDefaultImage(int PackageImageId)
        {
            try
            {
                using (var ts = new TransactionScope(TransactionScopeOption.Required))
                {
                    Air_PackagesImage result = _ent.Air_PackagesImage.Where(x => x.PackageImageId == PackageImageId).FirstOrDefault();
                    if (result != null)
                    {
                        var resultAll = _ent.Air_PackagesImage.Where(x => x.PackageId == result.PackageId && x.PackageImageId != PackageImageId);
                        if (resultAll != null)
                        {
                            foreach (var item in resultAll)
                            {
                                item.IsDefault = false;
                                _ent.ApplyCurrentValues(item.EntityKey.EntitySetName, item);
                                _ent.SaveChanges();
                            }
                        }

                        result.IsDefault = true;
                        _ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
                        _ent.SaveChanges();
                    }
                    ts.Complete();
                }

                _response = new ServiceResponse("Successfully updated!!", MessageType.Success, true, "SetDefault");
                return(_response);
            }
            catch (SqlException ex)
            {
                _response = new ServiceResponse(ServiceResponsesProvider.SqlExceptionMessage(ex), MessageType.SqlException, false);
            }
            catch (Exception ex)
            {
                _response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Delete");
            }
            return(_response);
        }