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);
}
