protected void btnSave_Click(object sender, EventArgs e)
{
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.Name = "RoadbookDB";
dbInfo.Ip = "127.0.0.1";
dbInfo.Port = 1433;
dbInfo.UserId = "sa";
dbInfo.UserPassword = "******";
MsSqlManager ms = new MsSqlManager();
ms.Open(dbInfo);
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append(" INSERT TB_CONTENTS ( TITLE, SUMMARY, CREATE_DT, CREATE_USER_NM, TAGS, CATEGORY_IDX ) ");
sbSQL.Append(
string.Format(" VALUES( '{0}', '{1}', '{2}', '{3}', '{4}', '{5}' )",
txtTitle.Text,
txtSummary.Text,
DateTime.Now.ToString("yyyy-MM-dd"),
txtUserNm.Text,
txtTags.Text,
2
)
);
ms.Insert(sbSQL.ToString());
Response.Redirect("Default.aspx");
}
public void Run()
{
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.Name = "RoadbookDB";
dbInfo.Ip = "127.0.0.1";
dbInfo.Port = 1433;
dbInfo.UserId = "sa";
dbInfo.UserPassword = "******";
MsSqlManager ms = new MsSqlManager();
ms.Open(dbInfo);
StringBuilder sbMessage = new StringBuilder();
sbMessage.AppendLine("******************************");
sbMessage.AppendLine("1. SELECT");
sbMessage.AppendLine("2. INSERT");
sbMessage.AppendLine("3. UPDATE");
sbMessage.AppendLine("4. DELETE");
sbMessage.AppendLine("0. QUIT");
sbMessage.AppendLine("******************************");
while (true)
{
Console.WriteLine(sbMessage.ToString());
string input = Console.ReadLine();
if (input == "0")
{
ms.Close();
Console.WriteLine("BYE!!");
break;
}
else
{
string index = string.Empty;
string title = string.Empty;
string summary = string.Empty;
string createUserNm = string.Empty;
string tags = string.Empty;
string createDate = string.Empty;
StringBuilder sbSQL = new StringBuilder();
switch (input)
{
case "1": // SELECT
DataTable dt = ms.Select("SELECT IDX, TITLE, SUMMARY, CREATE_DT, CREATE_USER_NM, TAGS, LIKE_CNT, CATEGORY_IDX FROM TB_CONTENTS");
if (dt.Rows.Count > 0)
{
string[] columns = new string[dt.Columns.Count];
for (int idx = 0; idx < dt.Columns.Count; idx++)
{
columns[idx] = dt.Columns[idx].ToString();
Console.Write(dt.Columns[idx] + "\t");
}
Console.WriteLine();
for (int idx = 0; idx < dt.Rows.Count; idx++)
{
for (int idx_j = 0; idx_j < dt.Columns.Count; idx_j++)
{
Console.Write(dt.Rows[idx][columns[idx_j]] + "\t");
}
Console.WriteLine();
}
}
else
{
Console.WriteLine("No Data!!");
}
break;
case "2": // INSERT
Console.Write("TITLE : ");
title = Console.ReadLine();
Console.Write("SUMMARY : ");
summary = Console.ReadLine();
Console.Write("CREATE_USER_NM : ");
createUserNm = Console.ReadLine();
Console.Write("TAGS : ");
tags = Console.ReadLine();
createDate = DateTime.Now.ToString("yyyy-MM-dd");
sbSQL.Append(" INSERT TB_CONTENTS ( TITLE, SUMMARY, CREATE_DT, CREATE_USER_NM, TAGS, CATEGORY_IDX ) ");
sbSQL.Append(
string.Format(" VALUES( '{0}', '{1}', '{2}', '{3}', '{4}', '{5}' )",
title, summary, createDate, createUserNm, tags, 2
)
);
ms.Insert(sbSQL.ToString());
break;
case "3": // UPDATE
ms.Open(dbInfo);
Console.Write("Changed IDX : ");
index = Console.ReadLine();
Console.Write("TITLE : ");
title = Console.ReadLine();
Console.Write("SUMMARY : ");
summary = Console.ReadLine();
sbSQL.Append(" UPDATE TB_CONTENTS SET ");
sbSQL.Append(
string.Format(" TITLE = '{0}', SUMMARY = '{1}' ",
title, summary
)
);
sbSQL.Append(
string.Format(" WHERE IDX = {0}",
index
)
);
ms.Update(sbSQL.ToString());
break;
case "4": // DELETE
ms.Open(dbInfo);
Console.Write("DELETED IDX : ");
index = Console.ReadLine();
sbSQL.Append(" DELETE FROM TB_CONTENTS ");
sbSQL.Append(
string.Format(" WHERE IDX = {0}",
index
)
);
ms.Update(sbSQL.ToString());
break;
default:
Console.WriteLine("Invalid");
break;
}
}
}
}
