public LineCustomerViewModel SearchLineCustomer(string customerId)
{
using (conn = new SqlConnection(connectionString))
{
string sql = "Select LineCustomerID,Name FROM LineCustomer WHERE LineCustomerID=@customerId";
LineCustomerViewModel result = conn.QueryFirstOrDefault <LineCustomerViewModel>(sql, new { customerId });
return(result);
}
}
public IHttpActionResult POST()
{
try
{
this.ChannelAccessToken = channelAccessToken;
//取得Line Event(範例，只取第一個)
var LineEvent = this.ReceivedMessage.events.FirstOrDefault();
//配合Line verify
if (LineEvent.replyToken == "00000000000000000000000000000000")
{
return(Ok());
}
DateTime time = DateTime.UtcNow.AddHours(8);
string userId = LineEvent.source.userId;
string groupId = LineEvent.source.groupId;
LineUserInfo UserInfo = null;
//回覆訊息
if (LineEvent.type == "message")
{
if (LineEvent.message.type == "text" && LineEvent.source.groupId != null)
{
UserInfo = isRock.LineBot.Utility.GetGroupMemberProfile(groupId, userId, channelAccessToken);
//使用者ID和群組ID
LineGroupService lineGroupService = new LineGroupService(groupId);
if (lineGroupService.SearchLineGroup()) //尋找群組
{
//取得正在執行的活動
CampaignService campaignService = new CampaignService();
List <Campaign> campaigns = campaignService.GetWorkingCampaign(groupId);
foreach (Campaign campaign in campaigns)
{
//取得留言數量(組)
////因為目前Line團購只有+1+2的關鍵字，所以在第三個參數(keywordPattern)寫+1的Pattern
int number = CommentFilterService.KeywordFilter(LineEvent.message.text, campaign.Keyword, "+1");
if (number != 0 && number <= campaign.ProductGroup)
{
//將搜尋到或新增的Customer存在lineCustomer裡
LineCustomerViewModel lineCustomer = new LineCustomerViewModel();
//搜尋是此訊息的人是否已存在LineCustomer資料表中
if (!BotService.SearchLineCustomer(userId, UserInfo.displayName, ref lineCustomer))
{
//否，新增一筆
lineCustomer = BotService.InsertLineCustomer(userId, UserInfo.displayName);
}
//開始建訂單
GroupOrderViewModel groupOrder = new GroupOrderViewModel();
GroupOrderService groupOrderService = new GroupOrderService();
Product product = new Product();
product = ProductService.GetProductById(campaign.ProductID);
DateTime messageDateTime = BotService.TimestampToDateTime(LineEvent.timestamp);
//若此留言要成單，所需的成團數量空間
int remaningNumber = campaign.ProductGroup - number;
//如果訂單人數還未滿，就拿此單來用，否則建新的
if (groupOrderService.GetGroupOrder(campaign.CampaignID, remaningNumber, ref groupOrder))
{
decimal amount = product.UnitPrice * number;
groupOrderService.InsertGroupOrder(campaign.CampaignID, messageDateTime, campaign.ProductGroup);
groupOrderService.GetGroupOrder(campaign.CampaignID, remaningNumber, ref groupOrder);
}
//條件都達成，開始下單
GroupOrderDetail groupOrderDetail = new GroupOrderDetail()
{
GroupOrderID = groupOrder.GroupOrderID,
LineCustomerID = lineCustomer.LineCustomerID,
ProductName = product.ProductName,
UnitPrice = product.UnitPrice,
Quantity = number,
MessageDateTime = messageDateTime
};
GroupOrderDetailService groupOrderDetailService = new GroupOrderDetailService();
groupOrderDetailService.InsertGroupOrderDetail(groupOrderDetail);
//更新清單資料
int currentNumberOfProduct = groupOrder.NumberOfProduct + number;
decimal Amount = groupOrder.Amount + groupOrderDetail.UnitPrice * groupOrderDetail.Quantity;
bool isGroup = false;
if (currentNumberOfProduct == campaign.ProductGroup)
{
isGroup = true;
}
groupOrderService.UpdateGroupOrder(groupOrder.GroupOrderID, currentNumberOfProduct, Amount, isGroup);
this.ReplyMessage(LineEvent.replyToken, "感謝" + UserInfo.displayName + "的下標!等待活動結束後會一併通知團購成功名單");
break;
}
}
}
}
if (LineEvent.message.type == "sticker")
{
return(Ok());
}
if (LineEvent.message.type == "image")
{
return(Ok());
}
}
if (LineEvent.type == "join")
{
DateTime timestampTotime = BotService.TimestampToDateTime(LineEvent.timestamp);
LineGroupService lineGroupService = new LineGroupService(groupId);
var linegroup = lineGroupService.GetGroupByID();
//新的群組
if (linegroup == null)
{
List <CompareStoreManager> managerId = LineBindingService.GroupNullCompare();
foreach (var item in managerId)
{
StoreMeanger checkProfile = BotService.CheckMeanger(groupId, item.LineID);
if (checkProfile.message != "Not found")
{
LineBindingService.CompareUpdateGroupid(groupId, item.StoreManagerID, timestampTotime);
}
}
}
else
{
var nullGroup = LineBindingService.GetNullGroup(linegroup.StoreManagerID);
//群組名字一樣，舊的改狀態新的null刪掉
if (nullGroup.Count == 0)
{
LineBindingService.UpdateBotGroupStatus(linegroup.GroupID, "True", timestampTotime);
}
else if (linegroup.GroupName == nullGroup.FirstOrDefault().GroupName)
{
LineBindingService.UpdateBotGroupStatus(linegroup.GroupID, "True", timestampTotime);
LineBindingService.DelNullGroup(nullGroup.FirstOrDefault().GroupID);
}
//群組名字不一樣，新的增加
else if (linegroup.GroupName != nullGroup.FirstOrDefault().GroupName)
{
LineBindingService.UpdateBotGroup(nullGroup.FirstOrDefault().GroupID, groupId, "True", timestampTotime);
}
}
}
if (LineEvent.type == "leave")
{
int id = LineBindingService.GetIdByGroupId(groupId);
if (id != 0)
{
LineBindingService.UpdateGroupStatus(id, "False");
}
}
return(Ok());
}
catch (Exception ex)
{
foreach (var AdminUserId in AdminUser)
{
this.PushMessage(AdminUserId, "發生錯誤:\n" + ex.Message);
}
return(Ok());
}
}
public static bool SearchLineCustomer(string customerId, string customerName, ref LineCustomerViewModel lineCustomer)
{
LineCustomerRepository LineCustomer_repo = new LineCustomerRepository();
var checkCustomer = LineCustomer_repo.SearchLineCustomer(customerId);
if (checkCustomer != null)
{
lineCustomer = checkCustomer;
return(true);
}
return(false);
}
