private static BasicExpenseClaimGroup ReadExpenseClaimGroupFromDataReader(DbDataReader reader) { int expenseClaimGroupId = reader.GetInt32(0); DateTime createdDateTime = reader.GetDateTime(1); int createdByPersonId = reader.GetInt32(2); bool open = reader.GetInt32(3) != 0 ? true : false; string groupTypeName = reader.GetString(4); string groupData = reader.GetString(5); ExpenseClaimGroupType groupType = (ExpenseClaimGroupType)Enum.Parse(typeof(ExpenseClaimGroupType), groupTypeName); return(new BasicExpenseClaimGroup(expenseClaimGroupId, createdDateTime, createdByPersonId, open, groupType, groupData)); }
/* * IN organizationId INT, * IN dateTime DATETIME, * IN createdByPersonId INT, * IN expenseClaimGroupType VARCHAR(64), * IN expenseClaimGroupData TEXT */ public int CreateExpenseClaimGroup(int organizationId, int personId, ExpenseClaimGroupType groupType, string groupData) { DateTime utcNow = DateTime.UtcNow; using (DbConnection connection = GetMySqlDbConnection()) { connection.Open(); DbCommand command = GetDbCommand("CreateExpenseClaimGroup", connection); command.CommandType = CommandType.StoredProcedure; AddParameterWithName(command, "organizationId", organizationId); AddParameterWithName(command, "createdByPersonId", personId); AddParameterWithName(command, "dateTime", utcNow); AddParameterWithName(command, "expenseClaimGroupType", groupType.ToString()); AddParameterWithName(command, "expenseClaimGroupData", groupData); return(Convert.ToInt32(command.ExecuteScalar())); } }
public static ExpenseClaimGroup Create(Organization organization, Person creatingPerson, ExpenseClaimGroupType groupType, string rawGroupData) { return(FromIdentityAggressive(SwarmDb.GetDatabaseForWriting().CreateExpenseClaimGroup(organization.Identity, creatingPerson.Identity, groupType, rawGroupData))); }
public BasicExpenseClaimGroup(int expenseClaimGroupId, DateTime createdDateTime, int createdByPersonId, bool open, ExpenseClaimGroupType groupType, string groupData) { this.ExpenseClaimGroupId = expenseClaimGroupId; this.CreatedDateTime = createdDateTime; this.CreatedByPersonId = createdByPersonId; this.Open = open; this.GroupType = groupType; this.GroupData = groupData; }