public static void DeleteItem(int id)
{
try
{
// Delete item.
DLAccount.Select(id, null, null, null, null, null, "DELETE FROM item WHERE id=@Id");
}
catch (Exception exception)
{
throw exception;
}
}
public static void InsertItem(int accountId, string iname)
{
try
{
// Insert item. WHERE id=@Id"
DLAccount.Insert(accountId, null, null, iname, null, DateTime.Now.ToString("yyyy.MM.dd H:mm:ss"), "INSERT INTO item (iname, rdate, account_id) VALUES (@Fname, @Rdate, @Id)");
}
catch (Exception exception)
{
throw exception;
}
}
public static int SetAccount(string email, string pword, string fname, string lname)
{
try
{
// Return inserted accountId from DL.
return(DLAccount.Insert(0, email, pword, fname, lname, DateTime.Now.ToString("yyyy.MM.dd H:mm:ss"), "INSERT INTO account VALUES (@Id, @Email, @Pword, @Fname, @Lname, @Rdate)"));
}
catch (Exception exception)
{
throw exception;
}
}
public static bool IsAccountExist(string email, string pword)
{
try
{
// Get accountId dataTable from DL.
DataTable dataTable = DLAccount.Select(0, email, pword, null, null, null, "SELECT id FROM account WHERE email=@Email AND pword=@Pword");
// Return bool if account exist. (Conditional operator)
return((dataTable.Rows.Count > 0) ? true : false);
}
catch (Exception exception)
{
throw exception;
}
}
public static Account GetAccount(int id)
{
try
{
// Get account dataTable from DL.
DataTable dataTable = DLAccount.Select(id, null, null, null, null, null, "SELECT * FROM account WHERE id=@Id");
// Return account.
return(new Account(dataTable.Rows[0][0].ToString(), dataTable.Rows[0][1].ToString(), dataTable.Rows[0][2].ToString(), dataTable.Rows[0][3].ToString(), dataTable.Rows[0][4].ToString(), dataTable.Rows[0][5].ToString()));
}
catch (Exception exception)
{
throw exception;
}
}
public static int GetAccountId(string email, string pword)
{
try
{
// Get accountId dataTable from DL.
DataTable dataTable = DLAccount.Select(0, email, pword, null, null, null, "SELECT id FROM account WHERE email=@Email AND pword=@Pword");
// Return accountId if account exist. (Conditional operator)
return((dataTable.Rows.Count > 0) ? Convert.ToInt32(dataTable.Rows[0][0]) : 0);
}
catch (Exception exception)
{
throw exception;
}
}
public static List <Item> GetItems(int accountId)
{
try
{
List <Item> items = new List <Item>();
// Get items dataTable from DL.
DataTable dataTable = DLAccount.Select(accountId, null, null, null, null, null, "SELECT item.id, item.iname, account.email, item.rdate FROM item LEFT JOIN account ON account.id = item.account_id");
foreach (DataRow dataRow in dataTable.Rows)
{
items.Add(new Item(dataRow[0].ToString(), dataRow[1].ToString(), dataRow[2].ToString(), dataRow[3].ToString()));
}
return(items);
}
catch (Exception exception)
{
throw exception;
}
}