private static void CreateParticularAndSubType(IDBManager dbManager, string particularName, string particularSubType) { ParticularsModel pModel = new ParticularsModel(); ParticularsSubTypeModel pSubModel = new ParticularsSubTypeModel(); string sql; int lastID; try { pModel.CreateParticular(particularName); dbManager.Open(); sql = "select seq from sqlite_sequence where name='Particulars'"; lastID = Convert.ToInt32(dbManager.ExecuteScalar(CommandType.Text, sql)); dbManager.Close(); pSubModel.CreateParticularsSubType(particularSubType, lastID); } catch { } finally { } }
protected T ExecuteScalar <T>(string storedProcedureName, DynamicParameters parameters) { CommandDefinition command = dbManager.GetStoredProcedureCommand(storedProcedureName, parameters, 600); return(dbManager.ExecuteScalar <T>(command)); }