public void CreateCases(DbManagerProxy manager, AsSession obj) { if (obj._idfFarmForCaseCreation.HasValue) { manager.SetSpCommand("spASSession_CreateCase", manager.Parameter("idfFarm", obj._idfFarmForCaseCreation), manager.Parameter("idfPersonEnteredBy", obj.idfPersonEnteredBy), manager.OutputParameter("CasesList", DBNull.Value)).ExecuteNonQuery(); string cases = manager.Parameter("@CasesList").Value.ToString(); if (!string.IsNullOrWhiteSpace(cases)) { _LoadCases(obj); _LoadCaseTestValidations(obj); obj._strCreatedCases = cases; } else { obj._strCreatedCases = string.Empty; } obj._idfFarmForCaseCreation = null; } }