public static Common.Models.Events.EventTask RelateToTask(Common.Models.Events.Event model, Common.Models.Tasks.Task task, Common.Models.Account.Users actor) { Common.Models.Events.EventTask et; DBOs.Events.EventTask dbo = null; et = Data.Events.EventTask.Get(task.Id.Value, model.Id.Value); if (et != null) { return(et); } et = new Common.Models.Events.EventTask(); et.Id = Guid.NewGuid(); et.CreatedBy = et.ModifiedBy = actor; et.Created = et.Modified = DateTime.UtcNow; et.Event = model; et.Task = task; dbo = Mapper.Map <DBOs.Events.EventTask>(et); using (IDbConnection conn = Database.Instance.GetConnection()) { conn.Execute("INSERT INTO \"event_task\" (\"id\", \"event_id\", \"task_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @EventId, @TaskId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo); } return(et); }
public static Common.Models.Events.EventTask RelateToTask(Common.Models.Events.Event model, Common.Models.Tasks.Task task, Common.Models.Account.Users actor, IDbConnection conn = null, bool closeConnection = true) { Common.Models.Events.EventTask et; DBOs.Events.EventTask dbo = null; et = Data.Events.EventTask.Get(task.Id.Value, model.Id.Value); if (et != null) { return(et); } et = new Common.Models.Events.EventTask(); et.Id = Guid.NewGuid(); et.CreatedBy = et.ModifiedBy = actor; et.Created = et.Modified = DateTime.UtcNow; et.Event = model; et.Task = task; dbo = Mapper.Map <DBOs.Events.EventTask>(et); conn = DataHelper.OpenIfNeeded(conn); if (conn.Execute("INSERT INTO \"event_task\" (\"id\", \"event_id\", \"task_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @EventId, @TaskId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo) > 0) { model.Id = conn.Query <DBOs.Events.EventTask>("SELECT currval(pg_get_serial_sequence('event_task', 'id')) AS \"id\"").Single().Id; } DataHelper.Close(conn, closeConnection); return(et); }