static public void post()
{
var csvFile = SqliteHelper.CsvContext("RoomData.csv");
using (csvFile){
using (var csv = new CsvReader(csvFile, System.Globalization.CultureInfo.CurrentCulture))
{
// Get room data
var roomData = csv.GetRecords <Room>();
// Connect to db
var connection = SqliteHelper.DBContext("HsiuHsien_MainDB.db");
using (connection){
connection.DefaultTimeout = 60;
//Insert initial room data
connection.Open();
var insertCmd = connection.CreateCommand();
foreach (var rm in roomData)
{
insertCmd.CommandText = String.Format(@"INSERT INTO Ro_Dtl (
Ro_No, Ro_Lv, Ro_Nm, Ro_Type,
Ro_Bos_No, Mns_No, Pre_Ro_No, Child_Ro_No
) VALUES (
'{0}', '{1}', '{2}', {3},
'{4}', '{5}', '{6}', '{7}')",
rm.Ro_No, rm.Ro_Lv, rm.Ro_Nm, rm.Ro_Type,
rm.Ro_Bos_No, rm.Mns_No, rm.Pre_Ro_No, rm.Child_Ro_No
);
insertCmd.ExecuteNonQuery();
}
}
}
}
}
static public void post()
{
var csvFile = SqliteHelper.CsvContext("MonsterData.csv");
using (csvFile){
using (var csv = new CsvReader(csvFile, System.Globalization.CultureInfo.CurrentCulture))
{
// Get monster data .csv
var monsterData = csv.GetRecords <Monster>();
// Connnect to db
var connection = SqliteHelper.DBContext("HsiuHsien_MainDB.db");
using (connection){
connection.DefaultTimeout = 60;
// Insert initial monster data
connection.Open();
var insertCmd = connection.CreateCommand();
foreach (var mns in monsterData)
{
insertCmd.CommandText = String.Format(@"INSERT INTO Mns_Dtl (
Mns_No, Mns_Nm, Mns_Type,
Lv, HP, MP, ATK, MATK,
Critical, DEF, MDEF,
ASPD, re_EXP, re_Mon
) VALUES (
'{0}', '{1}', {2},
'{3}', '{4}', '{5}', {6}, {7},
{8}, {9}, {10},
{11}, '{12}', '{13}')",
mns.Mns_No, mns.Mns_Nm, mns.Mns_Type,
mns.Lv, mns.HP, mns.MP, mns.ATK, mns.MATK,
mns.Critical, mns.DEF, mns.MDEF,
mns.ASPD, mns.re_EXP, mns.re_Mon);
insertCmd.ExecuteNonQuery();
}
}
}
}
}