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)); }