private void AddPendingItems(string parentId, string wwpParentId, string consignmentNo) { //insert into pending items var pendingConsole = new Adapters.Oal.dbo_event_pending_console { id = GenerateId(20), event_id = parentId, event_class = "pos.oal.DeliveryEventNew", console_no = consignmentNo, version = 0, date_field = DateTime.Now }; m_deliEventPendingConsoleRows.Add(pendingConsole); var pendingWwp = new Adapters.Oal.dbo_event_pending_console { id = GenerateId(20), event_id = wwpParentId, event_class = "pos.oal.WwpEventNewLog", console_no = consignmentNo, version = 0, date_field = DateTime.Now }; m_deliEventPendingConsoleRows.Add(pendingWwp); }
private async Task <IEnumerable <Adapters.Oal.dbo_event_pending_console> > SearchEventPendingAsync(string consoleNo) { var pendingAdapter = new Adapters.Oal.dbo_event_pending_consoleAdapter(); var query = $"SELECT [id], [event_class], [event_id] FROM [dbo].[event_pending_console] WHERE console_no = '{consoleNo}'"; var list = new List <Adapters.Oal.dbo_event_pending_console>(); using (var conn = new SqlConnection(pendingAdapter.ConnectionString)) using (var cmd = new SqlCommand(query, conn)) { await conn.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { var item = new Adapters.Oal.dbo_event_pending_console { id = reader["id"].ReadNullableString(), event_class = reader["event_class"].ReadNullableString(), event_id = reader["event_id"].ReadNullableString() }; list.Add(item); } } } return(list); }
private Adapters.Oal.dbo_event_pending_console GetPendingConsoleRow(string parentId, string consignmentNo) { var pendingConsole = new Adapters.Oal.dbo_event_pending_console { id = GenerateId(20), event_id = parentId, event_class = "pos.oal.DeliveryConsoleEventNew", console_no = consignmentNo, version = 0, date_field = DateTime.Now }; return(pendingConsole); }
private void AddPendingItems(string parentId, string wwpParentId, string consignmentNo) { //insert into pending items var pendingConsole = new Adapters.Oal.dbo_event_pending_console(); pendingConsole.id = GenerateId(20); pendingConsole.event_id = parentId; pendingConsole.event_class = "pos.oal.HipEventNew"; pendingConsole.console_no = consignmentNo; pendingConsole.version = 0; pendingConsole.date_field = DateTime.Now; m_hipEventPendingConsoleRows.Add(pendingConsole); var pendingWwp = new Adapters.Oal.dbo_event_pending_console(); pendingWwp.id = GenerateId(20); pendingWwp.event_id = wwpParentId; pendingWwp.event_class = "pos.oal.WwpEventNewLog"; pendingWwp.console_no = consignmentNo; pendingWwp.version = 0; pendingWwp.date_field = DateTime.Now; m_hipEventPendingConsoleRows.Add(pendingWwp); }
private async Task ProcessEventPendingItem(Norms.Domain.Norm norm, Adapters.Oal.dbo_event_pending_console pending) { var itemList = norm.AllConsignmentNotes.Split(new[] { ',', '\t' }, StringSplitOptions.RemoveEmptyEntries); var ok = false; switch (pending.event_class) { case "pos.oal.DeliveryEventNew": await ProcessDeliveryPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.SopEventNew": await ProcessSopPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.SipEventNew": await ProcessSipPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.HipEventNew": await ProcessHipPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.HopEventNew": await ProcessHopPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.StatusEventNew": await ProcessStatPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.VasnEventNew": await ProcessVasnPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.NormalConsoleEventNew": //ProcessNormPendingItem(item.console_no, item.event_id); break; case "pos.oal.MissortEventNew": await ProcessMissPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.WwpEventNewLog": await ProcessWwpPendingItem(pending.event_id, itemList); ok = true; break; case "pos.oal.IpsImport": await ProcessIpsPendingItem(pending.event_id, itemList); ok = true; break; } if (ok) { var pendingAdapter = new Adapters.Oal.dbo_event_pending_consoleAdapter(); await pendingAdapter.DeleteAsync(pending.id); } }