private List <ContItem> GetGisList()
{
using (SqlConnection connection = new SqlConnection(_builder.ConnectionString))
{
//Console.WriteLine("\nQuery data example:");
//Console.WriteLine("=========================================\n");
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ID ");
sb.Append(", CONT_NAME as CONT_NAME");
sb.Append(", POPU_CNT ");
sb.Append(", Latitude ");
sb.Append(", Longitude ");
sb.Append("FROM CONT_INFO ");
sb.Append("WHERE 1=1 ");
//if ((!string.IsNullOrEmpty(pId)) && (pId != "전체"))
//{
// sb.Append("AND ID = '" + pId + "' ");
//}
String sql = sb.ToString();
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(sql, connection);
adapter.Fill(ds);
//DataRow row = ds.Tables[0].Rows[0];
List <ContItem> list = new List <ContItem>();
list.Add(new ContItem()
{
ID = "", etc = "전체"
});
foreach (DataRow row in ds.Tables[0].Rows)
{
ContItem item = new ContItem();
item.ID = row["ID"].ToString();
item.CONT_NAME = row["CONT_NAME"].ToString();
item.POPU_CNT = row["POPU_CNT"].ToString();
item.Latitude = row["Latitude"].ToString();
item.Longitude = row["Longitude"].ToString();
item.etc = row["CONT_NAME"].ToString();
list.Add(item);
}
return(list);
}
}
public void AddNewItem()
{
var cont = new Cont();
cont.Age = "32";
cont.Contact = "";
var contItem = GroupedCollection.FirstOrDefault(g => g.Key == cont.Age);
if (contItem != null)
{
contItem.ContactColl.Add(cont);
}
else
{
contItem = new ContItem();
contItem.Key = cont.Age;
contItem.ContactColl.Add(cont);
}
}
public void SetInitialCollection()
{
//Add the existing items in ContactList (if any) to a grouped collection.
var keyList = Contlist.GroupBy(c => c.Age).Select(g => g.Key);
foreach (var key in keyList)
{
var contItem = new ContItem();
contItem.Key = key;
var contList = Contlist.Where(c => c.Age == key);
foreach (var item in contList)
{
contItem.ContactColl.Add(item);
}
GroupedCollection.Add(contItem);
}
}
public XNode ToXML()
{
XElement xSection = new XElement(Fb2Const.fb2DefaultNamespace + Fb2TextSectionElementName);
if (!string.IsNullOrEmpty(ID))
{
xSection.Add(new XAttribute("id", ID));
}
if (!string.IsNullOrEmpty(Lang))
{
xSection.Add(new XAttribute(XNamespace.Xml + "lang", Lang));
}
if (Title != null)
{
xSection.Add(Title.ToXML());
}
foreach (EpigraphItem EpItem in epigraphs)
{
xSection.Add(EpItem.ToXML());
}
if (SectionImages.Count != 0)
{
//xSection.Add(SectionImages.ToXML());
foreach (var image in SectionImages)
{
xSection.Add(image.ToXML());
}
}
if (Annotation != null)
{
xSection.Add(Annotation.ToXML());
}
foreach (IFb2TextItem ContItem in content)
{
xSection.Add(ContItem.ToXML());
}
return(xSection);
}
