public IActionResult GetTransferToDTR()
{
_dksDao.GetTransferToDTR("C", "U", "ART005");
return(Ok());
}
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));
}