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