public static SecurityCollection GetSecuritiesByName(string secName, Type securityType) { SecurityCollection matchingSecs = new SecurityCollection(); string query = string.Format("SELECT SecurityId, Name FROM {0} WHERE Name LIKE '%{1}%'", securityType.Name, secName); DataTable result = DAL.DbInstance.ExecuteSqlQuery(query).Tables[0]; foreach(DataRow row in result.Rows) { matchingSecs.Add(new Security() { Name = (string)row["Name"], SecurityId = Convert.ToInt32(row["SecurityId"]) }); } return matchingSecs; }
public string UpdateSecurity(Json_Tabs json) { try { Security newSecurity = json.ConvertToSecurityObject(); SecurityCollection securities = new SecurityCollection(); securities.Add(newSecurity); securities.PersistCollection(true); } catch (Exception ex) { return ex.Message; } return "true"; }
public SecurityCollection ReadSecuritiesFromFile(string filePath) { SecurityCollection securities = new SecurityCollection(); string securityName = Path.GetFileNameWithoutExtension(filePath); Dictionary<string, List<Dictionary<string, string>>> securitiesData = new Dictionary<string, List<Dictionary<string, string>>>(); if(File.Exists(filePath)) { InstantiateReader(Path.GetExtension(filePath)); reader.OpenFile(filePath); if (reader.GetType() == typeof(ExcelReader)) (reader as ExcelReader).SheetName = securityName; securitiesData = reader.ReadFile(); reader.CloseFile(); //Convert the complex dictionary to a list of security objects Dictionary<string, string> attributeMapping = SecurityAttribute.GetAttributeMappings(GetSecurityObject(securityName).GetType()); foreach (var securityRow in securitiesData[securityName]) { securities.Add(FillSecurityObject(GetSecurityObject(securityName), securityRow, attributeMapping)); } } return securities; }