public void Save(DBHelper target, Project project) { _blockTypeInstanceId = project != null ? project.BlockTypeInstanceId : NonProjectTTBlockTypeInstanceId; _blockId = target.RunTextInteger("INSERT INTO [cls_TimeTrackingBlock] ([Modified],[ModifierId],[Card],[Title],[BlockTypeInstanceId],[Day1],[Day2],[Day3],[Day4],[Day5],[Day6],[Day7],[OwnerId],[mc_StateId],[mc_StateMachineId],[StartDate],[ProjectId],[AreFinancesRegistered],[IsRejected]) VALUES (@p1,@p2,@p3,@p5,@p6,@p7,@p7,@p7,@p7,@p7,@p7,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14) SELECT @retval = SCOPE_IDENTITY()" , DBHelper.MP("@p1", SqlDbType.DateTime, _lastSavedDate) , DBHelper.MP("@p2", SqlDbType.Int, _lastEditorId) , DBHelper.MP("@p3", SqlDbType.NVarChar, 50, "TimeTrackingBlockDescr") , DBHelper.MP("@p5", SqlDbType.NVarChar, 100, _title) , DBHelper.MP("@p6", SqlDbType.Int, _blockTypeInstanceId) , DBHelper.MP("@p7", SqlDbType.Float, 0F) , DBHelper.MP("@p8", SqlDbType.Int, _userId) , DBHelper.MP("@p9", SqlDbType.Int, ConvertState(_statusId, _projectId > 0, ref _isRejected)) , DBHelper.MP("@p10", SqlDbType.Int, TTBlockStateMachineId) , DBHelper.MP("@p11", SqlDbType.DateTime, _startDate) , DBHelper.MP("@p12", SqlDbType.Int, _projectId > 0 ? (object)_projectId : DBNull.Value) , DBHelper.MP("@p13", SqlDbType.Bit, _areFinancesRegistered) , DBHelper.MP("@p14", SqlDbType.Bit, _isRejected) ); if (!string.IsNullOrEmpty(_managerComments)) { target.RunText("INSERT INTO [cls_TimeTrackingBlockDescr] ([TimeTrackingBlockId],[Description]) VALUES (@p1,@p2)" , DBHelper.MP("@p1", SqlDbType.Int, _blockId) , DBHelper.MP("@p2", SqlDbType.NText, _managerComments) ); } // Save role principals Helper.SaveRolePrincipals(target, "cls_TimeTrackingBlock_Role_Principal", _blockId, 6, _userId); // Owner if (project != null) project.SaveProjectRoles(target, "cls_TimeTrackingBlock_Role_Principal", _blockId); }
public void Save(DBHelper target) { target.RunText( "INSERT INTO [cls_Project] ([ProjectId],[Title],[StatusId]) VALUES (@p1,@p2,@p3)" , DBHelper.MP("@p1", SqlDbType.Int, _projectId) , DBHelper.MP("@p2", SqlDbType.NVarChar, 100, _title) , DBHelper.MP("@p3", SqlDbType.Int, _statusId) ); SaveProjectRoles(target, "cls_Project_Role_Principal", _projectId); _blockTypeInstanceId = target.RunTextInteger( "INSERT INTO [cls_TimeTrackingBlockTypeInstance] ([Title],[BlockTypeId],[ProjectId]) VALUES (@p1,@p2,@p3) SELECT @retval = SCOPE_IDENTITY()" , DBHelper.MP("@p1", SqlDbType.NVarChar, 100, _title) , DBHelper.MP("@p2", SqlDbType.Int, ProjectTTBlockTypeId) , DBHelper.MP("@p3", SqlDbType.Int, _projectId) ); SaveProjectRoles(target, "cls_TimeTrackingBlockTypeInstance_Role_Principal", _blockTypeInstanceId); }
public void Save(DBHelper target) { int objectTypeId = _objectTypeId; int objectId = _objectId; if (objectTypeId == 11) { objectTypeId = -1; objectId = -1; } _entryId = target.RunTextInteger("INSERT INTO [cls_TimeTrackingEntry] ([Card],[Title],[BlockTypeInstanceId],[Day1],[Day2],[Day3],[Day4],[Day5],[Day6],[Day7],[OwnerId],[ParentBlockId],[ObjectTypeId],[ObjectId],[TotalApproved],[Rate]) VALUES (@p1,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19) SELECT @retval = SCOPE_IDENTITY()" , DBHelper.MP("@p1", SqlDbType.NVarChar, 50, "TimeTrackingEntryDescr") , DBHelper.MP("@p5", SqlDbType.NVarChar, 100, _title) , DBHelper.MP("@p6", SqlDbType.Int, _blockTypeInstanceId) , DBHelper.MP("@p7", SqlDbType.Float, _day1) , DBHelper.MP("@p8", SqlDbType.Float, _day2) , DBHelper.MP("@p9", SqlDbType.Float, _day3) , DBHelper.MP("@p10", SqlDbType.Float, _day4) , DBHelper.MP("@p11", SqlDbType.Float, _day5) , DBHelper.MP("@p12", SqlDbType.Float, _day6) , DBHelper.MP("@p13", SqlDbType.Float, _day7) , DBHelper.MP("@p14", SqlDbType.Int, _ownerId) , DBHelper.MP("@p15", SqlDbType.Int, _parentBlockId) , DBHelper.MP("@p16", SqlDbType.Int, objectTypeId > 0 ? (object)objectTypeId : DBNull.Value) , DBHelper.MP("@p17", SqlDbType.Int, objectId > 0 ? (object)objectId : DBNull.Value) , DBHelper.MP("@p18", SqlDbType.Float, _totalApproved) , DBHelper.MP("@p19", SqlDbType.Money, _rate) ); if (!string.IsNullOrEmpty(_userComments)) { target.RunText("INSERT INTO [cls_TimeTrackingEntryDescr] ([TimeTrackingEntryId],[Comment]) VALUES (@TimeTrackingEntryId,@Comment)" , DBHelper.MP("@TimeTrackingEntryId", SqlDbType.Int, _entryId) , DBHelper.MP("@Comment", SqlDbType.NText, _userComments) ); } if (_actualId > 0) { target.RunText("UPDATE [ActualFinances] SET [BlockId]=@BlockId, [OwnerId]=@OwnerId, [TotalApproved]=@TotalApproved WHERE [ActualFinancesId]=@ActualFinancesId" , DBHelper.MP("@BlockId", SqlDbType.Int, _parentBlockId) , DBHelper.MP("@ActualFinancesId", SqlDbType.Int, _actualId) , DBHelper.MP("@OwnerId", SqlDbType.Int, _ownerId) , DBHelper.MP("@TotalApproved", SqlDbType.Float, _totalApproved) ); } }