public void Update(ActiveUp.Net.Common.DeltaExt.Action entity) { using (var dbcontext = new FAXPECContext()) { try { var action = dbcontext.ACTIONS.Where(x => x.ID == (double)entity.Id).FirstOrDefault(); action = DaoSQLServerDBHelper.MapToActionDto(entity, false); int resp = dbcontext.SaveChanges(); if (resp == 0) { throw new Exception("Nessun record aggiornato"); } } catch (Exception ex) { if (ex.GetType() == typeof(ManagedException)) { ManagedException mEx = new ManagedException(ex.Message, "ACT_ORA002", string.Empty, string.Empty, ex); ErrorLogInfo er = new ErrorLogInfo(mEx); log.Error(er); throw mEx; } } } }
public void Update(ActiveUp.Net.Common.DeltaExt.Action action) { using (ActionsSQLDb dao = new ActionsSQLDb()) { dao.Update(action); } }
public void Insert(ActiveUp.Net.Common.DeltaExt.Action action) { using (ActionsSQLDb dao = new ActionsSQLDb()) { dao.Insert(action); } }
internal static ActiveUp.Net.Common.DeltaExt.Action MapToAction(IDataRecord dr) { ActiveUp.Net.Common.DeltaExt.Action a = new ActiveUp.Net.Common.DeltaExt.Action(); a.Id = (decimal)dr.GetDecimal("ID"); a.NomeAzione = dr.GetString("NOME_AZIONE"); a.IdDestinazione = (decimal)dr.GetDouble("ID_NOME_DESTINAZIONE"); a.NuovoStatus = dr.GetString("NUOVO_STATUS"); a.TipoAzione = dr.GetString("TIPO_AZIONE"); a.TipoDestinazione = dr.GetString("TIPO_DESTINAZIONE"); if (dr.FieldCount > 7) { a.IdComp = dr.GetDecimal("IDFOLDER").ToString(); } a.IdFolderDestinazione = int.Parse(dr.GetDouble("ID_FOLDER_DESTINAZIONE").ToString()); return(a); }
internal static ACTIONS MapToActionDto(ActiveUp.Net.Common.DeltaExt.Action entity, bool isInsert) { ACTIONS a = new ACTIONS() { ID_FOLDER_DESTINAZIONE = entity.IdFolderDestinazione, NOME_AZIONE = entity.NomeAzione, NUOVO_STATUS = entity.NuovoStatus, TIPO_AZIONE = entity.TipoAzione, ID_NOME_DESTINAZIONE = (double)entity.IdDestinazione, TIPO_DESTINAZIONE = entity.TipoDestinazione }; if (!isInsert) { a.ID = (double)entity.Id; } return(a); }
public ActiveUp.Net.Common.DeltaExt.Action GetById(long id) { ActiveUp.Net.Common.DeltaExt.Action action = null; using (var dbcontext = new FAXPECContext()) { try { ACTIONS a = dbcontext.ACTIONS.Where(x => x.ID == id).FirstOrDefault(); action = AutoMapperConfiguration.MapToAction(a); } catch (Exception ex) { ManagedException mEx = new ManagedException(ex.Message, "ACT_ORA003", string.Empty, string.Empty, ex); ErrorLogInfo er = new ErrorLogInfo(mEx); log.Error(er); throw mEx; } return(action); } }
public void Insert(ActiveUp.Net.Common.DeltaExt.Action entity) { using (var dbcontext = new FAXPECContext()) { try { ACTIONS action = DaoSQLServerDBHelper.MapToActionDto(entity, true); dbcontext.ACTIONS.Add(action); } catch (Exception ex) { if (ex.GetType() == typeof(ManagedException)) { ManagedException mEx = new ManagedException(ex.Message, "ACT_ORA001", string.Empty, string.Empty, ex); ErrorLogInfo er = new ErrorLogInfo(mEx); log.Error(er); throw mEx; } } } }
internal static void CreateActionsForFolders(decimal idIn, decimal idOut, decimal idInArch, decimal idOutArch, string nome, string idNome) { List <ActiveUp.Net.Common.DeltaExt.Action> actions = new List <ActiveUp.Net.Common.DeltaExt.Action>(); ActiveUp.Net.Common.DeltaExt.Action actionin = new ActiveUp.Net.Common.DeltaExt.Action(); actionin.IdDestinazione = decimal.Parse(idNome); actionin.IdFolderDestinazione = (int)idIn; actionin.NomeAzione = "SPOSTA IN " + nome; actionin.TipoAzione = "SP"; actions.Add(actionin); ActiveUp.Net.Common.DeltaExt.Action actionout = new ActiveUp.Net.Common.DeltaExt.Action(); actionout.IdDestinazione = decimal.Parse(idNome); actionout.IdFolderDestinazione = (int)idOut; actionout.NomeAzione = "SPOSTA IN " + nome; actionout.TipoAzione = "SP"; actions.Add(actionout); // archivio ActiveUp.Net.Common.DeltaExt.Action actioninArch = new ActiveUp.Net.Common.DeltaExt.Action(); actioninArch.IdDestinazione = decimal.Parse(idNome); actioninArch.IdFolderDestinazione = (int)idInArch; actioninArch.NomeAzione = "SPOSTA IN " + nome; actioninArch.TipoAzione = "SP"; actions.Add(actioninArch); ActiveUp.Net.Common.DeltaExt.Action actionoutArch = new ActiveUp.Net.Common.DeltaExt.Action(); actionoutArch.IdDestinazione = decimal.Parse(idNome); actionoutArch.IdFolderDestinazione = (int)idOutArch; actionoutArch.NomeAzione = "SPOSTA IN " + nome; actionoutArch.TipoAzione = "SP"; actions.Add(actionoutArch); ActionsService actService = new ActionsService(); try { actService.Insert(actions); List <ActionFolder> actionsFolders = new List <ActionFolder>(); // inserimento azioni e collegamento con folders ActionFolder afInbox = new ActionFolder(); afInbox.idAction = actionin.Id; afInbox.idFolder = 1; actionsFolders.Add(afInbox); ActionFolder afNewFolder = new ActionFolder(); afNewFolder.idAction = 4; afNewFolder.idFolder = idIn; actionsFolders.Add(afNewFolder); ActionFolder afOutBox = new ActionFolder(); afOutBox.idAction = actionout.Id; afOutBox.idFolder = 2; actionsFolders.Add(afOutBox); ActionFolder afNewFolderOut = new ActionFolder(); afNewFolderOut.idAction = 6; afNewFolderOut.idFolder = idOut; actionsFolders.Add(afNewFolderOut); // ARCHIVI ActionFolder afInboxArch = new ActionFolder(); afInboxArch.idAction = actioninArch.Id; afInboxArch.idFolder = 5; actionsFolders.Add(afInboxArch); ActionFolder afNewFolderArch = new ActionFolder(); afNewFolderArch.idAction = 4; afNewFolderArch.idFolder = idInArch; actionsFolders.Add(afNewFolderArch); ActionFolder afOutBoxArch = new ActionFolder(); afOutBoxArch.idAction = actionoutArch.Id; afOutBoxArch.idFolder = 7; actionsFolders.Add(afOutBoxArch); ActionFolder afNewFolderOutArch = new ActionFolder(); afNewFolderOutArch.idAction = 6; afNewFolderOutArch.idFolder = idOutArch; actionsFolders.Add(afNewFolderOutArch); ActionsFoldersService service = new ActionsFoldersService(); service.Insert(actionsFolders); } catch (Exception ex) { ManagedException mEx = new ManagedException(ex.Message, "FOL_APP001", string.Empty, string.Empty, ex); ErrorLogInfo er = new ErrorLogInfo(mEx); log.Error(er); throw mEx; } }