public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
//DButil.HistoryLog("activity.Recipient.Name : " + activity.Recipient.Name);
//DButil.HistoryLog("activity.Name : " + activity.Name);
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
Debug.WriteLine("* NO bannedMsg !");
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
//루이스 체크
cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
}
if (cacheList != null && cacheList.luisIntent != null)
{
if (cacheList.luisIntent.Contains("testdrive") || cacheList.luisIntent.Contains("branch"))
{
apiFlag = "TESTDRIVE";
}
else if (cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
else if (cacheList.luisIntent.Contains("recommend "))
{
apiFlag = "RECOMMEND";
}
else
{
apiFlag = "COMMON";
}
DButil.HistoryLog("cacheList.luisIntent : " + cacheList.luisIntent);
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
String fullentity = db.SearchCommonEntities;
DButil.HistoryLog("fullentity : " + fullentity);
if (!string.IsNullOrEmpty(fullentity) || !fullentity.Equals(""))
{
if (!String.IsNullOrEmpty(luisEntities))
{
//entity 길이 비교
if (fullentity.Length > luisEntities.Length || luisIntent == null || luisIntent.Equals(""))
{
//DefineTypeChkSpare에서는 인텐트나 루이스아이디조건 없이 엔티티만 일치하면 다이얼로그 리턴
relationList = db.DefineTypeChkSpare(fullentity);
}
else
{
relationList = db.DefineTypeChk(MessagesController.luisId, MessagesController.luisIntent, MessagesController.luisEntities);
}
}
else
{
relationList = db.DefineTypeChkSpare(fullentity);
}
}
else
{
if (apiFlag.Equals("COMMON"))
{
relationList = db.DefineTypeChkSpare(cacheList.luisEntities);
}
else
{
relationList = null;
}
}
if (relationList != null)
//if (relationList.Count > 0)
{
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
DButil.HistoryLog("relationList is not NULL");
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("kona_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
DButil.HistoryLog("apiFlag : COMMON | relationList.Count : " + relationList.Count);
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
String beforeMent = "";
facebookpagecount = 1;
//int fbLeftCardCnt = 0;
if (conversationhistory.commonBeforeQustion != null && conversationhistory.commonBeforeQustion != "")
{
DButil.HistoryLog(fbLeftCardCnt + "{fbLeftCardCnt} :: conversationhistory.commonBeforeQustion : " + conversationhistory.commonBeforeQustion);
if (conversationhistory.commonBeforeQustion.Equals(orgMent) && activity.ChannelId.Equals("facebook") && fbLeftCardCnt > 0)
{
DButil.HistoryLog("beforeMent : " + beforeMent);
conversationhistory.facebookPageCount++;
}
else
{
conversationhistory.facebookPageCount = 0;
fbLeftCardCnt = 0;
}
}
DButil.HistoryLog("* MessagesController.relationList.Count : " + MessagesController.relationList.Count);
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
if (conversationhistory.facebookPageCount > 0)
{
if (tempcard.card_order_no > (MAXFACEBOOKCARDS * facebookpagecount) && tempcard.card_order_no <= (MAXFACEBOOKCARDS * (facebookpagecount + 1)))
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
else if (tempcard.card_order_no > (MAXFACEBOOKCARDS * (facebookpagecount + 1)))
{
fbLeftCardCnt++;
tempAttachment = null;
}
else
{
fbLeftCardCnt = 0;
tempAttachment = null;
}
}
else if (activity.ChannelId.Equals("facebook"))
{
DButil.HistoryLog("facebook tempcard.card_order_no : " + tempcard.card_order_no);
if (tempcard.card_order_no <= MAXFACEBOOKCARDS && fbLeftCardCnt == 0)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
else
{
fbLeftCardCnt++;
tempAttachment = null;
}
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
}
}
else
{
DButil.HistoryLog("* facebook dlg.dlgId : " + dlg.dlgId);
DButil.HistoryLog("* activity.ChannelId : " + activity.ChannelId);
DButil.HistoryLog("* dlg.dlgId : " + dlg.dlgId + " | dlg.cardText : " + dlg.cardText);
if (dlg.dlgId.Equals(24)) // 주문내역 dialog 일시..
{
DButil.HistoryLog("*** activity.Conversation.Id : " + activity.Conversation.Id + " | dlg.cardText : " + dlg.cardText + " | fullentity : " + fullentity);
string[] strComment = new string[3];
string optionComment = "";
strComment[0] = db.SelectUserHistoryComment(activity.Conversation.Id, "selectDiet");
strComment[1] = db.SelectUserHistoryComment(activity.Conversation.Id, "selectDelievery");
//strComment[2] = db.SelectUserHistoryComment(activity.Conversation.Id, "order");
DButil.HistoryLog("*** strComment[0] : " + strComment[0] + " | strComment[1] : " + strComment[1] + " | strComment[2] : " + strComment[2]);
//optionComment = strComment[0] + "/" + strComment[1] + "/" + strComment[2];
optionComment = strComment[0] + "/" + strComment[1] + "/" + fullentity;
dlg.cardText = dlg.cardText.Replace("#OPTIONS", optionComment);
}
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dlg.cardTitle) && dlg.dlgType.Equals(TEXTDLG))
{
commonReply.Recipient = activity.From;
commonReply.Type = "message";
DButil.HistoryLog("facebook card Text : " + dlg.cardText);
commonReply.Text = dlg.cardText;
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
}
if (commonReply.Attachments.Count > 0)
{
DButil.HistoryLog("* commonReply.Attachments.Count : " + commonReply.Attachments.Count);
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
/*
* else
* {
* string newUserID = activity.Conversation.Id;
* string beforeUserID = "";
* string beforeMessgaeText = "";
* //string messgaeText = "";
*
* Activity intentNoneReply = activity.CreateReply();
* Boolean sorryflag = false;
*
*
* if (beforeUserID != newUserID)
* {
* beforeUserID = newUserID;
* MessagesController.sorryMessageCnt = 0;
* }
*
* var message = MessagesController.queryStr;
* beforeMessgaeText = message.ToString();
*
* Debug.WriteLine("SERARCH MESSAGE : " + message);
* //네이버 기사 검색
* if ((message != null) && message.Trim().Length > 0)
* {
* //Naver Search API
*
* string url = "https://openapi.naver.com/v1/search/news.json?query=" + message + "&display=10&start=1&sort=sim"; //news JSON result
* //string blogUrl = "https://openapi.naver.com/v1/search/blog.json?query=" + messgaeText + "&display=10&start=1&sort=sim"; //search JSON result
* //string cafeUrl = "https://openapi.naver.com/v1/search/cafearticle.json?query=" + messgaeText + "&display=10&start=1&sort=sim"; //cafe JSON result
* //string url = "https://openapi.naver.com/v1/search/blog.xml?query=" + query; //blog XML result
* HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
* request.Headers.Add("X-Naver-Client-Id", "Y536Z1ZMNv93Oej6TrkF");
* request.Headers.Add("X-Naver-Client-Secret", "cPHOFK6JYY");
* HttpWebResponse httpwebresponse = (HttpWebResponse)request.GetResponse();
* string status = httpwebresponse.StatusCode.ToString();
* if (status == "OK")
* {
* Stream stream = httpwebresponse.GetResponseStream();
* StreamReader reader = new StreamReader(stream, Encoding.UTF8);
* string text = reader.ReadToEnd();
*
* RootObject serarchList = JsonConvert.DeserializeObject<RootObject>(text);
*
* Debug.WriteLine("serarchList : " + serarchList);
* //description
*
* if (serarchList.display == 1)
* {
* //Debug.WriteLine("SERARCH : " + Regex.Replace(serarchList.items[0].title, @"[^<:-:>-<b>-</b>]", "", RegexOptions.Singleline));
*
* if (serarchList.items[0].title.Contains("코나"))
* {
* //Only One item
* List<CardImage> cardImages = new List<CardImage>();
* CardImage img = new CardImage();
* img.Url = "";
* cardImages.Add(img);
*
* string searchTitle = "";
* string searchText = "";
*
* searchTitle = serarchList.items[0].title;
* searchText = serarchList.items[0].description;
*
*
*
* if (activity.ChannelId == "facebook")
* {
* searchTitle = Regex.Replace(searchTitle, @"[<][a-z|A-Z|/](.|)*?[>]", "", RegexOptions.Singleline).Replace("\n", "").Replace("<:", "").Replace(":>", "");
* searchText = Regex.Replace(searchText, @"[<][a-z|A-Z|/](.|)*?[>]", "", RegexOptions.Singleline).Replace("\n", "").Replace("<:", "").Replace(":>", "");
* }
*
*
* LinkHeroCard card = new LinkHeroCard()
* {
* Title = searchTitle,
* Subtitle = null,
* Text = searchText,
* Images = cardImages,
* Buttons = null,
* Link = Regex.Replace(serarchList.items[0].link, "amp;", "")
* };
* var attachment = card.ToAttachment();
*
* intentNoneReply.Attachments = new List<Attachment>();
* intentNoneReply.Attachments.Add(attachment);
* }
* }
* else
* {
* //intentNoneReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
* intentNoneReply.Attachments = new List<Attachment>();
* for (int i = 0; i < serarchList.display; i++)
* {
* string searchTitle = "";
* string searchText = "";
*
* searchTitle = serarchList.items[i].title;
* searchText = serarchList.items[i].description;
*
* if (activity.ChannelId == "facebook")
* {
* searchTitle = Regex.Replace(searchTitle, @"[<][a-z|A-Z|/](.|)*?[>]", "", RegexOptions.Singleline).Replace("\n", "").Replace("<:", "").Replace(":>", "");
* searchText = Regex.Replace(searchText, @"[<][a-z|A-Z|/](.|)*?[>]", "", RegexOptions.Singleline).Replace("\n", "").Replace("<:", "").Replace(":>", "");
* }
*
* if (serarchList.items[i].title.Contains("코나"))
* {
* List<CardImage> cardImages = new List<CardImage>();
* CardImage img = new CardImage();
* img.Url = "";
* cardImages.Add(img);
*
* List<CardAction> cardButtons = new List<CardAction>();
* CardAction[] plButton = new CardAction[1];
* plButton[0] = new CardAction()
* {
* Value = Regex.Replace(serarchList.items[i].link, "amp;", ""),
* Type = "openUrl",
* Title = "기사 바로가기"
* };
* cardButtons = new List<CardAction>(plButton);
*
* if (activity.ChannelId == "facebook")
* {
* LinkHeroCard card = new LinkHeroCard()
* {
* Title = searchTitle,
* Subtitle = null,
* Text = searchText,
* Images = cardImages,
* Buttons = cardButtons,
* Link = null
* };
* var attachment = card.ToAttachment();
* intentNoneReply.Attachments.Add(attachment);
* }
* else
* {
* LinkHeroCard card = new LinkHeroCard()
* {
* Title = searchTitle,
* Subtitle = null,
* Text = searchText,
* Images = cardImages,
* Buttons = null,
* Link = Regex.Replace(serarchList.items[i].link, "amp;", "")
* };
* var attachment = card.ToAttachment();
* intentNoneReply.Attachments.Add(attachment);
* }
* }
* }
* }
* //await connector.Conversations.SendToConversationAsync(intentNoneReply);
* //replyresult = "S";
*
* if (intentNoneReply.Attachments.Count == 0)
* {
* sorryflag = true;
* }
* else
* {
* //await connector.Conversations.SendToConversationAsync(intentNoneReply);
* SetActivity(intentNoneReply);
* replyresult = "S";
* }
*
* }
* else
* {
* //System.Diagnostics.Debug.WriteLine("Error 발생=" + status);
* sorryflag = true;
* }
* }
* else
* {
* sorryflag = true;
* }
* if (sorryflag)
* {
* //Sorry Message
* int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
*
++MessagesController.sorryMessageCnt;
*
* Activity sorryReply = activity.CreateReply();
*
* sorryReply.Recipient = activity.From;
* sorryReply.Type = "message";
* sorryReply.Attachments = new List<Attachment>();
* sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
*
* List<TextList> text = new List<TextList>();
* if (sorryMessageCheck == 0)
* {
* text = db.SelectSorryDialogText("5");
* }
* else
* {
* text = db.SelectSorryDialogText("6");
* }
*
* for (int i = 0; i < text.Count; i++)
* {
* HeroCard plCard = new HeroCard()
* {
* Title = text[i].cardTitle,
* Text = text[i].cardText
* };
*
* Attachment plAttachment = plCard.ToAttachment();
* sorryReply.Attachments.Add(plAttachment);
* }
*
* SetActivity(sorryReply);
* //await connector.Conversations.SendToConversationAsync(sorryReply);
* sorryflag = false;
* replyresult = "D";
* }
* }
*/
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
Debug.WriteLine("* insertHistory | Conversation.Id : " + activity.Conversation.Id + "ChannelId : " + activity.ChannelId);
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
finally
{
// facebook 환경에서 text만 있는 멘트를 제외하고 carousel 등록
if (!(activity.ChannelId == "facebook" && reply1.Text != ""))
{
reply1.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
if (!(activity.ChannelId == "facebook" && reply2.Text != ""))
{
reply2.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
if (!(activity.ChannelId == "facebook" && reply3.Text != ""))
{
reply3.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
if (!(activity.ChannelId == "facebook" && reply4.Text != ""))
{
reply4.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
//페이스북에서 남은 카드가 있는경우
if (activity.ChannelId.Equals("facebook") && fbLeftCardCnt > 0)
{
Activity replyToFBConversation = activity.CreateReply();
replyToFBConversation.Recipient = activity.From;
replyToFBConversation.Type = "message";
replyToFBConversation.Attachments = new List <Attachment>();
replyToFBConversation.AttachmentLayout = AttachmentLayoutTypes.Carousel;
replyToFBConversation.Attachments.Add(
GetHeroCard_facebookMore(
"", "",
fbLeftCardCnt + "개의 컨테츠가 더 있습니다.",
new CardAction(ActionTypes.ImBack, "더 보기", value: MessagesController.queryStr))
);
await connector.Conversations.SendToConversationAsync(replyToFBConversation);
replyToFBConversation.Attachments.Clear();
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
Debug.WriteLine("* CARDDLG");
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
Debug.WriteLine("* NOT CARDDLG");
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Debug.WriteLine("* NOT CARDDLG - 1");
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
Debug.WriteLine("* NOT CARDDLG - 2");
//tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
HeroCard plCard = new UserHeroCard()
{
Title = "Welcome",
Text = "반갑습니다. 인천공항공사 챗봇입니다.",
Images = null,
Buttons = null,
Card_division = "",
Card_value = ""
};
tempAttachment = plCard.ToAttachment();
initReply.Attachments.Add(tempAttachment);
}
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
startTime = DateTime.Now;
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
//
string strDetectLang = DetectLang(orgMent);
Debug.WriteLine("* strDetectLang : " + strDetectLang);
string qnaMakerRes = "";
qnaMakerRes = GetQnaMakerResult(orgMent, strDetectLang);
Debug.WriteLine("*** strDetectLang : " + strDetectLang + " | qnaMakerRes : " + qnaMakerRes);
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else if (!qnaMakerRes.Equals(""))
{
string strReplyText = "Sorry";
QnAMakerResult responseQna;
responseQna = JsonConvert.DeserializeObject <QnAMakerResult>(qnaMakerRes);
if (!responseQna.Score.Equals(0))
{
//Convert.ToInt32(responseQna.Score);
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
strReplyText = responseQna.Answer + " || score: " + Convert.ToInt32(responseQna.Score) + "p, " + ((endTime - startTime).Milliseconds) + "/ms";
DButil.QnALog(orgMent + " |*| " + responseQna.Answer + " |*| " + Convert.ToInt32(responseQna.Score) + "p," + ((endTime - startTime).Milliseconds) + "/ms");
string logQuestion = orgMent.Replace(" ", "");
string logAnswer = responseQna.Answer.Replace(" ", "").Replace(Environment.NewLine, "");
string strLogQuestion, strLogAnswer;
if (logQuestion.Length > 20)
{
strLogQuestion = logQuestion.Substring(0, 20) + "...";
}
else
{
strLogQuestion = logQuestion;
}
if (logAnswer.Length > 30)
{
strLogAnswer = logAnswer.Substring(0, 30) + "...";
}
else
{
strLogAnswer = logAnswer;
}
DButil.QnALogSub(Convert.ToInt32(responseQna.Score) + "p," + ((endTime - startTime).Milliseconds) + "/ms |*| " + strLogQuestion + " |*| " + strLogAnswer);
}
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
//reply_ment.Text = qnaMakerRes;
reply_ment.Text = strReplyText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
//루이스 체크
cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
}
if (cacheList != null && cacheList.luisIntent != null)
{
if (cacheList.luisIntent.Contains("testdrive") || cacheList.luisIntent.Contains("branch"))
{
apiFlag = "TESTDRIVE";
}
else if (cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
else if (cacheList.luisIntent.Contains("recommend "))
{
apiFlag = "RECOMMEND";
}
else
{
apiFlag = "COMMON";
}
DButil.HistoryLog("cacheList.luisIntent : " + cacheList.luisIntent);
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
String fullentity = db.SearchCommonEntities;
DButil.HistoryLog("fullentity : " + fullentity);
if (!string.IsNullOrEmpty(fullentity) || !fullentity.Equals(""))
{
if (!String.IsNullOrEmpty(luisEntities))
{
//entity 길이 비교
if (fullentity.Length > luisEntities.Length || luisIntent == null || luisIntent.Equals(""))
{
//DefineTypeChkSpare에서는 인텐트나 루이스아이디조건 없이 엔티티만 일치하면 다이얼로그 리턴
relationList = db.DefineTypeChkSpare(fullentity);
}
else
{
relationList = db.DefineTypeChk(MessagesController.luisId, MessagesController.luisIntent, MessagesController.luisEntities);
}
}
else
{
relationList = db.DefineTypeChkSpare(fullentity);
}
}
else
{
if (apiFlag.Equals("COMMON"))
{
relationList = db.DefineTypeChkSpare(cacheList.luisEntities);
}
else
{
relationList = null;
}
}
if (relationList != null)
//if (relationList.Count > 0)
{
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("cjchat_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
}
}
else
{
DButil.HistoryLog("facebook dlg.dlgId : " + dlg.dlgId);
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
else
{
string newUserID = activity.Conversation.Id;
string beforeUserID = "";
string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
Boolean sorryflag = false;
if (beforeUserID != newUserID)
{
beforeUserID = newUserID;
MessagesController.sorryMessageCnt = 0;
}
var message = MessagesController.queryStr;
beforeMessgaeText = message.ToString();
Debug.WriteLine("SERARCH MESSAGE : " + message);
sorryflag = true;
//네이버 기사 검색
if (sorryflag)
{
Debug.WriteLine("sorryflag : true");
//Sorry Message
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Debug.WriteLine("sorryflag : true | Title : " + text[i].cardTitle + " | Text : " + text[i].cardText);
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
//await connector.Conversations.SendToConversationAsync(sorryReply);
sorryflag = false;
replyresult = "D";
}
}
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
queryStr = orgMent;
//인텐트 엔티티 검출
///////////////////////////////////////////////////////////////////////////////////////////////
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크 (TBL_QUERY_ANALYSIS_RESULT 조회..)
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
Debug.WriteLine("cache none : " + orgMent);
//루이스 체크(intent를 루이스를 통해서 가져옴)
//cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
//Debug.WriteLine("cacheList.luisId : " + cacheList.luisId);
cacheList.luisIntent = dbutil.GetMultiLUIS(orgMent);
Debug.WriteLine("cacheList.luisIntent : " + cacheList.luisIntent);
//Debug.WriteLine("cacheList.luisEntitiesValue : " + cacheList.luisEntitiesValue);
//cacheList = db.CacheDataFromIntent(cacheList.luisIntent, cacheList.luisEntitiesValue);
}
///////////////////////////////////////////////////////////////////////////////////////////////
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
DButil.HistoryLog("luisId : " + luisId);
DButil.HistoryLog("luisIntent : " + luisIntent);
DButil.HistoryLog("luisEntities : " + luisEntities);
///////////////////////////////////////////////////////////////////////
//물량정보조회3의 entitites를 가격으로 임의 지정
//if (luisIntent.Equals("물량정보조회2") || luisIntent.Equals("물량정보조회3") || luisIntent.Equals("물량정보조회4") || luisIntent.Equals("물량정보조회5"))
//{
// cacheList.luisEntities = "가격"; //임시설정
//}
//if (luisIntent.Equals("문자안내재전송"))
//{
// cacheList.luisEntities = "reSendMsg";
//}
//if (luisIntent.Equals("등록신청"))
//{
// cacheList.luisEntities = "insertEtcComment";
//}
////orgMent 변경(문자수신 시나리오)
//if (luisIntent.Equals("문자수신시나리오") || orgMent.Equals("예") || orgMent.Equals("아니오")
// || orgMent.Equals("예스") || orgMent.Equals("노") || orgMent.Equals("yes") || orgMent.Equals("no"))
//{
// luisIntent = "문자수신시나리오";
// cacheList.luisEntities = "smsScenario";
//}
//if (luisIntent.Equals("물량그룹건수조회"))
//{
// cacheList.luisEntities = "groupperentity";
//}
//DButil.HistoryLog("luisEntities : " + luisEntities);
///////////////////////////////////////////////////////////////////////
//String fullentity = db.SearchCommonEntities;
//DButil.HistoryLog("fullentity : " + fullentity);
if (apiFlag.Equals("COMMON"))
{
relationList = db.DefineTypeChkSpare(cacheList.luisIntent, cacheList.luisEntities);
}
else
{
relationList = null;
}
if (relationList != null)
//if (relationList.Count > 0)
{
DButil.HistoryLog("relationList 조건 in ");
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("cjlogisticsChatBot_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
DButil.HistoryLog("apiFlag : " + apiFlag);
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
//2018-04-19:KSO:Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
commonReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
//DLG 출력
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
if (luisIntent == "통화가능시간")
{
info += "정보 : " + orgMent + "||\r\n";
}
else if (luisIntent == "연락처")
{
info += "통화가능시간 : " + orgMent + "||\r\n";
}
else if (luisIntent == "지역")
{
info += "연락처 : " + orgMent + "||\r\n";
}
else if (luisIntent == "정보수집")
{
info += "지역 : " + orgMent + " " + ((Microsoft.Bot.Connector.HeroCard)tempAttachment.Content).Text;
}
Debug.WriteLine("info===" + info + " " + ((Microsoft.Bot.Connector.HeroCard)tempAttachment.Content).Text);
Debug.WriteLine("Title===" + ((Microsoft.Bot.Connector.HeroCard)tempAttachment.Content).Title);
if (((Microsoft.Bot.Connector.HeroCard)tempAttachment.Content).Text == "정보확인")
{
((Microsoft.Bot.Connector.HeroCard)tempAttachment.Content).Text = info.Replace("정보확인", "");
}
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
else
{
Debug.WriteLine("no dialogue-------------");
string newUserID = activity.Conversation.Id;
string beforeUserID = "";
string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
if (beforeUserID != newUserID)
{
beforeUserID = newUserID;
MessagesController.sorryMessageCnt = 0;
}
var message = MessagesController.queryStr;
beforeMessgaeText = message.ToString();
Debug.WriteLine("SERARCH MESSAGE : " + message);
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
replyresult = "D";
}
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("8");
}
else
{
//text = db.SelectSorryDialogText("6");
}
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
DButil.HistoryLog("초기 인사말 시작 ");
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
}
DButil.HistoryLog("초기 인사말 종료 ");
await connector.Conversations.SendToConversationAsync(initReply);
}
//현재위치사용승인 테스트
//Activity replyLocation = activity.CreateReply();
//replyLocation.Recipient = activity.From;
//replyLocation.Type = "message";
//replyLocation.Attachments = new List<Attachment>();
//replyLocation.AttachmentLayout = AttachmentLayoutTypes.Carousel;
//replyLocation.Attachments.Add(
// GetHeroCard_facebookMore(
// "", "",
// "현재 위치 사용 승인",
// new CardAction(ActionTypes.ImBack, "현재 위치 사용 승인", value: MessagesController.queryStr))
//);
//await connector.Conversations.SendToConversationAsync(replyLocation);
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
//현재위치사용승인
if (orgMent.Contains("current location") || orgMent.Equals("현재위치사용승인"))
{
if (!orgMent.Contains(':'))
{
//첫번쨰 메세지 출력 x
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
//위도경도에 따른 값 출력
try
{
string location = orgMent.Replace("current location:", "");
//테스트용
//string location = "129.0929788:35.2686635";
string[] location_result = location.Split(':');
//regionStr = db.LocationValue(location_result[1], location_result[2]);
DButil.HistoryLog("*regionStr : " + location_result[0] + " " + location_result[1]);
Debug.WriteLine("*regionStr : " + location_result[0] + " " + location_result[1]);
DButil.mapSave(location_result[0], location_result[1]);
Activity reply_brach = activity.CreateReply();
reply_brach.Recipient = activity.From;
reply_brach.Type = "message";
reply_brach.Attachments = new List <Attachment>();
reply_brach.AttachmentLayout = AttachmentLayoutTypes.Carousel;
reply_brach.Attachments.Add(
DButil.GetHeroCard_Map(
"타이호인스트",
"연락처",
"주소",
new CardImage(url: "https://nanetChatBot.azurewebsites.net/image/map/" + location_result[1] + "," + location_result[0] + ".png"),
new CardAction(ActionTypes.OpenUrl, "타이호인스트", value: "http://www.taihoinst.com/"),
location_result[1],
location_result[0])
);
var reply_brach1 = await connector.Conversations.SendToConversationAsync(reply_brach);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
catch
{
queryStr = "서울 시승센터";
}
}
}
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
String checkBookIntent = "";
String checkIntent = "";
String bookName = "";
if (activity.Text.Contains("[") && activity.Text.Contains("]"))
{
int apiIntentS = activity.Text.IndexOf("[");
int apiIntentE = activity.Text.IndexOf("]");
bookName = activity.Text.Substring(apiIntentS + 1, (apiIntentE - 1) - apiIntentS);
Debug.WriteLine("bookName-------------" + bookName);
}
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크 (TBL_QUERY_ANALYSIS_RESULT 조회..)
Debug.WriteLine("smalltalk 로 intent 찾기");
String apiActiveText = Regex.Replace(activity.Text, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);//공백 및 특수문자 제거
Activity apiMakerReply = activity.CreateReply();
apiMakerReply.Recipient = activity.From;
apiMakerReply.Type = "message";
apiMakerReply.Attachments = new List <Attachment>();
string smallTalkConfirm = "";
String sampleData = "";
/************************
* 임시로 책장보는 하드코딩 한다.
*************************/
String bookData = "삼국지,조선왕조실록,90년생이온다,여행의이유,호모커넥서스,임나일본부해부";
String[] bookDataArray = bookData.Split(',');
for (int i = 0; i < bookDataArray.Length; i++)
{
if (cashOrgMent.Contains(bookDataArray[i]))
{
checkBookIntent = "F_도서검색";
searchWord = bookDataArray[i];
}
}
//이용안내TIP
if (apiActiveText.Equals("이용안내TIP"))
{
checkIntent = "F_이용안내TIP";
}
else
{
if (checkBookIntent.Equals("") || checkBookIntent == null)
{
//checkIntent = db.getIntentFromSmallTalk(orgMent);
String IntentDataFromRelation = db.getIntentDataFromRelation().Substring(1);
String[] IntentDataFromRelationArray = IntentDataFromRelation.Split('%');
for (int j = 0; j < IntentDataFromRelationArray.Length; j++)
{
String[] checkData = IntentDataFromRelationArray[j].Split(':');
String intentString = checkData[0];
String EntityString = checkData[1];
if (EntityString.Contains(","))
{
String[] checkEntityArray = EntityString.Split(',');
for (int ii = 0; ii < checkEntityArray.Length; ii++)
{
if (apiActiveText.Contains(checkEntityArray[ii]))
{
checkIntent = intentString;
break;
}
}
}
else
{
if (apiActiveText.Contains(EntityString))
{
checkIntent = intentString;
break;
}
}
}
}
else
{
checkIntent = checkBookIntent;
}
}
if (checkIntent.Equals("") || checkIntent == null)
{
relationList = null;
//INTENT 가 없으니까 SORRY MESSAGE
Activity sorryReply = activity.CreateReply();
string queryStr = activity.Text;
queryStr = Regex.Replace(queryStr, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
queryStr = queryStr.Replace(" ", "").ToLower();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
List <CardAction> cardButtons = new List <CardAction>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
UserHeroCard plCard = new UserHeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText,
//Buttons = cardButtons
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
//db.InsertError(activity.Conversation.Id, e.Message);
DateTime endTime1 = DateTime.Now;
int dbResult1 = db.insertUserQuery(null, "", "", "", "", "E", queryStr);
//db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), "", "", "", "","E");
db.insertHistory(null, activity.Conversation.Id, activity.ChannelId, ((endTime1 - MessagesController.startTime).Milliseconds), "", "", "", "", "E", queryStr);
}
else if (checkIntent.Equals("F_도서검색"))
{
relationList = null;
/************************************************************
* 네이버 API 적용
* ******************************************************/
if (apiActiveText.Contains("도서자료") && !string.IsNullOrEmpty(bookName))
{
//bookName = System.Web.HttpUtility.UrlEncode(bookName);
int currentPage = 1;
if (queryStr.IndexOf("페이지") > 0)
{
string[] pageResult = queryStr.Split(' ');
Debug.WriteLine(pageResult[1]);
currentPage = Convert.ToInt32(Regex.Replace(pageResult[1], @"\D", ""));
}
string url = "https://openapi.naver.com/v1/search/book.json?query=" + System.Web.HttpUtility.UrlEncode(bookName) + "&display=10&start=" + currentPage + "&sort=sim"; //news JSON result
//string blogUrl = "https://openapi.naver.com/v1/search/blog.json?query=" + messgaeText + "&display=10&start=1&sort=sim"; //search JSON result
//string cafeUrl = "https://openapi.naver.com/v1/search/cafearticle.json?query=" + messgaeText + "&display=10&start=1&sort=sim"; //cafe JSON result
//string url = "https://openapi.naver.com/v1/search/blog.xml?query=" + query; //blog XML result
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Headers.Add("X-Naver-Client-Id", "8V_GHk868_ggD3d1Kr7x");
request.Headers.Add("X-Naver-Client-Secret", "EUIOkjlFKX");
HttpWebResponse httpwebresponse = (HttpWebResponse)request.GetResponse();
string status = httpwebresponse.StatusCode.ToString();
if (status == "OK")
{
Stream stream = httpwebresponse.GetResponseStream();
StreamReader reader = new StreamReader(stream, Encoding.UTF8);
string text = reader.ReadToEnd();
RootObject serarchList = JsonConvert.DeserializeObject <RootObject>(text);
apiMakerReply.Attachments = new List <Attachment>();
apiMakerReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
int searchTotal = 0;
searchTotal = serarchList.total;
Activity apiMakerReply1 = activity.CreateReply();
apiMakerReply1.Recipient = activity.From;
apiMakerReply1.Type = "message";
apiMakerReply1.Attachments = new List <Attachment>();
UserHeroCard plCard1 = new UserHeroCard()
{
Title = "",
Text = "도서자료 <strong>" + bookName + "</strong> 검색결과<br>검색건수 : " + searchTotal + "건" + " 현재페이지 : " + currentPage,
};
Attachment plattachment1 = plCard1.ToAttachment();
apiMakerReply1.Attachments.Add(plattachment1);
SetActivity(apiMakerReply1);
for (int i = 0; i < serarchList.display; i++)
{
string searchTitle = "";
string searchSubTitle = "";
string searchText = "";
string searchImageUrl = "";
string searchAuthor = "";
string searchPublisher = "";
searchTitle = serarchList.items[i].title;
searchAuthor = serarchList.items[i].author;
searchPublisher = serarchList.items[i].publisher;
searchImageUrl = serarchList.items[i].image;
searchText = serarchList.items[i].description;
searchImageUrl = serarchList.items[i].image;
searchSubTitle = "저자 : " + searchAuthor + " | " + "출판사 : " + searchPublisher;
List <CardImage> cardImages = new List <CardImage>();
CardImage img = new CardImage();
img.Url = searchImageUrl;
cardImages.Add(img);
List <CardAction> cardButtons = new List <CardAction>();
CardAction[] plButton = new CardAction[1];
plButton[0] = new CardAction()
{
Value = Regex.Replace(serarchList.items[i].link, "amp;", ""),
Type = "openUrl",
Title = "자세히보기"
};
cardButtons = new List <CardAction>(plButton);
LinkHeroCard card = new LinkHeroCard()
{
Title = searchTitle,
Subtitle = searchSubTitle,
Text = searchText,
Images = cardImages,
Buttons = cardButtons,
//Link = Regex.Replace(serarchList.items[i].link, "amp;", "")
Link = null
};
var attachment = card.ToAttachment();
apiMakerReply.Attachments.Add(attachment);
}
//apiMakerReply.Attachments.Add(attachment);
}
SetActivity(apiMakerReply);
Activity apiMakerReplyPageing = activity.CreateReply();
apiMakerReplyPageing.Recipient = activity.From;
apiMakerReplyPageing.Type = "message";
apiMakerReplyPageing.Attachments = new List <Attachment>();
List <CardAction> cardPagingButtons = new List <CardAction>();
if (currentPage == 1)
{
int nextMovePage = currentPage + 1;
CardAction plButtonPaging_new = new CardAction();
plButtonPaging_new = new CardAction()
{
Value = "도서자료[" + bookName + "] " + nextMovePage + "페이지로 이동",
Type = "imBack",
Title = "다음 페이지"
};
cardPagingButtons.Add(plButtonPaging_new);
}
else
{
int nextMovePage = currentPage + 1;
int preMovePage = currentPage - 1;
CardAction[] plButtonPaging_new = new CardAction[2];
for (int pageCnt = 0; pageCnt < 2; pageCnt++)
{
if (pageCnt == 0)
{
plButtonPaging_new[pageCnt] = new CardAction()
{
Value = "도서자료[" + bookName + "] " + preMovePage + "페이지로 이동",
Type = "imBack",
Title = "이전 페이지"
};
}
else
{
plButtonPaging_new[pageCnt] = new CardAction()
{
Value = "도서자료[" + bookName + "] " + nextMovePage + "페이지로 이동",
Type = "imBack",
Title = "다음 페이지"
};
}
cardPagingButtons.Add(plButtonPaging_new[pageCnt]);
}
}
//cardPagingButtons = new List<CardAction>(plButtonPaging);
//cardPagingButtons.Add(plButtonPaging);
UserHeroCard plCardPageing = new UserHeroCard()
{
Title = null,
Text = "다음 페이지로 이동합니다.",
Buttons = cardPagingButtons
};
Attachment plAttachmentPageing = plCardPageing.ToAttachment();
apiMakerReplyPageing.Attachments.Add(plAttachmentPageing);
SetActivity(apiMakerReplyPageing);
}
else
{
List <CardAction> cardButtons = new List <CardAction>();
CardAction bookButton1 = new CardAction();
bookButton1 = new CardAction()
{
Type = "imBack",
Value = "전체자료[" + searchWord + "]",
Title = "전체자료(30건)"
};
cardButtons.Add(bookButton1);
CardAction bookButton2 = new CardAction();
bookButton2 = new CardAction()
{
Type = "imBack",
Value = "학위논문[" + searchWord + "]",
Title = "학위논문(0건)"
};
cardButtons.Add(bookButton2);
CardAction bookButton3 = new CardAction();
bookButton3 = new CardAction()
{
Type = "imBack",
Value = "특종기사[" + searchWord + "]",
Title = "특종기사(21건)"
};
cardButtons.Add(bookButton3);
CardAction bookButton4 = new CardAction();
bookButton4 = new CardAction()
{
Type = "imBack",
Value = "도서자료[" + searchWord + "]",
Title = "도서자료(7건)"
};
cardButtons.Add(bookButton4);
CardAction bookButton5 = new CardAction();
bookButton5 = new CardAction()
{
Type = "imBack",
Value = "인터넷자료[" + searchWord + "]",
Title = "인터넷자료(2건)"
};
cardButtons.Add(bookButton5);
UserHeroCard plCard = new UserHeroCard()
{
Title = "",
Text = "아래와 같이 자료에 대해서 알려 드릴 수 있습니다.",
Buttons = cardButtons,
};
Attachment plAttachment = plCard.ToAttachment();
apiMakerReply.Attachments.Add(plAttachment);
SetActivity(apiMakerReply);
}
}
else if (checkIntent.Equals("F_이용안내TIP"))
{
relationList = null;
UserHeroCard plCard = new UserHeroCard()
{
Title = "NALI 이용안내",
Text = "1. 대화예시문<br>저자 검색 :<br>예시)<br> 박경리가 쓴 책을 알려줘<br> 저자 박경리 검색해줘<br>자료명 검색 :<br> 예시)<br> 삼국지 검색해줘<br> 수호지 찾아줘<br><br> 2. 결과내 검색<br> 검색 후 결과내 검색을 클릭 후 검색하시면 됩니다.<br><br> 3. 결과 더 보기<br> 결과 더보기를 클릭하시면 전체 검색결과를 확인 할 수 있습니다.",
};
Attachment plAttachment = plCard.ToAttachment();
apiMakerReply.Attachments.Add(plAttachment);
SetActivity(apiMakerReply);
}
else
{
relationList = db.DefineTypeChkSpare(checkIntent, luisEntities);
}
DButil.HistoryLog("luisId : " + luisId);
DButil.HistoryLog("luisIntent : " + luisIntent);
DButil.HistoryLog("luisEntities : " + luisEntities);
if (relationList != null)
{
dlgId = "";
for (int m = 0; m < relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(relationList[m].dlgId, "MOBILE");
dlgId += Convert.ToString(dlg.dlgId) + ",";
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
//2018-04-19:KSO:Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
commonReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
//DButil.HistoryLog("* facebook dlg.dlgId : " + dlg.dlgId);
DButil.HistoryLog("* activity.ChannelId : " + activity.ChannelId);
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
replyresult = "H";
}
}
}
//SMALLTALK 확인
else if (!string.IsNullOrEmpty(smallTalkConfirm))
{
Debug.WriteLine("smalltalk dialogue-------------");
Random rand = new Random();
//SMALLTALK 구분
string[] smallTalkConfirm_result = smallTalkConfirm.Split('$');
int smallTalkConfirmNum = rand.Next(0, smallTalkConfirm_result.Length);
Activity smallTalkReply = activity.CreateReply();
smallTalkReply.Recipient = activity.From;
smallTalkReply.Type = "message";
smallTalkReply.Attachments = new List <Attachment>();
HeroCard plCard = new HeroCard()
{
Title = "",
Text = smallTalkConfirm_result[smallTalkConfirmNum]
};
Attachment plAttachment = plCard.ToAttachment();
smallTalkReply.Attachments.Add(plAttachment);
SetActivity(smallTalkReply);
replyresult = "S";
}
else
{
}
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery(relationList, luisId, luisIntent, luisEntities, luisIntentScore, replyresult, orgMent);
db.insertHistory(null, activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), luisIntent, luisEntities, luisIntentScore, dlgId, replyresult, orgMent);
replyresult = "";
luisIntent = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
DButil.HistoryLog("ERROR===" + e.Message);
Activity sorryReply = activity.CreateReply();
string queryStr = activity.Text;
queryStr = Regex.Replace(queryStr, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
queryStr = queryStr.Replace(" ", "").ToLower();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
List <CardAction> cardButtons = new List <CardAction>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
UserHeroCard plCard = new UserHeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText,
//Buttons = cardButtons
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
//db.InsertError(activity.Conversation.Id, e.Message);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery(null, "", "", "", "", "E", queryStr);
//db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), "", "", "", "","E");
db.insertHistory(null, activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), "", "", "", "", "E", queryStr);
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
DbConnect db = new DbConnect();
var response = Request.CreateResponse(HttpStatusCode.OK);
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
List <ConfList> confList = db.SelectConfig();
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = getAttachmentFromDialog(tempcard);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
tempAttachment = getAttachmentFromDialog(dialogs);
initReply.Attachments.Add(tempAttachment);
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
string orgMent = activity.Text;
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
//await Conversation.SendAsync(activity, () => new TestDriveApi(orgMent));
//await Conversation.SendAsync(activity, () => new RecommendApiDialog());
//response = Request.CreateResponse(HttpStatusCode.OK);
//return response;
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////페이스북 위치 값 저장
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//var facebooklocation = activity.Entities?.Where(t => t.Type == "Place").Select(t => t.GetAs<Place>()).FirstOrDefault();
//if (facebooklocation != null)
//{
// try
// {
// var geo = (facebooklocation.Geo as JObject)?.ToObject<GeoCoordinates>();
// if (geo != null)
// {
// HistoryLog("[activity.Text]2 ==>> activity.Text :: location [" + activity.Text + "]");
// HistoryLog("[logic start] ==>> userID :: location [" + geo.Longitude + " " + geo.Latitude + "]");
// orgMent = "current location:" + geo.Longitude + ":" + geo.Latitude;
// }
// }
// catch (Exception ex)
// {
// Debug.WriteLine("ex : " + ex.ToString());
// HistoryLog("[logic start] ==>> userID :: location error [" + activity.Conversation.Id + "]");
// }
//}
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
return(response);
}
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
//루이스 호출전 TBL_WORD_CHG_DICT 테이블에서 전처리
//for (int n = 0; n < Regex.Split(orgMent, " ").Length; n++)
//{
// string chgMsg = db.SelectChgMsg(Regex.Split(orgMent, " ")[n]);
// if (!string.IsNullOrEmpty(chgMsg))
// {
// orgMent = orgMent.Replace(Regex.Split(orgMent, " ")[n], chgMsg);
// }
//}
//루이스 체크
cacheList.luisId = GetMultiLUIS(orgMent);
if (!cacheList.luisId.Equals(""))
{
if (!Luis.Equals("null") || Luis.Count > 0)
{
float luisScore = (float)Luis["intents"][0]["score"];
int luisEntityCount = (int)Luis["entities"].Count();
string luisEntities = "";
string luisType = "";
if (luisScore > Convert.ToDouble(LUIS_SCORE_LIMIT) && luisEntityCount > 0)
{
for (int i = 0; i < luisEntityCount; i++)
{
//luisEntities = luisEntities + Luis["entities"][i]["entity"] + ",";
luisType = (string)Luis["entities"][i]["type"];
luisType = Regex.Split(luisType, "::")[1];
luisEntities = luisEntities + luisType + ",";
}
Debug.WriteLine("luisEntities - 1 : " + luisEntities);
}
}
if (!luisEntities.Equals("null") || luisEntities.Length > 0)
{
luisEntities = luisEntities.Substring(0, luisEntities.LastIndexOf(","));
luisEntities = Regex.Replace(luisEntities, " ", "");
//string[] luisEntities_array = new string[10];
//luisEntities_array = Regex.Split(luisEntities, ",");
//Array.Resize(ref luisEntities_array, luisEntities_array.Count(s => s != null));
////Array.Sort(luisEntities_array);
////Array.Reverse(luisEntities_array);
//luisEntities_array = luisEntities_array.OrderByDescending(c => c).ToArray();
//foreach (var str in luisEntities_array)
//{
// Debug.WriteLine(str.ToString());
//}
//Debug.WriteLine("luisEntities_array = " + luisEntities_array);
luisEntities = db.SelectArray(luisEntities);
Debug.WriteLine("luisEntities - 2 : " + luisEntities);
if (Luis["intents"] == null)
{
cacheList.luisIntent = "";
}
else
{
cacheList.luisIntent = (string)Luis["intents"][0]["intent"];
}
cacheList.luisEntities = luisEntities;
}
}
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
//다이얼로그 호출
await Conversation.SendAsync(activity, () => new RootDialog(cacheList.luisId, cacheList.luisIntent, cacheList.luisEntities));
}
else
{
HandleSystemMessage(activity);
}
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
qTempTable = new Hashtable();
qTempTable.Add(1, "VPN+");
qTempTable.Add(2, "워터마크+해지");
qTempTable.Add(3, "비업무사이트+");
qTempTable.Add(4, "USB+");
//qTempTable.Add(5, "파일업로드+인터넷,파일업로드");
qTempTable.Add(5, "파일업로드+권한,인터넷,파일업로드");
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
/*
* 들어온 데이터가 숫자인지 아닌지 판단
* 숫자가 들어오면 임시해시테이블을 통해서 검색어를 재조정한다.
*/
bool checkNum = Regex.IsMatch(orgMent, @"^\d+$");
String[] msgEntity = null;
String newMessageTemp = null;
String newMessage = null;
String plusEntity = "";
if (checkNum)
{
int tempMessageNum = Int32.Parse(orgMent);
newMessageTemp = (String)qTempTable[tempMessageNum];
msgEntity = newMessageTemp.Split('+');
newMessage = msgEntity[0];
if (msgEntity[1] == null || msgEntity[1] == "")
{
plusEntity = msgEntity[1];
}
else
{
plusEntity = "," + msgEntity[1];
}
orgMent = newMessage;
}
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
//루이스 체크
cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
}
if (cacheList != null && cacheList.luisIntent != null)
{
if (cacheList.luisIntent.Contains("testdrive") || cacheList.luisIntent.Contains("branch"))
{
apiFlag = "TESTDRIVE";
}
else if (cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
else if (cacheList.luisIntent.Contains("recommend "))
{
apiFlag = "RECOMMEND";
}
else
{
apiFlag = "COMMON";
}
DButil.HistoryLog("cacheList.luisIntent : " + cacheList.luisIntent);
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
//String fullentity = db.SearchCommonEntities;
String fullentity_ = db.SearchCommonEntities + plusEntity;
String[] DupCheckArray = fullentity_.Split(',');
String[] DupCheck = DupCheckArray.Distinct().ToArray();
//Array.Sort(DupCheck);
String fullentity_make = "";
String fullentity = "";
for (int i = 0; i < DupCheck.Length; i++)
{
if (i == 0)
{
fullentity_make = DupCheck[i];
}
else
{
fullentity_make = fullentity_make + "," + DupCheck[i];
}
}
fullentity = db.EntityOrder(fullentity_make);
DButil.HistoryLog("fullentity : " + fullentity);
Debug.WriteLine("fullentity log : " + fullentity);
if (!string.IsNullOrEmpty(fullentity) || !fullentity.Equals(""))
{
if (!String.IsNullOrEmpty(luisEntities))
{
//entity 길이 비교
if (fullentity.Length > luisEntities.Length || luisIntent == null || luisIntent.Equals(""))
{
//DefineTypeChkSpare에서는 인텐트나 루이스아이디조건 없이 엔티티만 일치하면 다이얼로그 리턴
relationList = db.DefineTypeChkSpare(fullentity);
}
else
{
relationList = db.DefineTypeChk(MessagesController.luisId, MessagesController.luisIntent, MessagesController.luisEntities);
}
}
else
{
relationList = db.DefineTypeChkSpare(fullentity);
}
}
else
{
if (apiFlag.Equals("COMMON"))
{
relationList = db.DefineTypeChkSpare(cacheList.luisEntities);
}
else
{
relationList = null;
}
}
if (relationList != null)
//if (relationList.Count > 0)
{
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("kona_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
}
}
else
{
qTempTable = new Hashtable();
String test = dlg.cardText;
String test2 = Regex.Replace(test, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
String onlyNumCheck = Regex.Replace(test2, @"\D", "");
Regex cntStr = new Regex("12345"); //1.2.3.4. 이런식으로 넘어갈 테니까...답변 중에 12345 가 연속적으로 나오는 것은 없다.
int cntStrCount = int.Parse(cntStr.Matches(onlyNumCheck, 0).Count.ToString());
if (cntStrCount > 0)
{
for (int i = 0; i < 10; i++)
{
test2 = test2.Replace("1", "#");
test2 = test2.Replace("2", "#");
test2 = test2.Replace("3", "#");
test2 = test2.Replace("4", "#");
test2 = test2.Replace("5", "#");
test2 = test2.Replace("6", "#");
test2 = test2.Replace("7", "#");
test2 = test2.Replace("8", "#");
test2 = test2.Replace("9", "#");
}
test2.Replace("##", "#");
String[] tempData = test2.Split('#');
for (int j = 0; j < tempData.Length; j++)
{
//여기의 데이터는 예외사항이다.
if (tempData[j].Equals("사용기간") ||
tempData[j].Equals("결재라인") ||
tempData[j].Equals("요청서작성방법") ||
tempData[j].Equals("대리신청") ||
tempData[j].Equals("권한회수") ||
tempData[j].Equals("권한상태") ||
tempData[j].Equals("웹하드사이트접속") ||
tempData[j].Equals("쇼핑사이트접속")
)
{
qTempTable.Add(j, tempData[j] + "+");//위의값은 공통사항이다.
}
else
{
qTempTable.Add(j, tempData[j] + "+" + fullentity);//entity 값도 같이 넣는다.
}
}
}
else
{
}
DButil.HistoryLog("facebook dlg.dlgId : " + dlg.dlgId);
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
else
{
string newUserID = activity.Conversation.Id;
string beforeUserID = "";
string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
Boolean sorryflag = false;
if (beforeUserID != newUserID)
{
beforeUserID = newUserID;
MessagesController.sorryMessageCnt = 0;
}
var message = MessagesController.queryStr;
beforeMessgaeText = message.ToString();
Debug.WriteLine("SERARCH MESSAGE : " + message);
sorryflag = true;
if (sorryflag)
{
//Sorry Message
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
//text = db.SelectSorryDialogText("5");
text = db.SelectSorryDialogText("4"); //원래 5 인데 그냥 소스에서 수정함.
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
//await connector.Conversations.SendToConversationAsync(sorryReply);
sorryflag = false;
replyresult = "D";
}
}
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
//text = db.SelectSorryDialogText("5");
text = db.SelectSorryDialogText("4");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
Debug.WriteLine("* reply1 : " + reply1.Text);
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
//수정시작
if (activity != null)
{
try
{
switch (activity.GetActivityType())
{
case ActivityTypes.Message:
activity.Text = activity.RemoveRecipientMention();
await Conversation.SendAsync(activity, () => new ProactiveBusiness());
break;
case ActivityTypes.Event:
IEventActivity trigger = (IEventActivity)activity;
DButil.HistoryLog("****** Trigger Test ******");
var message = JsonConvert.DeserializeObject <QueueMessage>(((JObject)trigger.Value).GetValue("Message").ToString());
if (!string.IsNullOrEmpty(message.MessageText))
{
var messageactivity = (Activity)message.ResumptionCookie.GetMessage();
var client = new ConnectorClient(new Uri(messageactivity.ServiceUrl));
activity.Text = activity.RemoveRecipientMention();
Activity replyToConversation = messageactivity.CreateReply();
replyToConversation.Recipient = activity.From;
replyToConversation.Type = "message";
replyToConversation.Attachments = new List <Attachment>();
List <CardImage> cardImages = new List <CardImage>();
cardImages.Add(new CardImage(url: " http://cdn.wonderfulengineering.com/wp-content/uploads/2016/02/iron-man-wallpaper-22.jpg"));
List <CardAction> cardButtons = new List <CardAction>();
CardAction plButton = new CardAction()
{
Value = "https://en.wikipedia.org/wiki/Iron_Man",
Type = "openUrl",
Title = "Ironman Wiki"
};
cardButtons.Add(plButton);
HeroCard plCard = new HeroCard()
{
Title = message.MessageText,
Subtitle = "Triggered Iron Man Card",
Images = cardImages,
Buttons = cardButtons
};
Attachment plAttachment = plCard.ToAttachment();
replyToConversation.Attachments.Add(plAttachment);
await client.Conversations.ReplyToActivityAsync(replyToConversation);
}
break;
}
}
catch (Exception ex)
{
}
}
//수정끝
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
DButil.HistoryLog("* confList.Count : " + confList.Count);
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
DButil.HistoryLog("* confList[" + i + "].cnfNm : " + confList[i].cnfNm);
DButil.HistoryLog("* confList[" + i + "].cnfValue : " + confList[i].cnfValue);
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "QUOTE":
QUOTE = confList[i].cnfValue;
break;
case "TESTDRIVE":
TESTDRIVE = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
//루이스 체크
cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
}
if (cacheList != null && cacheList.luisIntent != null)
{
if (cacheList.luisIntent.Contains("testdrive") || cacheList.luisIntent.Contains("branch"))
{
apiFlag = "TESTDRIVE";
}
else if (cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
else if (cacheList.luisIntent.Contains("recommend "))
{
apiFlag = "RECOMMEND";
}
else
{
apiFlag = "COMMON";
}
DButil.HistoryLog("cacheList.luisIntent : " + cacheList.luisIntent);
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
String fullentity = db.SearchCommonEntities;
DButil.HistoryLog("fullentity : " + fullentity);
if (!string.IsNullOrEmpty(fullentity) || !fullentity.Equals(""))
{
if (!String.IsNullOrEmpty(luisEntities))
{
//entity 길이 비교
if (fullentity.Length > luisEntities.Length || luisIntent == null || luisIntent.Equals(""))
{
//DefineTypeChkSpare에서는 인텐트나 루이스아이디조건 없이 엔티티만 일치하면 다이얼로그 리턴
relationList = db.DefineTypeChkSpare(fullentity);
}
else
{
relationList = db.DefineTypeChk(MessagesController.luisId, MessagesController.luisIntent, MessagesController.luisEntities);
}
}
else
{
relationList = db.DefineTypeChkSpare(fullentity);
}
}
else
{
if (apiFlag.Equals("COMMON"))
{
relationList = db.DefineTypeChkSpare(cacheList.luisEntities);
}
else
{
relationList = null;
}
}
if (relationList != null)
//if (relationList.Count > 0)
{
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("TimeSolution_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
//2018-04-19:KSO:Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
commonReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
DButil.HistoryLog("facebook dlg.dlgId : " + dlg.dlgId);
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
else
{
string newUserID = activity.Conversation.Id;
string beforeUserID = "";
string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
Boolean sorryflag = false;
if (beforeUserID != newUserID)
{
beforeUserID = newUserID;
MessagesController.sorryMessageCnt = 0;
}
var message = MessagesController.queryStr;
beforeMessgaeText = message.ToString();
Debug.WriteLine("SERARCH MESSAGE : " + message);
//네이버 기사 검색
if (sorryflag)
{
//Sorry Message
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
//await connector.Conversations.SendToConversationAsync(sorryReply);
sorryflag = false;
replyresult = "D";
}
}
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCheck == 0)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds));
replyresult = "";
recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
//string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
//2018-11-26:KSO:INIT Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
await connector.Conversations.SendToConversationAsync(initReply);
}
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
//정규화
luisQuery = orgMent;
orgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
orgMent = orgMent.Replace(" ", "").ToLower();
queryStr = orgMent;
cacheList = db.CacheChk(orgMent.Replace(" ", "")); // 캐시 체크 (TBL_QUERY_ANALYSIS_RESULT 조회..)
//cacheList.luisIntent 초기화
//cacheList.luisIntent = null;
//smalltalk 문자 확인
String smallTalkSentenceConfirm = db.SmallTalkSentenceConfirm;
//smalltalk 답변이 있을경우
if (!string.IsNullOrEmpty(smallTalkSentenceConfirm))
{
luisId = "";
}
//luis 호출
else if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
Debug.WriteLine("cache none : " + orgMent);
//루이스 체크(intent를 루이스를 통해서 가져옴)
//cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
//Debug.WriteLine("cacheList.luisId : " + cacheList.luisId);
cacheList.luisIntent = dbutil.GetMultiLUIS(luisQuery);
Debug.WriteLine("cacheList.luisIntent : " + cacheList.luisIntent);
//Debug.WriteLine("cacheList.luisEntitiesValue : " + cacheList.luisEntitiesValue);
cacheList = db.CacheDataFromIntent(cacheList.luisIntent);
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
luisIntentScore = cacheList.luisScore;
}
else
{
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
luisIntentScore = cacheList.luisScore;
}
string smallTalkConfirm = "";
if (!string.IsNullOrEmpty(luisIntent))
{
relationList = db.DefineTypeChkSpare(cacheList.luisIntent);
}
else
{
relationList = null;
//smalltalk 답변가져오기
if (orgMent.Length < 11) // 2019-04-30 smalltalk 길이제한 10으로 변경 (epkim)
{
smallTalkConfirm = db.SmallTalkConfirm;
}
else
{
smallTalkConfirm = "";
}
}
if (relationList != null)
{
dlgId = "";
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
dlgId += Convert.ToString(dlg.dlgId) + ",";
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
//2018-04-19:KSO:Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
commonReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
//DButil.HistoryLog("* facebook dlg.dlgId : " + dlg.dlgId);
DButil.HistoryLog("* activity.ChannelId : " + activity.ChannelId);
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
replyresult = "H";
}
}
}
//SMALLTALK 확인
else if (!string.IsNullOrEmpty(smallTalkConfirm))
{
Debug.WriteLine("smalltalk dialogue-------------");
Random rand = new Random();
//SMALLTALK 구분
string[] smallTalkConfirm_result = smallTalkConfirm.Split('$');
int smallTalkConfirmNum = rand.Next(0, smallTalkConfirm_result.Length);
Activity smallTalkReply = activity.CreateReply();
smallTalkReply.Recipient = activity.From;
smallTalkReply.Type = "message";
smallTalkReply.Attachments = new List <Attachment>();
HeroCard plCard = new HeroCard()
{
Title = "",
Text = smallTalkConfirm_result[smallTalkConfirmNum]
};
Attachment plAttachment = plCard.ToAttachment();
smallTalkReply.Attachments.Add(plAttachment);
SetActivity(smallTalkReply);
replyresult = "S";
}
else
{
Debug.WriteLine("no dialogue-------------");
string newUserID = activity.Conversation.Id;
//string beforeUserID = "";
//string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
//if (beforeUserID != newUserID)
//{
// beforeUserID = newUserID;
// MessagesController.sorryMessageCnt = 0;
//}
var message = MessagesController.queryStr;
//beforeMessgaeText = message.ToString();
//Debug.WriteLine("SERARCH MESSAGE : " + message);
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <CardList> text = new List <CardList>();
List <CardAction> cardButtons = new List <CardAction>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
CardAction plButton = new CardAction();
plButton = new CardAction()
{
Type = text[i].btn1Type,
Value = text[i].btn1Context,
Title = text[i].btn1Title
};
cardButtons.Add(plButton);
UserHeroCard plCard = new UserHeroCard()
{
//Title = text[i].cardTitle,
Text = text[i].cardText,
Buttons = cardButtons
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
replyresult = "D";
}
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), luisIntent, luisEntities, luisIntentScore, dlgId, replyresult);
replyresult = "";
luisIntent = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
//int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <CardList> text = new List <CardList>();
List <CardAction> cardButtons = new List <CardAction>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
CardAction plButton = new CardAction();
plButton = new CardAction()
{
Type = text[i].btn1Type,
Value = text[i].btn1Context,
Title = text[i].btn1Title
};
cardButtons.Add(plButton);
UserHeroCard plCard = new UserHeroCard()
{
//Title = text[i].cardTitle,
Text = text[i].cardText,
Buttons = cardButtons
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), luisIntent, luisEntities, luisIntentScore, "", "E");
replyresult = "";
//recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
public async Task <HttpResponseMessage> Post([FromBody] Activity activity)
{
string cashOrgMent = "";
//DbConnect db = new DbConnect();
//DButil dbutil = new DButil();
DButil.HistoryLog("db connect !! ");
//HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
HttpResponseMessage response;
Activity reply1 = activity.CreateReply();
Activity reply2 = activity.CreateReply();
Activity reply3 = activity.CreateReply();
Activity reply4 = activity.CreateReply();
// Activity 값 유무 확인하는 익명 메소드
Action <Activity> SetActivity = (act) =>
{
if (!(reply1.Attachments.Count != 0 || reply1.Text != ""))
{
reply1 = act;
}
else if (!(reply2.Attachments.Count != 0 || reply2.Text != ""))
{
reply2 = act;
}
else if (!(reply3.Attachments.Count != 0 || reply3.Text != ""))
{
reply3 = act;
}
else if (!(reply4.Attachments.Count != 0 || reply4.Text != ""))
{
reply4 = act;
}
else
{
}
};
if (activity.Type == ActivityTypes.ConversationUpdate && activity.MembersAdded.Any(m => m.Id == activity.Recipient.Id))
{
startTime = DateTime.Now;
//activity.ChannelId = "facebook";
//파라메터 호출
if (LUIS_NM.Count(s => s != null) > 0)
{
//string[] LUIS_NM = new string[10];
Array.Clear(LUIS_NM, 0, LUIS_NM.Length);
}
if (LUIS_APP_ID.Count(s => s != null) > 0)
{
//string[] LUIS_APP_ID = new string[10];
Array.Clear(LUIS_APP_ID, 0, LUIS_APP_ID.Length);
}
//Array.Clear(LUIS_APP_ID, 0, 10);
DButil.HistoryLog("db SelectConfig start !! ");
List <ConfList> confList = db.SelectConfig();
DButil.HistoryLog("db SelectConfig end!! ");
for (int i = 0; i < confList.Count; i++)
{
switch (confList[i].cnfType)
{
case "LUIS_APP_ID":
LUIS_APP_ID[LUIS_APP_ID.Count(s => s != null)] = confList[i].cnfValue;
LUIS_NM[LUIS_NM.Count(s => s != null)] = confList[i].cnfNm;
break;
case "LUIS_SUBSCRIPTION":
LUIS_SUBSCRIPTION = confList[i].cnfValue;
break;
case "BOT_ID":
BOT_ID = confList[i].cnfValue;
break;
case "MicrosoftAppId":
MicrosoftAppId = confList[i].cnfValue;
break;
case "MicrosoftAppPassword":
MicrosoftAppPassword = confList[i].cnfValue;
break;
case "LUIS_SCORE_LIMIT":
LUIS_SCORE_LIMIT = confList[i].cnfValue;
break;
case "LUIS_TIME_LIMIT":
LUIS_TIME_LIMIT = Convert.ToInt32(confList[i].cnfValue);
break;
default: //미 정의 레코드
Debug.WriteLine("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
DButil.HistoryLog("*conf type : " + confList[i].cnfType + "* conf value : " + confList[i].cnfValue);
break;
}
}
Debug.WriteLine("* DB conn : " + activity.Type);
DButil.HistoryLog("* DB conn : " + activity.Type);
//초기 다이얼로그 호출
DButil.HistoryLog("초기 인사말 시작 ");
List <DialogList> dlg = db.SelectInitDialog(activity.ChannelId);
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
foreach (DialogList dialogs in dlg)
{
Activity initReply = activity.CreateReply();
initReply.Recipient = activity.From;
initReply.Type = "message";
initReply.Attachments = new List <Attachment>();
//initReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
Attachment tempAttachment;
if (dialogs.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dialogs.dialogCard)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
initReply.Attachments.Add(tempAttachment);
}
}
else
{
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dialogs.cardTitle) && dialogs.dlgType.Equals(TEXTDLG))
{
Activity reply_facebook = activity.CreateReply();
reply_facebook.Recipient = activity.From;
reply_facebook.Type = "message";
DButil.HistoryLog("facebook card Text : " + dialogs.cardText);
reply_facebook.Text = dialogs.cardText;
var reply_ment_facebook = connector.Conversations.SendToConversationAsync(reply_facebook);
//SetActivity(reply_facebook);
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dialogs, activity);
initReply.Attachments.Add(tempAttachment);
}
}
DButil.HistoryLog("초기 인사말 종료 ");
await connector.Conversations.SendToConversationAsync(initReply);
}
//현재위치사용승인 테스트
//Activity replyLocation = activity.CreateReply();
//replyLocation.Recipient = activity.From;
//replyLocation.Type = "message";
//replyLocation.Attachments = new List<Attachment>();
//replyLocation.AttachmentLayout = AttachmentLayoutTypes.Carousel;
//replyLocation.Attachments.Add(
// GetHeroCard_facebookMore(
// "", "",
// "현재 위치 사용 승인",
// new CardAction(ActionTypes.ImBack, "현재 위치 사용 승인", value: MessagesController.queryStr))
//);
//await connector.Conversations.SendToConversationAsync(replyLocation);
DateTime endTime = DateTime.Now;
Debug.WriteLine("프로그램 수행시간 : {0}/ms", ((endTime - startTime).Milliseconds));
Debug.WriteLine("* activity.Type : " + activity.Type);
Debug.WriteLine("* activity.Recipient.Id : " + activity.Recipient.Id);
Debug.WriteLine("* activity.ServiceUrl : " + activity.ServiceUrl);
DButil.HistoryLog("* activity.Type : " + activity.ChannelData);
DButil.HistoryLog("* activity.Recipient.Id : " + activity.Recipient.Id);
DButil.HistoryLog("* activity.ServiceUrl : " + activity.ServiceUrl);
}
else if (activity.Type == ActivityTypes.Message)
{
//activity.ChannelId = "facebook";
ConnectorClient connector = new ConnectorClient(new Uri(activity.ServiceUrl));
try
{
Debug.WriteLine("* activity.Type == ActivityTypes.Message ");
channelID = activity.ChannelId;
string orgMent = activity.Text;
//현재위치사용승인
if (orgMent.Contains("current location") || orgMent.Equals("현재위치사용승인"))
{
if (!orgMent.Contains(':'))
{
//첫번쨰 메세지 출력 x
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
//위도경도에 따른 값 출력
try
{
string location = orgMent.Replace("current location:", "");
//테스트용
//string location = "129.0929788:35.2686635";
string[] location_result = location.Split(':');
//regionStr = db.LocationValue(location_result[1], location_result[2]);
DButil.HistoryLog("*regionStr : " + location_result[0] + " " + location_result[1]);
Debug.WriteLine("*regionStr : " + location_result[0] + " " + location_result[1]);
DButil.mapSave(location_result[0], location_result[1]);
Activity reply_brach = activity.CreateReply();
reply_brach.Recipient = activity.From;
reply_brach.Type = "message";
reply_brach.Attachments = new List <Attachment>();
reply_brach.AttachmentLayout = AttachmentLayoutTypes.Carousel;
reply_brach.Attachments.Add(
DButil.GetHeroCard_Map(
"타이호인스트",
"연락처",
"주소",
new CardImage(url: "https://tiizchatbotv3.azurewebsites.net/image/map/" + location_result[1] + "," + location_result[0] + ".png"),
new CardAction(ActionTypes.OpenUrl, "타이호인스트", value: "http://www.taihoinst.com/"),
location_result[1],
location_result[0])
);
var reply_brach1 = await connector.Conversations.SendToConversationAsync(reply_brach);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
catch
{
queryStr = "서울 시승센터";
}
}
}
apiFlag = "COMMON";
//대화 시작 시간
startTime = DateTime.Now;
long unixTime = ((DateTimeOffset)startTime).ToUnixTimeSeconds();
DButil.HistoryLog("orgMent : " + orgMent);
//금칙어 체크
CardList bannedMsg = db.BannedChk(orgMent);
Debug.WriteLine("* bannedMsg : " + bannedMsg.cardText);//해당금칙어에 대한 답변
// QnA Maker 확인 - START
string qnaOrgMent = orgMent.Replace("'", "\""); // singlequote problem..
string qnAMakerAnswer = dbutil.GetQnAMaker(qnaOrgMent);
if (bannedMsg.cardText != null)
{
Activity reply_ment = activity.CreateReply();
reply_ment.Recipient = activity.From;
reply_ment.Type = "message";
reply_ment.Text = bannedMsg.cardText;
var reply_ment_info = await connector.Conversations.SendToConversationAsync(reply_ment);
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else if (!qnAMakerAnswer.Contains("No good match"))
{
Debug.WriteLine("* qnaOrgMent : " + qnaOrgMent);
Debug.WriteLine("* qnAMakerAnswer : " + qnAMakerAnswer);
Activity qnAMakerReply = activity.CreateReply();
qnAMakerReply.Recipient = activity.From;
qnAMakerReply.Type = "message";
qnAMakerReply.Attachments = new List <Attachment>();
List <CardList> text = new List <CardList>();
UserHeroCard plCard = new UserHeroCard()
{
//Title = "QnA",
Text = qnAMakerAnswer,
Gesture = 9
};
Attachment plAttachment = plCard.ToAttachment();
qnAMakerReply.Attachments.Add(plAttachment);
SetActivity(qnAMakerReply);
replyresult = "Q";
luisIntent = "QnA";
}
else
{
queryStr = orgMent;
//인텐트 엔티티 검출
//캐시 체크
cashOrgMent = Regex.Replace(orgMent, @"[^a-zA-Z0-9ㄱ-힣]", "", RegexOptions.Singleline);
cacheList = db.CacheChk(cashOrgMent.Replace(" ", "")); // 캐시 체크 (TBL_QUERY_ANALYSIS_RESULT 조회..)
//캐시에 없을 경우
if (cacheList.luisIntent == null || cacheList.luisEntities == null)
{
DButil.HistoryLog("cache none : " + orgMent);
Debug.WriteLine("cache none : " + orgMent);
//루이스 체크(intent를 루이스를 통해서 가져옴)
//cacheList.luisId = dbutil.GetMultiLUIS(orgMent);
//Debug.WriteLine("cacheList.luisId : " + cacheList.luisId);
cacheList.luisIntent = dbutil.GetMultiLUIS(orgMent);
Debug.WriteLine("cacheList.luisIntent : " + cacheList.luisIntent);
//Debug.WriteLine("cacheList.luisEntitiesValue : " + cacheList.luisEntitiesValue);
cacheList = db.CacheDataFromIntent(cacheList.luisIntent);
}
luisId = cacheList.luisId;
luisIntent = cacheList.luisIntent;
luisEntities = cacheList.luisEntities;
luisIntentScore = cacheList.luisScore;
DButil.HistoryLog("luisId : " + luisId);
DButil.HistoryLog("luisIntent : " + luisIntent);
DButil.HistoryLog("luisEntities : " + luisEntities);
String fullentity = db.SearchCommonEntities;
DButil.HistoryLog("fullentity : " + fullentity);
if (apiFlag.Equals("COMMON") && luisIntent != null) //MTC 관련 수정(&& luisIntent != null 추가)
{
relationList = db.DefineTypeChkSpare(cacheList.luisIntent, cacheList.luisEntities);
}
else
{
relationList = null;
}
if (relationList != null)
//if (relationList.Count > 0)
{
DButil.HistoryLog("relationList 조건 in ");
if (relationList.Count > 0 && relationList[0].dlgApiDefine != null)
{
if (relationList[0].dlgApiDefine.Equals("api testdrive"))
{
apiFlag = "TESTDRIVE";
}
else if (relationList[0].dlgApiDefine.Equals("api quot"))
{
apiFlag = "QUOT";
}
else if (relationList[0].dlgApiDefine.Equals("api recommend"))
{
apiFlag = "RECOMMEND";
}
else if (relationList[0].dlgApiDefine.Equals("D"))
{
apiFlag = "COMMON";
}
DButil.HistoryLog("relationList[0].dlgApiDefine : " + relationList[0].dlgApiDefine);
}
}
else
{
if (MessagesController.cacheList.luisIntent == null || apiFlag.Equals("COMMON"))
{
apiFlag = "";
}
else if (MessagesController.cacheList.luisId.Equals("TIIZChatBotV3_luis_01") && MessagesController.cacheList.luisIntent.Contains("quot"))
{
apiFlag = "QUOT";
}
DButil.HistoryLog("apiFlag : " + apiFlag);
}
if (apiFlag.Equals("COMMON") && relationList.Count > 0)
{
//context.Call(new CommonDialog("", MessagesController.queryStr), this.ResumeAfterOptionDialog);
dlgId = "";
for (int m = 0; m < MessagesController.relationList.Count; m++)
{
DialogList dlg = db.SelectDialog(MessagesController.relationList[m].dlgId);
dlgId += Convert.ToString(dlg.dlgId) + ",";
Activity commonReply = activity.CreateReply();
Attachment tempAttachment = new Attachment();
DButil.HistoryLog("dlg.dlgType : " + dlg.dlgType);
if (dlg.dlgType.Equals(CARDDLG))
{
foreach (CardList tempcard in dlg.dialogCard)
{
DButil.HistoryLog("tempcard.card_order_no : " + tempcard.card_order_no);
if (conversationhistory.facebookPageCount > 0)
{
if (tempcard.card_order_no > (MAXFACEBOOKCARDS * facebookpagecount) && tempcard.card_order_no <= (MAXFACEBOOKCARDS * (facebookpagecount + 1)))
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
else if (tempcard.card_order_no > (MAXFACEBOOKCARDS * (facebookpagecount + 1)))
{
fbLeftCardCnt++;
tempAttachment = null;
}
else
{
fbLeftCardCnt = 0;
tempAttachment = null;
}
}
else if (activity.ChannelId.Equals("facebook"))
{
DButil.HistoryLog("facebook tempcard.card_order_no : " + tempcard.card_order_no);
if (tempcard.card_order_no <= MAXFACEBOOKCARDS && fbLeftCardCnt == 0)
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
else
{
fbLeftCardCnt++;
tempAttachment = null;
}
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(tempcard, activity);
}
if (tempAttachment != null)
{
commonReply.Attachments.Add(tempAttachment);
}
//2018-04-19:KSO:Carousel 만드는부분 추가
if (tempcard.card_order_no > 1)
{
commonReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
}
}
}
else
{
//DButil.HistoryLog("* facebook dlg.dlgId : " + dlg.dlgId);
DButil.HistoryLog("* activity.ChannelId : " + activity.ChannelId);
if (activity.ChannelId.Equals("facebook") && string.IsNullOrEmpty(dlg.cardTitle) && dlg.dlgType.Equals(TEXTDLG))
{
commonReply.Recipient = activity.From;
commonReply.Type = "message";
DButil.HistoryLog("facebook card Text : " + dlg.cardText);
commonReply.Text = dlg.cardText;
}
else
{
tempAttachment = dbutil.getAttachmentFromDialog(dlg, activity);
commonReply.Attachments.Add(tempAttachment);
}
}
if (commonReply.Attachments.Count > 0)
{
SetActivity(commonReply);
conversationhistory.commonBeforeQustion = orgMent;
replyresult = "H";
}
}
}
else
{
Debug.WriteLine("no dialogue-------------");
Debug.WriteLine("luisIntent : " + luisIntent);
string newUserID = activity.Conversation.Id;
string beforeUserID = "";
string beforeMessgaeText = "";
//string messgaeText = "";
Activity intentNoneReply = activity.CreateReply();
if (beforeUserID != newUserID)
{
beforeUserID = newUserID;
MessagesController.sorryMessageCnt = 0;
}
var message = MessagesController.queryStr;
beforeMessgaeText = message.ToString();
Debug.WriteLine("SERARCH MESSAGE : " + message);
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
text = db.SelectSorryDialogText("5");
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
replyresult = "D";
}
DateTime endTime = DateTime.Now;
//analysis table insert
//if (rc != null)
//{
int dbResult = db.insertUserQuery();
//}
//history table insert
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), luisIntent, luisEntities, luisIntentScore, dlgId);
replyresult = "";
recommendResult = "";
}
}
catch (Exception e)
{
Debug.Print(e.StackTrace);
int sorryMessageCheck = db.SelectUserQueryErrorMessageCheck(activity.Conversation.Id, MessagesController.chatBotID);
++MessagesController.sorryMessageCnt;
Activity sorryReply = activity.CreateReply();
sorryReply.Recipient = activity.From;
sorryReply.Type = "message";
sorryReply.Attachments = new List <Attachment>();
//sorryReply.AttachmentLayout = AttachmentLayoutTypes.Carousel;
List <TextList> text = new List <TextList>();
if (sorryMessageCnt == 1)
{
text = db.SelectSorryDialogText("5");
}
else
{
text = db.SelectSorryDialogText("6");
}
for (int i = 0; i < text.Count; i++)
{
HeroCard plCard = new HeroCard()
{
Title = text[i].cardTitle,
Text = text[i].cardText
};
Attachment plAttachment = plCard.ToAttachment();
sorryReply.Attachments.Add(plAttachment);
}
SetActivity(sorryReply);
DateTime endTime = DateTime.Now;
int dbResult = db.insertUserQuery();
db.insertHistory(activity.Conversation.Id, activity.ChannelId, ((endTime - MessagesController.startTime).Milliseconds), luisIntent, luisEntities, luisIntentScore, "");
replyresult = "";
recommendResult = "";
}
finally
{
if (reply1.Attachments.Count != 0 || reply1.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply1);
}
if (reply2.Attachments.Count != 0 || reply2.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply2);
}
if (reply3.Attachments.Count != 0 || reply3.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply3);
}
if (reply4.Attachments.Count != 0 || reply4.Text != "")
{
await connector.Conversations.SendToConversationAsync(reply4);
}
}
}
else
{
HandleSystemMessage(activity);
}
response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}