public static void NpgsqlDBImportCategory(ModelCategory mCategory)
{
string conn_str = "Server=localhost;Port=5432;User ID=xiao;Database=note;Password=xiao;Enlist=true";
using (NpgsqlConnection conn = new NpgsqlConnection(conn_str))
{
//PostgreSQLへ接続
conn.Open();
int cid = GetLastId("category", 40000000, conn);
int chid = GetLastId("category_item", 41000000, conn);
for (int i = mCategory.Items.Count - 1; i >= 0; i--)
{
var item = mCategory.Items[i];
var root = InsertCategoryChild(conn, item.Category, 0, 0, ref chid);
string cmd_str = string.Format("insert into category (id, name, start_date, end_date, input_date, item_id) values " +
"('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');",
++cid, QuoConv(item.Name), QuoConv(item.Date.ToString("yyyy-MM-dd")), "9999-12-31",
QuoConv(item.Date.ToString("yyyy-MM-dd")), root);
NpgsqlCommand cmd = new NpgsqlCommand(cmd_str, conn);
var rtn1 = cmd.ExecuteNonQuery();
Console.WriteLine("Insert success! {0}", item.Name);
}
Console.WriteLine("Insert Complete!");
conn.Close();
}
}
private void InitialCategory()
{
mCategory = new ModelCategory();
mCategory.Read();
hisCategoryList = new List <ViewCategoryObject>();
BindCategoryList();
newCategoryItems = new List <CategoryItem>();
BindCategoryItem();
dateTimePickerCategory.Value = DateTime.Today;
}
public Category ReadCategory(DateTime curDate, ModelCategory mCategory)
{
EndTime = DateTime.MaxValue;
foreach (var itr in mCategory.Items)
{
if (itr.Name == "Collection" && itr.Date > curDate)
{
EndTime = itr.Date;
}
else if (itr.Name == "Collection" && itr.Date <= curDate)
{
Category = new Category(itr.Category);
StartTime = itr.Date;
break;
}
}
if (Category == null)
{
Category = new Category("Collection");
//throw new Exception("No Timetable is found in \"Category.xml\".");
}
return(Category);
}
//Timetable Read
public TimetableItem ReadTimetable(DateTime curDate, ModelCategory mCategory)
{
EndTime = DateTime.MaxValue;
foreach (var itr in mCategory.Items)
{
if (itr.Name == "Event" && itr.Date > curDate)
{
EndTime = itr.Date;
}
else if (itr.Name == "Event" && itr.Date <= curDate)
{
Timetable = new TimetableItem(itr.Category);
StartTime = itr.Date;
break;
}
}
if (Timetable == null)
{
Timetable = new TimetableItem("Event");
//throw new Exception("No Timetable is found in \"Category.xml\".");
}
return(Timetable);
}
private void InitializeCategory()
{
mCategory = new ModelCategory();
mCategory.Read();
}
