public static Common.Models.Tasks.TaskTime Create( Common.Models.Tasks.TaskTime model, Common.Models.Account.Users creator, IDbConnection conn = null, bool closeConnection = true) { if (!model.Id.HasValue) { model.Id = Guid.NewGuid(); } model.Created = model.Modified = DateTime.UtcNow; model.CreatedBy = model.ModifiedBy = creator; DBOs.Tasks.TaskTime dbo = Mapper.Map <DBOs.Tasks.TaskTime>(model); conn = DataHelper.OpenIfNeeded(conn); conn.Execute("INSERT INTO \"task_time\" (\"id\", \"task_id\", \"time_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @TaskId, @TimeId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo); DataHelper.Close(conn, closeConnection); return(model); }
public static Common.Models.Tasks.TaskTime RelateTask(Common.Models.Timing.Time timeModel, long taskId, Common.Models.Account.Users creator) { Common.Models.Tasks.TaskTime taskTime = new Common.Models.Tasks.TaskTime() { Id = Guid.NewGuid(), Task = new Common.Models.Tasks.Task() { Id = taskId, IsStub = true }, Time = timeModel, Created = DateTime.UtcNow, Modified = DateTime.UtcNow, CreatedBy = creator, ModifiedBy = creator }; DBOs.Tasks.TaskTime dbo = Mapper.Map <DBOs.Tasks.TaskTime>(taskTime); using (IDbConnection conn = Database.Instance.GetConnection()) { conn.Execute("INSERT INTO \"task_time\" (\"id\", \"task_id\", \"time_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @TaskId, @TimeId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo); } return(taskTime); }
public static Common.Models.Tasks.TaskTime Create(Common.Models.Tasks.TaskTime model, Common.Models.Account.Users creator) { if (!model.Id.HasValue) { model.Id = Guid.NewGuid(); } model.Created = model.Modified = DateTime.UtcNow; model.CreatedBy = model.ModifiedBy = creator; DBOs.Tasks.TaskTime dbo = Mapper.Map <DBOs.Tasks.TaskTime>(model); using (IDbConnection conn = Database.Instance.GetConnection()) { conn.Execute("INSERT INTO \"task_time\" (\"id\", \"task_id\", \"time_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @TaskId, @TimeId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo); } return(model); }
public static Common.Models.Tasks.TaskTime RelateTask( Common.Models.Timing.Time timeModel, long taskId, Common.Models.Account.Users creator, IDbConnection conn = null, bool closeConnection = true) { Common.Models.Tasks.TaskTime taskTime = new Common.Models.Tasks.TaskTime() { Id = Guid.NewGuid(), Task = new Common.Models.Tasks.Task() { Id = taskId, IsStub = true }, Time = timeModel, Created = DateTime.UtcNow, Modified = DateTime.UtcNow, CreatedBy = creator, ModifiedBy = creator }; DBOs.Tasks.TaskTime dbo = Mapper.Map <DBOs.Tasks.TaskTime>(taskTime); conn = DataHelper.OpenIfNeeded(conn); if (conn.Execute("INSERT INTO \"task_time\" (\"id\", \"task_id\", \"time_id\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " + "VALUES (@Id, @TaskId, @TimeId, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo) > 0) { timeModel.Id = conn.Query <DBOs.Tasks.TaskTime>("SELECT currval(pg_get_serial_sequence('task_time', 'id')) AS \"id\"").Single().Id; } DataHelper.Close(conn, closeConnection); return(taskTime); }