public static int SelectTransactionTypeIdByName(string designation)
{
var attrValue = DB_IO.AttrValue();
attrValue[TransactionTypeEnt.designation] = designation;
return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_transaction_types, attrValue));
}
public static string SelectTransactionTypeNameById(int transaction_tpe_id)
{
var attrValue = DB_IO.AttrValue();
attrValue[TransactionTypeEnt.transaction_type_id] = transaction_tpe_id;
return((string)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_transaction_types, attrValue));
}
public static int SelectCategoryTypeIdByDesignation(string designation)
{
var attrValue = DB_IO.AttrValue();
attrValue[CategoryTypeEnt.designation] = designation;
return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_category_types, attrValue));
}
public static string SelectCategoryTypeDesignationById(int category_type_id)
{
var attrValue = DB_IO.AttrValue();
attrValue[CategoryTypeEnt.category_type_id] = category_type_id;
return((string)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_category_types, attrValue));
}
public static int SelectRecurenceIdbyDesignation(string designation)
{
var attrValue = DB_IO.AttrValue();
attrValue[RecurrenceEnt.designation] = designation;
Console.WriteLine(DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_recurrences, attrValue));
return((int)DB_IO.SelectScalar(DB_IO.DB_Interface.pr_select_recurrence_id, attrValue));
}