// Get a studios id by passing in a name
public static int GetStudio(string studio)
{
string sql = SqlProcedures.GetStudio(studio);
DataTable temp = Call(sql);
if (temp.Rows.Count == 0)
{
sql = SqlProcedures.CreateStudio(studio);
Run(sql, "Create Studio");
sql = SqlProcedures.GetStudio(studio);
temp = Call(sql);
}
if (temp.Rows.Count > 0)
{
int id;
int.TryParse(temp.Rows[0][0].ToString(), out id);
return(id);
}
else
{
return(-1);
}
}