public Boolean DeleteSecurity(Security securityObject)
{
command = new SqlCommand();
command.Connection = conn;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "DeleteSecurity";
command.Parameters.AddWithValue("@securityTypeId", SqlDbType.VarChar).Value = securityObject.GetType();
command.Parameters.AddWithValue("@securityId", SqlDbType.VarChar).Value = securityObject.SecurityId;
command.ExecuteNonQuery();
return true;
}
Security FillSecurityObject(Security security, Dictionary<string, string> securityRow, Dictionary<string, string> attributeMapping)
{
foreach (var key in securityRow.Keys)
{
if (attributeMapping.Keys.Contains(key) && securityRow[key] != string.Empty)
{
Type propertyType = security.GetType().GetProperty(attributeMapping[key]).PropertyType;
//TODO: Find a way to convert the date strings from excel into SqlDateTime properly. Below statement is temporarily placed to avoid using the Date attributes.
if (propertyType == typeof(SqlDateTime))
continue;
security.GetType().GetProperty(attributeMapping[key]).SetValue(
security,
Convert.ChangeType(securityRow[key], propertyType),
null
);
}
}
return security;
}
//public Security this[int index] { get { return securitiesList[index]; } }
public void Add(Security security)
{
SecuritiesList.Add(security);
}