public Type810Name ParseName(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type810Name { EntityIdType = element.GetChildText(empty + "EntityIdType"), EntityName = element.GetChildText(empty + "EntityName"), EntityDuns = element.GetChildText(empty + "EntityDuns"), EntityIdCode = element.GetChildText(empty + "EntityIdCode"), Address1 = element.GetChildText(empty + "Address1"), Address2 = element.GetChildText(empty + "Address2"), City = element.GetChildText(empty + "City"), State = element.GetChildText(empty + "State"), PostalCode = element.GetChildText(empty + "PostalCode"), EntityName2 = element.GetChildText(empty + "EntityName2"), EntityName3 = element.GetChildText(empty + "EntityName3"), }; return(model); }
public Type810Name[] ListNames(int headerKey) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("esp_810NameList")) { command.AddWithValue("@HeaderKey", headerKey); if (connection.State != ConnectionState.Open) { connection.Open(); } var collection = new List <Type810Name>(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var item = new Type810Name { HeaderKey = headerKey, NameKey = reader.GetInt32("Name_Key"), }; reader.TryGetString("EntityIdType", x => item.EntityIdType = x); reader.TryGetString("EntityName", x => item.EntityName = x); reader.TryGetString("EntityDuns", x => item.EntityDuns = x); reader.TryGetString("EntityIdCode", x => item.EntityIdCode = x); reader.TryGetString("EntityName2", x => item.EntityName2 = x); reader.TryGetString("EntityName3", x => item.EntityName3 = x); reader.TryGetString("Address1", x => item.Address1 = x); reader.TryGetString("Address2", x => item.Address2 = x); reader.TryGetString("City", x => item.City = x); reader.TryGetString("State", x => item.State = x); reader.TryGetString("PostalCode", x => item.PostalCode = x); collection.Add(item); } return(collection.ToArray()); } } }
public Type810Name LoadFirstName(int headerKey) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("csp810ExportName")) { command.AddWithValue("@HeaderKey", headerKey); if (connection.State != ConnectionState.Open) { connection.Open(); } using (var reader = command.ExecuteReader()) { if (!reader.Read()) { return(null); } var item = new Type810Name { HeaderKey = headerKey, NameKey = reader.GetInt32("Name_Key"), }; reader.TryGetString("EntityIdType", x => item.EntityIdType = x); reader.TryGetString("EntityName", x => item.EntityName = x); reader.TryGetString("EntityDuns", x => item.EntityDuns = x); reader.TryGetString("EntityIdCode", x => item.EntityIdCode = x); reader.TryGetString("Address1", x => item.Address1 = x); reader.TryGetString("Address2", x => item.Address2 = x); reader.TryGetString("City", x => item.City = x); reader.TryGetString("State", x => item.State = x); reader.TryGetString("PostalCode", x => item.PostalCode = x); reader.TryGetString("EntityName2", x => item.EntityName2 = x); reader.TryGetString("EntityName3", x => item.EntityName3 = x); return(item); } } }
public int InsertName(Type810Name model) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("csp810NameInsert")) { SqlParameter keyParameter; command.AddWithValue("@810_Key", model.HeaderKey) .AddWithValue("@EntityIdType", model.EntityIdType) .AddWithValue("@EntityName", model.EntityName) .AddWithValue("@EntityDuns", model.EntityDuns) .AddWithValue("@EntityIdCode", model.EntityIdCode) .AddWithValue("@EntityName2", model.EntityName2) .AddWithValue("@EntityName3", model.EntityName3) .AddWithValue("@Address1", model.Address1) .AddWithValue("@Address2", model.Address2) .AddWithValue("@City", model.City) .AddWithValue("@State", model.State) .AddWithValue("@PostalCode", model.PostalCode) .AddOutParameter("@Name_Key", SqlDbType.Int, out keyParameter); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); if (keyParameter.Value == null) { throw new Exception(); } var nameKey = (int)keyParameter.Value; model.NameKey = nameKey; return(nameKey); } }
public int InsertName(Type810Name model) { return(-1); }