/// <summary> /// Inserts this instance's data into the database as a new record. /// </summary> /// <param name="createdBy">Used to set the CreatedBy value of the record.</param> private void Insert(Guid createdBy) { var userDih = new DataIntegrationHub.Business.Entities.User(createdBy); var planPerformanceSecurityRole = new DataIntegrationHub.Business.Entities.SecurityRole(new Guid("7FE92C15-05A4-4848-851D-C9B5319CAA0B")); var userDihSecurityRoles = DataIntegrationHub.Business.Entities.UserSecurityRole.GetAssociatedFromUser(userDih); var userDihPlanPerformanceRoleCount = userDihSecurityRoles.FindAll(x => x.SecurityRoleId == planPerformanceSecurityRole.SecurityRoleId).Count(); var userIsAuthorized = userDihPlanPerformanceRoleCount > 0; if (userIsAuthorized) { SqlCrud.ClearColumns(); RegisteredColumns.Clear(); RegisterMembers(); foreach (ColumnTuple columnTuple in RegisteredColumns) { SqlCrud.AddColumn(columnTuple.Name, columnTuple.Value); } SqlCrud.AddColumn("ModifiedBy", createdBy); SqlCrud.AddColumn("ModifiedOn", DateTime.Now); SqlCrud.AddColumn("CreatedBy", createdBy); SqlCrud.AddColumn("CreatedOn", DateTime.Now); SqlCrud.AddColumn("StateCode", this.StateCode); SqlCrud.Create(this.Id); } else { throw new Exception("You are not authorized to insert records in the plan performance app."); } }
/// <summary> /// Inserts this instance's data into the database as a new record. /// </summary> /// <param name="createdBy">Used to set the CreatedBy value of the record.</param> private void Insert(Guid createdBy) { SqlCrud.ClearColumns(); RegisteredColumns.Clear(); RegisterMembers(); foreach (ColumnTuple columnTuple in RegisteredColumns) { SqlCrud.AddColumn(columnTuple.Name, columnTuple.Value); } SqlCrud.AddColumn("ModifiedBy", createdBy); SqlCrud.AddColumn("ModifiedOn", DateTime.Now); SqlCrud.AddColumn("CreatedBy", createdBy); SqlCrud.AddColumn("CreatedOn", DateTime.Now); SqlCrud.AddColumn("StateCode", this.StateCode); SqlCrud.Create(this.Id); }