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);
}
