private void add(string strMode)
{
string _TransDate;
string _MainCategoryId;
string _SubCategoryId;
string _Amount;
string _DenomiId;
string _Memo;
DateTime dt = DateTime.Today;
string _Today = dt.ToShortDateString();
Console.Write(string.Format("Trans date? (Default : {0}) : ", _Today));
_TransDate = Console.ReadLine();
if (_TransDate == "")
{
_TransDate = _Today;
}
while (true)
{
Console.Write("Input MainCategoryId (Optional) : ");
_MainCategoryId = Console.ReadLine();
switch (_MainCategoryId)
{
case "\t":
Category ctg = new Category(_strConn);
ctg.listMain();
continue;
case "":
//Noneを選択
_MainCategoryId = "1";
break;
case "x":
return;
default:
break;
}
break;
}
while (true)
{
Console.Write("Input SubCategoryId (Optional) : ");
_SubCategoryId = Console.ReadLine();
switch (_SubCategoryId)
{
case "\t":
Category ctg = new Category(_strConn);
ctg.list();
continue;
case "":
//Noneを選択
_SubCategoryId = "1";
break;
case "x":
return;
default:
break;
}
break;
}
while (true)
{
Console.Write("Input Amount : ");
_Amount = Console.ReadLine();
//Expenseの場合に符号を逆転
if (strMode =="e")
{
_Amount = "-" + _Amount;
}
try
{
Convert.ToDecimal(_Amount);
}
catch
{
Console.WriteLine("Inputed was not decimal number. \n");
continue;
}
break;
}
while (true)
{
Console.Write("Input DenomiId : ");
_DenomiId = Console.ReadLine();
Denomination dnm = new Denomination(_strConn);
switch (_DenomiId)
{
case "\t":
dnm.list();
continue;
case "x":
return;
case "":
Console.WriteLine("Input valid DenomiId");
continue;
default:
break;
}
if (dnm.find(_DenomiId) == "")
{
Console.WriteLine(_DenomiId + " is not valid.");
continue;
}
break;
}
Console.Write("Input Memo (Optional) : ");
_Memo = Console.ReadLine();
string strCommand;
strCommand = string.Format(@"
insert into GeneralTrans(
TransDate
, MainCategoryId
, SubCategoryId
, Amount
, DenomiId
, Memo)
values(
'{0}' #TransDate
, {1} #MainCategoryId
, {2} #SubCategoryId
, {3} #Amount
, {4} #DenomiId
, '{5}' #Memo
)
", _TransDate, _MainCategoryId, _SubCategoryId, _Amount, _DenomiId, _Memo);
Sql sql = new Sql(_strConn);
sql.exec(strCommand);
}
