public static void Create(FinancialValidationType validationType, IHasIdentity foreignObject,
Person actingPerson, double amount)
{
SwarmDb.GetDatabaseForWriting()
.CreateFinancialValidation(validationType, GetDependencyType(foreignObject), foreignObject.Identity,
DateTime.Now, actingPerson.Identity, amount);
}
public BasicFinancialValidation(int financialValidationId, FinancialValidationType validationType, int personId, DateTime dateTime, FinancialDependencyType dependencyType, int foreignId)
{
this.FinancialValidationId = financialValidationId;
this.ValidationType = validationType;
this.PersonId = personId;
this.DateTime = dateTime;
this.DependencyType = dependencyType;
this.ForeignId = foreignId;
}
public BasicFinancialValidation (int financialValidationId, FinancialValidationType validationType, int personId, DateTime dateTime, FinancialDependencyType dependencyType, int foreignId)
{
this.FinancialValidationId = financialValidationId;
this.ValidationType = validationType;
this.PersonId = personId;
this.DateTime = dateTime;
this.DependencyType = dependencyType;
this.ForeignId = foreignId;
}
public BasicFinancialValidation(int financialValidationId, FinancialValidationType validationType, int personId,
DateTime dateTime, FinancialDependencyType dependencyType, int foreignId)
{
FinancialValidationId = financialValidationId;
ValidationType = validationType;
PersonId = personId;
DateTime = dateTime;
DependencyType = dependencyType;
ForeignId = foreignId;
}
private static BasicFinancialValidation ReadFinancialValidationFromDataReader(IDataRecord reader)
{
int financialValidationId = reader.GetInt32(0);
FinancialValidationType validationType =
(FinancialValidationType)(Enum.Parse(typeof(FinancialValidationType), reader.GetString(1)));
FinancialDependencyType dependencyType =
(FinancialDependencyType)(Enum.Parse(typeof(FinancialDependencyType), reader.GetString(2)));
int foreignId = reader.GetInt32(3);
DateTime dateTime = reader.GetDateTime(4);
int personId = reader.GetInt32(5);
double amount = reader.GetDouble(6); // not yet used
return(new BasicFinancialValidation(financialValidationId, validationType, personId, dateTime, dependencyType, foreignId));
}
// TODO: Return BasicFinancialValidation object
public void CreateFinancialValidation (FinancialValidationType validationType, FinancialDependencyType dependencyType, int foreignId,
DateTime validatedDateTime, int personId, double amount)
{
using (DbConnection connection = GetMySqlDbConnection())
{
connection.Open();
DbCommand command = GetDbCommand("CreateFinancialValidation", connection);
command.CommandType = CommandType.StoredProcedure;
AddParameterWithName(command, "validationType", validationType.ToString());
AddParameterWithName(command, "dependencyType", dependencyType.ToString());
AddParameterWithName(command, "foreignId", foreignId);
AddParameterWithName(command, "validatedDateTime", validatedDateTime);
AddParameterWithName(command, "personId", personId);
AddParameterWithName(command, "amount", amount);
command.ExecuteNonQuery();
}
}
public static void Create(FinancialValidationType validationType, IHasIdentity foreignObject, Person actingPerson)
{
Create(validationType, foreignObject, actingPerson, 0.0);
}
