public ActionResult GroupOrderDetailList(int GroupOrderID, int campaignID) { ViewBag.campaignID = campaignID; ViewBag.GroupOrderID = GroupOrderID; var GOdetailService = new GroupOrderDetailService(); ViewData.Model = GOdetailService.GetDetailByGroupOrderID(GroupOrderID); return(View()); }
public ActionResult GroupOrderChart(int CampaignID) { var name = new List <string>(); var qty = new List <int>(); var dateTime = new List <string>(); var price = new List <decimal>(); var arrayData = new { name, dateTime, qty, price }; var GOdetailService = new GroupOrderDetailService(); var data = GOdetailService.GetDetailByCampaignID(CampaignID); foreach (var item in data) { name.Add(item.Name); qty.Add(item.Quantity); dateTime.Add(item.MessageDateTime.ToString()); var amount = item.Quantity * item.UnitPrice; price.Add(amount); } return(Json(arrayData)); }
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()); } }