public bool SharePictureExists(CloudBlobContainer container, ArticlePicture picture) { var name = picture.Extension + ".jpg"; CloudBlockBlob blob = container.GetBlockBlobReference(name); if (blob.Properties.Created != null) { return(true); } return(false); }
public async Task CreateArticlePicturesAsync(int articleId, string userId, string pictureURL) { var pictures = new ArticlePicture { ArticleId = articleId, UserId = userId, PictureURL = pictureURL, }; await this.articlePictureRepository.AddAsync(pictures); await this.articlePictureRepository.SaveChangesAsync(); }
public void AddArticlePicture(Guid articleId, ArticlePicture articlePicture) { if (articleId == Guid.Empty) { throw new ArgumentNullException("Article Id"); } if (articlePicture == null) { throw new ArgumentNullException(nameof(articlePicture)); } articlePicture.ArticleId = articleId; _context.ArticlePictures.Add(articlePicture); }
//------------------------------------------------------------------------------------------------------// //---------------PictureSection---------------// public ArticlePicture GetOutstandingPicture(int id) { try { ArticlePicture OutstandingPicture = new ArticlePicture(); OutstandingPicture = db.ArticlePictures.FirstOrDefault(a => a.ArticleId == id && a.OutstandingPicture == true); return(OutstandingPicture); } catch (Exception ex) { ViewBag.error += "Error al obtener la foto de portada" + ex.InnerException; return(null); } }
public override Guid GetArticleId() { if (qsAct == ConfigFormAction.add) { return(qsArtId); } ArticlePublisherLogic artPub = new ArticlePublisherLogic(); ArticlePicture pic = artPub.GetArticlePictureDataForBackend(qsPicId); Guid articleId = Guid.Empty; if (pic != null) { articleId = pic.ArticleId.Value; } return(articleId); }
//---------------ArticleViewModelSection---------------// public ArticleViewModel GetArticleViewModel(Article article) { try { List <ArticlePicture> pictures = GetPictureList(article.Id); ArticlePicture outstandingPicture = GetOutstandingPicture(article.Id); var houses = GetHouses(article.Id); article.Terrain.TerrainFeaturesTerrain = GetTerrainFeatures(article.Terrain); ArticleViewModel articleViewModel = SetArticleViewModel(pictures, outstandingPicture, houses.House, houses.HouseAux, article); return(articleViewModel); } catch (Exception ex) { ViewBag.error += "Error al obtener el modelo de articulo" + ex.InnerException; return(null); } }
public ArticleViewModel SetArticleViewModel(List <ArticlePicture> pictures, ArticlePicture outstandingPicture, House house, HouseAux houseAux, Article article) { try { ArticleViewModel articleViewModel = new ArticleViewModel(); articleViewModel.Article = article; articleViewModel.Pictures = pictures; articleViewModel.OutstandingPicture = outstandingPicture; articleViewModel.House = house; articleViewModel.HouseAux = houseAux; return(articleViewModel); } catch (Exception ex) { ViewBag.error += "Error al setear el modelo de articulo" + ex.InnerException; return(null); } }
public ArticleDetailsUserControl(List <string> Articles) { InitializeComponent(); Menus.AddDeleteMenu(this); Drag.AddDNDFunctions(this); ListOfArticles = Articles; int x = 356; int y = 376; try { x = Convert.ToInt32(Articles[1]); y = Convert.ToInt32(Articles[2]); } catch (ArgumentOutOfRangeException) { // Используем тандартный размер } this.Size = new Size(x, y); List <string> result = SQLClass.Select("SELECT Author, Category, Text, Picture FROM " + "Articles1" + " WHERE `Header` = '" + Articles[0] + "'"); if (result.Count > 3) { AuthorsNameLabel.Text = result[0]; ArticleLabel.Text = Articles[0]; ArticleTextLabel.Text = result[2]; } try { ArticlePicture.Load(result[3]); } catch { ArticlePicture.Image = null; } }
protected override string GetFileFullName(Guid attId) { string fileFullName = ""; string attRootDir = Server.MapPath(string.Format("~/{0}", ConfigurationManager.AppSettings["AttRootDir"])); ArticlePublisherLogic artPub = new ArticlePublisherLogic(null); ArticlePicture pic = artPub.GetArticlePictureDataForBackend(attId); if (pic == null) { logger.ErrorFormat("can't get data of attId[{0}]", attId); return(""); } string filePath = "ArticlePictures"; string articleId = pic.ArticleId.ToString(); string fileSavedName = pic.FileSavedName; fileFullName = string.Format("{0}{1}/{2}/{3}", attRootDir, filePath, articleId, fileSavedName); return(fileFullName); }
public async Task <IActionResult> TransitArticle(TransitArticleDto transitArticleDto) { string status = "0"; string errMsg = ""; _logger.LogInformation(String.Format(@"****** DKSController TransitArticle fired!! ******")); Articled checkArt = _articledDAO.FindSingle( x => x.ARTICLE.Trim() == transitArticleDto.Article.Trim() && x.STAGE.Trim() == transitArticleDto.Stage.Trim() && x.FACTORYID.Trim() == transitArticleDto.FactoryId.Trim()); if (checkArt != null) { errMsg = "The Article、Stage、Factory is exist. Please refresh page and try again."; return(Ok(errMsg)); } Articled fromArt = _articledDAO.FindSingle( x => x.PKARTBID.Trim() == transitArticleDto.PkArticle.Trim()); // Step1: save fromArt to db (status =0 ) fromArt.MODELNO = transitArticleDto.ModelNo.Trim(); fromArt.STAGE = transitArticleDto.Stage.Trim(); fromArt.FACTORYID = transitArticleDto.FactoryId; fromArt.STATUS = status; fromArt.MDUSERID = transitArticleDto.UpdateUser.ToDecimal(); fromArt.CHANGDATE = DateTime.Now; fromArt.INSERDATE = DateTime.Now; //fromArt.REMARK = string.Format("Transit From Factory: {0} ,Update User: {1}", transitArticleDto.FactoryIdFrom,transitArticleDto.UpdateUser); //get new PKARTICLE var newPkArticle = _commonService.GetPKARTBID(); fromArt.PKARTBID = newPkArticle; _articledDAO.Add(fromArt); await _articledDAO.SaveAll(); _logger.LogInformation(String.Format(@"****** Save ARTICLED Success!! PKARTICLE: {0} ******", newPkArticle)); // Step2: copy ARTICLE_PICTURE and save to DB ArticlePicture fromArtPic = _articlePictureDAO.FindSingle( x => x.FKARTICID.Trim() == transitArticleDto.PkArticle.Trim()); if (fromArtPic != null) { fromArtPic.FKARTICID = newPkArticle; _articlePictureDAO.Add(fromArtPic); await _articlePictureDAO.SaveAll(); } _logger.LogInformation(String.Format(@"****** Save ARTICLEPICTURE Success!! FKARTICID: {0} ******", newPkArticle)); // Step3: if the new article don't have model in db copy one. ModelDah toModel = _modelDahDAO.FindSingle( x => x.MODELNO.Trim() == transitArticleDto.ModelNo.Trim() && x.FACTORYID.Trim() == transitArticleDto.FactoryId.Trim()); if (toModel == null) { ModelDah fromModel = _modelDahDAO.FindSingle( x => x.MODELNO.Trim() == transitArticleDto.ModelNoFrom.Trim() && x.FACTORYID.Trim() == transitArticleDto.FactoryIdFrom.Trim()); fromModel.MODELNO = transitArticleDto.ModelNo.Trim(); fromModel.DEVTEAMID = transitArticleDto.DevTeamId; fromModel.DEVELOPERID = ""; fromModel.FACTORYID = transitArticleDto.FactoryId; fromModel.STATUS = status; fromModel.MDUSERID = transitArticleDto.UpdateUser.ToDecimal(); fromModel.CHANGDATE = DateTime.Now; _modelDahDAO.Add(fromModel); await _modelDahDAO.SaveAll(); _logger.LogInformation(String.Format(@"****** Save ModelDah Success!! ModelNo: {0}, FactoryId: {1} ******", fromModel.MODELNO, fromModel.FACTORYID)); } //step4: stend email /* * //var dksSignature = _config.GetSection("DksSignatureLine").Value; * var dksSignature = ""; * var content = string.Format(@"The Article : {0} was Transit from factory: {1}, please check it in F205 Article of the below website.{2}", transitArticleDto.Article, transitArticleDto.FactoryIdFrom , dksSignature); * * var toMails = new List<string>(); * * toMails.Add(transitArticleDto.Email); * await _sendMailService.SendListMailAsync(toMails, null, "A Article was Transit Please check it in F205 !", content, null); * _logger.LogInformation(String.Format(@"******Sent Mail F205 Article Transit to : {0} ******", transitArticleDto.Email)); */ //step5 : insert to dtr_excel and dtr_cwa date _dKSDAO.GetTransferToDTR(transitArticleDto.FactoryIdFrom, transitArticleDto.FactoryId, transitArticleDto.Article.Trim()); return(Ok(errMsg)); }
protected override bool LoadData() { bool result = false; if (attId != Guid.Empty) { ArticlePublisherLogic artPub = new ArticlePublisherLogic(null); ArticlePicture pic = artPub.GetArticlePictureDataForBackend(attId); if (pic == null) { errState = AttFileErrState.LoadDataFailed; return(false); } contextId = pic.ArticleId; filePath = GetDirectoryName(); fileSavedName = pic.FileSavedName; fileSize = pic.FileSize; sortNo = pic.SortNo.Value; fileMIME = pic.FileMIME; fileFullName = string.Format("{0}{1}/{2}", GetAttRootDirectoryFullName(), filePath, fileSavedName); postAccount = pic.PostAccount; postDate = pic.PostDate.Value; if (pic.MdfDate.HasValue) { mdfAccount = pic.MdfAccount; mdfDate = pic.MdfDate.Value; } //zh-TW if (LangManager.IsEnableEditLangZHTW()) { ArticlePictureMultiLang picZhTw = artPub.GetArticlePictureMultiLangDataForBackend(attId, LangManager.CultureNameZHTW); if (picZhTw == null) { errState = AttFileErrState.LoadMultiLangDataFailed; return(false); } attSubjectZhTw = picZhTw.PicSubject; isShowInLangZhTw = picZhTw.IsShowInLang; if (picZhTw.MdfDate.HasValue) { DateTime mdfDateZhTw = picZhTw.MdfDate.Value; if (!mdfDate.HasValue || mdfDateZhTw > mdfDate.Value) { mdfAccount = picZhTw.MdfAccount; mdfDate = mdfDateZhTw; } } } //en if (LangManager.IsEnableEditLangEN()) { ArticlePictureMultiLang picEn = artPub.GetArticlePictureMultiLangDataForBackend(attId, LangManager.CultureNameEN); if (picEn == null) { errState = AttFileErrState.LoadMultiLangDataFailed; return(false); } attSubjectEn = picEn.PicSubject; isShowInLangEn = picEn.IsShowInLang; if (picEn.MdfDate.HasValue) { DateTime mdfDateEn = picEn.MdfDate.Value; if (!mdfDate.HasValue || mdfDateEn > mdfDate.Value) { mdfAccount = picEn.MdfAccount; mdfDate = mdfDateEn; } } } result = true; } else if (contextId != null) { // new one sortNo = GetNextSortNo(); result = true; } return(result); }