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