DbCommand oDBCommand = oDatabase.GetStoredProcCommand("Proc_GetCourseWithStatus");
oDBCommand.CommandType = CommandType.StoredProcedure;
// we can not set CommandTimeout in all pages in existing application, we also set in connection string in web.config but it taking default 30 sec only
// oDBCommand.CommandTimeout = 100;
oDatabase.AddInParameter(oDBCommand, "InstitutionCode", DbType.Int32, iInstCode);
oDatabase.AddInParameter(oDBCommand, "UserApplicationLoginActivityID", DbType.Int64, loginActivityLogID);