public void DeleteModelInMailQueueCollection(MailQueueModel queueModel) { string sql = "delete from T_QueueLog where GUID ='" + queueModel.Guid + "'"; sqlo.getSomeDate(sql); MailQueueCollection.Remove(queueModel); }
private void FixLegacyNodeIds(MailQueueModel mailModel) { if (mailModel.OrderItemNodeId < 100000) { var order = _orderItemManager.GetOrderItem(mailModel.OrderId); mailModel.OrderItemNodeId = order.NodeId; } }
private string getBoundOrder(MailQueueModel m) { string ret = null; // Search for our items var results = _orderItemSearcher.Search(@"status:01\:Ny OR status:02\:Åtgärda OR status:03\:Beställd OR status:04\:Väntar OR status:09\:Mottagen"); string providerOrderId; string orderId; foreach (var result in results) { providerOrderId = result.ProviderOrderId; orderId = result.OrderId; if (!String.IsNullOrEmpty(providerOrderId) && !String.IsNullOrEmpty(orderId)) { var attachmentIndicatingBinding = false; foreach (var att in m.Attachments) { if (att.Title.EndsWith(".txt")) { att.Data.Position = 0; StreamReader sr = new StreamReader(att.Data); string dataStr = sr.ReadToEnd(); if (att.Title.Contains(providerOrderId) || dataStr.Contains(providerOrderId) || att.Title.Contains(orderId) || dataStr.Contains(orderId)) { attachmentIndicatingBinding = true; break; } } } if ((m.Subject != null && m.Subject.Contains(providerOrderId)) || (m.MessageBody != null && m.MessageBody.Contains(providerOrderId)) || (m.Subject != null && m.Subject.Contains(orderId)) || (m.MessageBody != null && m.MessageBody.Contains(orderId)) || attachmentIndicatingBinding) { ret = orderId; break; } } } return(ret); }
private void GetMailQueueCollection() { string sql = "select * from T_QueueLog"; sqlo.getSomeDate(sql); foreach (DataRow dr in sqlo.dt.Rows) { MailQueueModel queueModel = new MailQueueModel(dr["GUID"].ToString()); queueModel.StartTime = (DateTime)dr["StartTime"]; queueModel.EndTime = (DateTime)dr["EndTime"]; queueModel.Mask = Convert.ToInt32(dr["Mask"]); queueModel.SendMailAddress = dr["SendMailAddress"].ToString(); queueModel.SendSize = Convert.ToDouble(dr["SendSize"]); queueModel.Details = dr["Details"].ToString(); queueModel.MailID = dr["MailID"].ToString(); MailQueueCollection.Add(queueModel); } }
public int CreateOrderItemInDbFromMailQueueModel(MailQueueModel model, bool doReindex = true, bool doSignal = true) { IContentService cs = new Umbraco.Core.Services.ContentService(); // Temporary OrderId with MD5 Hash var orderId = "cthb-" + Helpers.CalculateMD5Hash(DateTime.Now.Ticks.ToString()); var contentName = orderId; // Create the OrderItem var uh = new Umbraco.Web.UmbracoHelper(Umbraco.Web.UmbracoContext.Current); IContent content = cs.CreateContent(contentName, uh.TypedContentAtXPath("//" + ConfigurationManager.AppSettings["umbracoOrderListContentDocumentType"]).First().Id, "ChalmersILLOrderItem"); // Set properties var originalOrder = UrlDecodeAndEscapeAllLinks(model.OriginalOrder); content.SetValue("originalOrder", originalOrder); content.SetValue("reference", originalOrder); content.SetValue("patronName", model.PatronName); content.SetValue("patronEmail", model.PatronEmail); content.SetValue("patronCardNo", model.PatronCardNo); content.SetValue("followUpDate", DateTime.Now); content.SetValue("editedBy", ""); content.SetValue("status", _umbraco.DataTypePrevalueId(ConfigurationManager.AppSettings["umbracoOrderStatusDataTypeDefinitionName"], "01:Ny")); content.SetValue("pType", model.SierraPatronInfo.ptype); content.SetValue("homeLibrary", model.SierraPatronInfo.home_library); content.SetValue("log", JsonConvert.SerializeObject(new List <LogItem>())); content.SetValue("attachments", JsonConvert.SerializeObject(new List <OrderAttachment>())); content.SetValue("sierraInfo", JsonConvert.SerializeObject(model.SierraPatronInfo)); content.SetValue("sierraPatronRecordId", model.SierraPatronInfo.record_id); content.SetValue("dueDate", DateTime.Now); content.SetValue("providerDueDate", DateTime.Now); content.SetValue("deliveryDate", new DateTime(1970, 1, 1)); content.SetValue("bookId", ""); content.SetValue("providerInformation", ""); content.SetValue("readOnlyAtLibrary", "0"); if (!String.IsNullOrEmpty(model.SierraPatronInfo.home_library)) { if (model.SierraPatronInfo.home_library.ToLower() == "hbib") { content.SetValue("deliveryLibrary", _umbraco.DataTypePrevalueId(ConfigurationManager.AppSettings["umbracoOrderDeliveryLibraryDataTypeDefinitionName"], "Huvudbiblioteket")); } else if (model.SierraPatronInfo.home_library.ToLower() == "abib") { content.SetValue("deliveryLibrary", _umbraco.DataTypePrevalueId(ConfigurationManager.AppSettings["umbracoOrderDeliveryLibraryDataTypeDefinitionName"], "Arkitekturbiblioteket")); } else if (model.SierraPatronInfo.home_library.ToLower() == "lbib") { content.SetValue("deliveryLibrary", _umbraco.DataTypePrevalueId(ConfigurationManager.AppSettings["umbracoOrderDeliveryLibraryDataTypeDefinitionName"], "Lindholmenbiblioteket")); } else { content.SetValue("deliveryLibrary", ""); } } // Set Type directly if "IsPurchaseRequest" is true if (model.IsPurchaseRequest) { content.SetValue("type", _umbraco.DataTypePrevalueId(ConfigurationManager.AppSettings["umbracoOrderTypeDataTypeDefinitionName"], "Inköpsförslag")); } // Save the OrderItem to get an Id SaveWithoutEventsAndWithSynchronousReindexing(content, false, false); // Shorten the OrderId and include the NodeId content.SetValue("orderId", orderId.Substring(0, 13) + "-" + content.Id.ToString()); content.Name = orderId.Substring(0, 13) + "-" + content.Id.ToString(); // Save SaveWithoutEventsAndWithSynchronousReindexing(content, doReindex, doSignal); return(content.Id); }